17 ms·
If you are working a lot with databases, and would like to automate some of the workflow in python, I'd highly recommend Pony ORM, which really feels like LINQ
by gamesbrainiac 7y ago
If you are working a lot with databases, and would like to automate some of the workflow in python, I'd highly recommend Pony ORM, which really feels like LINQ for python, and feels very close to the original SQL.
- whalesalad 7y agoPony is the LAST product I’d ever recommend to anyone, ever. It’s probably the worst open source software I’ve ever used. That being said, thanks to Pony I was called in to fix a shitshow and it likely earned me an additional 25% in consulting fees... so maybe I do like it in that regard. But in all seriousness, stay far away.
- gamesbrainiac 7y agoI suggest pony because it would be quite good for people who have a deep understanding of SQL, because the translation is quite nice. The alternative - SA is really overkill for most things.
- whalesalad 7y agoSQLAlchemy is a buzzkill but it’s not as heinous as Pony which is a straight up ticking time bomb in your project. Read the source code for 2 minutes and it should be enough to shy you away. As far as lightweight Python ORMs, I really enjoy Peewee and it’s usually my first choice.
- gamesbrainiac 7y agoI tried PeeWee, but it does not have support for SQLServer, which I need to work with on a daily basis.