Questions tagged [sqlalchemy]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-3
votes
0answers
17 views

Looking for proper documentation on using flask with oracle database express edition using cx_Oracle or sqlalchemy for academic project [closed]

I am a beginner to backend software development but I know HTML, CSS, JS and also basic SQL Queries. I am just looking for some resources to learn how to develop a website using python with backend ...
0
votes
0answers
44 views

Database-driven application. Code pattern to establish relationships

I have an application that mostly is composed of forms that create, modify, read, and deletes tables and establish relationships. I use SQLAlchemy. If, for example, I need to create an invoice and ...
1
vote
1answer
162 views

How to organize ORM models and business logic

I have a Python application using SQLAlchemy. It uses around 15 database tables. For example, I have an image table that lists image files manipulated by the application. Most operations involving ...
0
votes
0answers
506 views

How to store articles (with text and images) in SQLAlchemy database

I'm working on a blog-like application with Flask and SQLAlchemy and I'm unsure how to store the blog posts (articles) in the database. These are going to contain text and images (placed between ...
0
votes
0answers
50 views

Flask/SQLAlchemy Object Classes across app layers

I’m looking for advice where the business logic and data layers in a Flask/SQLAlchemy-based app all use essentially the same object class. As an example, my app includes a task scheduler. Tasks ...
4
votes
1answer
95 views

Maintaining parallel libraries: Binary files access + Metadata Database ORM design

I'm dealing with a higher-level data abstraction that I would appreciate some input on. I'm working on an application that uses a large data lake. The data lake is consisted of thousands of large ...
1
vote
2answers
144 views

When using an ORM when should I sacrifice performance for convenience?

I work with SQL Alchemy a lot and, as a "lazy programmer", I enjoy the convenience it offers. But the "diligent programmer" in me often worries about optimisation and the performance of the queries ...
5
votes
1answer
1k views

Separate business logic from ORM models in SQLAlchemy

I have a Flask application with tens of complex models, almost all of them related to each other. A simple pseudo-schema of some of them: +----------------+ | FoodGroup | +-------+--------+ ...
1
vote
2answers
3k views

SQLAlchemy and DDD: It's own pattern?

While reading "Patterns, Principles, and Practices of Domain-Driven Design" by Nick Tune; Scott Millett (certainly not the first book on DDD I've read) I started to understand usage of Martin Fowler's ...