Posts

Using dbvr with PostgreSQL: From First Datasource to Production Queries

What dbvr is, and why use it with PostgreSQL dbvr lets you define PostgreSQL connections and run SQL from the command line, with no graphical interface. That makes it a fit for servers, containers, and pipelines where a desktop database tool cannot run. DBeaver Corporation announced dbvr on March 26, 2026 as a standalone CLI built on the same multi-database engine as the DBeaver desktop products. It can: Run SQL queries and scripts from saved or inline connection settings, with no interactive login. Run on locked-down servers, inside containers, and over SSH on remote hosts. Authenticate natively to AWS, GCP, and Azure databases. Export query results to S3, Google Cloud, or Azure storage. Plug into CI/CD pipelines for database checks and backup/restore validation. The announcement lists the commercial edition as an annual per-machine subscription with a 14-day trial. DBeaver's 26.1 release post also introduced dbvr Community, a free edition under the Apache License 2.0.  This po...

Getting Started With Ollama With DBeaver Community Edition

Image
  Ollama is popular because it makes running large language models (LLMs) locally simple, private, and inexpensive . DBeaver 26.2.5, also free & open-source, recently added support for Ollama. And both pair well with PostgreSQL. Why Ollama Is Popular? Runs AI Locally — Execute models such as Llama, Qwen, Gemma, and DeepSeek on your own computer without relying on cloud services. Privacy and Data Control — Prompts and data can remain entirely on your machine, making Ollama attractive for sensitive business information and internal applications. Free and Open Source — Ollama is free to use locally, with no per-token API charges. Individual models have their own licenses. Easy Installation — Download and run models with simple commands: ollama run llama3.2 Developer-Friendly API — Provides a local REST API compatible with many AI development tools, making integration with Python, applications, and databases straightforward. Broad Model Support — Supports numerous open-weigh...

Is PostgreSQL Really Winning Part 2: The Evidence Beyond the Rankings

 My last post leaned hard on the DB-Engines ranking, and I admitted that ranking measures popularity, not installed base or revenue. Several of you called me on that, politely and otherwise. Fair enough. So this time I went looking for evidence that does not come from one ranking site. Usage surveys: where the money is going, what cloud vendors are building, and what AI tools reach for when nobody tells them what to use. My conclusion has not changed, but I think the case is much stronger than I made it out to be. Beyond DB-Engines The best usage number I can find comes from developers themselves. In the 2025 Stack Overflow Developer Survey, 55.6% of all respondents said they use PostgreSQL, up from 48.7% in 2024. Among professional developers it was 58.2%, roughly 18 points ahead of MySQL ( summary of the survey ). It also topped the admired and desired lists again. That is still a survey, not an install count. But it is people saying "I use this," not people searching for ...

Is PostgreSQL Really Winning?

Image
 The November 2026 DB-Engines rankings are out. PostgreSQL is the only database in the top four whose line is going up and to the right. Oracle, MySQL and Microsoft SQL Server all lost points this month, and all three are down from a year ago. PostgreSQL gained points on both counts. It now sits just 3.84 points behind SQL Server for third place. On the past year's trend, PostgreSQL could move ahead of SQL Server as early as next month. So it's time to celebrate, right? Maybe not yet. Before anyone orders the cake, let's look at what the numbers say, why people are moving, and how hard the next step up will be. The numbers Only PostgreSQL gained points this month, and only PostgreSQL is up from a year ago. Source: DB-Engines Ranking of Relational DBMS , November 2026. A little napkin math shows when the order could change: SQL Server: The gap is 3.84 points. At this month's pace, it closes in about two months. At the past year's pace, it closes in less than one. S...

Structured Query Language 101 at Texas Linuxfest

 Structured Query Language 101 -15:00–16:20 Nov. 6, 2026 · 15:00 - 6:20 I will be teaching the basics of SQL at the 2026 Texas Linuxfest. The session is listed for only 100 minutes, but I wrote the materials for a 3-hour course. We will cover as much of those three hours as the audience can stand (sit?), or they send us off to Sixth Street. Tickets are available, and this event is great for networking.  Ping me if you have questions about this session.  Description: SQL is a powerful language for working with relational databases such as MySQL, PostgreSQL, SQL Server, and Oracle. This is an 80-minute introduction to writing SQL database queries. Please load a copy of DBeaver Community Edition (free, open-source) from https://dbeaver.io/download/ on your Mac, Windows, or Linux laptop to work along with the presentation. We will use the sample database that is included with DBeaver. We will start with simple SELECT statements to retrieve data, INSERT to add data, use...

Loading the Northwinds Database Into PostgreSQL with DBeaver

Image
 Note: I am presenting a tutorial for those who want to learn SQL at this year's Texas Linuxfest (https://pretalx.com/txlf2026/talk/DQ3XW7/) on November 6th.  This is a great opportunity at a fantastic community event and I encourage you to attend. Demo databases are good way to develop skills with Structured Query Language. Some are associate with one data store more than another, like Sakila and World with MySQL, or DVD with PostgreSQL. The Northwind database originated in the Microsoft sphere of influence but it is easy to obtain for PostgreSQL. Step 1 Go to https://github.com/pthom/northwind_psql and download https://github.com/pthom/northwind_psql/blob/master/northwind.sql This file has all you need. Step 2 I am using DBeaver Enterprise Edition 26.1.0 and open the northwind.sql file. DBeaver is an amazing data tool and makes this type of project simple.  Opening the northwind.sql file Step 3 This is that northwind.sql file in all its glory. If you are new to SQL, tak...