DbSchema Blog

Categories

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

SQLite Create Database – CLI, Python, GUI, and DbSchema Setup | DbSchema

Learn how to create a SQLite database with sqlite3, Python, GUI tools, and DbSchema. See file-based setup, first schema steps, and best practices.

Sqlite • 02-Jun-2023

PostgreSQL JOINs Explained with Examples | DbSchema

Learn how to use PostgreSQL JOIN types with practical examples in psql and DbSchema, including INNER, LEFT, RIGHT, FULL, CROSS, NATURAL, and SELF JOIN.

Postgresql • 30-May-2023

PostgreSQL Aggregate Functions Guide with Examples | DbSchema

Learn how to use PostgreSQL aggregate functions like AVG, COUNT, MIN, MAX, and SUM in psql and DbSchema with practical examples.

Postgresql • 30-May-2023

PostgreSQL CREATE TRIGGER Guide with psql and DbSchema | DbSchema

Learn how to create triggers in PostgreSQL using psql and DbSchema, with trigger types, parameters, examples, and practical guidance.

Postgresql • 29-May-2023

PostgreSQL Transactions Guide with COMMIT and ROLLBACK | DbSchema

Learn how PostgreSQL transactions work with BEGIN, COMMIT, and ROLLBACK in psql and DbSchema, including benefits and practical workflow.

Postgresql • 29-May-2023

Cassandra ALTER TABLE Guide: What You Can and Cannot Change

Learn what ALTER TABLE actually supports in Cassandra, including adding columns, dropping columns, renaming primary-key columns, and changing table options.

Cassandra • 27-May-2023

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 • 27-May-2023

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 • 27-May-2023

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 • 27-May-2023

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 • 18-May-2023