194,070 questions
0
votes
0
answers
57
views
Which index is useful on like clause? [duplicate]
SELECT o
FROM Order o
WHERE o.customerEmail LIKE %:emailPart%
are there any RDBMS (PostgreSQL) index type which can improve performance of the query above? (i.e. which index can help on like clause?)
- 3,181
Advice
0
votes
0
replies
43
views
How to Install ScyllaDB Manager?
I'm new to ScyllaDB and I'm trying to install ScyllaDB Manager. However, I’m having trouble following the instructions on the official website because some steps seem to be missing.
Can anyone point ...
- 13
-2
votes
0
answers
36
views
Issue Failure to Retrieve Workbook Path for Dynamic Relative Pathing in Power Query - Excel [closed]
I am having trouble implementing a dynamic relative path in Power Query to ensure the portability of my projects
My project structure is always the following
/Project_Name/Resultats.xlsx (...
Advice
0
votes
3
replies
38
views
Review FMCG business inventory system DB design normalization and ERD
My case study project inventory system tracks stock and updates stock after every sale of a FMCG (Fast-moving consumer goods) business. Since it is FMCG, they get stock by consignment and the database ...
-1
votes
1
answer
42
views
I need to unlock a Pervasive database without the DDF files
I need to unlock a Pervasive database.
I managed to retrieve one, and need to transform it to readable data, or import it to another database.
However, we don't have the DDF files.
This DB is from ...
-3
votes
0
answers
38
views
Should each application environment use a separate database instance? [closed]
I am setting up a database configuration for a web application with multiple environments:
local
development
staging
production
I often see projects using a different database for each environment and ...
0
votes
0
answers
90
views
Prisma V7 Error: Client Password must be a string
I am sorry if it's asked already, I just migrated to Prisma V7 and am stuck with an unsolvable error.
SCRAM-SERVER-FIRST-MESSAGE: client password must be a string
The server runs fine, Though the ...
-1
votes
1
answer
62
views
Selenium use database for Chrome but not for Firefox
I have an app for listing my books.
I want to test my code in chrome and firefox both, using the fixture in my database but without touching the real database. In the database I have some data for the ...
- 1,387
Tooling
0
votes
1
replies
50
views
What database to choose?
I'm analysing a case that a data warehouse can be used instead of CRM - as a base that collect all information about customers, offers, invoices and soon.
I will scrape data from 3 already existing ...
- 1
0
votes
1
answer
58
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
69
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
33
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
16
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
170
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
92
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