SQLite Plus: all the missing SQLite functions

• sqlite-plus

  28 3,372 7.7 C

  The ultimate set of SQLite extensions

That makes way more sense. GGP is probably meaning exactly that, specifically vsv from the OP.

https://github.com/nalgeon/sqlite-plus/blob/main/docs/vsv.md

• sqlite_ora_functions

  1 2 0.0 Python

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• json2csv

  3 2,698 0.0 JavaScript

  Convert json to csv with column titles

I read it as "I already have or can easily get a folder of JSON files (each representing a table); I want to open them up in SQLite with nearly zero effort."

That should be hackable with something like json2csv[1], but I imagine the intent is a desire for something supported, rather than awfully hacked up.

1 - https://github.com/zemirco/json2csv

• sqlite_protobuf

  2 80 0.0 C++

  A SQLite extension for extracting values from serialized Protobuf messages

Some time ago I joined a project that was recording logs in Protobuf format. I demonstrated that we could log the serialized Protobuf structures to a SQLite database and then use a plugin to query across the message fields: https://github.com/rgov/sqlite_protobuf

Learning how to use the SQLite extension API was a little mind-expanding but it worked like a charm.

• dflat

  5 300 3.8 Swift

  Structured Data Store for Mobile

Flatbuffers would be better as it doesn't need to deserialize at all (I think protobuf supports to partially deserialization nowadays?). I did something similar with https://dflat.io/ too!

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project