Time-Series DB

[beriberikix]

There are a lot of applications where a simple Time-Series DB would be ideal if it was embedded/local. I work in IoT and it's extremely common to try to run something like Timescale or Influx on the edge (Influx even launched a product last year.)

So what's needed to bring TS to libSQL? Setting up the table efficiently, time-related queries and efficient compression (ex.gorilla) come to mind but are there other challenges to supporting Time-Series data?

[franchb]

Stanchion – Column-oriented tables in SQLite