sqlite3

Overview ¶

Package sqlite3 provides a zdb driver for SQLite.

This uses https://github.com/mattn/go-sqlite3/

Several connection parameters are set to different defaults in SQLite:

_journal_mode=wal          Almost always faster with better concurrency,
                           with little drawbacks for most use cases.
                           https://www.sqlite.org/wal.html

_foreign_keys=on           Check FK constraints; by default they're not
                           enforced, which is probably not what you want.

_busy_timeout=200          Wait 200ms for locks instead of immediately
                           throwing an error.

_defer_foreign_keys=on     Delay FK checks until the transaction commit; by
                           default they're checked immediately (if
                           enabled).

_case_sensitive_like=on    LIKE is case-sensitive, like PostgreSQL.

_cache_size=-20000         20M cache size, instead of 2M. Can be a
                           significant performance improvement.

You can still use "?_journal_mode=something_else" in the connection string to set something different.

• https://github.com/mattn/go-sqlite3/

To use a ConnectHook, you can DefaultHook() to automatically set the given connection hook on every new connection. Alternatively, you can register it first using the regular method:

sql.Register("sqlite3-hook1", &sqlite3.SQLiteDriver{
    ConnectHook: func(c *sqlite3.SQLiteConn) error {
        return c.RegisterFunc("hook1", func() string { return "hook1" }, true)
    },
})

And then call zdb.Connect() with "sqlite3-hook1" as the driver name. Note the driver name *must* start with "sqlite3".