{"repo":"b4fun/sqlite-rest","free":true,"listed":false,"github":"https://github.com/b4fun/sqlite-rest","clone":"git clone https://github.com/b4fun/sqlite-rest.git","description":"sqlite-rest adds a RESTful API to any SQLite database","language":"Go","stars":100,"topics":["api","database","golang","postgrest","rest","sql","sqlite","sqlite3","sqlite-rest"],"license":"MIT","category":"databases-storage","readme_excerpt":"Serve a RESTful API from any SQLite database sqlite-rest is similar to [PostgREST][postgrest], but for [SQLite][sqlite]. It's a standalone web server that adds a RESTful API to any SQLite database. [PostgREST]: https://postgrest.org/en/stable/ [SQLite]: https://www.sqlite.org/ Installation Build From Source Using docker image Quick Start Suppose we are serving a book store database with the following schema: Create a database Start server Generate authentication token NOTE: the following steps create a sample token for testing only, please use a strong password in production. - Visit https://jwt.io/ - Choose HS256 as the algorithm - Enter topsecret as the secret - Copy the encoded JWT from the encoded output - Export the token as an environment variable Querying Querying by book id Querying by book price Features Parity with PostgRest sqlite-rest aims to implement the same API as PostgRest. But currently not all of them are being implemented. Below is a list that features supported in sqlite-rest. If you need support for implementing a feature absent in the list, feel free to create an issue :smile: - Tables and Views - [x] Horizontal Filtering (Rows) - [x] Vrtical Filtering (Columns) - [x] Unicode support - [x] Ordering - [x] Limit and Pagination - [x] Exact Count - Insertions - [x] Specifying Columns - [x] Updates - [x] Upsert - [x] Deletions Authentication sqlite-rest provides built-in JWT based authentication. To use HS256 / HS384 / HS512 algorithm, please specific the to","default_branch":null,"files":null,"tree":[],"storefront":"/r/b4fun","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/b4fun/sqlite-rest/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."}