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/

Figuring out how to distribute the extension took more time than actually making it. 😂

Let's hope this week will be as productive as the last.

All three of this projects were released last week.

- jabroni
- parenv
- pglite-fusion

pglite-fusion has been deployed to pgxn

https://pgxn.org/dist/pglite_fusion/0.0.1/

all the real hackers and tinkerer's are dead 😭

just a bunch of corporate douche bags who forgot that some of us code for our curiosity

The HN moderators thought that pglite-fusion fit HN's sprit but didn't get much activity when it was posted to Show HN. So they contacted me over email to have it placed in the second chance pool 🎉.

I love HN. The "hacker" in the name really holds true to the original meaning of the word.

I'm back on the front page of HN 🎉