193,811 questions
Advice
0
votes
2
replies
44
views
When it comes to measured data. How would you define an anomoly?
This is a very general question, but I am currently working on a project that researches anomalies in databases. I know there are a lot of general algorithms I can look into, but what are the correct ...
-3
votes
0
answers
55
views
Getting all delete sql queries in mysql [closed]
Context
I am working on migrating a large, single production MySQL database into a split Active and Archive database architecture.
The data routing is based on a cutoff year (e.g., 2023):
Active DB: ...
- 9
Best practices
0
votes
1
replies
41
views
What APIs exist for accessing music/album metadata?
I am a student building a web app as a personal project. The app will involve storing user data (accounts, reviews of albums + songs) as well as music-related data such as albums, artists, and tracks. ...
Advice
0
votes
2
replies
33
views
How could i impove it guys?
from __main__ import app
from flask import render_template, redirect, url_for, flash, session, request
import sqlite3
from db_connector import database
from flask import request
import hashlib
from ...
Advice
1
vote
5
replies
56
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 ...
Advice
1
vote
1
replies
31
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
58
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
38
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
59
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
57
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
77
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