Is there a free software addition to SQLite available for data-replication?

Question

I am aware of the possibility to create my own trigger(ed) solution, but I didn't want to reinvent the wheel :-)

score 6 · Accepted Answer · edited Mar 08 '11 at 20:02

6

Berkeley DB's SQL API is completely SQLite compatible and offers HA/replication for high availability. The combination of SQLite's easy-of-use and Berkeley DB's scalability and reliability are a great combination.

Disclaimer: I'm the Product Manager for Berkeley DB, so I'm a little biased. However, one of the main benefits of adding the SQLite API to Berkeley DB is that SQLite applications can now have HA/replication for mission-critical, highly available applications.

edited Mar 08 '11 at 20:02

Gaius

11,200
3
31
64

answered Mar 08 '11 at 19:47

dsegleau

176
2

1

I read from the docs: Only the master node can modify the database. So this is not for me :-( – ralf.w. Mar 09 '11 at 08:10

Bernardo Ramos · Answer 2 · 2020-12-21T17:29:42.190

2

Yes, there are some:

LiteReplica (Single master)
LiteSync (Multi-master)
AergoLite (Blockchain based)

They are additions to the SQLite3 code. The interface is unchanged so we don't need to change the application code.

Disclosure: I am the creator

edited Dec 21 '20 at 17:29

answered Nov 15 '15 at 22:52

Bernardo Ramos

131
3

Is there a free software addition to SQLite available for data-replication?

2 Answers2