TheTable Blog

The Table by DbVisualizer ↗ is where we gather together to learn about and simplify the complexity of working with database technologies.
MySQL

MySQL’s UTF-8: Is It Real?

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-06-01
PostgreSQL

Mastering Advanced SQL Queries With DbVisualizer And PostgreSQL

Author: Leslie S. Gyamfi
Length: 20 MINS
Type: Guide
Date: 2023-06-01
Bug

Why do we call software bugs, bugs?

Author: TheTable
Length: 4 MINS
Type: Guide
Date: 2023-05-30
MySQL
Daemon

Exploring the MySQL Daemon – A Guide

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-05-30
MySQL
Partitions

Archiving Data in MySQL Using Partitions

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-05-25
Migration
MySQL
PostgreSQL

Migrating Data Between Databases Using DbVisualizer

Author: Leslie S. Gyamfi
Length: 7 MINS
Type: Guide
Date: 2023-05-25
SQL

The Top Four Sites for Database Professionals Seeking New Job Opportunities

Author: TheTable
Length: 2 MINS
Type: Guide
Date: 2023-05-23
PostgreSQL
hstore

Storing Unstructured Data With Hstore in PostgreSQL

Author: Antonello Zanini
Length: 9 MINS
Type: Guide
Date: 2023-05-23
SQL

How to Pronounce SQL: SQL or Sequel?

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-05-23
SQL server
Security

How to Make Your SQL Server More Secure

Author: Igor Bobriakov
Length: 8 MINS
Type: Guide
Date: 2023-05-17
MySQL

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

Author: TheTable
Length: 2 MINS
Type: Guide
Date: 2023-05-17
Visualize

Creating Custom Visualizations with DbVisualizer

Author: Ochuko Onojakpor
Length: 6 MINS
Type: Guide
Date: 2023-05-16
MySQL

MySQL SUBSTRING Function: The Complete Guide

Author: TheTable
Length: 2 MINS
Type: Guide
Date: 2023-05-16
SQL
Security

Parameterized Queries in SQL – A Guide

Author: Lukas Vileikis
Length: 5 MINS
Type: Guide
Date: 2023-05-12
PostgreSQL

Understanding PostgreSQL Data Integrity

Author: Antonello Zanini
Length: 10 MINS
Type: Guide
Date: 2023-05-08
PostgreSQL
Docker

How to Set Up Postgres using Docker

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-05-08
MSSQL
Dates

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

Author: TheTable
Length: 4 MINS
Type: Guide
Date: 2023-05-04
PostgreSQL

How To List Databases in PostgreSQL

Author: Antonello Zanini
Length: 6 MINS
Type: Guide
Date: 2023-05-03
MySQL
Connection

How to Connect to MySQL Using Admin Account Remotely

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-05-03
MariaDB
Security

Solved: sudo mysql_secure_installation command not found in MariaDB

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-04-27
Performance

Why Are Your Databases Slow with Large Tables? An Overview

Author: Lukas Vileikis
Length: 9 MINS
Type: Guide
Date: 2023-04-27
Security

MySQL User Management: A Guide

Author: Lukas Vileikis
Length: 8 MINS
Type: Guide
Date: 2023-04-25
Columns

The Ultimate Guide to Generated Columns

Author: Antonello Zanini
Length: 7 MINS
Type: Guide
Date: 2023-04-20
ERD

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

Author: Antonello Zanini
Length: 8 MINS
Type: Guide
Date: 2023-04-19
Performance

A Guide to Multithreading in SQL

Author: Ochuko Onojakpor
Length: 8 MINS
Type: Guide
Date: 2023-04-14
SQL

Best Practices for SQL Coding and Development

Author: Ochuko Onojakpor
Length: 12 MINS
Type: Guide
Date: 2023-04-11
MySQL

Character Sets vs. Collations in a MySQL Database Infrastructure

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-04-06
Performance
Indexes

10x Query Performance with a Database Index

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-04-04
MySQL
Subquery

A Guide to Subqueries in MySQL

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-03-30
Performance

Deadlocks in Databases: A Guide

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-03-28
ACID

ACID in Database Systems: All You Need to Know

Author: Lukas Vileikis
Length: 5 MINS
Type: Guide
Date: 2023-03-28
ALTER TABLE

ALTER TABLE Explained

Author: Lukas Vileikis
Length: 8 MINS
Type: Guide
Date: 2023-03-23
MySQL
Ports

The Ultimate Guide to the MySQL Port

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-03-23
MySQL
Security

Preventing Illicit Uploads in MySQL – secure_file_priv

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-03-21
ACID
MySQL
Security

A Guide to ACID In MySQL

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-03-17
BLOB

BLOB Data Type: Everything You Can Do With It

Author: Antonello Zanini
Length: 8 MINS
Type: Guide
Date: 2023-03-13
Foreign Key
PostgreSQL

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

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-03-13
PostgreSQL
Concurrency

Getting Started with Multiversion Concurrency Control (MVCC) in PostgreSQL

Author: Leslie S. Gyamfi
Length: 8 MINS
Type: Guide
Date: 2023-03-10
Security
Encryption

Best Practices for Encrypting Data In Your Database

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-03-07
Security

Database Security 101: Best Practices to Secure Your Data

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-03-02
NULL

Working with NULL in Databases: Turn Your Frustration Into Delight

Author: Lukas Vileikis
Length: 4 MINS
Type: Guide
Date: 2023-02-23
Security
PostgreSQL

How To Secure Data In A Postgres Database: A Guide

Author: Bonnie
Length: 13 MINS
Type: Guide
Date: 2023-02-21
Subquery

The Complete Guide to SQL Subqueries

Author: Antonello Zanini
Length: 7 MINS
Type: Guide
Date: 2023-02-17
Transactions

Database Transactions 101: The Essential Guide

Author: Antonello Zanini
Length: 5 MINS
Type: Guide
Date: 2023-02-14
Data structures

A Comprehensive Guide to Data Structures in SQL

Author: Ochuko Onojakpor
Length: 8 MINS
Type: Guide
Date: 2023-02-09
Triggers

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

Author: Ochuko Onojakpor
Length: 8 MINS
Type: Guide
Date: 2023-02-06
MySQL

How To Create a Table Like Another Table in MySQL

Author: Antonello Zanini
Length: 5 MINS
Type: Guide
Date: 2023-02-03
SSH

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

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-01-31
Stored procedure
MySQL

Stored Procedures in SQL: A Complete Tutorial

Author: Antonello Zanini
Length: 12 MINS
Type: Guide
Date: 2023-01-27
Triggers

SQL Triggers: What They Are and How to Use Them

Author: Antonello Zanini
Length: 6 MINS
Type: Guide
Date: 2023-01-26
PostgreSQL

Using PostgreSQL to Manage Business Inventory Data and Visualize It

Author: Bonnie
Length: 7 MINS
Type: Guide
Date: 2023-01-23
Microsoft SQL Server
Optimization

Top five query tuning techniques for Microsoft SQL Server

Author: Igor Bobriakov
Length: 8 MINS
Type: Guide
Date: 2023-01-19
PostreSQL

How To Design And Build A Database In Postgres

Author: Bonnie
Length: 12 MINS
Type: Guide
Date: 2023-01-16
Reusable queries

Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts

Author: Ochuko Onojakpor
Length: 7 MINS
Type: Guide
Date: 2023-01-12
BIG Data

How To Deal With a Database With Billions of Records

Author: Antonello Zanini
Length: 7 MINS
Type: Guide
Date: 2023-01-06
MySQL
Security

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

Author: Lukas Vileikis
Length: 9 MINS
Type: Guide
Date: 2022-12-28
MySQL

Fixing Messy Queries with DbVisualizer – a Guide for MySQL

Author: Lukas Vileikis
Length: 8 MINS
Type: Guide
Date: 2022-12-22
Beginner
SQL

SQL for Beginners: 3 Sites You Should Know About

Author: TheTable
Length: 4 MINS
Type: Guide
Date: 2022-12-22
CRUD
SQL Transactions

SQL Transactions in a Flask CRUD Application

Author: Ochuko Onojakpor
Length: 8 MINS
Type: Guide
Date: 2022-12-16
MySQL
Security

Architecting for Security: MySQL Edition

Author: Lukas Vileikis
Length: 10 MINS
Type: Guide
Date: 2022-12-08
PostgreSQL
JSON

JSON vs. JSONB in PostgreSQL: A Complete Comparison

Author: Antonello Zanini
Length: 5 MINS
Type: Guide
Date: 2022-12-02
MySQL
InnoDB
ibdata1

InnoDB and ibdata1: Things You Need to Know

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2022-11-09
MySQL

Optimizing Queries for Performance: MySQL Edition

Author: Lukas Vileikis
Length: 9 MINS
Type: guide
Date: 2022-11-09
Filter

Filtering on aggregated data

Author: Scott A. Adams
Length: 7 MINS
Type: Guide
Date: 2022-03-21
SQLite

Create Your Own SQLite Database

Author: Scott A. Adams
Length: 8 MINS
Type: Guide
Date: 2021-12-21
Excel
Export

Excel to SQL Basics

Author: Scott A. Adams
Length: 10 MINS
Type: Guide
Date: 2021-12-21
ERD
Join

How to join your tables using ERD

Author: Scott A. Adams
Length: 8 MINS
Type: Guide
Date: 2021-12-21