194,890 questions
0
votes
1
answer
13
views
Hibernate won't generate SQLite table with autoincrement PK
I created the JPA entity Country for a Springboot project
@Getter
@Setter
@Entity
@Data
public class Country {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
...
0
votes
0
answers
10
views
Import calc spreadsheet to MySQL - again
Yes, I did see the warning and looked at some of the other answers, but I'm struggling a bit all the same. It is a simple enough question, but with a complication:
Some of the columns contain line ...
-1
votes
2
answers
82
views
What approach would be best for SQL dynamically-ordered lists (i.e. music playlists)?
I am designing a database for a music player. I am already using SQLite to store music tracks in a table called tracks, containing a unique id.
I need to add very standard playlist functionality: ...
1
vote
1
answer
6
views
Can the designated timestamp syntax using TIMESTAMP keyword automatically sort by ts?
Is it possible to make TIMESTAMP(ts) not only make ts be a designated timestamp, but also ensure the data is ordered by it?
At the moment, If I have unordered (or potentially unordered) data and need ...
0
votes
1
answer
4
views
Compare DOUBLE columns with exact ZERO value in QuestDB
I'm looking to query rows where a DOUBLE column is exactly zero but the following query also returns rows where the value is near but not exactly zero.
SELECT * FROM trades
WHERE timestamp in today()
...
0
votes
1
answer
8
views
handling nested data efficiently
If i have this JSON to store in questdb, how would you recommend i handle the nested portions of it?
As far as searching goes, i do need to search within the json. Should i just flatten the json?
the ...
0
votes
0
answers
7
views
QuestDB transactions lagging behind after one hour of heavy streaming
I have a medium-to-large table (over 4.5 billion rows, with about 760 Million per day, partitioned per hour).
I start ingesting from 3 processes in parallel. I have demo data in parquet files and each ...
0
votes
0
answers
11
views
How to connect one xampp database to multiple developers [closed]
I want to serve my laptop as the host of xampp database over multiple developers. Now can i host my xampp database even the developers have different networks? Can you teach me a step by step tutorial ...
-1
votes
0
answers
27
views
different constraints in a trigger [closed]
if i have two tables and i have two distinct constraints example constraint1 check a certain thing between one attribute and another between the two tables. constraint 2 checks a certain thing ...
0
votes
1
answer
42
views
Laravel Auth::attempt() error: "Unknown column 'password'" when using a custom password field
I'm working on a Laravel project to migrate the project from codeigniter to laravel so i'm using a multi guard authentication and custom admin user table named tbl_admin_user, where both email and ...
0
votes
0
answers
63
views
How a class can have an attribute that can contain any enum? and map this class with JPA
I'm doing a personal project to learn. full-backend console program. To show user actions I print different enums according user role. My idea is persist the enums in a db, as a field of the role ...
0
votes
1
answer
34
views
Is it necessary to carry out a Point-in-Time Recovery for both an original Azure database server and its read-only complement?
Given that:
You have an Azure subscription.
Within that subscription, you have an "Azure Database for PostgreSQL flexible server" - call this Server A.
Within the same subscription, you ...
0
votes
1
answer
12
views
Volume Spike Detector
I want to calculate spikes on my trading data. I have candles aggregated at 30 seconds intervals, and I basically want to show a flag 'spike' if volume is bigger than twice the latest record for the ...
0
votes
1
answer
11
views
Math operations with lag()
I have a questdb 8.3.0 and i want to graph a typical snmp counter containing network incoming traffic (ifHCInOctets).
If I run this query:
SELECT
timestamp,
ifDescr,
ifHCInOctets,
(...
0
votes
1
answer
12
views
ASOF JOIN query timing out
The below ASOF query that I would expect to return quickly is currently timing out.
It returns last 100 option trades matched to the most recent stock trade.
SELECT
o.timestamp AS option_ts,
o....