4 ms·
This might benefit from SQLite's Virtual tables: https://sqlite.org/vtab.html https://sqlite.org/vtab.html With Virtual Tables you can expose any data source a
by Erwin 10y ago
This might benefit from SQLite's Virtual tables: https://sqlite.org/vtab.html https://sqlite.org/vtab.html
With Virtual Tables you can expose any data source as a SQLite table -- then you can use every SQL feature that sqlite offers. You can just tell sqlite how to iterate through your data with a few functions, with an option to push down filtering information for efficiency.
You can also create your own aggregates, functions etc.
Here's an article where the author exposes redis as a table within sqlite: http://charlesleifer.com/blog/extending-sqlite-with-python/ http://charlesleifer.com/blog/extending-sqlite-with-python/
- erydo 10y agoMy thoughts went straight to PostgreSQL Foreign Data Wrappers. Something like that would be really helpful!
- andrewstuart2 10y agoWouldn't that require a running Postgres server, though? Seems a bit heavy for ad hoc queries. For something like a GitLab server, though, that would be amazing.
- deleted 10y ago[deleted]
- oneweekwonder 10y agoAccording to the Ubuntu Dependencies[0] it already uses Postgres, it also needs Redis, so with gitlab we are a bit pass the heavy bit. [0]: http://packages.ubuntu.com/xenial/gitlab http://packages.ubuntu.com/xenial/gitlab
- simonw 10y agoSQLite virtual tables for git would be phenomenal - you could join your git history against data from other sources! And you wouldn't need to run a huge MySQL/Postgres server process to do it. A very cursory search suggests no one has built this yet.