{"repo":"proofrock/ws4sqlite","free":true,"listed":false,"github":"https://github.com/proofrock/ws4sqlite","clone":"git clone https://github.com/proofrock/ws4sqlite.git","description":"Query sqlite via json+http","language":"Go","stars":557,"topics":["sqlite","ws","isc","golang","database","sql"],"license":"ISC","category":"databases-storage","readme_excerpt":"🌱 ws4sqlite A bit of status report. The ws4sql fork (to integrate duckdb alongside sqlite ) is back on track, hopefully to be released \"as soon as\" the documentation is in good shape. ws4sqlite is a server application that, applied to one or more sqlite files, allows to perform SQL queries and statements on them via REST (or better, JSON over HTTP). Possible use cases are the ones where remote access to a sqlite db is useful/needed, for example a data layer for a remote application, possibly serverless or even called from a web page ( after security considerations of course). Client libraries are available, that will abstract the \"raw\" JSON-based communication. See here for Java/JVM, here for Go(lang); others will follow. As a quick example, after launching It's possible to make a POST call to http://localhost:12321/mydatabase , e.g. with the following body: Obtaining an answer of Features Docs, a Tutorial, a Discord. - Aligned to SQLite 3.53.3 ; - A single executable file (written in Go); - HTTP/JSON access, with client libraries for convenience; - Directly call ws4sqlite on a database (as above), many options available using a YAML companion file; - In-memory DBs are supported; - Serving of multiple databases in the same server instance; - Batching of multiple value sets for a single statement; - Parameters may be passed to statements positionally (lists) or by name (maps); - Results of queries may be returned as key-value maps, or as values lists; - All queries of a call ","default_branch":null,"files":null,"tree":[],"storefront":"/r/proofrock","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/proofrock/ws4sqlite/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}