Comments URL: https://news.ycombinator.com/item?id=47286873

Points: 1

# Comments: 0

CREATE TABLE crime_against_humanity ( databases SQLITE[] );

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`. When a query is made, this `Vec` 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

Comments URL: https://news.ycombinator.com/item?id=42182146

Points: 180

# Comments: 110

Comments URL: https://news.ycombinator.com/item?id=42174753

Points: 3

# Comments: 0

Comments URL: https://news.ycombinator.com/item?id=41756532

Points: 4

# Comments: 0

It is a CLI tool, that creates a local server. I will make the readme better soon.