Go database/sql driver based on CGO FREE modernc.org/sqlite, providing high availability for SQLite databases.

• Built on the robust foundation of modernc.org/sqlite.
• High availability support for SQLite databases.
• Replication: Synchronize data across nodes using NATS.
• Customize the replication strategy
• Leaderless clusters: Read/Write from/to any node. Last-writer wins by default, but you can customize conflict resolutions by implementing ChangeSetInterceptor.
• Embedded or External NATS: Choose between an embedded NATS server or an external one for replication.
• Easy to integrate with existing Go projects.

go get github.com/litesql/go-sqlite-ha

package main
import (
    "database/sql"
    _ "github.com/litesql/go-sqlite-ha"
)
func main() {
    db, err := sql.Open("sqlite-ha", "file:example.db?_journal=WAL&_timeout=5000&replicationURL=nats://broker:4222&name=node0")
    if err != nil {
        panic(err)
    }
    defer db.Close()
    // Use db to interact with your database
}

package main
import (
    "database/sql"
    sqliteha "github.com/litesql/go-sqlite-ha"
)
func main() {
    c, err := sqliteha.NewConnector("file:example.db?_journal=WAL&_timeout=5000",
		ha.WithName("node1"),
		ha.WithEmbeddedNatsConfig(&ha.EmbeddedNatsConfig{
			Port: 4222,
		}))
	if err != nil {
		panic(err)
	}
	defer c.Close()
	db := sql.OpenDB(c)
	defer db.Close()
    // Use db to interact with your database
}

• Check out all options at option.go file.

• HA: Highly available leaderless SQLite cluster with HTTP and PostgreSQL Wire Protocol
• PocketBase HA: Highly available leaderless PocketBase cluster

Contributions are welcome! Please open an issue or submit a pull request.

This project is licensed under the MIT License. See the LICENSE file for details.