Skip to content

DEV Community

The Table Series' Articles

Back to DbVisualizer's Series

Cover image for Optimizing Queries for Performance: MySQL Edition

Feb 1 '23

Optimizing Queries for Performance: MySQL Edition

#crypto #web3 #blockchain #offers

9 min read

Cover image for JSON vs. JSONB in PostgreSQL: A Complete Comparison

Feb 1 '23

JSON vs. JSONB in PostgreSQL: A Complete Comparison

#json #jsonb #postgres

5 min read

Cover image for Architecting for Security: MySQL Edition

Feb 3 '23

Architecting for Security: MySQL Edition

#web3 #ethereum #cryptocurrency #cybersecurity

10 min read

Feb 16 '23

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

#announcement #devto #offers

7 min read

Cover image for How To Deal With a Database With Billions of Records

Feb 20 '23

How To Deal With a Database With Billions of Records

#discuss

6 min read

Cover image for Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts

Feb 23 '23

Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts

#discuss #programming

6 min read

Cover image for How To Design And Build A Database In Postgres

Feb 27 '23

How To Design And Build A Database In Postgres

#help #git #github #snippet

15 min read

Cover image for Top five query tuning techniques for Microsoft SQL Server

Mar 3 '23

Top five query tuning techniques for Microsoft SQL Server

#gratitude

6 min read

Cover image for Using PostgreSQL to Manage Business Inventory Data and Visualize It

Mar 6 '23

Using PostgreSQL to Manage Business Inventory Data and Visualize It

9 min read

Cover image for SQL Triggers: What They Are and How to Use Them

Mar 10 '23

SQL Triggers: What They Are and How to Use Them

#triggers

8 min read

Cover image for Stored Procedures in SQL: A Complete Tutorial

Mar 13 '23

Stored Procedures in SQL: A Complete Tutorial

#sql

9 min read

Cover image for SSH Tunneling: the Good, the Bad, and the Ugly

Mar 17 '23

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

5 min read

Cover image for How To Create a Table Like Another Table in MySQL

Mar 20 '23

How To Create a Table Like Another Table in MySQL

6 min read

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

Mar 24 '23

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

6 min read

Cover image for A Comprehensive Guide to Data Structures in SQL

Mar 27 '23

A Comprehensive Guide to Data Structures in SQL

8 min read

Cover image for Database Transactions 101: The Essential Guide

Mar 31 '23

Database Transactions 101: The Essential Guide

6 min read

Cover image for The Complete Guide to SQL Subqueries

Apr 3 '23

The Complete Guide to SQL Subqueries

#rust #csharp #java #cloudnative

7 min read

Cover image for How To Secure Data In A Postgres Database: A Guide

Apr 6 '23

How To Secure Data In A Postgres Database: A Guide

15 min read

Cover image for Working with NULL in Databases. Turn Your Frustration Into Delight

Apr 11 '23

Working with NULL in Databases. Turn Your Frustration Into Delight

#null

5 min read

Cover image for ACID in Database Systems: All You Need to Know

Apr 14 '23

ACID in Database Systems: All You Need to Know

5 min read

Cover image for Database Security 101: Best Practices to Secure Your Data

Apr 17 '23

Database Security 101: Best Practices to Secure Your Data

7 min read

Cover image for Best Practices for Encrypting Data In Your Database

Apr 21 '23

Best Practices for Encrypting Data In Your Database

#security #encryption #mysql

5 min read

Cover image for Getting Started with Multiversion Concurrency Control (MVCC) in PostgreSQL

Apr 24 '23

Getting Started with Multiversion Concurrency Control (MVCC) in PostgreSQL

#postgres #concurrency

8 min read

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

Apr 28 '23

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

#postgres #beginners

3 min read

May 3 '23

BLOB Data Type: Everything You Can Do With It

#blob

6 min read

Cover image for A Guide to ACID In MySQL

May 8 '23

A Guide to ACID In MySQL

#acid #mysql #security

6 min read

Cover image for Preventing Illicit Uploads in MySQL – secure_file_priv

May 12 '23

Preventing Illicit Uploads in MySQL – secure_file_priv

#mysql #security

6 min read

Cover image for The Ultimate Guide to the MySQL Port

May 15 '23

The Ultimate Guide to the MySQL Port

#mysql #ports

3 min read

Cover image for ALTER TABLE Explained

May 17 '23

ALTER TABLE Explained

6 min read

Cover image for Deadlocks in Databases: A Guide

May 19 '23

Deadlocks in Databases: A Guide

#performance

6 min read