taxi-react-app
datasette
Our great sponsors
| taxi-react-app | datasette | |
|---|---|---|
| 1 | 142 | |
| 59 | 6,990 | |
| - | - | |
| 0.0 | 9.5 | |
| 26 days ago | 3 days ago | |
| JavaScript | Python | |
| - | 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.
taxi-react-app
datasette
- The Untold Story of SQLite
-
Open Source Project to Create a Comprehensive Food Database [Help wanted]
Very cool. Have you considered making the data available as a (static) Datasette website? https://datasette.io/ You can probably host it on Github pages for free.
-
I'm sure I'm being stupid.. Copying data from an API and making a database
My project https://datasette.io/ is ideal for this kind of thing. You can use https://sqlite-utils.datasette.io/ to load JSON data into a SQLite database, then publish it with Datasette.
-
Datasette is my data hammer
I'm definitely keen on suggestions for improvements I can make to the default UI.
Datasette provides both a JSON API (easily enabled for CORS access) and supports custom templates, so it's possible to customize the UI any way you like.
So far I've not seen many examples of extensive customization. I use the custom templates a lot myself - these four sites are all just regular Datasette with some custom templates:
- https://til.simonwillison.net/
- https://www.niche-museums.com/
- https://www.rockybeaches.com/us/pillar-point
Source code is on GitHub for all four.
- WAL Mode in LiteFS
-
ETL recommendations? (personal project)
Thinking I might be able to use datasette.io for some easy query and data viz. Can probably host the result on a private VPN using something like tailscale.com
-
Hanukkah of Data 2022 - Puzzle 2
VisiData is great for quick exploration and can perform joins, but considering the number of tables involved I figured this would be more straightforward with SQL. And since SQLite was an available format, Datasette seemed like a great fit.
- PostgREST – Serve a RESTful API from Any Postgres Database
-
[SQLlite] Is there any online SQL editor I can host on my website? Maybe something in JS or php
This might be helpful: https://datasette.io/
-
Go and SQLite in the Cloud
A long way off from PostgREST, but you might be able to hack together something sort of similar with Datasette [0] and the new JSON api. Not out of the box at all, but the potential is there to get a similar product.
What are some alternatives?
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
duckdb - DuckDB is an in-process SQL OLAP Database Management System
sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages
gomodest - A complex SAAS starter kit using Go, the html/template package, and sprinkles of javascript.
litestream - Streaming replication for SQLite.
Sequel-Ace - MySQL/MariaDB database management for macOS
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
dbhub.io - A "Cloud" for SQLite databases. Collaborative development for your data. :)
temporal_tables - Temporal Tables PostgreSQL Extension
Sapper - The next small thing in web development, powered by Svelte
roapi - Create full-fledged APIs for slowly moving datasets without writing a single line of code.
sqlitebrowser - Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at: