Hacker News new | ask | show | jobs
Show HN: VillageSQL = MySQL and Extensions (github.com)
27 points by metzby 132 days ago
INSTALL EXTENSION vsql-complex; CREATE TABLE t (val COMPLEX);

Look, MySQL is awesome [flamewar incoming?]. But the ecosystem has stagnated. Why?

No permissionless innovation. Postgres has flourished because people can change the core of the database (look at pgvector and pg_textsearch), without having to get their changes accepted upstream.

(This, btw, is what powered GitHub's early success: you can fork a repo and make changes without needing the owners' approval)

VillageSQL is a tracking fork of MySQL (open source, ofc) that adds an extension framework: * Drop-in replacement

* Add custom data types and functions (with indexes coming soon)

* we wrote example extensions (vsql-ai, -uuid, crypto, etc.)

* you have a better idea for an extension

* my CEO submitted a Show HN post but linked to the announcement blog; help me show him hackers want code first

* I'm particularly proud of the friendly C++ API to add custom functions (in func_builder.h)

That link again is https://github.com/villagesql/villagesql-server

(Oh, and I get to work with the former TL of Google's BigTable and Colossus, so we care about doing databases Right)

2 comments

One of the major problems of MySQL and its many derivatives is the splintering of the ecosystem.

Would rather prefer people would cooperate on ONE fork, e.g. get your extension framework integrated into MariaDB or something.

Ha! Founder here. Tell me why? Trying to make it easy, not be terrifying! I think the embed generation saves folks some steps.
It's terrifying in a hacker/cool way. Making the wrong query, creating millions of rows, and sending possibly millions of requests to the LLM provider sounds risky. But I like it :)
This looks really useful for the people that need it!
built-in vector generation looks nice?