Writing My Own Extension For Village SQL Part II

 Writing my own extension for Village SQL has been a learning experience. Extensions are a big part of the PostgreSQL ecosystem, and the idea of bringing them to the MySQL ecosystem is a source of hope for the 'most popular database'.  


The Good News

I was able to build my extension, vsql_cube, and get it into the server! Yeah!     

mysql> select * from information_schema.extensions;
+----------------+-------------------+
| EXTENSION_NAME | EXTENSION_VERSION |
+----------------+-------------------+
| vsql_complex   | 0.0.1             |
| vsql_cube      | 1.0.0             |
| vsql_simple    | 0.0.1             |
+----------------+-------------------+
3 rows in set (0.01 sec)


The Bad News


My extension does not work. 

mysql> select vsql_simple(5);
ERROR 1305 (42000): FUNCTION demo.vsql_simple does not exist
mysql> 

Dang!

Onwards, If Not Upwards

The Village SQL docs are excellent. So I am working through them to find the issue.  My .veb file is in the correct directory and with the proper permissions.

I will keep plugging along and provide updates. I have received many inquiries (thank you) about this, and it appears many are interested in Village SQL. Updates will be forthcoming.
 
My 'off hours' supervisor Bill
 gave me moral support but refuses
to comment on my coding.

My Suspicion On What Is Wrong


I have not written any C/C++ code in many years. Those of us who wrote C in the era of 6502 and 68000 assembly language found it a joy. Well, skip a long time without using a programming language, and you lose your skills. I asked Grok to write the code, and I suspect an 'impedance mismatch' may be in it.  So I will pore over the language specs, searching for an answer.

The Village SQL roadmap mentions the possibility of Rust inclusion later. I am a little more up to date with Rust than with C/C++. But I wonder how many 'Joe Average' DBA/SREs are up to speed on any of these languages.  I see the great value and opportunity being offered to the MySQL-verse with Village SQL, but we averages will need some extra coaching to take advantage.




Comments

Post a Comment

Popular posts from this blog

Migrating From MySQL To PostgreSQL in Five Simple Steps

Image
There are many reasons you may want to migrate from MySQL to PostgreSQL, which we will skip over for brevity.  I see many questions about moving tables and data, and sadly, the answers range from sloppy to incredibly complicated.  Each database migration is unique, as issues range from heavily relying on a vendor's feature to extremely complex schemas that require attention to minute detail. Step 1 This may seem obvious, but the first step is access to the original 'source' database. You will need FULL admin access to the database.  If you do not have full access for security, administrative, or other reasons, you will most likely not receive all the desired data.  We will use DBeaver Enterprise to connect to the source database. We need to choose a MySQL database driver Configure the connection We will be porting the World database. In this example, we will port the MySQL World database. This dataset has been used for decades in MySQL documentation, training, and ex...
Read more

Village SQL - A MySQL Fork With Easy Extensions

 I was happy to see a new MySQL fork appear. Village SQL  bills itself as 'A drop-in replacement for MySQL with extensions for the agentic AI era'. Mainstream Oracle MySQL does have Plug-ins, but I have found them less easy to develop and use than other implementations, such as PostgreSQL extensions. So how does it work? Head over to  https://github.com/villagesql/villagesql-server and follow the directions to clone and build the code. You will see detailed instructions for Linux and Mac builds. I followed the directions, let the make run overnight (slow hampsters in my testbed Ubuntu laptop).   The instructions were complete and easy to follow. First Run $ ~/build/villagesql/bin/mysql -u root -h 127.0.0.1 Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 10 Server version: 8.4.6-villagesql0.0.1-dev Source distribution Copyright (c) 2000, 2025, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corp...
Read more

Do You Need An AI Assistant?

Image
 Artificial Intelligence has been over hyped the last several years. But one of the bright, shining spots for AI is acting as an assistant. a super-powerful IDE, when working with a database. Example You want to find your top three customers in the Sakila database. This database has been used for decades in the MySQL world. As your question in English (or another language) The '@ai' directs the rest of the prompt to the DBeaver Artificial Intelligence Assistant See the generated SQL Here is the generated Structured Query Language And get the results. Now we have the top three customers without having to write any SQL directly Fixing Mistakes Occasionally, you may 'fat finger' a query.  I will take the query from above and change first_name to just first .   SELECT c . customer_id , c . first , c . last_name , SUM ( p . amount ) AS total_revenue FROM customer AS c JOIN payment AS p ON c . customer_id = p . customer_id GROUP BY ...
Read more