datasette-graphql
tuql
Our great sponsors
datasette-graphql | tuql | |
---|---|---|
2 | 5 | |
97 | 1,035 | |
- | - | |
4.1 | 3.8 | |
19 days ago | almost 3 years ago | |
Python | JavaScript | |
Apache License 2.0 | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
datasette-graphql
-
Tuql: Automatically create a GraphQL server from a SQLite database
Impressive how little code is involved here! This is really neat.
The biggest feature I can see that's missing is pagination - it looks like this doesn't have a way to retrieve e.g. ten results, then pass a next token to get back the next set.
Here's how I implemented pagination in my similar datasette-graphql plugin (which also gives you a GraphQL API for an existing SQLite database): https://github.com/simonw/datasette-graphql#pagination
-
Are there open source projects to view that would help me understand cursors/pagination/edges/nodes & Inmemorycache ?
My source code is here, but it likely won't be much use to you - it's full of weird introspection because I'm trying to make this work against any database table: https://github.com/simonw/datasette-graphql/blob/1.4/datasette_graphql/utils.py
tuql
- Tuql: Automatically create a GraphQL server from a SQLite database
-
postlite: Postgres wire compatible SQLite proxy.
Postlite fakes the pg_catalog but it would probably take some work to get it good enough to work with a GraphQL wrapper. Those also may use SQL that's only supported by Postgres since they usually try to bundle up fetches into a single query. I think you're probably better off using a wrapper specific to SQLite such as tuql.
- Ws4sqlite: Query SQLite via HTTP
What are some alternatives?
datasette-dashboards - Datasette plugin providing data dashboards from metadata
ws4sqlite - Query sqlite via json+http
csvs-to-sqlite - Convert CSV files into a SQLite database
sqlite-s3-query - Python functions to query SQLite files stored on S3
pluralize - Pluralize or singularize any word based on a count
aurora - CLI tool that orchestrates prisma files in a way that allows multiple .prisma files with cross-relations
datasette-auth-github - Datasette plugin that authenticates users against GitHub
postlite - Postgres wire compatible SQLite proxy.
madatdata - 😠📈 Madatdata ("mad at data") is a TypeScript library for managing and querying SQL databases (so far including Seafowl and Splitgraph, but with an interface that makes it easy to add plugins for other databases).
sqlite3vfshttp - Go sqlite3 http vfs: query sqlite databases over http with range headers
datasette-chatgpt-plugin - A Datasette plugin that turns a Datasette instance into a ChatGPT plugin
graphql-sequelize-generator - A Graphql API generator based on Sequelize.