SQLite Plus: all the missing SQLite functions

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • Appwrite - The Open Source Firebase alternative introduces iOS support
  • SonarLint - Clean code begins in your IDE with SonarLint
  • InfluxDB - Access the most powerful time series database as a service
  • sqlite-plus

    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

  • 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!

  • json2csv

    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

    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

    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!

  • 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.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts