triplit
sqlsync
triplit | sqlsync | |
---|---|---|
5 | 7 | |
870 | 1,731 | |
9.0% | 2.8% | |
9.9 | 9.2 | |
13 days ago | 2 months ago | |
TypeScript | Rust | |
GNU Affero General Public License v3.0 | 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.
triplit
-
Triplit: Open-source DB that syncs data between server and browser in real-time
If you want to try that out, we use Sqlite in our server implementation so you can see an example there: https://github.com/aspen-cloud/triplit/blob/main/packages/se...
-
Show HN: RemoteStorage – sync localStorage across devices and browsers
Your app might not need it but if you want partial replication or relational querying in addition to offline-first syncing then check out https://github.com/aspen-cloud/triplit (disclaimer: I'm working on this)
- Show HN: Triplit – The Full-Stack Database
-
SQLSync – Stop Building Databases
I'm currently writing a very similar article about "full-stack databases" which highlights the same pattern where many apps end recreating the logic of our backend and database in the frontend client code. The solution we're promoting is to choose a database that can run on both the server and in the client and then sync between them.
The reason we aren't using Sqlite for our product is because Sql is frankly not the right tool for querying data for an application. It doesn't easily map to the data-structures you want in your client code and nearly all SQL databases have no way to subscribe to changes to a query without polling the query repeatedly.
So if you like the idea of having a complete database on your client but also want deep integration with Typescript/Javascript check out what we're building at https://github.com/aspen-cloud/triplit
sqlsync
-
A future for SQL on the web (2021)
If you're looking for a very real use case of SQLite in the browser, there's SQLSync[1]. It was recently discussed on HN[2].
[1]: https://sqlsync.dev/posts/stop-building-databases/, https://sqlsync.dev/
- SQLSync: Collaborative Offline-first SQLite
-
SQLSync – Stop Building Databases
No, there is a client part: https://github.com/orbitinghail/sqlsync/blob/main/GUIDE.md
> Step 2: Install and configure the React library
- SQLSync: Collaborative Offline-First SQLite
-
Some notes on local-first development
Here's another local-first collaborative component: SQLSync [0]
[0] https://github.com/orbitinghail/sqlsync
- SQLSync is a collaborative offline-first wrapper around SQLite
What are some alternatives?
drumroll-music - Full Stack Website for Uploading and Streaming Music Built using Next.JS and Supabase
localfirstweb.dev - A list of various resources for local-first web development
excalidraw - Virtual whiteboard for sketching hand-drawn like diagrams
sea-query - 🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite
RxDB - A fast, local first, reactive Database for JavaScript Applications https://rxdb.info/
rusqlite - Ergonomic bindings to SQLite for Rust
remote-storage - remoteStorage is a simple library that combines the localStorage API with a remote server to persist data across sessions, devices, and browsers. It works as a simple key value database store and backend with support for React, Next.js, Vue, Node, or any Javascript stack
wa-sqlite - WebAssembly SQLite with experimental support for browser storage extensions
TanStack Query - 🤖 Powerful asynchronous state management, server-state utilities and data fetching for the web. TS/JS, React Query, Solid Query, Svelte Query and Vue Query.
evolu - Local-first platform designed for privacy, ease of use, and no vendor lock-in
htmx - </> htmx - high power tools for HTML