194,092 questions
0
votes
1
answer
49
views
What is the practical difference between static and dynamic background workers in PostgreSQL?
I’m trying to understand when to use a static background worker vs a dynamic one in PostgreSQL.
From what I know so far:
Static workers are registered during postmaster startup
Dynamic workers can be ...
- 53
Advice
0
votes
3
replies
61
views
PostgreSQL: primary key based on timestamp
I am working on a highload system, which needs to process quite a lot of events, but not an insanely huge amount. The data ingested has to be editable during a short period of time, and then the need ...
- 9,790
0
votes
1
answer
15
views
Neo4j has issues with loading Reactome Graph Database
I have been trying to start exploring the Reactome Graph Database today following the instructions given at https://reactome.org/dev/graph-database#GetStarted
I have installed Neo4j Desktop 2 (version ...
- 301
Advice
0
votes
0
replies
12
views
ER Model and Scheduling Logic for a Pet Grooming Appointment System
Function Table
ER Model
I am currently designing the database schema for a Pet Grooming Appointment System (focusing solely on the appointment functionality, excluding user registration). I've ...
- 1
Best practices
3
votes
5
replies
135
views
Fastest way to read 10M DB rows in Python?
I’m trying to efficiently read about 10 million rows (single column) from a database table in Python and I’m not sure if my current approach is reasonable or if I’m missing some optimizations.
...
1
vote
0
answers
78
views
Heavy duplication when upserting with GORM generics in SQLite
I have several models in my application, which have associations between each other. I'm trying to recursively upsert them, but haven't been able to find a good solution that doesn't extensively rely ...
- 49
0
votes
0
answers
27
views
PolarDB vector database data import
I tried to import some MD files into PolarDB vector database. Some files hit errors like follow:
Failed file: monthly_2021_07_05.md
Log file: import_with_errors.log
Error context:
2025-10-28 17:23:07,...
- 21
Tooling
0
votes
4
replies
71
views
Is there a Database First approach in Java like Entity Framework in C#?
I’m used to working with a Database First approach in C#. I design my database schema (often with MySQL Workbench) and do a forward engineering, then generate my C# models using Entity Framework’s. ...
-2
votes
1
answer
70
views
Online clothing store: Which tables are well normalized and which need to be normalized? [closed]
The project is a database for an online clothing store.
Which tables are well normalized and which need to be normalized?
DB schema of all the tables before doing any normalization:
https://i.sstatic....
Best practices
0
votes
0
replies
50
views
How to physical, logical model your unstructured data
If I have data lake.. which have a lot of files and data.. structured and un structured .. is it the correct place , or what is the best practice to create the physical, logical model of my data.. ...
- 49
2
votes
0
answers
123
views
Can not mark more then one line in DBeaver
I am facing an issue in DBeaver.
I always update my DBeaver program when it says to update, and I am using a MAC.
The version of DBeaver is 25.2.5.202511161745.
I try to mark via the mouse more than ...
- 1,267
0
votes
0
answers
47
views
How to handle contention at scale?
We’re building a system where an offer can be redeemed until a global limit is reached.
For example, an offer may allow a maximum total redeemable amount (e.g., 10M), or/and only allow each user to ...
- 657
Advice
0
votes
2
replies
104
views
Force all character columns in a list of data frames to UTF-8 before uploading to a UTF-8-only database
I have a list of two tables in R.
Each data frame contains several character and numeric columns. One of the columns is a company name column (for example, Company_Name).
The target database only ...
- 1
1
vote
0
answers
93
views
DB query execution hanging in golang
I don’t understand why this is happening. I’m using the Go database package to connect to a PostgreSQL database. I loop through fullmsg (88 messages), but after processing about 27 messages, ...
- 46
1
vote
1
answer
167
views
Prisma CLI Error: "Missing required environment variable: DATABASE_URL" in NestJS Project (Even Though .env Is Set) [closed]
I'm trying to use Prisma in my NestJS project. Prisma initializes correctly, but whenever I run any Prisma CLI command (e.g., npx prisma, npx prisma migrate dev, etc.), I get this error:
Failed to ...
