lance icon indicating copy to clipboard operation
lance copied to clipboard

Lance as an append-only time series database?

Open mutexstream opened this issue 2 years ago • 1 comments

Is lance a good fit for building an append-only time series database, where batches of data are continuously appended as "versions" of the dataset? Are there other ways to achieve this?

Context: I want a file format that allows me to query for data in a given time range and also to append new data to the end of the current file as new data arrives.

mutexstream avatar Mar 26 '23 16:03 mutexstream

Hey, @mutexstream . Currently each "append" operation create a new file and seal it after finishes.

Before the WAL feature is landed, it would expect each append operation insert a large chunk of data to be more efficient. Does it fit the workload you are expecting?

eddyxu avatar Mar 26 '23 23:03 eddyxu

Closing due to inactivity

changhiskhan avatar Jul 02 '23 08:07 changhiskhan

Missed the comment. No inserting large chunk doesn't fit my use case, but I decided to move on to other tasks for now.

mutexstream avatar Aug 25 '23 02:08 mutexstream