SQLite is so darn useful. Yesterday, I used its built-in CSV ingestion capability on a personal project to turn a large CSV file into a queryable database in seconds. Awesome tool in the toolbelt.
Jonathan's location at time of posting:
DesertSunstationary-3.6 km/h85%
Comments (3)
jsonbecker
via
Micro.blog
@cleverdevil not to be that guy, but https://duckdb.org is so great for analytics tasks in a sqlite way. Especially with select * from read_csv_auto() etc
cleverdevil
via
Micro.blog
@jsonbecker indeed! It’s quite good. But, SQLite is pervasively available on pretty much every computer I have access to. 😇
Bradford Dillon
via
Mastodon
@jonathan have you met https://datasette.io? It’s built on these kinds of features of SQLite. Datasette
Comments (3)
@cleverdevil not to be that guy, but https:// duckdb.org is so great for analytics tasks in a sqlite way. Especially with select * from read_csv_auto() etc
@jsonbecker indeed! It’s quite good. But, SQLite is pervasively available on pretty much every computer I have access to. 😇
@jonathan have you met https:// datasette.io? It’s built on these kinds of features of SQLite. Datasette