Useful articles

Added: convenient table and column selection for linking, the ability to switch between dark and light themes, and 2FA authentication.

Try the new convenient table selection for linking! A table search feature has been added, and now you can specify a column for linking. For fans of light interfaces, a light theme has been added. Security has been improved. read article

Access settings have been added!

It is now possible to share the database schema with your team or clients! Everyone will be thrilled with how you presented the database schema, and this has already been verified! read article

Added: a convenient color selection for the table header, table groups, the ability to add a description to the table, and to duplicate the table. Improved scaling of the workspace.

By assigning a color to a table, you can quickly assign the same color to another table. Each color can be given a name by creating a color group for tables. You can display only one group of tables while hiding the others. The description of the table is always displayed above the table. A scaling bug has been fixed. read article

Data types have been added, extended settings and FOREIGN export, as well as mouse and touchpad sensitivity switching

It is now significantly easier to select data types, as there are more of them and hints have been added. For the convenience of using the touchpad, a dedicated mode has been introduced read article

How to get data from a table in SQL: the SQL query SELECT FROM WHERE

Learning SQL with examples: how to write SQL commands to retrieve data from a database? I explain how to extract information from a database in simple terms without fluff. The command SELECT FROM WHERE is easy! It works for MySQL, PostgreSQL, MS SQL, SQLite, Oracle, MariaDB, and other SQL DBMS. read article

How to add a row to a table in SQL: the SQL INSERT INTO statement

Learning SQL with examples: how to write SQL commands to add data to a table? I explain how to insert data into a database table in simple terms without any fluff. The INSERT INTO command is easy! It works for MySQL, PostgresQL, MS SQL, SQLite, Oracle, MariaDB, and other SQL databases. read article

How to modify data in a table record in SQL: SQL UPDATE query

Updating SQL records, how to write SQL commands to change a row in a table? I explain how to edit data in a SQL database tuple in simple words without any unnecessary details. The UPDATE SET command is easy! It works for MySQL, PostgreSQL, MS SQL, SQLite, Oracle, MariaDB, and other SQL DBMS. read article

How to delete data from a table in SQL: the SQL query DELETE FROM WHERE

Learning SQL with examples: how to write SQL commands to delete a row from a database table? I explain row deletion in SQL, how to delete an SQL record in simple terms without unnecessary information. The DELETE FROM WHERE query is easy! It works for MySQL, PostgreSQL, MS SQL, SQLite, Oracle, MariaDB, and other SQL DBMS. read article

Relational databases are one of the components of almost any IT project. What is the essence of databases? What are they needed for?

Why is a database needed? What is a database from a programming perspective? The structure of data in a database, what does "relational" mean, and finally, why is it important to approach the design phase of a database very responsibly? read article

Basics of database design: how to create a "one-to-one" (1:1) relationship and when this type of relationship is needed, in simple terms with an example

Lessons on relational databases, online database training. How to create a "one-to-one" (1:1) relationship and when this type of relationship is needed. Learning the structure of relational databases with examples of SQL queries. read article

Fundamentals of database design: how to create a many-to-many (M:M) relationship and when this type of relationship is needed, explained simply with an example

Lessons on relational databases, online database learning. How to create a many-to-many (M:M) relationship and when this type of relationship is necessary. Exploring the structure of relational databases with examples of SQL queries. read article

Fundamentals of database design: data normalization in simple terms, the purpose of relationships in relational databases, one-to-many relationship

Lessons on relational databases, online database training. The one-to-many relationship, also known as "one to many" (1:M), explained with examples and in simple terms. read article

MySQL won't start: how to fix MySQL Shutdown Unexpectedly Error

Everything was working like a charm, and suddenly MySQL crashes with an error? Let me explain how to fix the problem without losing data. read article