All Questions
464 questions
0
votes
2
answers
68
views
Integer PK but a GUID as FK
In our current PostgreSQL DB, primary keys are Ints. However, in almost all of the communications between services another candidate key is used, a GUID. While I am not the original author of the ...
- 35
0
votes
1
answer
66
views
Reducing vacuum overhead & partitioning strategy for high-volume messages in PostgreSQL 13
I have a use case where I need to process a file containing messages generated for multiple customers. These messages need to be stored in a database and to be forwarded to respective customer in ...
- 771
-2
votes
1
answer
72
views
Scalable Database Design [closed]
I am creating a website, and this is the database I have designed. I have created this design in such a way that it scales well in the long term. The following features are supported by my database:
...
- 5
1
vote
2
answers
101
views
How to system-design paying a payment with multiple currencies
I am developing an accounting app where users can have a product with currency A. The value of the product can be escrowed using a cheque payment with currency B and this cheque payment can be paid in ...
1
vote
1
answer
204
views
How do I set up Baserow to migrate data from one table to another?
I want to set up a system in Baserow such that a record added to one table is automatically copied to another table.
For example, once someone pays for the service the user data is to be copied to ...
1
vote
0
answers
172
views
SQLite Strict Mode or any other alternatives
I am currently developing a QT C++ Application for my friend's shop. Simple application for inventory management and billing system. So, the DB will be in his computer itself which also hosts the ...
- 159
1
vote
1
answer
108
views
Merge many large tables in PostgreSQL
I have 150 tables with the same columns representing areas in a country. The size of each table is millions of rows and tens of GB in size.
I want to combine all the tables into one with the aim of ...
- 561
0
votes
1
answer
50
views
Designing SQL Postgres Relations Table for Editing Entered Documents and Undo Functionality
I'm currently working on a system where users can edit entered documents in a PostgreSQL database. The functionality entails allowing users to click on a document to edit it, effectively creating a ...
- 292
1
vote
1
answer
122
views
How to implement a wide multi-level self-join PostgreSQL query?
I have several rows that represent a person. Each person has a column for bio_mother _uuid and a bio_father_uuid. I used this page (I mention that because it's referenced in this similar question) to ...
- 308
1
vote
1
answer
84
views
Use conditional constraint or normalize table?
I have two entities: A and B. The latter has two types B1 and B2. Their relationship is:
(A,B1) is (1:1)
(A,B2) is (1,N)
When creating database tables, I wonder how is the best way to guarantee ...
- 72
0
votes
1
answer
99
views
Design SQL Schema for User Interests
I'm trying to find the best approach for designing sql schema for the following scenario:
-A User can have multiple interests
-The platform provides predefined interests from which the user can ...
- 1
0
votes
0
answers
242
views
Database Design for storing Key-Value Tags per Item
I want to build an online shop where the products don't follow a specific schema, so the attributes can be quite different for each product.
My idea is to allow the sellers to define custom tags with ...
- 46
0
votes
1
answer
56
views
Maintain the current count of buildings in a different table
I have two tables:
Table apartments:
house_no
house_street
1
Pomona
2
Pomona
1
Dubai
2
Dubai
Table streets:
street_name
total_buildings
Dubai
NULL
Pomona
NULL
I would love the column streets....
0
votes
1
answer
195
views
Timescaledb design for existing tables / dedicated table(s)
I'm building a software that is indexing and analyzing a large amount of blockchain data and I'm considering using TimescaleDB for better analytics performance as I'm running into performance issues ...
- 2,807
0
votes
1
answer
214
views
Define/design these related Postgres tables in my Prisma schema
My application using Prisma has users who can create many projects. These projects are akin to text documents, but with some additional attributes that assist with organization.
These projects will ...
- 420