Dave's MySQL Stuff

  Hopefully, you are regularly using both  DBeaver  and  GitHub . But did you know that you can link them together? If you are running DBeaver Community, you will have to install some software that is built into the Pro versions.  1. Install Git Extension (Community Edition)   Go to  Help  ->  Install New Software . In the "Work with" field, enter:  https://dbeaver.io/update/git/latest/ . Check the box for  DBeaver Git Support , click  Next , and follow the prompts to finish and restart DBeaver.   2. Configure GitHub Authentication   GitHub requires a  Personal Access Token (PAT)  rather than your standard account password for DBeaver's connection:   Generate Token:  On GitHub, go to  Settings  ->  Developer Settings  ->  Personal access tokens  ->  Tokens (classic) . Permissions:  Select all  repo  scopes and  read:org  under...

 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 ex...

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...