DbSchema Blog

Categories

• Cassandra
• Databases
• Dbschema features
• Design
• Firebird
• Migrations
• Mongodb
• Mysql
• Oracle
• Postgresql
• Release notes
• Snowflake
• Sql server
• Sqlite
• Tool comparisons
• Tools
• Tutorials

Finding Schema Drift Between Database Environments

Learn what database schema drift is, why it breaks data engineering pipelines, and how to detect and synchronize schema changes across environments.

Migrations • 06-Sep-2026

Schema Versioning Without a Migration Framework

Version your database schema without a migration framework. Save the design as an XML file in Git and generate SQL migration scripts automatically.

Migrations • 06-Sep-2026

Open-Source Schema Migration Tools

Discover how open-source schema migration tools help backend developers manage database changes safely. Compare DbSchema, Liquibase, and Flyway.

Migrations • 06-Sep-2026

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.

Oracle • 06-Sep-2026

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.

Oracle • 06-Sep-2026

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 • 06-Sep-2026

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 • 06-Sep-2026

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 • 06-Sep-2026

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.

Cassandra • 06-Sep-2026

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 • 06-Sep-2026