cr-sqlite
Monica
cr-sqlite | Monica | |
---|---|---|
28 | 151 | |
2,434 | 20,736 | |
3.2% | 0.9% | |
9.6 | 9.3 | |
8 days ago | 12 days ago | |
Rust | PHP | |
MIT License | GNU Affero General Public License v3.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.
cr-sqlite
-
Show HN: RemoteStorage – sync localStorage across devices and browsers
I'm a happy user of https://github.com/vlcn-io/cr-sqlite/
-
Marmot: Multi-writer distributed SQLite based on NATS
If you're interested in this, here are some related projects that all take slightly different approaches:
- LiteSync directly competes with Marmot and supports DDL sync, but is closed source commercial (similar to SQLite EE): https://litesync.io
- dqlite is Canonical's distributed SQLite that depends on c-raft and kernel-level async I/O: https://dqlite.io
- cr-sqlite is a Rust-based loadable extension that adds CRDT changeset generation and reconciliation to SQLite: https://github.com/vlcn-io/cr-sqlite
Slightly related but not really (no multi writer, no C-level SQLite API or other restrictions):
- comdb2 (Bloombergs multi-homed RDMS using SQLite as the frontend)
- rqlite: RDMS with HTTP API and SQLite as the storage engine, used for replication and strong consistency (does not scale writes)
- litestream/LiteFS: disaster recovery replication
- liteserver: active read-only replication (predecessor of LiteSync)
-
Offline eventually consistent synchronization using CRDTS
Theory is great, but how can we apply this in practice? Instead of starting from 0, and writing a CRDT, let's try and leverage an existing project to do the heavy lifting. My choice is crSQLITE, an extension for SQLite to support CRDT merging of databases. Under the hood, the extension creates tables to track changes and allow inserting into an event log for merging states of separated peers.
-
Local-first software: You own your data, in spite of the cloud (2019)
Also https://github.com/vlcn-io/cr-sqlite/ which is SQLite + CRDTs
Runs/syncs to the browser too which is just lovely.
-
I'm All-In on Server-Side SQLite
If you need multiple writers and can handle eventual correctness, you should really be using cr-sqlite[1]. It'll allow you to have any number of workers/clients that can write locally within the same process (so no network overhead) but still guarantee converge to the same state.
[1] https://github.com/vlcn-io/cr-sqlite
-
Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps
I am fully on the offline-first bandwagon after starting to use cr-sqlite (https://vlcn.io), which works similar to ElectricSQL.
I thought the bundle size of wasm-sqlite would be prohibitive, but it's surprisingly quick to download and boot. Reducing network reliance solves so many problems and corner-cases in my web app. Having access to local data makes everything very snappy too - the user experience is much better. Even if the user's offline data is wiped by the browser (offline storage limits are a bit of a minefield), it is straightforward to get all synced changes back from the server.
-
Launch HN: Tiptap (YC S23) – Toolkit for developing collaborative editors
I didn't know that. Especially the first approach sounds interesting to me, because as far as I know the transactions of Yjs seem to be a problem on heavily changing documents. https://github.com/vlcn-io/cr-sqlite#approach-1-history-free... Thanks!
- Scaling Linear's Sync Engine
-
Mycelite: SQLite extension to synchronize changes across SQLite instances
I wonder how this compares to https://vlcn.io?
-
Ask HN: Incremental View Maintenance for SQLite?
The short ask: Anyone know of any projects that bring incremental view maintenance to SQLite?
The why:
Applications are usually read heavy. It is a sad state of affairs that, for these kinds of apps, we don't put more work on the write path to allow reads to benefit.
Would the whole No-SQL movement ever even have been a thing if relational databases had great support for materialized views that updated incrementally? I'd like to think not.
And more context:
I'm working to push the state of "functional relational programming" [1], [2] further forward. Materialized views with incremental updates are key to this. Bringing them to SQLite so they can be leveraged one the frontend would solve this whole quagmire of "state management libraries." I've been solving the data-sync problem in SQLite (https://vlcn.io/) and this piece is one of the next logical steps.
If nobody knows of an existing solution, would love to collaborate with someone on creating it.
[1] - https://github.com/papers-we-love/papers-we-love/blob/main/design/out-of-the-tar-pit.pdf
Monica
- Selfhosting services to make life easier for my parents?
-
Open Source Projects You Can Lay Your Hand On
Monica is a Personal Relationship Management (PRM) web application developed on PHP by Monicahq. The main aim of this project is to help individuals to organize and record their interactions with others. It works as a CRM tailored for managing relationships with friends and family. The Monica project is designed for individuals who struggle to remember important details about the lives of people they care about, including those with conditions, like Asperger syndrome or Alzheimer’s disease. It provides a private and personal space for users to keep track of essential information about their friends and family.
-
Ask HN: As a hobbyist developer, what are the odds of getting hired as a pro?
I've created some OSS projects, one of them being Monica [1], an open source CRM which pops up sometimes on HN. The project has more than 20k+ stars and a lot of contributors. I've also created other projects (OfficeLife [2], Bivouac [3]).
However, all these are passion projects, worked on at nights and weekends. My day job is about project management (currently a very senior position) at various big corps.
I would like to switch careers and become a professional full stack developer. I can't choose between backend and frontend since I've done everything on my projects. I only know Laravel, Vue 3, HTMX. I have to deploy my projects myself, maintain them myself, and design everything myself.
I'm not an expert in anything, but I know a bit of everything that is required to ship something that works.
That being said, what are the chances of being hired as a professional developer? Will I be taken seriously?
[1]: https://github.com/monicahq/monica
-
Show HN: A “CRM” for your personal relationships
I've been using Monica [1] for the personal CRM and it does what it is supposed to do. It's a basic web app and lacks the sophistication moderns apps have, but it hasn't died for 5 years at least. Just FYI.
[1] https://www.monicahq.com/
-
Looking for a cli tool like Monica
I am looking for some kind of cli/tui app that has similar functionality as Monica.
-
New version of Monica, codename Chandler, is available in beta
My wife and I tried to use Monica for many months in the past but had to give up because of the incredibly buggy CardDAV implementation when using iOS. Now that this has come out it seems the issue (https://github.com/monicahq/monica/issues/6175) was ignored likely because of all this work.
Have improvements been made with this in the new version?
-
Is anyone using an alternative to or modified version of Eloquent with Laravel?
Example: https://github.com/monicahq/monica/blob/chandler/app/Models/Contact.php
-
Keep a list of gift ideas on your phone and add to it though the year, so you're never wondering what to get someone last minute
That does remind me of this project: https://github.com/monicahq/monica
- Any Diarium (journaling) alternative?
-
Monica VS DiceCRM - a user suggested alternative
2 projects | 21 May 2023
What are some alternatives?
electric - Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres.
Baïkal - Baïkal is a Calendar+Contacts server
marmot - A distributed SQLite replicator built on top of NATS
CyberChef - The Cyber Swiss Army Knife - a web app for encryption, encoding, compression and data analysis
vlcn-orm - Develop with your data model anywhere. Query and load data reactively. Replicate between peers without a central server.
CapRover - Scalable PaaS (automated Docker+nginx) - aka Heroku on Steroids
edgedb-go - The official Go client library for EdgeDB
TeslaMate - A self-hosted data logger for your Tesla 🚘
imdbench - IMDBench — Realistic ORM benchmarking
Ulterius
edgedb-cli - The EdgeDB CLI
blynk - Blynk is an Internet of Things Platform aimed to simplify building mobile and web applications for the Internet of Things. Easily connect 400+ hardware models like Arduino, ESP8266, ESP32, Raspberry Pi and similar MCUs and drag-n-drop IOT mobile apps for iOS and Android in 5 minutes