SQLite-Utils

https://sqlite-utils.datasette.io/en/stable/index.html

by dedalus • 3 years ago

142 17 3 years ago

sqlite-utils.datasette.io

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

Hendrikto2• 3 years ago

Dude, what? Python has SQLite, JSON, and CSV support in its stdlib. It has been stable for years and years, and there is no indication this will change.

thangngoc894• 3 years ago

Oops. My bad. Me mostly working with DL/ML parts of Python so it’s absolutely madness to get a random DL project running

tibudiyanto• 3 years ago

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.

jgalt212• 3 years ago

If you want to fiddle with SQLite and don't need all the power herein, I recommend DB Browser for SQLite.

https://sqlitebrowser.org/

binwiederhier• 3 years ago

Another fantastic UI is IntelliJ (database support is built into the IDE) or Datagrip. It's a paid product, but it's more than worth the money if you use it daily.

mhitza• 3 years ago

Can you sell me on the IntelliJ suite of IDEs database UI? What makes it in your opinion fantastic?

I'm using it at the monent, it sure beats dealing with sqlite at the cli level but apart from that to me it feels as rudimentary as any other DB UI I've used in the past.

thangngoc894• 3 years ago

I would recommend TablePlus, the free version has annoying limitations (how many tabs you can open at the same time) but it’s more than enough if you’re just getting started. One of the best developer tools that I’ve ever bought

https://tableplus.com/

last_responder• 3 years ago

I second table plus. Great tool

srik• 3 years ago

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

`$ pbpaste | sqlite-utils memory --table - "select * from stdin;"`

p4bl0• 3 years ago

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.

FragenAntworten• 3 years ago

Julia Evans has a brief description of SQLite-Utils that sold me on it: https://jvns.ca/blog/2022/05/12/sqlite-utils--a-nice-way-to-...

7373737373• 3 years ago

Another sqlite-based high level library that positively surprised me: https://dataset.readthedocs.io/en/latest/

SQLite-Utils

Related Stories