A remote JSON interface for SQLite, in Go

• ws4sqlite

  7 390 7.3 Go

  Query sqlite via json+http

ws4sqlite is a web service layer on one (or more) SQLite databases. It’s written in Go, over mattn's go-sqlite3, and allows to use HTTP POST requests to submit SQL statements to a database, in a transaction. It can “serve” multiple databases at once, supports authentication, “stored queries”, in-memory databases, maintenance (vacuum/backups), batching and several other security features and configurations.

• go-sqlite3

  40 7,488 6.2 C

  sqlite3 driver for go using database/sql

ws4sqlite is a web service layer on one (or more) SQLite databases. It’s written in Go, over mattn's go-sqlite3, and allows to use HTTP POST requests to submit SQL statements to a database, in a transaction. It can “serve” multiple databases at once, supports authentication, “stored queries”, in-memory databases, maintenance (vacuum/backups), batching and several other security features and configurations.

• InfluxDB

  www.influxdata.com featured

  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.

  

• Sqinn-Go

  8 402 5.5 Go

  Golang SQLite without cgo

Of course, it may seem... odd to add a remote interface to an embedded database, but I think that it fits some niches well, especially when decoupling persistence and logic is needed, without renouncing to the expressivity of SQL. It was inspired by PostgREST, but it’s much more “low level” – and it should be even simpler to adapt to some cases. Also, it serves the same purpose of sqinn but with a more general interface.

Suggest a related project