3 ms·
Hey, just wanted to chime with a tool I'm a co-author of, OctoSQL[1]. I too very like a common interface to various data sources. OctoSQL allows you to use pla
by cube2222 7y ago
Hey, just wanted to chime with a tool I'm a co-author of, OctoSQL[1].
I too very like a common interface to various data sources. OctoSQL allows you to use plain SQL to transform, analyse and join data from various datasources, currently including MySQL, PostgreSQL, Redis, JSON files, CSV, Excel.
However, we're very inspired with yesteryears paper "One SQL to rule them all" and should have ergonomic steaming support with Kafka as a new datasource available very soon.
[1]: https://github.com/cube2222/octosql https://github.com/cube2222/octosql
- keanzu 7y agoq - Text as Data q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple encodings. http://harelba.github.io/q/ http://harelba.github.io/q/
- marvel_boy 7y agoDo you plan support for Sqlite?
- cube2222 7y agoI see no reason to not add it, but we're currently busy so it'll have to wait till we either have time or somebody contributes it. Should be an hour of copypasting one of the sql data sources and adapting it for sqlite.