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) ...
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) ...
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!