News for hackers. Stuff that matters.
Re:Getting the Most Out of Sqlite3 with Python by nrjames on Sunday October 22, 2017 @09:29AM (#15526732)
I often use the Dataset library (from Mozilla, I believe). It provides a lot of convenience for incorporating SQLite (and other databases) into Python projects and it's very easy to use it to fall back to straight SQL queries and other statements.

https://dataset.readthedocs.io/en/latest/

Re:Getting the Most Out of Sqlite3 with Python by jgalt212 on Sunday October 22, 2017 @09:59AM (#15526860)
Dataset is neat, but it relies on the monster that is sqlalchemy. I have recently been using Pony ORM for new experiments with sqlite, and then if the project sticks data transfer to MySQL, et is trivial.

Pony is not a light as Dataset, but way less heavy/confusing than sqlalchemy.

Re:Getting the Most Out of Sqlite3 with Python by StavrosK on Sunday October 22, 2017 @11:33AM (#15527232)
I agree, but Pony is also less flexible than SQLAlchemy :/ For anything other than trivial queries, you'll end up writing some horrible code.

Having used Pony for a month or so, it feels like someone saw generators, thought SELECTs would be cool using them, and then implemented all other query types as well instead of shelving the whole thing like they should have.

Re:Getting the Most Out of Sqlite3 with Python by jboynyc on Sunday October 22, 2017 @07:31PM (#15529630)
Kenneth Reitz's records library is similar (and also reliant on Sqlalchemy): https://github.com/kennethreitz/records