All Questions
464
questions
1
vote
2
answers
64
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 ...
0
votes
0
answers
19
views
Product variant but has other variation
I have product table and produk variant
But I want that product variant has other options again
This is my product,
I have a custom cloth that has types of collars , cuff, pocket, plackets, fabric
But ...
0
votes
0
answers
35
views
How do I setup baserow such that I can migrate data from one table to another?
I am new to base row and I would want to set up a system such that a record added to one table is automatically copied to another table.
I can't really go into too much detail but for example, once ...
0
votes
0
answers
60
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 ...
1
vote
1
answer
69
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 ...
0
votes
1
answer
36
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 ...
1
vote
1
answer
98
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 ...
1
vote
1
answer
75
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 ...
0
votes
1
answer
54
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 ...
0
votes
0
answers
99
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 ...
0
votes
1
answer
54
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
111
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 ...
-1
votes
1
answer
142
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 ...
-1
votes
1
answer
118
views
Postgres Query to find similar strings
I have a 10 million+ PostgreSQL (v16) table that stores address details for a person. I have to find the addresses that are similar to the input address and exceed a threshold.
We have tried module ...
1
vote
2
answers
495
views
Postgres hide some columns from user in SELECT *
I want to give a group of users selective access only to particular columns of an Application due a privacy concern. So, when user types '''SELECT *''' on restricted table, he could only see allowed ...