Questions tagged [database]
This tag is for general database questions. If you question is specific to SQL or NoSQL, use the corresponding tags instead.
2,163 questions
1
vote
2
answers
254
views
What is a good strategy to avoid creating duplicate profiles for many individuals in a database?
I'm designing an application that is going to receive tens to hundreds of thousands of requests. Users submit requests on behalf of Customers (which are singular persons). Each request will contain ...
- 19
6
votes
5
answers
3k
views
System Design for low latency reliable online chess game
I want to build a low-latency chess backend (something similar to live chess on chess.com or basically any other online real-time chess), but there are a couple of questions I am unable to get answers ...
- 170
3
votes
2
answers
440
views
Why do database protocols use fixed endianness instead of native server endianness?
Most database wire protocols mandate a specific byte order for multi-byte integers:
PostgreSQL: big-endian (network byte order)
MySQL: little-endian
MongoDB: little-endian (BSON format)
OracleDB: ...
- 41
1
vote
3
answers
296
views
How can I introduce migration scripts to a team that has stopped using them?
In my working experience, I am into a situation in which the team has stopped using migration scripts for setting up the db. The team is fast paced focusing on business upon a 1-year old startup.
...
1
vote
2
answers
144
views
Designing persistence guarantees in an ingestion pipeline with a non-customizable intermediary
I’m migrating a large volume of historical RRD data into a VictoriaMetrics cluster.
By design, vminsert buffers and asynchronously forwards data to vmstorage. This makes it unclear when data is ...
- 21
1
vote
3
answers
141
views
How should we design an IoT platform that handles dynamic device schemas and time-series ingestion at scale (100K writes/min)? [closed]
We’re a small dev team (3 full-stack web devs + 1 mobile dev) working on a B2B IoT monitoring platform for an industrial energy component manufacturer. Think: batteries, inverters, chargers. We have 3 ...
- 39
0
votes
1
answer
142
views
How can I scale an embedded Java DB to support multiple processes or nodes?
I’m using JetBrains Xodus—a transactional, append‑only embedded Java database—inside a single JVM process and it meets my performance needs there.
Now I need to:
Allow multiple JVM processes on the ...
- 145
0
votes
1
answer
153
views
Microservice Architecture Design
I want to create one service that reads data from two databases and passes it to the customer devices. Is this an overall bad design decision? I think that since it is only read-only, it should be ...
- 121
0
votes
2
answers
157
views
Designing a social media notification system, would a single table with JSON column be the correct approach for data?
I am trying to create a notification system similar to Instagram, for the lack of better comparasion.
The Goal:
Getting user notifications in a unify way, for easy unparsing and displaying to user.
...
- 101
0
votes
1
answer
133
views
Best Practice for Managing Payment Subscription Tier Status
I'm trying to understand the best way to approach how to manage and update a user’s payment subscription status in a web application. Let’s say you have a subscriptions table in a database that is ...
12
votes
4
answers
3k
views
Is the separation of a database process from the main backend process really "good practice"?
In our current architecture, we have a React frontend communicating with a Rust backend via REST calls. We are considering introducing a PostgreSQL database, and my colleague suggests that we should ...
user469823
4
votes
4
answers
323
views
how can CQRS improve performence when we have to duplicate the writes
I was reading about CQRS, and from what I understand, it separates reading from writing by using two databases: one for queries (reading) and another for commands (writing). However, I don’t quite get ...
- 51
0
votes
3
answers
327
views
Transaction management with one connection
We have a desktop application written in Java that communicates with a DB. We support Oracle and Postgres. For the purpose of this question, let's focus on Postgres
Our app uses one connection for all ...
- 2,030
21
votes
5
answers
4k
views
How manage inventory discrepancies due to measurement errors in warehouse management systems
I'm developing an enterprise-grade warehouse management application for a chemistry laboratory. A critical feature involves mixing multiple stock solutions to create new solutions based on predefined ...
- 321
2
votes
2
answers
490
views
Best design pattern to synchronize local and cloud databases?
Right now I have an edge device (resource constrained) which is processing, storing, and querying time series data using a Postgres DB.
When a data collection event has ended, a simple script on the ...
- 29