|8 days ago||about 1 month 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.
I'm All-In on Server-Side SQLite
7 projects | news.ycombinator.com | 22 Sep 2023
SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s
5 projects | news.ycombinator.com | 12 Apr 2023
I'd be curious for a similar tuning with Dqlite: https://github.com/canonical/dqlite
Strong Consistency with Raft and SQLite
6 projects | news.ycombinator.com | 21 Mar 2023
9 years of open-source database development: reviewing the designs
2 projects | /r/programming | 10 Mar 2023
Anyone knows how the DB this is about, https://rqlite.io/, compares with https://dqlite.io/ by Canonical (both seem to be distributed versions of sqlite)?
SQLite the only database you will ever need in most cases
12 projects | news.ycombinator.com | 15 Feb 2023
Transcending Posix: The End of an Era?
8 projects | news.ycombinator.com | 10 Sep 2022
For folks' context, the new tool that's being discussed in the thread mentioned by the parent here is litefs , as well as which you can also look at rqlite  and dqlite , which all provide different trade-offs (e.g. rqlite is 'more strongly consistent' than litefs).
SQLite is not a toy database
10 projects | news.ycombinator.com | 15 Aug 2022
GitDB, a distributed embeddable database on top of Git
4 projects | news.ycombinator.com | 5 Jul 2022
Check out dqlite, it's sqlite but with a raft consensus to distribute changes through a log: https://dqlite.io/ You can link it in as a library too, it sounds like exactly what you want.
Ask HN: Free and open source distributed database written in C++ or C
12 projects | news.ycombinator.com | 16 May 2022
Fly.io Buys Litestream
15 projects | news.ycombinator.com | 9 May 2022
I’m sure there’s more, those are just the ones I remember.
Show HN: My Single-File Python Script I Used to Replace Splunk in My Startup
6 projects | news.ycombinator.com | 21 Sep 2023
Not only that, but with https://litestream.io/ things becomes even more interesting.
I'm currently using this for a small application to easily backup databases in docker containers.
Fly.io Postgres cluster went down for 3 days, no word from them about it
9 projects | news.ycombinator.com | 20 Jul 2023
Mycelite: SQLite extension to synchronize changes across SQLite instances
8 projects | news.ycombinator.com | 25 Jun 2023
Be interested to hear a comparison between this lib and litestream/litefs, which seem to be actively developed by fly.io for a similar use case
The Stupid Programmer Manifesto
3 projects | news.ycombinator.com | 15 Jun 2023
I mean, not really. The hard work was done by benbjohnson who is now working on https://litestream.io/ and https://fly.io/
I put a relatively thin layer on top of it.
Now, to address your point more directly: I'm too stupid to figure out configuration, but not too stupid to figure out code. Code gets compiled and type checked. You can have tests, etc. Tractability for code is much higher than configuration.
With configuration, you have to be really smart and keep many moving parts in your head.
With code, you can be a bit dumb and lean heavily on the tooling.
D1: We turned it up to 11
8 projects | news.ycombinator.com | 19 May 2023
Ah you're right!
I thought this was a wrapper for Litestream but apparently it's a parallel project by the same author who Fly hired.
Show HN: Capillaries: Distributed data processing with Go and Cassandra
2 projects | news.ycombinator.com | 15 May 2023
snips.sh: passwordless, anonymous SSH-powered pastebin
5 projects | /r/golang | 12 May 2023
Currently this is all running on a single DigitalOcean droplet (plus DO object storage for the SQLite DB backups with Litestream). Since it's just using SQLite (def helps keep costs down vs. anything hosted) I just need to monitor disk at the moment.
Ask HN: It's 2023, how do you choose between MySQL and Postgres?
7 projects | news.ycombinator.com | 11 May 2023
Just to point out, there are now SQLite replication and various "distributed database" projects which seem to work fairly well.
They're probably not as battle tested as the PostgreSQL ones, but they are around, have users, and are actively developed.
The ones I remember off the top of my head:
* https://github.com/rqlite/rqlite <-- more of a "distributed database using RAFT" type of thing
Go with PHP
19 projects | news.ycombinator.com | 10 May 2023
I left PHP for Go.
- with http://sqlc.dev I don't have to write ORM or model code anymore.
- with http://goa.design I can have well-documented API's that any team can generate a client for in any language. It also generates the HTTP JSON and gRPC servers for me so I can focus on my logic.
- with https://github.com/99designs/gqlgen I can define GraphQL revolvers that play well with sqlc (any RDBMS) or I can use a key-value store.
- speaking of key-value stores, Go allows them to be embedded! Even SQLite now has the https://litestream.io/ project to make it super simple to use a durable, always backed-up SQLite database even in a serverless context.
Go is faster, uses less memory, and has really-well designed stdlib without all the bugs I used to face trying to use the PHP stdlib.
Syncthing: A continuous file synchronization program
9 projects | news.ycombinator.com | 9 May 2023
Syncthing "just" syncs files. Near instantly, which could mean a delay of a few seconds to maybe even a minute. And it won't de-conflict changes beyond saving the "bad" version in a file like `sqlite.db-syncthing-conflict-20230101T043044`.
I like it and IMO it does what it does well. But litestream can "Continuously stream SQLite changes" (pulled from https://litestream.io/, I've never heard of it before). It seems like that's litestream's killer feature, and I think syncthing would leave you wanting.
What are some alternatives?
rqlite - The lightweight, distributed relational database built on SQLite
pocketbase - Open Source realtime backend in 1 file
kine - Run Kubernetes on MySQL, Postgres, sqlite, dqlite, not etcd.
realtime - Broadcast, Presence, and Postgres Changes via WebSockets
k8s-mediaserver-operator - Repository for k8s Mediaserver Operator project
sqlcipher - SQLCipher is a standalone fork of SQLite that adds 256 bit AES encryption of database files and other security features.
flyctl - Command line tools for fly.io services
datasette - An open source multi-tool for exploring and publishing data
PostgreSQL - Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
better-sqlite3 - The fastest and simplest library for SQLite3 in Node.js.