Posts

AI Chat With DBeaver Community Edition

Image
  AI Chat With DBeaver Community Edition July 29, 2026   DBeaver recently introduced interactive chat capabilities into the free, open-source Community Edition. What does that mean?  It means some of your database tasks can be accomplished significantly faster !  First , you can ask for information without coding SQL. I love Structured Query Language, but it is much faster to write this prompt: What are the top ten most popular rentals and how much revenue did they genera te? And faster than I look at the schema, the AI answers: -- This query finds the top 10 most rented films and their total revenue with film_rentals as ( select i . film_id , count ( r . rental_id ) as rental_count , sum ( p . amount ) as total_revenue from rental r join inventory i on r . inventory_id = i . inventory_id join payment p on r . rental_id = p . rental_id group by i . film_id ) select f . title , fr . rental_count ,...
Post a Comment
Read more

MySQL Workbench to DBeaver Transition

Image
 First, there were the MySQL Query Browser and the MySQL Administrator, collectively known as the MySQL GUI Tool Bundle. But they were given End-of-Life status in 2009. Next was MySQL Workbench, but that tool is now EOL as well. MySQL Workbench provides a warning if you try to use it with later versions of MySQL.  You could still run Workbench, but it will grumble if you try to use it with any version other than 5.6, 5.7, or 8.0. Heck, it warns you that 8.4 may be a bit sketchy. On, and you need an older version for MySQL 5.5 and earlier.   Many people swore by Workbench as the tool for checking on system status, wiring queries, and making backups. Others swore at it. Yes, it had quirks. But Workbench did a lot of this right.  There is a free, open-source database tool you should consider as a replacement. DBeaver Community Edition  is also a database tool, but it supports many databases, not just MySQL. It uses JDBC connectors. DBeaver is an IDE that offers sma...
Post a Comment
Read more

Github And DBeaver

Image
  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...
Post a Comment
Read more

Writing My Own Extension For Village SQL Part II

Image
 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...
Post a Comment
Read more

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...
Post a Comment
Read more