Skip to main content
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; ...
Iooosef's user avatar
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 ...
j4nd3r53n's user avatar
  • 850
-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: ...
goose_lake's user avatar
  • 1,540
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 ...
Javier Ramirez's user avatar
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() ...
Javier Ramirez's user avatar
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 ...
Javier Ramirez's user avatar
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 ...
Javier Ramirez's user avatar
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 ...
Bullo Ivan Christopher's user avatar
-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 ...
dok's user avatar
  • 387
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 ...
Manish's user avatar
  • 13
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 ...
Bujakiewicz Franco's user avatar
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 ...
Tom Hosker's user avatar
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 ...
Javier Ramirez's user avatar
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, (...
Javier Ramirez's user avatar
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....
Javier Ramirez's user avatar

15 30 50 per page
1
2 3 4 5
12993
X