SDT ORM

What python ORM is best for a crypto application?

ChatGBT: "Conclusion
SQLAlchemy is a powerful and flexible choice that can handle complex applications with large datasets and transactions, making it ideal for more sophisticated crypto applications.
Tortoise ORM is a great option for asynchronous applications, particularly if you expect high concurrency or need real-time data processing.
Django ORM works best if you're building a full-stack web application with a focus on scalability, security, and a robust admin interface for managing crypto data.
Peewee is suitable for smaller applications or when you need something lightweight for rapid development.

For a crypto application that may handle large volumes of real-time transactions and interactions, SQLAlchemy or Tortoise ORM would be strong choices, with SQLAlchemy being more versatile if you require both synchronous and asynchronous capabilities.

I used the Django ORM in the Sila stablecoin and it had some nice update and generation features but it was probably overkill. It was a fairly simple schema compared to a CRM or Analytics app. And there's a lot of duplicate functionality with AWS Lambda.

Tortoise isn't a large, established project.

So I'll prototype with PeeWee first since this is a proof-of-concept and demo app. Switch to SQLAlchemy later if necessary.

https://github.com/coleifer/peewee

Best Version of Python to Use with Peewee ORM

ChatGBT: "While Peewee is compatible with Python 3.5 and above, the best version to use for optimal performance, security, and compatibility would typically be: Python 3.8, 3.9, or 3.10."