193,810 questions
Advice
0
votes
1
replies
46
views
how to use the last file in?
Code of how the web application picks the file:
#Load Data
this_dir = Path(__file__).parent if '__file__' in locals() else Path.cwd()
wb_file_path = this_dir / 'vital_log_2026-03-13_21-20-51.csv'
data ...
Advice
1
vote
5
replies
53
views
The different types of databases, sql server
Describe the different types of database and which business would each databases be suitable for. The reasons why these businesses and organization would use these database
What are the types of sql ...
0
votes
0
answers
16
views
How to do composite unique constraints using SQLAlchemy and Alembic? [duplicate]
I'm trying to figure out how to add a composite unique to a table where the combination should be unique, but the individual fields can be the same
How my migration looks: (uses batch ops because the ...
- 3
Advice
1
vote
1
replies
25
views
How to set a timestamp field default to current time (with seconds) in GBase 8s?
Environment: GBase 8s, CentOS 7
When creating a table in GBase 8s, I want a timestamp field to default to the current time (e.g., 2023-08-08 10:00:00). What keyword or expression should I use?
- 1
Advice
0
votes
3
replies
51
views
Difference between MongoDB and MongoDB altas
I am a learner and right now at Database thing and choose MongoDB to learn as my stack is MERN so, but I am very confused about what MongoDB actually is and is MongoDB Atlas part of it or is it the ...
Advice
0
votes
1
replies
32
views
When a rebalance operation fails in RUNNING state, why does the table state revert to STARTING instead of CANCELED in GBase 8a?
In GBase 8a, when a table is in the RUNNING state and a rebalance operation fails, the table state transitions to STARTING rather than CANCELED. Meanwhile, when a CANCEL REBALANCE command is issued on ...
- 1
-2
votes
1
answer
37
views
Why does GBase 8c installation fail due to missing dependencies and how to fix it? [closed]
I am trying to install the GBase 8c database in a Linux environment, but the installation fails with errors related to missing dependencies.
For example, during installation I encounter errors like:
...
- 1
Best practices
13
votes
12
replies
2k
views
I built a database. What should I do next?
I built a small relational database as a personal learning project. It is around 10,000 lines of code and already includes many of the core parts of a basic relational database, such as page-based ...
- 1
Tooling
1
vote
0
replies
58
views
Database design for high-frequency options tick data (fast ingestion + query performance)
Title: Database design for high-frequency options tick data (fast ingestion + query performance)
I’m working with a large dataset of options tick data (1-second resolution) from 2019 to present, and I ...
-1
votes
1
answer
36
views
How can I use specific values for query in Apache IoTDB [closed]
I’m trying to find the values of other series exactly when s1 hits its maximum. SELECT MAX(s1) only gives me the peak, but I need the full row (s2, s3, s4) for every timestamp where s1 equals that max ...
Advice
2
votes
1
replies
56
views
How to view the table creation statement (DDL) in GBase 8s Oracle-compatible edition?
Environment:
GBase version: GBase8sV8.8_TL_3.3.0_2_36477d
Edition: GBase 8s Oracle-compatible
I am using GBase 8s (Oracle-compatible edition) and need to retrieve the table creation statement (DDL) ...
- 1
Best practices
0
votes
8
replies
76
views
Is using prisma findFirst() faster than findMany() then getting the first item in the returned array?
In the Prisma ORM, is there any performance difference between doing this:
const users = await prisma.users.findMany();
return users[0]
And that:
return await prisma.users.findFirst();
I need to ...
- 1
Advice
1
vote
1
replies
35
views
What data distribution strategies does GBase 8a support besides hash?
We are using GBase 8a as our analytical database and are currently evaluating distribution strategies for large fact tables. We know hash distribution is commonly used, but we would like to understand ...
- 1
-1
votes
0
answers
61
views
What causes `sqlite3_rsync` to produce "database disk image is malformed" on a target database [closed]
I have two small devices, A and B. Device A continuously reads and writes to a SQLite database in WAL mode called mydata.sqlite.
At regular intervals, a different process synchronizes this file from ...
- 682
1
vote
1
answer
128
views
How do I delete an entity in a one-to-many relationship?
I'm implementing a small e-commerce system, but I've encountered the following problem: I can't delete entities with one-to-many relationships.
I have a shopping cart class that goes as follow:
@...
- 13