Embed an SQLite database in your PostgreSQL table

Hacker News

pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database. In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README. The pglite-fusion extension is written in Rust using the pgrx framework [1]. ---- Implementation Details The PostgreSQL `SQLITE` type is stored as a CBOR-encoded `Vec<u8>`. When a query is made, this `Vec<u8>` is written to a random file in the `/tmp` directory. SQLite then loads the file, performs the query, and returns the result as a table containing a single row with an array of JSON-encoded values. The `execute_sqlite` function follows a similar process. However, instead of returning query results, it returns the contents of the SQLite file (stored in `/tmp`) as a new `SQLITE` instance. [1] https://github.com/pgcentralfoundation/pgrx

Visit product View on Hacker NewsNov 19, 2024

Share card

Actual performance

180points

110comments

Made the leaderboard

Launch Intel predictions

Analyze your own launch →

Hacker NewsStrong engagement from HN community · Strong signals: ide, io · Missing: https docs, excited, just released

67%67% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

Product HuntOn track for Day 1 leaderboard · Strong signals: new, single, using · Missing: mac, agents, macos

53%53% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

AppSumoMay struggle as an AppSumo deal · Missing: plus, platform, intuitive

36%36% predicted probability of success on AppSumo, based on ML models trained on real launch data.

TrustMRRLess likely to generate early MRR · Missing: mobile apps, ios, personal

35%35% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Indie HackersIH features products with proven revenue · Missing: supports, reddit linkedin, podcasting

34%34% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Strong signals: arr · Missing: mrr, revenue, profit

16%16% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto

3%3% predicted probability of success on BetaList, based on ML models trained on real launch data.

Correct prediction on native model

Similar products

Embed an SQLite database in your PostgreSQL table71%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Embed an SQLite database in your PostgreSQL table

Hacker News7

A Django extension that supports PostgreSQL native table partitioning32%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

A Django extension that supports PostgreSQL native table partitioning

Hacker News1

Pg_road – PostgreSQL Table Access Method for Read-Only Archived Data37%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Pg_road – PostgreSQL Table Access Method for Read-Only Archived Data

Hacker News1

Kafka FDW for PostgreSQL65%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Kafka FDW for PostgreSQL

Hacker News2

es2postgres – ElasticSearch to PostgreSQL Loader71%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

es2postgres – ElasticSearch to PostgreSQL Loader

Hacker News3

Metagration: PostgreSQL Migrator in PostgreSQL56%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Metagration: PostgreSQL Migrator in PostgreSQL

Hacker News1

PRQL in PostgreSQL73%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

PRQL in PostgreSQL

Hacker News267

Database-replicator – Replicate any DB to PostgreSQL59%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Database-replicator – Replicate any DB to PostgreSQL

Hacker News3

Xata, serverless database on top of PostgreSQL and Elasticsearch84%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Xata, serverless database on top of PostgreSQL and Elasticsearch

Hacker News47

Rails PostgreSQL database performance insights. Locks, buffers and more45%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Rails PostgreSQL database performance insights. Locks, buffers and more

Hacker News4

Browse all products Analyze your launch