12 requests per second: A realistic look at Python web frameworks

Re:12 requests per second: A realistic look at Python web fr... by BiteCode_dev on Friday February 19, 2021 @10:14AM (#26194019)

I always though it would be a nice alternative to an ORM: having a tool that take a marshmallow/pydantic/whatever model, optionally passing it additional db specific options, then it generates a bunch of sql files you can call with aiosql. The whole things would then let you optionally get the result wrapped in a model if you need to, with ORM like helpers for common CRUD things.

That would have the benefit of the standardized api of an ORM and the flexibility of SQL, without the coupling.

[ Parent | on HN ]

Re:12 requests per second: A realistic look at Python web fr... by polyrand on Friday February 19, 2021 @06:07PM (#26199255)

Absolutely! I think it should be doable, FastAPI and other libraries do heavy Pydantic model inspection, and some do automatic code generation. I should explore this a bit more.

[ Parent | on HN ]

Re:12 requests per second: A realistic look at Python web fr... by BiteCode_dev on Saturday February 20, 2021 @06:23AM (#26203369)

It also has some nice properties:

- because you have all your queries written in the same place, when you create a db migration, you know where to look for code to update, and can even perform some automatically.

- sql queries could be turned into a stored procedure with a simple marking, without changing any code.

Of course the downside is that dynamically exploring data is not as easy as with an ORM.

[ Parent | on HN ]