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.
Simplifying Oracle Databases with DbSchema's Unique Features
Connect DbSchema to your Oracle database, reverse-engineer it into a diagram, generate HTML5 documentation, and keep the model file in Git.
Reverse Engineering an Oracle Database
Learn how to reverse engineer an Oracle database into a complete schema diagram over JDBC and verify model completeness using data dictionary views.
Cassandra CREATE KEYSPACE Guide in cqlsh and DbSchema
Learn how to create a Cassandra keyspace in cqlsh and DbSchema, choose the right replication strategy, and pick a safe replication factor.
Cassandra DROP TABLE Guide in cqlsh and DbSchema
Learn how to drop a Cassandra table in cqlsh and DbSchema, use IF EXISTS safely, and avoid accidental data loss with backups and dependency checks.
Cassandra ALTER MATERIALIZED VIEW Guide for Safe Changes
Learn what ALTER MATERIALIZED VIEW supports in Cassandra, which changes require a drop and recreate, and how to update view options safely.
Cassandra Materialized View Guide: CREATE VIEW in cqlsh and DbSchema
Learn how to create a Cassandra materialized view, understand the CQL restrictions, and decide when a view is appropriate for a new query path.
Firebird BLOB Guide in isql and DbSchema
Learn how to work with Firebird BLOB columns in isql and DbSchema, including create, insert, and export workflows.
Firebird Database Clustering Guide with isql and DbSchema
Firebird has no clustering. Set up its built-in primary-replica replication and shadow files in isql, then check the replica schema in DbSchema.
Schema Migration Tools Compared
Database schema migration tools compared: DbSchema, Liquibase and Flyway, on where the change is authored, how the script is produced and how each is licensed.
DBeaver Alternatives for Visual Database Design
Compare top DBeaver alternatives for visual database design: DbSchema, pgAdmin, DbVisualizer, Navicat and dbForge, on features, licensing and workflow.