Ws4sqlite: Query SQLite via HTTP

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

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • rqlite

    The lightweight, distributed relational database built on SQLite.

  • I would just like to warn people that you shouldn't use this in any production or client-facing app, it's trivial for a malicious actor to change the SQL and drop your database or whatever.

    If you need to access a sqlite database remotely, try https://github.com/rqlite/rqlite, it offers clustering on top of a basic SQLite database as well as a HTTP(s) API.

  • ws4sqlite

    Query sqlite via json+http

  • WorkOS

    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.

    WorkOS logo
  • sqlite3vfshttp

    Go sqlite3 http vfs: query sqlite databases over http with range headers

  • You can also access sqlite databases directly from an http server that supports range requests (like s3). There are a bunch of implementations of this in different languages including Go[0] and Javascript[1].

    [0]: https://github.com/psanford/sqlite3vfshttp

    [1]: https://github.com/phiresky/sql.js-httpvfs

  • sql.js-httpvfs

    Hosting read-only SQLite databases on static file hosters like Github Pages

  • You can also access sqlite databases directly from an http server that supports range requests (like s3). There are a bunch of implementations of this in different languages including Go[0] and Javascript[1].

    [0]: https://github.com/psanford/sqlite3vfshttp

    [1]: https://github.com/phiresky/sql.js-httpvfs

  • tuql

    Automatically create a GraphQL server from a SQLite database or a SQL file

  • sqlite-s3-query

    Python functions to query SQLite files stored on S3

  • go-sqlite3

    sqlite3 driver for go using database/sql

  • Sorry, forgot to comment: SQLite is currently 3.38.0, see https://github.com/mattn/go-sqlite3/blob/master/sqlite3-bind... I don't package it directly, but via the go bindings by mattn (go-sqlite3).

  • InfluxDB

    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.

    InfluxDB logo
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