Our great sponsors
-
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
-
Appwrite
Appwrite - The Open Source Firebase alternative introduces iOS support. Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!
-
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.
-
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.
-
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!
-
SonarLint
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.