search

cube2222 / octosql

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
Mozilla Public License 2.0
4.76k stars 200 forks source link

SQLite support? #215

Open Dialga opened 4 years ago

Dialga commented 4 years ago

Hi, since octosql supports mysql and postgresql, can sqlite support be added?

cube2222 commented 4 years ago

Hey, we indeed wanted to add it, but SQLite unfortunately requires CGO.

We haven't yet thought through how we stand on the CGO issue. On the one hand we could add it, with the caveat that it would only work on Linux, on the other it would be nice to explore developing such functionality fully cross-platform.

cube2222 commented 4 years ago

We should experiment with something like https://github.com/karalabe/xgo

Dialga commented 3 years ago

There is now a pure go implementation of sqlite here https://gitlab.com/cznic/sqlite.