Since you did not mention, I would like to ask your opinion on Tortoise ORM (https://tortoise.github.io). Actively maintained, has great "async story" & migration framework(aerich, maintained separately) ...
I like most of the API, but I think redoing a whole ORM without having idiomatic type annotations, and pydantic serialization for free is a missed opportunity. However, I haven't tried it in a real project. Do you have good things to say about it?
Thanks for the rundown. I'm going to stick with Peewee. I've used it for years and also pair it with APSW, since I'm only ever going to use SQLite and don't feel a need to experiment with async.
Personally, I don't see the value of UVX.sh. Installing UV is not complicated.
Oxyde seems promising; hopefully it will be better maintained than Tortoise ORM. It would also be better if it supported sync operations — not everyone has async issues/tastes.
Since you did not mention, I would like to ask your opinion on Tortoise ORM (https://tortoise.github.io). Actively maintained, has great "async story" & migration framework(aerich, maintained separately) ...
I like most of the API, but I think redoing a whole ORM without having idiomatic type annotations, and pydantic serialization for free is a missed opportunity. However, I haven't tried it in a real project. Do you have good things to say about it?
Thank you for a great summary - always a pleasure to read
Thanks for the rundown. I'm going to stick with Peewee. I've used it for years and also pair it with APSW, since I'm only ever going to use SQLite and don't feel a need to experiment with async.
What APSW extension do you use?
I use the one supplied by PeeWee.
I think, there is an issue with your first Pandas example, the dtype is the old "object" and not "str".
Thanks, copy/pasting will get the best of me
Personally, I don't see the value of UVX.sh. Installing UV is not complicated.
Oxyde seems promising; hopefully it will be better maintained than Tortoise ORM. It would also be better if it supported sync operations — not everyone has async issues/tastes.
Your comment reminds me of this one: https://news.ycombinator.com/item?id=9224
Haha, I don't think it's as useful, but only time will tell!