HackerTrans
TopNewTrendsCommentsPastAskShowJobs

x2bool

no profile record

Submissions

Libgsqlite: A SQLite extension which loads a Google Sheet as a virtual table

github.com
266 points·by x2bool·há 3 anos·80 comments

comments

x2bool
·há 2 anos·discuss
There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)
x2bool
·há 2 anos·discuss
Yes, it should.

Before you know what you can SELECT you should know FROM where does the data come.

Except maybe cases where there is no data source: SELECT 1; or SELECT NOW();
x2bool
·há 3 anos·discuss
This project actually started as a fork of https://github.com/x2bool/xlite - SQLite extension for querying .xls and .xlsx spreadsheets.