SQLite-Utils - Hackdot

Re:SQLite-Utils by thangngoc89 on Saturday July 29, 2023 @04:21AM (#36918105)

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

[ Parent | on HN ]

Re:SQLite-Utils by Hendrikto on Saturday July 29, 2023 @05:27AM (#36918430)

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.

[ Parent | on HN ]

Re:SQLite-Utils by thangngoc89 on Saturday July 29, 2023 @09:07AM (#36919926)

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

[ Parent | on HN ]

Re:SQLite-Utils by Hendrikto on Saturday July 29, 2023 @10:43AM (#36920790)

That, I fully agree with. It‘s a mess. Virtual envs help a bit, but are not perfect either.

[ Parent | on HN ]

Re:SQLite-Utils by thangngoc89 on Saturday July 29, 2023 @11:20AM (#36921110)

One year into Python and I still don’t know what is the universal way to have a reproducible environment across machine. Poetry, Conda, Pip, ugh. All have problems that I don’t know how to deal with

[ Parent | on HN ]