datasette-graphql
csvs-to-sqlite
Our great sponsors
| datasette-graphql | csvs-to-sqlite | |
|---|---|---|
| 2 | 4 | |
| 97 | 858 | |
| - | - | |
| 4.1 | 0.0 | |
| 19 days ago | 4 months ago | |
| Python | Python | |
| Apache License 2.0 | Apache License 2.0 |
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
csvs-to-sqlite
-
Turning database into a searchable dashboard?
Oh what's that you say, your data is in CSV and you don't want to write code to load them up into a database, well try this https://github.com/simonw/csvs-to-sqlite
-
Show HN: Work with CSV files using SQL. For data scientists and engineers
The datasette author offers this tool for conversion: https://github.com/simonw/csvs-to-sqlite
-
Datasette 0.58: The annotated release notes
There's csvs-to-sqlite which allows converting CSVs to SQLite (dumping part of another database to CSV should be more or less trivial). There's also Dogsheep, which can convert more esoteric data sources like GitHub and HackerNews to SQLite. Recently, Simon worked on Django SQL Dashboard, which brings a subset of Datasette to Django.
-
I made a regexp cheatsheet for grep, sed, awk and highlighted differences between them
And sometimes it's nice to throw csv files into a database. You can do that with https://github.com/simonw/csvs-to-sqlite
What are some alternatives?
datasette-dashboards - Datasette plugin providing data dashboards from metadata
db-benchmark - reproducible benchmark of database-like ops
pluralize - Pluralize or singularize any word based on a count
octosql - OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
datasette-auth-github - Datasette plugin that authenticates users against GitHub
textql - Execute SQL against structured text like CSV or TSV
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).
sqlitebrowser - Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
datasette-chatgpt-plugin - A Datasette plugin that turns a Datasette instance into a ChatGPT plugin
datasette - An open source multi-tool for exploring and publishing data
tuql - Automatically create a GraphQL server from a SQLite database or a SQL file
sqlite-utils - Python CLI utility and library for manipulating SQLite databases