omni_sqlite

pig build pkg omnigres;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install omnigres;		# install via package name, for the active PG version
pig install omni_sqlite;		# install by extension name, for the current active PG version

pig install omni_sqlite -v 18;   # install for PG 18
pig install omni_sqlite -v 17;   # install for PG 17
pig install omni_sqlite -v 16;   # install for PG 16
pig install omni_sqlite -v 15;   # install for PG 15
pig install omni_sqlite -v 14;   # install for PG 14

CREATE EXTENSION omni_sqlite;

SELECT 'CREATE TABLE user_config (key text, value text)'::omni_sqlite.sqlite;

CREATE TABLE customer (
    id   bigserial PRIMARY KEY,
    name text NOT NULL,
    data omni_sqlite.sqlite DEFAULT 'CREATE TABLE user_config (key text, value text);'
);

UPDATE customer
SET data = omni_sqlite.sqlite_exec(data,
    $$INSERT INTO user_config VALUES ('color', 'blue')$$)
RETURNING *;

SELECT omni_sqlite.sqlite_exec('CREATE TABLE tab (val text)',
    'INSERT INTO tab VALUES ($1)', row('hello'));

SELECT * FROM omni_sqlite.sqlite_query(
    (SELECT data FROM customer),
    'SELECT rowid, key, value FROM user_config')
AS (id bigint, key text, value text);

-- Serialize to bytea:
SELECT omni_sqlite.sqlite_serialize('CREATE TABLE foo (x)');
-- Deserialize from bytea:
SELECT omni_sqlite.sqlite_deserialize(bytea_data);