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.
DbSchema Blog
Database design, migrations, SQL and everyday database work — explained with practical examples.
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.
Database Design Tools on Linux: Which Modellers Install Natively
Compare database design tools that run natively on Linux, see which modellers list only Windows and macOS, and open your own database in DbSchema Community
Data Modelling Tools for Snowflake: Five Tools Compared
Compare five data modelling tools for Snowflake on connection, reverse engineering, VARIANT support and model storage, with a fit guide per team.