Posts

Showing posts from April, 2026

Writing My Own Extension for Village SQL Part I

Since my previous post on Village SQL, life has been filled with too many other things. But finally I was able this past weekend to circle back and try to write my own extension. The Village SQL TL;DR -> MySQL with PostgreSQL like extensions.   The  documentation on writing new extensions seems complete, but I have run into issues that are probably caused by me, and not the docs.   Starting with a bad joke  I heard a joke about a husband who was sent to the store by a long suffering wife because she said a recipe needed five cubed potatoes.  So he bought one hundred and twenty five potatoes!  That made me think a first extension that cubes an integer might be a good idea. But there are problems I haven't written anything serious in C/C++ in a very long time. I asked Grok to create the code for me. #include <villagesql/extension.h> #include <cstdint>   // for int64_t (optional but recommended) // Cube implementation - corre...