This sounds more like a limitation of QuestDB and not timeseries databases in general.

…imitations compared to relational databases. First and foremost, given its focus on fast ingestion, it does not have referential integrity and strong guarantees as the traditional transactional ACID model. Also, it is not as flexible as relational databases in storing different data types such as text and geospatial shapes. If these features are critical for your workload, consider splitting the data to keep transactional…

Migrating from Relational Databases to Time Series Databases

Yitaek Hwang

Ashraf Miah

Apr 13

This sounds more like a limitation of QuestDB and not timeseries databases in general. I don't believe these limitations exist for TimescaleDB.

Written by Ashraf Miah

113 Followers

Data Scientist and Chartered Aeronautical Engineer (MEng CEng EUR ING MRAeS) with over 15 years experience in the Aerospace, Defence and Rail Industry.

Recommended from Medium

The ChatGPT Hype Is Over — Now Watch How Google Will Kill ChatGPT.

AL Anany

The ChatGPT Hype Is Over — Now Watch How Google Will Kill ChatGPT.

It never happens instantly. The business game is longer than you know.

6 min readSep 1

280

An AI-generated image of a man radiating vibrant energy and calm after his morning routine

Neeramitra Reddy
in
Better Humans

The Most Powerful Morning Routine I’ve Found After 3+ Years of Experimenting

A realistic, science-based, customizable, and aggressively self-tested morning system

18 min read5 days ago

Lists

Staff Picks

454 stories296 saves

Stories to Help You Level-Up at Work

19 stories223 saves

Self-Improvement 101

20 stories600 saves

Productivity 101

20 stories555 saves

10 Seconds That Ended My 20 Year Marriage

Unbecoming

10 Seconds That Ended My 20 Year Marriage

It’s August in Northern Virginia, hot and humid. I still haven’t showered from my morning trail run. I’m wearing my stay-at-home mom…

4 min readFeb 16, 2022

944

The End of the Subscription Era is Coming

Nick Hilton

The End of the Subscription Era is Coming

You’re overpaying for your porn (and journalism)

10 min readAug 30

204

Dmitry Kruglov
in
Better Programming

The Architecture of a Modern Startup

Hype wave, pragmatic evidence vs the need to move fast

16 min readNov 7, 2022

Mirijam Missbichler

Why Japanese Websites Look So Different

& how to analyze design choices without jumping to conclusions

8 min readMay 1

194

See more recommendations

Help
Status
Writers
Blog
Careers
Privacy
Terms
About
Text to speech
Teams

Written by Ashraf Miah

More from Ashraf Miah

Running Svelte Tutorial Locally

Set-up a nodejs environment locally to follow the Svelte Tutorial locally.

Introduction to Multipass

Ubuntu Virtual Machines (VMs) On-Demand

An Alternative Introduction to Altair Plotting

Common Options and Best Practices

Streamline your Data Science Experience with Jupyter Hub

Improve your workflow with Jupyter Hub, ipykernel and systemd