DbSchema Blog

Categories

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

SQLite Expressions Explained with Examples | DbSchema

Learn how SQLite expressions work in SELECT and WHERE clauses with boolean, numeric, and date examples in sqlite3 and DbSchema.

Sqlite • 03-Jun-2023

PostgreSQL Foreign Key – ALTER TABLE, CASCADE Rules, and Indexing | DbSchema

Learn PostgreSQL foreign key syntax, ALTER TABLE, NOT VALID, CASCADE rules, and indexing. Model and document table relationships in DbSchema.

Postgresql • 02-Jun-2023

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