DEV Community

The Table Series' Articles

Back to DbVisualizer's Series
Optimizing Queries for Performance: MySQL Edition
Cover image for Optimizing Queries for Performance: MySQL Edition

Optimizing Queries for Performance: MySQL Edition

4
Comments 1
9 min read
JSON vs. JSONB in PostgreSQL: A Complete Comparison
Cover image for JSON vs. JSONB in PostgreSQL: A Complete Comparison

JSON vs. JSONB in PostgreSQL: A Complete Comparison

3
Comments
5 min read
Architecting for Security: MySQL Edition
Cover image for Architecting for Security: MySQL Edition

Architecting for Security: MySQL Edition

3
Comments
10 min read
The Data You‘ve Left Behind – an Attacker‘s Perspective

The Data You‘ve Left Behind – an Attacker‘s Perspective

1
Comments
7 min read
How To Deal With a Database With Billions of Records
Cover image for How To Deal With a Database With Billions of Records

How To Deal With a Database With Billions of Records

2
Comments
6 min read
Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts
Cover image for Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts

Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts

1
Comments
6 min read
How To Design And Build A Database In Postgres
Cover image for How To Design And Build A Database In Postgres

How To Design And Build A Database In Postgres

4
Comments
15 min read
Top five query tuning techniques for Microsoft SQL Server
Cover image for Top five query tuning techniques for Microsoft SQL Server

Top five query tuning techniques for Microsoft SQL Server

1
Comments
6 min read
Using PostgreSQL to Manage Business Inventory Data and Visualize It
Cover image for Using PostgreSQL to Manage Business Inventory Data and Visualize It

Using PostgreSQL to Manage Business Inventory Data and Visualize It

2
Comments
9 min read
SQL Triggers: What They Are and How to Use Them
Cover image for SQL Triggers: What They Are and How to Use Them

SQL Triggers: What They Are and How to Use Them

3
Comments
8 min read
Stored Procedures in SQL: A Complete Tutorial
Cover image for Stored Procedures in SQL: A Complete Tutorial

Stored Procedures in SQL: A Complete Tutorial

1
Comments
9 min read
SSH Tunneling: the Good, the Bad, and the Ugly
Cover image for SSH Tunneling: the Good, the Bad, and the Ugly

SSH Tunneling: the Good, the Bad, and the Ugly

1
Comments
5 min read
How To Create a Table Like Another Table in MySQL
Cover image for How To Create a Table Like Another Table in MySQL

How To Create a Table Like Another Table in MySQL

2
Comments
6 min read
Firing Database Actions: A Guide to Using SQL Triggers with DbVisualizer
Cover image for Firing Database Actions: A Guide to Using SQL Triggers with DbVisualizer

Firing Database Actions: A Guide to Using SQL Triggers with DbVisualizer

1
Comments
6 min read
A Comprehensive Guide to Data Structures in SQL
Cover image for A Comprehensive Guide to Data Structures in SQL

A Comprehensive Guide to Data Structures in SQL

1
Comments
8 min read
Database Transactions 101: The Essential Guide
Cover image for Database Transactions 101: The Essential Guide

Database Transactions 101: The Essential Guide

1
Comments
6 min read
The Complete Guide to SQL Subqueries
Cover image for The Complete Guide to SQL Subqueries

The Complete Guide to SQL Subqueries

Comments
7 min read
How To Secure Data In A Postgres Database: A Guide
Cover image for How To Secure Data In A Postgres Database: A Guide

How To Secure Data In A Postgres Database: A Guide

Comments
15 min read
Working with NULL in Databases. Turn Your Frustration Into Delight
Cover image for Working with NULL in Databases. Turn Your Frustration Into Delight

Working with NULL in Databases. Turn Your Frustration Into Delight

Comments
5 min read
ACID in Database Systems: All You Need to Know
Cover image for ACID in Database Systems: All You Need to Know

ACID in Database Systems: All You Need to Know

Comments
5 min read
Database Security 101: Best Practices to Secure Your Data
Cover image for Database Security 101: Best Practices to Secure Your Data

Database Security 101: Best Practices to Secure Your Data

Comments
7 min read
Best Practices for Encrypting Data In Your Database
Cover image for Best Practices for Encrypting Data In Your Database

Best Practices for Encrypting Data In Your Database

Comments
5 min read
Getting Started with Multiversion Concurrency Control (MVCC) in PostgreSQL
Cover image for Getting Started with Multiversion Concurrency Control (MVCC) in PostgreSQL

Getting Started with Multiversion Concurrency Control (MVCC) in PostgreSQL

Comments
8 min read
How to Use a FOREIGN KEY Referring to the Source Table in Postgres
Cover image for How to Use a FOREIGN KEY Referring to the Source Table in Postgres

How to Use a FOREIGN KEY Referring to the Source Table in Postgres

Comments
3 min read
BLOB Data Type: Everything You Can Do With It

BLOB Data Type: Everything You Can Do With It

Comments
6 min read
A Guide to ACID In MySQL
Cover image for A Guide to ACID In MySQL

A Guide to ACID In MySQL

Comments
6 min read
Preventing Illicit Uploads in MySQL – secure_file_priv
Cover image for Preventing Illicit Uploads in MySQL – secure_file_priv

Preventing Illicit Uploads in MySQL – secure_file_priv

1
Comments
6 min read
The Ultimate Guide to the MySQL Port
Cover image for The Ultimate Guide to the MySQL Port

The Ultimate Guide to the MySQL Port

Comments
3 min read
ALTER TABLE Explained
Cover image for ALTER TABLE Explained

ALTER TABLE Explained

Comments
6 min read
Deadlocks in Databases: A Guide
Cover image for Deadlocks in Databases: A Guide

Deadlocks in Databases: A Guide

Comments
6 min read
A Guide to Subqueries in MySQL
Cover image for A Guide to Subqueries in MySQL

A Guide to Subqueries in MySQL

Comments
5 min read
10x Query Performance with a Database Index
Cover image for 10x Query Performance with a Database Index

10x Query Performance with a Database Index

Comments 4
7 min read
Character Sets vs. Collations in a MySQL Database Infrastructure
Cover image for Character Sets vs. Collations in a MySQL Database Infrastructure

Character Sets vs. Collations in a MySQL Database Infrastructure

Comments
7 min read
Best Practices for SQL Coding and Development
Cover image for Best Practices for SQL Coding and Development

Best Practices for SQL Coding and Development

Comments
11 min read
A Guide to Multithreading in SQL
Cover image for A Guide to Multithreading in SQL

A Guide to Multithreading in SQL

Comments
8 min read
ER Model, ER Diagram, and Relational Schema: What's the Difference?
Cover image for ER Model, ER Diagram, and Relational Schema: What's the Difference?

ER Model, ER Diagram, and Relational Schema: What's the Difference?

Comments
9 min read
The Ultimate Guide to SQL Generated Columns
Cover image for The Ultimate Guide to SQL Generated Columns

The Ultimate Guide to SQL Generated Columns

1
Comments
8 min read
MySQL User Management: A Guide
Cover image for MySQL User Management: A Guide

MySQL User Management: A Guide

Comments
7 min read
Why Are Your Databases Slow with Large Tables? An Overview
Cover image for Why Are Your Databases Slow with Large Tables? An Overview

Why Are Your Databases Slow with Large Tables? An Overview

Comments
9 min read
Solved: sudo mysql_secure_installation command not found in MariaDB
Cover image for Solved: sudo mysql_secure_installation command not found in MariaDB

Solved: sudo mysql_secure_installation command not found in MariaDB

Comments
3 min read
How to Connect to MySQL Using Admin Account Remotely
Cover image for How to Connect to MySQL Using Admin Account Remotely

How to Connect to MySQL Using Admin Account Remotely

Comments
5 min read
How To List Databases in PostgreSQL
Cover image for How To List Databases in PostgreSQL

How To List Databases in PostgreSQL

Comments
5 min read
Extracting Time and Date in MS SQL Server: A Comprehensive Guide
Cover image for Extracting Time and Date in MS SQL Server: A Comprehensive Guide

Extracting Time and Date in MS SQL Server: A Comprehensive Guide

Comments
5 min read
How to Set Up Postgres using Docker
Cover image for How to Set Up Postgres using Docker

How to Set Up Postgres using Docker

Comments
3 min read
Understanding PostgreSQL Data Integrity
Cover image for Understanding PostgreSQL Data Integrity

Understanding PostgreSQL Data Integrity

Comments
7 min read
Parameterized Queries in SQL – A Guide
Cover image for Parameterized Queries in SQL – A Guide

Parameterized Queries in SQL – A Guide

1
Comments
5 min read
MySQL SUBSTRING Function: The Complete Guide
Cover image for MySQL SUBSTRING Function: The Complete Guide

MySQL SUBSTRING Function: The Complete Guide

Comments
3 min read
Creating Custom Visualizations with DbVisualizer
Cover image for Creating Custom Visualizations with DbVisualizer

Creating Custom Visualizations with DbVisualizer

Comments
7 min read
How to update a value incrementally (+1) in MySQL
Cover image for How to update a value incrementally (+1) in MySQL

How to update a value incrementally (+1) in MySQL

Comments
2 min read
How to Make Your SQL Server More Secure
Cover image for How to Make Your SQL Server More Secure

How to Make Your SQL Server More Secure

Comments
6 min read
How to Pronounce SQL: SQL or Sequel?
Cover image for How to Pronounce SQL: SQL or Sequel?

How to Pronounce SQL: SQL or Sequel?

Comments 1
4 min read
Storing Unstructured Data With Hstore in PostgreSQL
Cover image for Storing Unstructured Data With Hstore in PostgreSQL

Storing Unstructured Data With Hstore in PostgreSQL

1
Comments
10 min read
The Top Four Sites for Database Professionals Seeking New Job Opportunities
Cover image for The Top Four Sites for Database Professionals Seeking New Job Opportunities

The Top Four Sites for Database Professionals Seeking New Job Opportunities

Comments
3 min read
Migrating Data Between Databases Using DbVisualizer
Cover image for Migrating Data Between Databases Using DbVisualizer

Migrating Data Between Databases Using DbVisualizer

8
Comments
9 min read
Archiving Data in MySQL Using Partitions
Cover image for Archiving Data in MySQL Using Partitions

Archiving Data in MySQL Using Partitions

Comments
6 min read
Exploring the MySQL Daemon – A Guide
Cover image for Exploring the MySQL Daemon – A Guide

Exploring the MySQL Daemon – A Guide

Comments
6 min read
Why do we call software bugs, bugs?
Cover image for Why do we call software bugs, bugs?

Why do we call software bugs, bugs?

Comments
4 min read
Mastering Advanced SQL Queries With DbVisualizer And PostgreSQL
Cover image for Mastering Advanced SQL Queries With DbVisualizer And PostgreSQL

Mastering Advanced SQL Queries With DbVisualizer And PostgreSQL

5
Comments
16 min read
MySQL’s UTF-8: Is It Real?
Cover image for MySQL’s UTF-8: Is It Real?

MySQL’s UTF-8: Is It Real?

Comments
7 min read
PostgreSQL COALESCE Function: Handling NULL Values Effectively
Cover image for PostgreSQL COALESCE Function: Handling NULL Values Effectively

PostgreSQL COALESCE Function: Handling NULL Values Effectively

Comments
6 min read
INSERT Queries - Advanced CRUD explanation part 1
Cover image for INSERT Queries - Advanced CRUD explanation part 1

INSERT Queries - Advanced CRUD explanation part 1

Comments
5 min read
SELECT Queries - Advanced CRUD explanation part 2
Cover image for SELECT Queries - Advanced CRUD explanation part 2

SELECT Queries - Advanced CRUD explanation part 2

Comments
6 min read
Automating Database Operations with Ansible and DbVisualizer
Cover image for Automating Database Operations with Ansible and DbVisualizer

Automating Database Operations with Ansible and DbVisualizer

Comments
9 min read
UPDATE Queries - Advanced CRUD explanation part 3
Cover image for UPDATE Queries - Advanced CRUD explanation part 3

UPDATE Queries - Advanced CRUD explanation part 3

Comments
6 min read
DELETE Queries – Advanced CRUD explanation part 4
Cover image for DELETE Queries – Advanced CRUD explanation part 4

DELETE Queries – Advanced CRUD explanation part 4

Comments
5 min read
Designing a Multi-Language Database
Cover image for Designing a Multi-Language Database

Designing a Multi-Language Database

Comments
5 min read
Preventing SQL Injection Attacks with DbVisualizer
Cover image for Preventing SQL Injection Attacks with DbVisualizer

Preventing SQL Injection Attacks with DbVisualizer

Comments
9 min read
How to Delete Elasticsearch Indices: An In-Depth Tutorial
Cover image for How to Delete Elasticsearch Indices: An In-Depth Tutorial

How to Delete Elasticsearch Indices: An In-Depth Tutorial

Comments
3 min read
A Guide to Data Types in Oracle
Cover image for A Guide to Data Types in Oracle

A Guide to Data Types in Oracle

Comments
10 min read
Bridging the Gap Between SQL and NoSQL in PostgreSQL with JSON
Cover image for Bridging the Gap Between SQL and NoSQL in PostgreSQL with JSON

Bridging the Gap Between SQL and NoSQL in PostgreSQL with JSON

Comments
10 min read
Exploring MongoDB Data Structure with DbVisualizer's Nested Tree-Table View
Cover image for Exploring MongoDB Data Structure with DbVisualizer's Nested Tree-Table View

Exploring MongoDB Data Structure with DbVisualizer's Nested Tree-Table View

Comments
14 min read
How To Kill All Connections to a Database in PostgreSQL
Cover image for How To Kill All Connections to a Database in PostgreSQL

How To Kill All Connections to a Database in PostgreSQL

Comments
4 min read
Postgres ON DELETE CASCADE - A Guide
Cover image for Postgres ON DELETE CASCADE - A Guide

Postgres ON DELETE CASCADE - A Guide

1
Comments
6 min read
Mastering the Trino Connection: Unleash the Power of DbVisualizer!
Cover image for Mastering the Trino Connection: Unleash the Power of DbVisualizer!

Mastering the Trino Connection: Unleash the Power of DbVisualizer!

Comments
10 min read
Querying Data with DbVisualizer and PrestoDb
Cover image for Querying Data with DbVisualizer and PrestoDb

Querying Data with DbVisualizer and PrestoDb

Comments
10 min read
PostgreSQL JSONPATH: Dealing with SQL/JSON Path Language
Cover image for PostgreSQL JSONPATH: Dealing with SQL/JSON Path Language

PostgreSQL JSONPATH: Dealing with SQL/JSON Path Language

Comments
7 min read
Deleting a Column in SQL: Everything You Need to Know
Cover image for Deleting a Column in SQL: Everything You Need to Know

Deleting a Column in SQL: Everything You Need to Know

1
Comments
7 min read
PostgreSQL ISNULL: The Missing Function
Cover image for PostgreSQL ISNULL: The Missing Function

PostgreSQL ISNULL: The Missing Function

Comments
6 min read
PostgreSQL's STRING_AGG() Function - A Comprehensive Guide
Cover image for PostgreSQL's STRING_AGG() Function - A Comprehensive Guide

PostgreSQL's STRING_AGG() Function - A Comprehensive Guide

Comments
3 min read
DESCRIBE TABLE PostgreSQL Alternatives
Cover image for DESCRIBE TABLE PostgreSQL Alternatives

DESCRIBE TABLE PostgreSQL Alternatives

Comments
6 min read
Comprehensive Guide on LIKE and FULLTEXT Search Wildcards
Cover image for Comprehensive Guide on LIKE and FULLTEXT Search Wildcards

Comprehensive Guide on LIKE and FULLTEXT Search Wildcards

Comments
5 min read
Understanding Self Joins in SQL
Cover image for Understanding Self Joins in SQL

Understanding Self Joins in SQL

Comments
6 min read
Oracle Create Database Link
Cover image for Oracle Create Database Link

Oracle Create Database Link

Comments
8 min read
NULLs Are Not The Same – A Guide
Cover image for NULLs Are Not The Same – A Guide

NULLs Are Not The Same – A Guide

Comments
4 min read
Using the EXPLAIN plan to analyze Query execution in PostgreSQL
Cover image for Using the EXPLAIN plan to analyze Query execution in PostgreSQL

Using the EXPLAIN plan to analyze Query execution in PostgreSQL

Comments
6 min read
Your Database Doesn’t Like Your Data – Reserved Words in MySQL
Cover image for Your Database Doesn’t Like Your Data – Reserved Words in MySQL

Your Database Doesn’t Like Your Data – Reserved Words in MySQL

Comments
6 min read
Google BigQuery: A Beginner’s Guide
Cover image for Google BigQuery: A Beginner’s Guide

Google BigQuery: A Beginner’s Guide

Comments
9 min read
No-code Ways of Generating SQL Queries.
Cover image for No-code Ways of Generating SQL Queries.

No-code Ways of Generating SQL Queries.

Comments
9 min read
MySQL Operators – A Guide
Cover image for MySQL Operators – A Guide

MySQL Operators – A Guide

Comments
5 min read
Discover DbVisualizer Security Features for MySQL
Cover image for Discover DbVisualizer Security Features for MySQL

Discover DbVisualizer Security Features for MySQL

Comments
7 min read
Working with Numeric Data Types in MySQL: A Comprehensive Guide
Cover image for Working with Numeric Data Types in MySQL: A Comprehensive Guide

Working with Numeric Data Types in MySQL: A Comprehensive Guide

Comments
5 min read
SQL Interview Questions (MySQL): Part 1
Cover image for SQL Interview Questions (MySQL): Part 1

SQL Interview Questions (MySQL): Part 1

Comments
5 min read
How to work with SQL query optimization
Cover image for How to work with SQL query optimization

How to work with SQL query optimization

Comments
9 min read
Error Establishing a database connection - Common Reasons and Solutions
Cover image for Error Establishing a database connection - Common Reasons and Solutions

Error Establishing a database connection - Common Reasons and Solutions

Comments
12 min read
SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries
Cover image for SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

Comments 1
2 min read
Postgres List Users: Two Different Approaches
Cover image for Postgres List Users: Two Different Approaches

Postgres List Users: Two Different Approaches

Comments
4 min read
SQL vs NoSQL Databases: Which is Better?
Cover image for SQL vs NoSQL Databases: Which is Better?

SQL vs NoSQL Databases: Which is Better?

Comments
11 min read
Change Data Capture: A Comprehensive Guide
Cover image for Change Data Capture: A Comprehensive Guide

Change Data Capture: A Comprehensive Guide

1
Comments
11 min read
MariaDB vs MySQL: The Ultimate Comparison
Cover image for MariaDB vs MySQL: The Ultimate Comparison

MariaDB vs MySQL: The Ultimate Comparison

1
Comments
8 min read
Leveraging Snowflake's Time Travel
Cover image for Leveraging Snowflake's Time Travel

Leveraging Snowflake's Time Travel

Comments
10 min read
Inner Join in SQL: A Comprehensive Guide
Cover image for Inner Join in SQL: A Comprehensive Guide

Inner Join in SQL: A Comprehensive Guide

Comments
10 min read
PostgreSQL Materialized Views: A Beginner's Guide
Cover image for PostgreSQL Materialized Views: A Beginner's Guide

PostgreSQL Materialized Views: A Beginner's Guide

Comments
8 min read
Casting in PostgreSQL: Handling Data Type Conversions Effectively
Cover image for Casting in PostgreSQL: Handling Data Type Conversions Effectively

Casting in PostgreSQL: Handling Data Type Conversions Effectively

Comments
6 min read
Date Formatting in Postgres: A Comprehensive Guide
Cover image for Date Formatting in Postgres: A Comprehensive Guide

Date Formatting in Postgres: A Comprehensive Guide

Comments
7 min read
View vs Materialized View in databases: Differences and Use cases
Cover image for View vs Materialized View in databases: Differences and Use cases

View vs Materialized View in databases: Differences and Use cases

Comments
9 min read
SQL Deep Dive: Mastering DATEDIFF with Code Examples
Cover image for SQL Deep Dive: Mastering DATEDIFF with Code Examples

SQL Deep Dive: Mastering DATEDIFF with Code Examples

Comments
1 min read
Automating Databases with SQL Triggers
Cover image for Automating Databases with SQL Triggers

Automating Databases with SQL Triggers

Comments
1 min read
PostgreSQL's ON DELETE CASCADE Feature
Cover image for PostgreSQL's ON DELETE CASCADE Feature

PostgreSQL's ON DELETE CASCADE Feature

Comments
2 min read
Simplified Overview of JSON vs. JSONB in PostgreSQL
Cover image for Simplified Overview of JSON vs. JSONB in PostgreSQL

Simplified Overview of JSON vs. JSONB in PostgreSQL

Comments
2 min read
SQL Column Deletion Techniques
Cover image for SQL Column Deletion Techniques

SQL Column Deletion Techniques

Comments
2 min read
Implementing Self Joins in SQL: A Guide for Developers
Cover image for Implementing Self Joins in SQL: A Guide for Developers

Implementing Self Joins in SQL: A Guide for Developers

Comments
1 min read
PostgreSQL - How To Kill Connections
Cover image for PostgreSQL - How To Kill Connections

PostgreSQL - How To Kill Connections

Comments
1 min read
Oracle Data Types: An Overview
Cover image for Oracle Data Types: An Overview

Oracle Data Types: An Overview

Comments
1 min read
ER Models, Diagrams, and Schemas: A Developer's Brief
Cover image for ER Models, Diagrams, and Schemas: A Developer's Brief

ER Models, Diagrams, and Schemas: A Developer's Brief

Comments
2 min read
Introduction to the BLOB Data Type
Cover image for Introduction to the BLOB Data Type

Introduction to the BLOB Data Type

Comments
2 min read
Quick Guide to Parameterized Queries in SQL
Cover image for Quick Guide to Parameterized Queries in SQL

Quick Guide to Parameterized Queries in SQL

Comments
1 min read
SQL Joins: Easy Guide for Joining tables
Cover image for SQL Joins: Easy Guide for Joining tables

SQL Joins: Easy Guide for Joining tables

Comments
2 min read
A Beginner's Guide to Database Transactions
Cover image for A Beginner's Guide to Database Transactions

A Beginner's Guide to Database Transactions

Comments
1 min read
Postgres in Docker: A Simplified Setup Process
Cover image for Postgres in Docker: A Simplified Setup Process

Postgres in Docker: A Simplified Setup Process

Comments
1 min read
Resolving "sudo mysql_secure_installation: command not found" in MariaDB
Cover image for Resolving "sudo mysql_secure_installation: command not found" in MariaDB

Resolving "sudo mysql_secure_installation: command not found" in MariaDB

Comments
1 min read
Efficient Date and Time Extraction in MS SQL Server
Cover image for Efficient Date and Time Extraction in MS SQL Server

Efficient Date and Time Extraction in MS SQL Server

Comments
1 min read
SQL vs. Sequel: Navigating the Pronunciation Landscape
Cover image for SQL vs. Sequel: Navigating the Pronunciation Landscape

SQL vs. Sequel: Navigating the Pronunciation Landscape

Comments
1 min read
A Quick Guide to MySQL Port Setup
Cover image for A Quick Guide to MySQL Port Setup

A Quick Guide to MySQL Port Setup

Comments
1 min read