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 ...

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 ...

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 ...

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 ...

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. ...

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 ...

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,...

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. ...

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....

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.. ...

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 ...

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 ...

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 ...

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, ...

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 ...