If you want to fiddle with SQLite and don't need all the power herein, I recommend DB Browser for SQLite.<p><a href="https://sqlitebrowser.org/" rel="nofollow noreferrer">https://sqlitebrowser.org/</a>
Julia Evans has a brief description of SQLite-Utils that sold me on it: <a href="https://jvns.ca/blog/2022/05/12/sqlite-utils--a-nice-way-to-import-data-into-sqlite/" rel="nofollow noreferrer">https://jvns.ca/blog/2022/05/12/sqlite-utils--a-nice-way-to-...</a>
Among other things that makes this tool awesome is how convenient it makes light weight data wrangling on the cli, e.g. to introspect some json data in your clipboard with sql<p>`$ pbpaste | sqlite-utils memory --table - "select * from stdin;"`
thank you @simonw for creating this wonderful tool! I reach for sqlite-utils for my adhoc data needs every now and then. For aggregation then I use duckdb to read the resulting sqlite file.
I'm absolutely recommend SQLite-utils for fast SQLite operations, converting to and from SQLite. I have piles of bash script that import different sources of data (json, csv) into SQLite so that I can run analysis on it using SQL. My scripts are expected to work for years to come because SQL in general are stable, unlike the dependencies hell that comes with Python or Node.js
That's very cool thanks for sharing. Reading the manual I wonder if it wouldn't be more work for me to use a library like this than to use the default sqlite3 Python biding and writing my SQL queries by hand. Still cool nonetheless, as I can totally see how it could be useful to some people.
Another sqlite-based high level library that positively surprised me: <a href="https://dataset.readthedocs.io/en/latest/" rel="nofollow noreferrer">https://dataset.readthedocs.io/en/latest/</a>