自动为数据库以及具有内置 HTTP API 的数据库公开 REST、GraphQL 或其他类型 API 的工具列表

心已赠人 2023-10-01 19:11 4阅读 0赞

[GitHub - dbohdan/automatic-api: A list of software that turns your database into a REST/GraphQL API][GitHub - dbohdan_automatic-api_ A list of software that turns your database into a REST_GraphQL API]

<table> 
 <tbody> 
  <tr> 
   <th>Project name/link</th> 
   <th>Database(s) supported</th> 
   <th>API type</th> 
   <th>Implementation language</th> 
   <th>License</th> 
   <th>GitHub stats</th> 
   <th>Notes</th> 
  </tr> 
  <tr> 
   <td><a href="https://www.apinizer.com/products/api-creator/" title="Apinizer API Creator" rel="nofollow">Apinizer API Creator</a></td> 
   <td>Oracle, MySQL, PostgreSQL, MsSQL, IBM DB2, SAP Sybase ASE, Apache Impala, Apache Hive</td> 
   <td>REST</td> 
   <td>Java</td> 
   <td>Proprietary (SaaS)</td> 
   <td>n/a</td> 
   <td>Generates OpenAPI Specifications.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/arangodb/arangodb" title="ArangoDB" rel="nofollow">ArangoDB</a></td> 
   <td>ArangoDB</td> 
   <td>REST</td> 
   <td>C++</td> 
   <td>Apache 2.0</td> 
   <td>11497&nbsp;★; 47767&nbsp;commits, latest&nbsp;2021-08-13</td> 
   <td>A database with a built-in REST API.&nbsp;<a href="https://hub.docker.com/r/arangodb/arangodb/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/apache/couchdb" title="CouchDB" rel="nofollow">CouchDB</a></td> 
   <td>CouchDB</td> 
   <td>REST</td> 
   <td>Erlang</td> 
   <td>Apache 2.0</td> 
   <td>5027&nbsp;★; 13129&nbsp;commits, latest&nbsp;2021-06-23</td> 
   <td>A database with a built-in REST API.&nbsp;<a href="https://hub.docker.com/r/_/couchdb/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/juxt/crux" title="Crux" rel="nofollow">Crux</a></td> 
   <td>Crux</td> 
   <td>REST</td> 
   <td>Clojure</td> 
   <td>MIT</td> 
   <td>1435&nbsp;★; 6832&nbsp;commits, latest&nbsp;2021-08-11</td> 
   <td>A database with a built-in REST API.&nbsp;<a href="https://hub.docker.com/r/juxt/crux-standalone" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/simonw/datasette" title="Datasette" rel="nofollow">Datasette</a></td> 
   <td>SQLite 3</td> 
   <td>REST</td> 
   <td>Python 3</td> 
   <td>Apache 2.0</td> 
   <td>5327&nbsp;★; 1739&nbsp;commits, latest&nbsp;2021-08-13</td> 
   <td>Read-only.&nbsp;<a href="https://hub.docker.com/r/terranodo/datasette/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/dgraph-io/dgraph" title="Dgraph" rel="nofollow">Dgraph</a></td> 
   <td>Dgraph</td> 
   <td>GraphQL (since version 2.0.0-rc1)</td> 
   <td>Go</td> 
   <td>Apache 2.0</td> 
   <td>16473&nbsp;★; 5730&nbsp;commits, latest&nbsp;2021-08-12</td> 
   <td>A database with a built-in GraphQL API.&nbsp;<a href="https://hub.docker.com/r/dgraph/dgraph/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/dreamfactorysoftware/dreamfactory" title="DreamFactory" rel="nofollow">DreamFactory</a></td> 
   <td>MySQL, PostgreSQL, SQLite, MongoDB, CouchDB, and&nbsp;<a href="https://www.dreamfactory.com/products" title="others" rel="nofollow">others</a>.</td> 
   <td>REST</td> 
   <td>PHP 5</td> 
   <td>Apache 2.0, proprietary (optional extras)</td> 
   <td>1178&nbsp;★; 980&nbsp;commits, latest&nbsp;2021-06-15</td> 
   <td><a href="https://hub.docker.com/r/dreamfactorysoftware/df-docker/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/Softmotions/ejdb" title="EJDB2" rel="nofollow">EJDB2</a></td> 
   <td>EJDB2</td> 
   <td>REST</td> 
   <td>C</td> 
   <td>MIT</td> 
   <td>1229&nbsp;★; 2512&nbsp;commits, latest&nbsp;2021-08-12</td> 
   <td>A database with a built-in REST API.&nbsp;<a href="https://github.com/Softmotions/ejdb" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/pyeve/eve" title="Eve" rel="nofollow">Eve</a></td> 
   <td>MongoDB; extensions for Elasticsearch, Neo4j, SQLAlchemy (SQL databases).</td> 
   <td>REST</td> 
   <td>Python 2/3</td> 
   <td>BSD (three-clause)</td> 
   <td>6370&nbsp;★; 3303&nbsp;commits, latest&nbsp;2021-03-14</td> 
   <td>The SQLAlchemy extension isn't automatic. It requires the user to write SQLAlchemy mappings.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/hasura/graphql-engine" title="Hasura GraphQL Engine" rel="nofollow">Hasura GraphQL Engine</a></td> 
   <td>PostgreSQL</td> 
   <td>GraphQL</td> 
   <td>Haskell</td> 
   <td>Apache 2.0</td> 
   <td>23786&nbsp;★; 3331&nbsp;commits, latest&nbsp;2021-08-13</td> 
   <td><a href="https://hub.docker.com/r/hasura/graphql-engine/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/prometheusresearch/htsql" title="HTSQL" rel="nofollow">HTSQL</a></td> 
   <td>MySQL, PostgreSQL, SQLite (free); Oracle, MS SQL (proprietary)</td> 
   <td>REST</td> 
   <td>Python 3</td> 
   <td>Apache 2.0, proprietary (Oracle and MS SQL support)</td> 
   <td>8&nbsp;★; 1235&nbsp;commits, latest&nbsp;2020-08-11</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/neo4j-graphql/neo4j-graphql" title="neo4j-graphql" rel="nofollow">neo4j-graphql</a></td> 
   <td>Neo4j</td> 
   <td>GraphQL</td> 
   <td>Kotlin</td> 
   <td>Apache 2.0</td> 
   <td>439&nbsp;★; 164&nbsp;commits, latest&nbsp;2020-10-22</td> 
   <td>Can generate a GraphQL API from an existing database or derive a new database model from a GraphQL schema and auto-generate the resolvers.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/orientechnologies/orientdb" title="OrientDB" rel="nofollow">OrientDB</a></td> 
   <td>OrientDB</td> 
   <td>REST</td> 
   <td>Java</td> 
   <td>Apache 2.0</td> 
   <td>4334&nbsp;★; 20555&nbsp;commits, latest&nbsp;2021-08-13</td> 
   <td>A database with a built-in REST API.&nbsp;<a href="https://store.docker.com/images/orientdb" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/mevdschee/php-crud-api" title="PHP-CRUD-API" rel="nofollow">PHP-CRUD-API</a></td> 
   <td>MySQL, PostgreSQL, MS SQL Server.</td> 
   <td>REST</td> 
   <td>PHP 7</td> 
   <td>MIT</td> 
   <td>2804&nbsp;★; 1922&nbsp;commits, latest&nbsp;2021-06-28</td> 
   <td>Supports GIS + automatic OpenAPI 3.0 docs.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/graphile/postgraphile" title="PostGraphile" rel="nofollow">PostGraphile</a></td> 
   <td>PostgreSQL</td> 
   <td>GraphQL</td> 
   <td>TypeScript (Node.js)</td> 
   <td>MIT</td> 
   <td>10561&nbsp;★; 1308&nbsp;commits, latest&nbsp;2021-08-12</td> 
   <td>Formerly "PostGraphQL",&nbsp;<a href="https://hub.docker.com/r/postgraphql/postgraphql/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/PostgREST/postgrest" title="PostgREST" rel="nofollow">PostgREST</a></td> 
   <td>PostgreSQL</td> 
   <td>REST</td> 
   <td>Haskell</td> 
   <td>MIT</td> 
   <td>17432&nbsp;★; 1907&nbsp;commits, latest&nbsp;2021-04-25</td> 
   <td><a href="https://hub.docker.com/r/postgrest/postgrest/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/prest/prest" title="pREST" rel="nofollow">pREST</a></td> 
   <td>PostgreSQL</td> 
   <td>REST</td> 
   <td>Go</td> 
   <td>MIT</td> 
   <td>2766&nbsp;★; 1343&nbsp;commits, latest&nbsp;2021-08-12</td> 
   <td><a href="https://hub.docker.com/r/prest/prest/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/geekypedia/pRESTige" title="pRESTige" rel="nofollow">pRESTige</a></td> 
   <td>MySQL</td> 
   <td>REST</td> 
   <td>PHP</td> 
   <td>MIT</td> 
   <td>66&nbsp;★; 1076&nbsp;commits, latest&nbsp;2020-10-30</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/SoftInstigate/restheart" title="RESTHeart" rel="nofollow">RESTHeart</a></td> 
   <td>MongoDB</td> 
   <td>REST</td> 
   <td>Java</td> 
   <td>GNU AGPLv3</td> 
   <td>683&nbsp;★; 3531&nbsp;commits, latest&nbsp;2021-08-13</td> 
   <td><a href="https://hub.docker.com/r/softinstigate/restheart/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/restsql/restsql" title="restSQL" rel="nofollow">restSQL</a></td> 
   <td>MySQL, PostgreSQL</td> 
   <td>REST</td> 
   <td>Java</td> 
   <td>MIT</td> 
   <td>126&nbsp;★; 54&nbsp;commits, latest&nbsp;2018-10-18</td> 
   <td><a href="https://hub.docker.com/r/restsql/service/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/jeffknupp/sandman2" title="sandman2" rel="nofollow">sandman2</a></td> 
   <td>All supported by SQLAlchemy (MySQL, PostgreSQL, SQLite, Oracle, MS SQL, and others).</td> 
   <td>REST</td> 
   <td>Python 2/3</td> 
   <td>Apache 2.0</td> 
   <td>1726&nbsp;★; 250&nbsp;commits, latest&nbsp;2020-12-21</td> 
   <td><a href="https://hub.docker.com/r/jeffknupp/sandman2/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/siodb/siodb" title="Siodb" rel="nofollow">Siodb</a></td> 
   <td>Siodb</td> 
   <td>REST</td> 
   <td>C++, Go</td> 
   <td>GNU AGPLv3</td> 
   <td>36&nbsp;★; 250&nbsp;commits, latest&nbsp;2021-08-12</td> 
   <td>A database with a built-in REST API.&nbsp;<a href="https://hub.docker.com/r/siodb/siodb/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://subzero.cloud/" title="subZero" rel="nofollow">subZero</a></td> 
   <td>PostgreSQL</td> 
   <td>REST and GraphQL</td> 
   <td>Haskell, Lua</td> 
   <td>Proprietary</td> 
   <td>n/a</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/bradleyboy/tuql" title="tuql" rel="nofollow">tuql</a></td> 
   <td>SQLite 3 or SQL infile</td> 
   <td>GraphQL</td> 
   <td>JavaScript (Node.js)</td> 
   <td>MIT</td> 
   <td>559&nbsp;★; 72&nbsp;commits, latest&nbsp;2021-06-06</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/nicolasff/webdis" title="Webdis" rel="nofollow">Webdis</a></td> 
   <td>Redis</td> 
   <td>REST</td> 
   <td>C</td> 
   <td>BSD (two-clause)</td> 
   <td>2417&nbsp;★; 567&nbsp;commits, latest&nbsp;2021-08-05</td> 
   <td>Supports pub/sub with chunked transfer encoding and WebSockets.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/xgenecloud/xgenecloud" title="XgeneCloud" rel="nofollow">XgeneCloud</a></td> 
   <td>MySQL, PostgreSQL, MS SQL, SQLite, MariaDB, Amazon Aurora</td> 
   <td>REST and GraphQL</td> 
   <td>JavaScript (Node.js)</td> 
   <td>Apache 2.0</td> 
   <td>1540&nbsp;★; 66&nbsp;commits, latest&nbsp;2021-05-16</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/o1lab/xmysql" title="xmysql" rel="nofollow">xmysql</a></td> 
   <td>MySQL</td> 
   <td>REST</td> 
   <td>JavaScript (Node.js)</td> 
   <td>MIT</td> 
   <td>30&nbsp;★; 3&nbsp;commits, latest&nbsp;2021-05-27</td> 
   <td><a href="https://hub.docker.com/r/markuman/xmysql/" title="Official Docker image" rel="nofollow">Official Docker image</a>.</td> 
  </tr> 
  <tr> 
   <td><a href="https://github.com/BjoernKW/ZenQuery" title="ZenQuery" rel="nofollow">ZenQuery</a></td> 
   <td>PostgreSQL, MySQL, IBM Db2, Oracle Database, Microsoft SQL Server and&nbsp;<a href="https://github.com/BjoernKW/ZenQuery#database" title="others" rel="nofollow">others</a></td> 
   <td>REST</td> 
   <td>Java</td> 
   <td>Apache 2.0</td> 
   <td>56&nbsp;★; 283&nbsp;commits, latest&nbsp;2018-10-16</td> 
   <td>Read-only.</td> 
  </tr> 
 </tbody> 
</table>

[GitHub - dbohdan_automatic-api_ A list of software that turns your database into a REST_GraphQL API]: https://github.com/dbohdan/automatic-api