Archive
Feeds Sign In
Archive Feeds Sign In
Note
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:

DesertSun stationary -3.6 km/h 85%

Comments (3)

jsonbecker
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
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
Bradford Dillon via Mastodon

@jonathan have you met https://datasette.io? It’s built on these kinds of features of SQLite. Datasette