Learn SQL in your browser
A free SQL tutorial in short lessons on one shop database. Every example runs on real PostgreSQL in your browser, and the page checks your answers.
DbSchema Blog
Database design, migrations, SQL and everyday database work — explained with practical examples.
What Is a .dbs File? The DbSchema Design Model Explained
A .dbs file is DbSchema's XML design model. What it stores, an excerpt from a real model, and how a schema change reads in a diff.
How to Generate Database Documentation (HTML5, PDF, Markdown)
Generate database documentation as HTML5, PDF or Markdown with DbSchema: the steps, where the table and column descriptions come from, and how to regenerate it from a script.
Migrating a Relational Schema to MongoDB
Move a MySQL or PostgreSQL schema to MongoDB: map tables to collections, embed or reference each relationship, and turn constraints into validation rules.
MySQL JDBC: com.mysql.cj.jdbc.Driver vs com.mysql.jdbc.Driver
Use com.mysql.cj.jdbc.Driver for MySQL Connector/J, fix the deprecation warning, and trace ClassNotFoundException and No suitable driver errors fast.
MySQL Connector/J: mysql-connector-j vs mysql-connector-java
mysql-connector-j vs mysql-connector-java: why the Maven coordinates changed in 8.0.31, which Connector/J version fits your MySQL server, and the dependency.
Fix 'Public Key Retrieval is not allowed' in MySQL JDBC
Fix MySQL JDBC 'Public Key Retrieval is not allowed': why caching_sha2_password causes it and when to use TLS, a pinned key or allowPublicKeyRetrieval.
MySQL JDBC URL and Connection String Parameters
The MySQL JDBC URL format, localhost and multi-host examples, and the connection properties worth setting: sslMode, connectionTimeZone and timeouts.
Text-to-SQL Tools and When to Trust Them
Text-to-SQL tools compared by what they see of your schema, BIRD and Spider 2.0 scores read 11 Oct 2026, and five checks before AI-written SQL runs.
SQL and Schema Tools for macOS: Choosing a SQL Client for Mac
Five SQL clients for Mac compared by engines, ER diagrams and Homebrew install, and how to install the free DbSchema Community Edition on macOS.
Data Modelling Tools for Databricks: What Reads Unity Catalog
Data modelling tools for Databricks compared: what Catalog Explorer draws free, and what DbSchema, erwin, ER/Studio, Hackolade and SqlDBM read.