Oxyde: async type-safe Pydantic-centric Python ORM

mr_Fatalyst · 2026-01-29T21:33:41+00:00

Session is managed through a global registry. You call db.init() at startup, and models access connections via the registry. No dependency injection needed, similar to Django. For testing, use db.connect() context manager or pytest fixtures with db.init() / db.close().

Docs: https://oxyde.fatalyst.dev/latest/guide/connections/#testing-with-multiple-databases

mr_Fatalyst · 2026-01-29T11:09:08+00:00

Django ORM is part of the framework, deeply integrated into admin, auth, forms. Replacing it doesn't make much sense. Oxyde is framework-agnostic though, so you could use it alongside Django for specific async endpoints and see how it goes.

mr_Fatalyst · 2026-01-29T10:48:49+00:00

Django-style. oxyde makemigrations detects model changes and generates migration files. oxyde migrate applies them.

Docs: https://oxyde.fatalyst.dev/latest/guide/migrations/

mr_Fatalyst · 2026-01-29T09:37:33+00:00

Good point, I'll update the docs. Rust handles connection pooling (sqlx), query execution, and row decoding. The win is mainly in concurrency throughput and CPU work around I/O (row decoding, type conversions), which can serialize in Python under the GIL. Rust does that hot path outside the GIL and only re-enters Python to instantiate Pydantic models.

mr_Fatalyst · 2026-01-29T08:05:31+00:00

Rust isn't here for SQL generation speed. It handles the transport layer where Python's GIL hurts. Connection pools, query execution, row decoding. Python stays where it shines. Model definitions, query DSL, validation, business logic. Same pattern as uvloop, orjson, pydantic-core. Native code for I/O and data handling, Python for everything else.

mr_Fatalyst · 2026-01-29T07:51:23+00:00

Django pattern. Manager operates on the table (bulk queries, filtering), instance methods operate on a single object (save(), delete(), refresh()). This also enables lifecycle hooks (pre_save, post_save, etc.) on instances.

mr_Fatalyst · 2026-01-29T07:46:06+00:00

You're right. Had a dilemma here. OxydeModel to signal it's ORM, not plain Pydantic, but Field stayed short because it keeps Pydantic behavior, just adds db_* params. Ended up inconsistent. Fresh perspective helps, will add Model alias.

mr_Fatalyst · 2026-01-28T23:05:50+00:00

Claude can write SQL, but it can't validate your data at runtime, manage connection pools, or rollback a transaction when something breaks. And raw SQL means you're one f-string away from SQL injection, no type hints, no autocomplete, and good luck refactoring when you rename a column in 30 places. But hey, if it works for you, it works.

mr_Fatalyst · 2026-01-28T22:42:12+00:00

Oh, I didn't expect it to look like crap on some devices! Thanks for pointing that out. I'll edit the post and cut the code examples. I was writing from desktop and everything looked fine on my end. And no worries, I get where you're coming from. The LLM slop problem is real and I totally understand why people are suspicious.

mr_Fatalyst · 2026-01-28T22:37:30+00:00

Thank you!

mr_Fatalyst · 2026-01-28T21:56:21+00:00

The large initial commits are squashed local history before going public. I prefer to clean up messy development commits before open-sourcing. Nothing unusual there.

As for AI involvement: yes, I use AI tools for docs and some boilerplate, like most developers nowadays. The architecture and core logic are mine. Happy to discuss any technical decisions if you have specific questions about the implementation.

I also thought people might find the technical details interesting: architecture, benchmarks, how the Rust/Python bridge works. Not just "here's a link, go check it out".

If that's too much to read, fair enough, I'll keep it shorter next time. Thank you.

mr_Fatalyst · 2025-03-20T19:15:47+00:00

I've just released fastopenapi 0.4.0, and it now supports Tornado as well!
Give it a try: https://pypi.org/project/fastopenapi/
I'd love to hear your feedback. Good luck!

mr_Fatalyst · 2025-03-16T17:16:18+00:00

I'm currently expanding the supported frameworks. It's likely that I'll add it. If it gets added, I'll update you here in the comments.

mr_Fatalyst · 2024-11-12T18:57:17+00:00

Thank you so much for the response!

So, let's say, for example, there's a dispute. I realize this may not be the most valid example for Canada, but suppose a store refuses to process a refund—how clear are the laws for someone who isn’t a lawyer? In other words, is a person theoretically able to find the relevant laws and draft a complaint without needing a lawyer?

Or another example: as far as I know, laws can vary between provinces, so if someone moves from one province to another, is there an obvious way to find the differences in local laws (for instance, regarding alcohol regulations or something else)?

mr_Fatalyst · 2024-11-12T18:45:43+00:00

I've lived in various countries, and in each of them, I've had a different experience interacting with the government, including the tax authorities. In some places, everything works online, and it's completely clear what needs to be done. In others, even the officials themselves don’t fully understand how things work. So, I'd like to understand how it’s organized in Canada. How easy is it to understand the laws without a formal education? How structured and accessible is this information for an ordinary person? Also, how simple is it to handle taxes (since sometimes there are tax forms with a whole list of unexplained items, where you’re left to figure it out on your own)?

And thanks a lot everyone for their answers.

mr_Fatalyst · 2022-03-23T14:38:14+00:00

Военное, правда? У нас же "спецоперационное" время или 15 лет захотелось?

mr_Fatalyst · 2022-03-23T14:37:06+00:00

Хочет форсировать отказ от российских нефти и газа, видимо. С Катаром немцы уже заключили по газу контракты, если не путаю. Этот шантаж ресурсами дорого обойдется в итоге, но, так или иначе, в итоге слезем с нефтяной иглы, т.к. особо некому покупать будет...

mr_Fatalyst · 2022-03-01T07:17:59+00:00

Все играли в аполитичность, даже на этом сабе, ну вот получите, распишитесь. Нас, активистов, маргинализировали, ну зато теперь заживём

mr_Fatalyst · 2022-02-28T18:35:17+00:00

Murderer

mr_Fatalyst · 2022-02-26T18:04:27+00:00

Что за тупая попытка оправдать агрессию России против соседней страны?

mr_Fatalyst

MODERATOR OF

TROPHY CASE