News for hackers. Stuff that matters.
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.