zed icon indicating copy to clipboard operation
zed copied to clipboard

sqlite reader

Open philrz opened this issue 4 years ago • 2 comments

In researching #2345, data set we're considering using happens to be stored as an sqlite DB. While the sqlite tools provide JSON/CSV export options that allow the data to make its way into Zed tooling for further shaping/storage/query, @mccanne also correctly pointed out that at some point we could add a native sqlite reader.

philrz avatar Jul 01 '21 17:07 philrz

This will be easy with the Go sqllite lib. We just scan all the tables and convert. There is so much sample data out there in sqllite this will be very worth the effort.

mccanne avatar Nov 09 '21 02:11 mccanne

A community user asked about this recently in the Zui context (https://github.com/brimdata/zui/issues/2923).

philrz avatar Dec 07 '23 17:12 philrz