On 2019-10-16 01:47, Peng Yu wrote:
Is there a solution that are known to fill in this niche? Thanks.
Would be clusteded SQLite (distributed SQLite instead of central shared
DB) be a good option for your project? - Bellow, I am pasting my
bookmarks for few well established projects developing that approach.
Kind Regards,
Alek
- notes:
- label: SQLite notes
- theme:
- label: SQLite Clustering
xmlns:n: decl:sqlite-notes-1
- project:
- gh: https://github.com/canonical/dqlite
- bookmark:
- label: WAL replication patch on top of the original SQLite tree
url:
https://sourcegraph.com/github.com/canonical/sqlite/-/compare/version-3.29.0...version-3.29.0%2Breplication3
- n:replication:
- style-code: single-master/bininary-log-shipping
- bookmark:
- url: https://en.wikipedia.org/wiki/Log_shipping
- n:interface:
- style-code: exising-c-api/patched-lib/libsqlite3
- note:
- >-
Supports existing SQLite Linux application, by switching to
patched libsqlite3
- note:
- >-
Out of the box build for Windows is not ready yet.
- n:interface:
- style-code: custom-protocol/binary-wire-protocol
url:
https://github.com/canonical/dqlite/blob/master/doc/protocol.md
- project:
- name: BedrockDB
gh: https://github.com/Expensify/Bedrock
license-code: MIT
- n:replication:
- style-code: single-master/distribute-update-sql-statements
- documentation:
- url: https://bedrockdb.com/blockchain.html
- documentation:
- url: https://bedrockdb.com/synchronization.html
- n:interface:
- style-code: exising-protocol/mysql-wire-protocol
url: https://bedrockdb.com/#how-to-use-it
- note:
- >-
Supports any MySQL client (But of course accpets only
SQLite SQL dialect)
- n:interface:
- style-code: exising-protocol/mysql-wire-protocol
- note:
- >-
Trivial socket protocol, json results
- n:interface:
- style-code: cli-tool
- project:
- name: rqlite
gh: https://github.com/rqlite/rqlite
license-code: MIT
- replication:
- style-code: single-master/distribute-update-sql-statements
- bookmark:
- tag: news-articles
url: http://www.philipotoole.com/tag/rqlite/
- note:
- >-
News about rqlite, gorqlite
- n:interface:
- style-code: rest-api
url: https://github.com/rqlite/rqlite/blob/master/DOC/DATA_API.md
- note:
- >-
Interface style: Serving HTTP API
- n:interface:
- style-code: cli-tool
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
