maxpert/marmot on Hacker News

Working on Marmot https://github.com/maxpert/marmot recently added support for vector index. My local benchmarks show pretty decent QPS with less than GB of RSS on DBpedia dataset. Interesting part is that I started off implementing a…

comment by maxpert · 2026-05-10 · in Ask HN: What are you working on? (May 2026)

I am as usual working on Marmot https://github.com/maxpert/marmot I've got replicas now working with DML proxy. This essentially means I can now have a cluster of primaries, and then spin up replicas on demand and nodes talking to local…

comment by maxpert · 2026-02-08 · in Ask HN: What are you working on? (February 2026)

…working on to build tenancy on top of SQLite CDC to make it a simple repayable SQLite for Marmot ( https://github.com/maxpert/marmot ). I personally think we have a synergy here, would drop by your discord.

comment by maxpert · 2026-01-23 · in Show HN: S2-lite, an open source Stream Store

Disclaimer: I am author of Marmot https://github.com/maxpert/marmot so I will sound extremely bias. I have been asked multiple times on why I chose SQLite and not Turso. I've always responded people that I don't trust an open-source…

comment by maxpert · 2026-01-23 · in Turso is an in-process SQL database, compatible with SQLite

https://github.com/maxpert/marmot?tab=readme-ov-file#limitat...

comment by foldr · 2026-01-02 · in Marmot – A distributed SQLite server with MySQL wire compatible interface

LOL what are the odds, I posted in `Show HN` about Marmot today https://github.com/maxpert/marmot/releases/tag/v2.2.0 and in my head I was thinking exact same thing for supporting MySQL's JSON datatype. At some level I am starting to feel,…

comment by maxpert · 2025-12-12 · in SQLite JSON at full index speed using generated columns

…year hibernation with a big overhaul that introduced a native gossip mechanism to replace NATS/Raft https://github.com/maxpert/marmot/

comment by nchmy · 2025-12-02 · in 100k TPS over a billion rows: the unreasonable effectiveness of SQLite

…years in hibernation, shed its NATS/Raft fat in favour of a native gossip protocol for replication. https://github.com/maxpert/marmot

comment by nchmy · 2025-12-02 · in Show HN: Marmot – Single-binary data catalog (no Kafka, no Elasticsearch)

…D1 system for free . Just a hetzner 4 euro cos is enough. Mine is holding about 200 gb of data. https://github.com/maxpert/marmot

comment by gedw99 · 2025-02-17 · in Searchcode.com’s SQLite database is probably 6 terabytes bigger than yours

…in some scenarios) then there are options like marmot [1] that replicate cdc over nats. [1]: https://github.com/maxpert/marmot

comment by infogulch · 2024-04-09 · in Distributed SQLite: Paradigm shift or hype?

https://github.com/maxpert/marmot is SQLite replication thats eventually consistent and doesnt require a master server.

comment by JohnnyGault · 2023-10-27 · in Why you should probably be using SQLite

I've written a whole SQLite replication system that works on top of RAFT ( https://github.com/maxpert/marmot ). Best part is RAFT has a well understood and strong library ecosystem as well. I started of with libraries and when I noticed I…

comment by maxpert · 2023-09-03 · in The Raft Consensus Algorithm (2015)

Very interesting! I have question ( out of my experience in https://github.com/maxpert/marmot ) how do get around the boot time, specially when a change log of table is pretty large in Postgres? I've implemented snapshotting mechanism in…

comment by maxpert · 2023-08-09 · in SQLedge: Replicate Postgres to SQLite on the Edge

…for my demo. Which reminds me since you folks have mentioned LiteStream, have you tried Marmot ( https://github.com/maxpert/marmot); I recently configured Isso with Marmot to scale it out horizontally (…

comment by maxpert · 2023-07-18 · in Stalwart All-in-One Mail Server (IMAP, JMAP, SMTP)

…you brought it up. I will fill in the perspective of what I am doing for solving this in Marmot ( https://github.com/maxpert/marmot ). Today Marmot already records changes via installing triggers to record changes of a table, hence all the…

comment by maxpert · 2023-07-06 · in LiteFS Cloud: Distributed SQLite with Managed Backups

…throwing in shameless plugs. But for people who might want to look for alternate options, Marmot ( https://github.com/maxpert/marmot ) is another option that can let you both replicate, and backup your database. I have recently embedded…

comment by maxpert · 2023-07-06 · in LiteFS Cloud: Distributed SQLite with Managed Backups

…backend. I would however love prebuilt binaries for Mac, that way I can test it with Marmot ( https://github.com/maxpert/marmot sorry for shameless plug). I wanted to build myself but then the instructions in README discouraged it, not…

comment by maxpert · 2023-07-05 · in Show HN: MongoDB Protocol for SQLite

So while working on Marmot ( https://github.com/maxpert/marmot ) I considered something similar, and the thing that stood obvious with my benchmarks was readers can go really fast if I let them do things in process vs over some protocol…

comment by maxpert · 2023-07-04 · in SQLite-based databases on the Postgres protocol? Yes we can

I will be testing it with Marmot ( https://github.com/maxpert/marmot ) to help scale Wordpress when needed! IMO Wordpress + SQLite is a no brainer for 95% of its sites. Hopefully do a demo video. Marmot will help folks scale their sites…

comment by maxpert · 2022-12-20 · in WordPress to support SQLite back end

Perfect! This will be a perfect use-case for Marmot ( https://github.com/maxpert/marmot ) to help scale Wordpress when needed! People can just publish (low writes + high reads), and Marmot will take care of replicating it as sidecar.…

comment by maxpert · 2022-12-16 · in WordPress testing official SQLite Support

Just in time! I've been planning a SQLite extension written in Rust for Marmot ( https://github.com/maxpert/marmot ) for evaluation purposes. I didn't wanted to touch C/C++ because I feel more comfortable with rust tooling. Thank you for…

comment by maxpert · 2022-12-13 · in SQLite-loadable-rs: A framework for building SQLite Extensions in Rust

Hey, I am author of Marmot ( https://github.com/maxpert/marmot ) would love to get in touch and explore a few things with you. I’ve been using Marmot in production in a while scaling couple of services, and since you mentioned LiteFS I…

comment by maxpert · 2022-12-07 · in Go and SQLite in the Cloud

Ideas in CRSQL are remarkably similar to Marmot ( https://github.com/maxpert/marmot ) except that it doesn't require an extension to be installed, and it can run as sidecar. I can see how having extension makes it simple to intercept…

comment by maxpert · 2022-11-15 · in Crsql – Multi-writer and CRDT support for SQLite

Interesting approach, I use a very similar methodology in Marmot ( https://github.com/maxpert/marmot ) to do CDC for SQLite via triggers, and then these changes are published over NATS, replicated over to other nodes. So row-level…

comment by maxpert · 2022-10-28 · in Push-based outbox pattern with Postgres logical replication