{"repo":"frectonz/pglite-fusion","free":true,"listed":false,"github":"https://github.com/frectonz/pglite-fusion","clone":"git clone https://github.com/frectonz/pglite-fusion.git","description":"Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.","language":"Nix","stars":832,"topics":["multitenancy","postgres-extension","postgresql","sqlite","sqlite-in-postgres"],"license":"MIT","category":"databases-storage","readme_excerpt":"pglite-fusion Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved. Usage Run a PostgreSQL 18 database that has pglite-fusion already installed. pglite-fusion is also distributed with other PostgreSQL versions. PostgreSQL 14 PostgreSQL 15 PostgreSQL 16 PostgreSQL 17 PostgreSQL 18 Connect to the PostgreSQL database using psql . Here's some demo usage. Build it from source API Documentation Every function is parallel-safe except for import sqlite from file and export sqlite to file . empty sqlite Creates an empty SQLite database and returns it as a binary object. This can be used to initialize an empty SQLite database in a PostgreSQL column. Example Usage: ----- query sqlite Executes a SQL query on a SQLite database stored as a binary object and returns the result as a table of JSON-encoded rows. This function is useful for querying SQLite databases stored in PostgreSQL columns. Parameters: - sqlite : The SQLite database to query, stored as a binary object. - query : The SQL query string to execute on the SQLite database. Example Usage: ----- execute sqlite Executes a SQL statement (such as INSERT , UPDATE , or DELETE ) on a SQLite database stored as a binary object. The updated SQLite database is returned as a binary object, allowing further operations on it. Parameters: - sqlite : The SQLite database to execute the SQL query on, stored as a binary object. - query : The SQL statement to execute on the SQLite database. Example Usage: ----- init sq","default_branch":null,"files":null,"tree":[],"storefront":"/r/frectonz","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/frectonz/pglite-fusion/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}