{"repo":"elgs/gosqlapi","free":true,"listed":false,"github":"https://github.com/elgs/gosqlapi","clone":"git clone https://github.com/elgs/gosqlapi.git","description":"Turns any SQL database into a RESTful API.","language":"Go","stars":69,"topics":["database","golang","rest","sql"],"license":"MIT","category":"databases-storage","readme_excerpt":"gosqlapi Turns any SQL database into a RESTful API. Currently supports MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server and SQLite. The intention of gosqlapi is not to replace a full-fledged backend server, but to provide a quick and easy way to expose any SQL databases as a RESTful API without writing any server code, except for only SQL scripts. Installation Install gosqlapi with one of the following commands, depending on the databases you want to use: homebrew or Arch Linux (AUR) go install Download pre-built binaries If you don't have Go installed, you can download pre-built binaries from the releases page. Usage If you have a gosqlapi.json file in the current directory: or if you don't have gosqlapi.json in the current directory: Change Log Version 43 Previously HTTP PATCH method was used to execute pre-defined SQL queries. Now HTTP GET method can be used to execute pre-defined SQL queries, if the script name does not conflict with the table name. The HTTP PATCH method is still supported. The reason for this change is to allow caching of the pre-defined SQL queries. So use HTTP GET method to execute pre-defined SQL queries if you want to cache the results. Hello World On the server side Prepare gosqlapi.json and init.sql in the current directory, and run gosqlapi : gosqlapi.json : init.sql : On the client side Run a pre-defined SQL query Get a record Create a new record Update a record Delete a record Primary Key If the table's primary key is not ID , you can sp","default_branch":null,"files":null,"tree":[],"storefront":"/r/elgs","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/elgs/gosqlapi/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."}