🪄 DuckDB sql hack : get things SORTED w/ constraint CHECK

🪝 Intro

Ever wanted to get that kind on constraint on a table :

CREATE TABLE sensor_data(
   ts TIMESTAMP,
   measurement INTEGER,
   ...,
   SORTED(ts)
);

Well, it turns out this topic has a dedicated discussion:

For now it's not implemented...yet. But we have a lot of use cases out there.

Let's see how to achieve this in pure sql... and why it would be so useful.

🍿 Demo

🤔 (A bit of) Context

We are currently using duckdb on GitHub Actions …

cases check database hack integer kind lot measurement productivity programming sql things topic use cases