|1 day ago||1 day ago|
|GNU General Public License v3.0 or later||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.
Show HN: Distributed SQLite on FoundationDB
5 projects | news.ycombinator.com | 28 Jul 2022
Why SQLite may become foundational for digital progress
9 projects | news.ycombinator.com | 22 May 2022
Bloomberg  uses SQLite in a custom distributed RDBMS engine of theirs in a way I lack the knowledge to completely understand its design.
I remember Richard Hipp mentioning Bloomberg in one of his interviews (don't ask me which one, I don't remember), that they use SQLite to serve billions of bank transaction on a daily basis without a problem.
The Untold Story of SQLite
3 projects | news.ycombinator.com | 28 Jan 2023
Open Source Project to Create a Comprehensive Food Database [Help wanted]
2 projects | reddit.com/r/Database | 26 Jan 2023
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
2 projects | reddit.com/r/Database | 19 Jan 2023
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
6 projects | news.ycombinator.com | 18 Jan 2023
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:
Source code is on GitHub for all four.
WAL Mode in LiteFS
9 projects | news.ycombinator.com | 4 Jan 2023
ETL recommendations? (personal project)
2 projects | reddit.com/r/dataengineering | 30 Dec 2022
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
2 projects | dev.to | 30 Dec 2022
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
22 projects | news.ycombinator.com | 29 Dec 2022
[SQLlite] Is there any online SQL editor I can host on my website? Maybe something in JS or php
4 projects | reddit.com/r/SQL | 20 Dec 2022
This might be helpful: https://datasette.io/
Go and SQLite in the Cloud
9 projects | news.ycombinator.com | 7 Dec 2022
A long way off from PostgREST, but you might be able to hack together something sort of similar with Datasette  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
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: