24,207 questions
Tooling
0
votes
2
replies
46
views
Could you please let me know which database programming language gives most efficieny with less data consumption?
This is my question regarding several databases used for storing large amount of data. As I have used many of the databases programming languages but I need your opinions and experience of using ...
Best practices
0
votes
2
replies
69
views
How do I find every view and function that uses a specific column in SQL Server?
I'm working on an old SQL Server database where the main table has columns with generic names like MSTFLG01, MSTFLG02, all the way up to MSTFLG67. The actual meaning of each column is hidden inside ...
- 720
Advice
0
votes
1
replies
83
views
what's the correct route to put the nested routes in, with featured-based architectrure
I'm learning Express.js and I'm working on a big project on my own, an e-commerce (kind of SaaS).
I'm building the nested routes and controller, service, repo, etc. but the project is so big that I ...
Advice
0
votes
2
replies
78
views
How should we design a multi-tenant SaaS architecture for a scalable product engineering platform?
We are building multi-tenant SaaS platform where multiple customers share the same system with isolated data. We usually start with a shared database using a tenant_id to keep the design simple and ...
Best practices
0
votes
1
replies
69
views
How should I model and generate an org chart from a MongoDB employee collection?
I’m building an HRIS in Spring Boot with MongoDB, and I need to generate an organization chart from an employees collection.
My current model is:
@Document(collection = "employees")
public ...
Advice
0
votes
6
replies
119
views
Database design: to normalise or not?
I’m wondering when designing a database, is really strict normalization better or do you denormalize for performance from the beginning? It’s better because it runs faster right?
Advice
2
votes
3
replies
112
views
How to efficiently query high-volume custom post types without hitting wp_postmeta join bottlenecks?
I am managing a WordPress site with 100k+ entries in a custom post type. Standard WP_Query with multiple meta_query arguments is causing significant performance bottlenecks due to complex wp_postmeta ...
Advice
0
votes
2
replies
151
views
How to improve search time for attribute based database design
I am currently working on my mini project to practice(16 yo). I have this simple database structure consisting of products, categories and their attributes. I want to add search function. Structure ...
- 1
Best practices
0
votes
10
replies
376
views
How should I interpret SELECT vs INSERT/UPDATE/DELETE ratios when designing indexes for an OLTP workload?
I'm analyzing a SQL Server 2022 OLTP database and trying to refine my indexing strategy based on actual workload patterns.
The exact schema and queries cannot be shared, but the observed ratios and ...
- 591
Advice
0
votes
2
replies
57
views
Derived attribute storing
I understand that derived attributes should generally be calculated. When should a derived attribute be physically stored in a database table?
0
votes
1
answer
92
views
Concurrent update error: race condition error in FastAPI
I have a function, that updated database
@router.put("/{task_id}/status")
def update_status(task_id: str, task_data: UpdateStatus, db: Session = Depends(get_db)):
task = ...
- 1,696
Advice
0
votes
6
replies
105
views
Multi Vendor Insurance system best db design
I am building a module in which I have to integrate multi-vendor insurance using the nestjs and mysql. Mainly our purpose is to do insurance for new E-rickshaws. So, what is the best tables schemas I ...
Advice
0
votes
7
replies
109
views
By what database design do I store the many-a-day reminder timestamps in the database?
I'm creating a medication reminder app.
A user creates a reminder by selecting a medication, how long they will be consuming it, and timestamps for when they would to be reminded (receive a ...
Best practices
0
votes
2
replies
65
views
When using internal ids and exposed secondary ids, which should be used for foreign keys?
I have tables user and user_role and a m:n table that connects those, user_has_user_role.
To keep to a standard I want to not expose database table ids. So there is a secondary id id_be used in the ...
- 1
Best practices
0
votes
0
replies
63
views
PostgreSQL creating a bookstore or library database with reference tables
I'm creating a bookstore / library style database, and I wanted to get some feedback on my tables. I've made a previous version without reference tables, and now I'm trying to separate out the authors ...
- 23