If you’re going to use SQLite regularly, you’ll need some extra infrastructure. OP’s post provides some boilerplate that would help you on your way.
What has really made the difference for me recently though, is Simon Willison’s sqlite_utils package. It’s heavier weight than OP’s wrapper classes, but it’s infinitely more powerful and has made using a local database a joy instead of the kludge I usually make of it. I’ll be bummed to writing stuff for PostGres when I have to do that
If you’re going to use SQLite regularly, you’ll need some extra infrastructure. OP’s post provides some boilerplate that would help you on your way.
What has really made the difference for me recently though, is Simon Willison’s sqlite_utils package. It’s heavier weight than OP’s wrapper classes, but it’s infinitely more powerful and has made using a local database a joy instead of the kludge I usually make of it. I’ll be bummed to writing stuff for PostGres when I have to do that
That is a very decent lib! It seems pretty mature and strikes a nice balance between ease of use and performant power.
sqlite_utils is the missing command line, in many ways
SQLite is an underused platform imo. More RDBMS would benefit from using it as an import / export format vs csv / json.