Questions tagged [sqlalchemy]
The sqlalchemy tag has no summary.
12 questions
0votes
1answer
140views
How to Design a Database for Both Flexibility and Data Isolation?
I am designing a system that serves multiple customers, providing data visualization for revenue and membership information. Currently I use a separate schema approach to isolate customer data. Each ...
0votes
1answer
155views
SQLAlchemy (ORM) details in service layer in Clean Architecture?
I'm trying to decide how to hide data layer details (joinedload of sqlalchemy) in clean architecture. I have some dilemma about clean architecture. Please look at the code of some api endpoint (full ...
2votes
2answers
836views
Splitting up large SQLAlchemy model
Anybody have advice on splitting up a large SQLAlchemy model into smaller parts? I have a ~2000 line model called Article that is becoming difficult to manage. We often have to scroll and scroll to ...
- 129
2votes
1answer
701views
Should integration tests of a repository pattern use low-level ORM calls
Problem summary: In an application with wrapper methods over SQLAlchemy add() and query() methods, can integration tests that use the add() method wrapper use the query() method wrapper to validate ...
- 131
0votes
0answers
51views
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 ...
user403463
2votes
1answer
3kviews
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 ...
- 159
1vote
0answers
1kviews
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 ...
0votes
0answers
105views
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 ...
- 119
4votes
1answer
130views
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 ...
- 151
1vote
2answers
197views
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 ...
- 1,701
6votes
2answers
3kviews
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 | +-------+--------+ ...
- 169
1vote
2answers
5kviews
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 ...
- 1,803
