24,207 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Advice
0
votes
6
replies
83
views
Best way to start learning SQL for database design and analysis?
I am new to SQL and I'm currently studying database design and analysis. I understand the basic concepts of databases, but I would like to build a strong foundation in SQL before moving on to more ...
- reputation score 1
Advice
0
votes
0
replies
44
views
MongoDB schema design for a documentation search engine
i am working on my psrfron project that is dev-serch or for that i desing the data so enyone can plece rewier my data base
Here is the architecture for my developer documentation crawler and data ...
- reputation score 1
Best practices
0
votes
4
replies
91
views
Multi-tenant SaaS Architecture: PostgreSQL Schema per Tenant vs Shared Database vs Database per Tenant
I'm designing a B2B SaaS application and I'm trying to choose the right multi-tenant database architecture before development begins.
This is not a social media application. It's an enterprise ...
- reputation score 476
Tooling
1
vote
11
replies
160
views
Which database programming language gives most efficiency with less data consumption?
Regarding several databases used for storing large amount of data, which database programming language gives most efficiency with less data consumption?
I have used many database programming languages....
- reputation score 1
Best practices
0
votes
1
replies
71
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 ...
- reputation score 720
Advice
0
votes
1
replies
87
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 ...
- reputation score 1
Advice
0
votes
3
replies
113
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 ...
- reputation score 1
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 ...
- reputation score 1
Advice
0
votes
6
replies
123
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?
- reputation score 1
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 ...
- reputation score 1
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 ...
- reputation score 1
Best practices
0
votes
10
replies
380
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 ...
- reputation score 591
Advice
0
votes
2
replies
58
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?
- reputation score 1
Score of 0
1 answer
94 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 = ...
- reputation score 1696
Advice
0
votes
6
replies
106
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 ...
- reputation score 1