New Project

jabroni - Query your SQLite DB over WebSockets

Real Life Phoebe Buffay

https://youtu.be/ratQlft_G5c

One of the winners of the /dev/tty/ prize, i hosted a while ago started his own channel.

He had the most impressive project. It was a reverse proxy the let's you modify requests and responses with a lua script. Looking at the commits on the projects looks like he is still working on it. I'm sure he will have more cool projects in the future. Yall should join his channel.

https://t.me/thought_vessle

This is me demoing his project.

New Project

parenv - Environment variable parser with a clap style derive macro and elm style error reporting.

Looks like am gonna watch the oscars this year

Happy Genghis Khan Day

Bell labs and Xerox Parc are the greatest counter examples to the idea that monopolies stifle innovation. There are some kinds of research that can only be sustained by the funding power of monopolies.

https://youtu.be/c-cSeTz3dMg

Just finished an initial implementation of an idea I had for a postgres extension.

I think it solves multi tenancy for most use cases.

pglite-fusion

I made a postgres extension that allows you to define SQLite columns on a PostgreSQL table. This means every row in your table can have an embedded SQLite DB.

Notice that the database column has the type SQLITE in the screenshot.

The functions execute_sqlite, empty_sqlite, get_sqlite_text, query_sqlite are all provided from the pglite_fusion extension.

Here's the above example running in psql

As always its open source.

https://github.com/frectonz/pglite-fusion

There's a package registry and package manger for installing PostgreSQL extensions.

https://pgt.dev/

There's also another one.

https://pgxn.org/

They also did this in the movies. 😂

Dune (1965)
Jihad

Dune: Part Two (2024)
Holy War

It is now much easier to run pglite-fusion.

Run a PostgreSQL database that has pglite-fusion already installed.

docker run --network=host frectonz/pglite-fusion

Connect to the PostgreSQL database using psql.

psql postgresql://postgres@localhost:5432/