DbVisualizer - DEV Community

DbVisualizer

Sep 18

MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

#mysql #sql

2 min read

DbVisualizer

Sep 15

Primary Key vs. Foreign Key in SQL: Explained with Examples

#sql #mysql #sqlserver

2 min read

DbVisualizer

Sep 11

SQL LIKE Operator: What It Is, How It Works, and Best Practices

#sql #mysql #postgressql

2 min read

DbVisualizer

Sep 8

How to Use PostgreSQL Foreign Keys the Right Way

#sql #postgressql

2 min read

DbVisualizer

Sep 4

MySQL IFNULL Simplified: Replace NULL Values in Queries

#mysql #ifnull

2 min read

DbVisualizer

Sep 1

Secure Sensitive Data: Discovery Practices and Tools That Work

#security

1 min read

DbVisualizer

Aug 28

How to Discover and Protect Sensitive Data Using CLI and SQL Tools

#security

2 min read

DbVisualizer

Aug 25

How to Use SQL Server DATEADD for Real-Time Date Calculations

#sql #sqlserver

2 min read

DbVisualizer

Aug 21

How to Back Up and Restore MySQL Using mysqldump

#sql #mysql #backup

2 min read

DbVisualizer

Aug 18

Simplifying SQL DELETE for Developers: Syntax and Best Practices

1 min read

DbVisualizer

Aug 14

Simplifying SQL Date Data Types with Practical Tips

#sql #mysql #oracle #postgressql

1 min read

DbVisualizer

Aug 11

SQL HAVING Explained: Filter Grouped Data With Ease

#sql

2 min read

DbVisualizer

Aug 7

SQL INTERSECT Explained: Find Shared Rows Easily

#sql

1

2 min read

DbVisualizer

Aug 4

Write Clean SQL: Tools That Format Your Queries for You

#sql #formatter

1 min read

DbVisualizer

Jul 31

Clean and Compare Strings in SQL with TRIM

#sql #mysql #trim

2 min read

DbVisualizer

Jul 28

A Developer's Guide to PostgreSQL Full Text Search

#postgressql #search

1 min read

DbVisualizer

Jul 24

SQL UNION ALL: Combine Queries and Keep Duplicates

#sql #mysql #union

2 min read

DbVisualizer

Jul 21

How to Use SQL UNION and UNION ALL to Merge Query Results

#sql #unionall #sqlserver

1

2 min read

DbVisualizer

Jul 17

How to Use SQL CONVERT for Clean Type Conversions

#convert #dataconversion #mysql #sqlserver

1 min read

DbVisualizer

Jul 14

SQL CASE Statement Explained with Real-World Examples

#sql #case

1 min read

DbVisualizer

Jul 10

SQL REPLACE Function: Quick Guide with Real Examples

#sql

2 min read

DbVisualizer

Jul 7

SQL ORDER BY: Quick Sorting Examples and Tips

#sql #mysql

1

2 min read

DbVisualizer

Jul 3

SQL EXCEPT: Find the Difference Between Two Tables

#sql

1

2 min read

DbVisualizer

Jun 30

How to Add and Subtract Dates in SQL (MySQL, PostgreSQL, SQL Server)

#date #datetime #mysql #postgressql

2 min read

DbVisualizer

Jun 26

Essential SQL Commands for Developers (With Code Samples)

#sql #mysql #postgressql

2 min read

DbVisualizer

Jun 23

Understanding SUBSTRING_INDEX in SQL: Real Use Cases

#sql #mysql

2 min read

DbVisualizer

Jun 19

A Developer’s Guide to SQL NOT IN: Smarter Queries, Faster Results

#sql

1

2 min read

DbVisualizer

Jun 16

SQL Add to Date: Simple Guide for MySQL, PostgreSQL, SQL Server & Oracle

#sql #mysql #oracle #postgressql

1 min read

DbVisualizer

Jun 12

Learn SQL’s CAST Function for Clean Type Conversion

1

1 min read

DbVisualizer

Jun 9

PostgreSQL Upsert: INSERT ON CONFLICT Explained

#postgressql #upsert

1

2 min read

DbVisualizer

Jun 5

Make Your SQL Cleaner with Common Table Expressions (CTEs)

#sql #cte

2 min read

DbVisualizer

Jun 2

Enhancing SQL INSERT INTO Performance: Tips and Tools

#insert #sql

2 min read

DbVisualizer

May 29

Why Data Visualization Tools Matter for Developers, Managers, and Analysts

#datavisualization

1

1 min read

DbVisualizer

May 26

Postgres TEXT vs VARCHAR: When to Use Which

#postgres #text #varchar

2 min read

DbVisualizer

May 22

ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools

#sql

2 min read

DbVisualizer

May 19

Schemas in PostgreSQL: A Practical Guide for Developers

#schema #postgressql

2 min read

DbVisualizer

May 15

Database Schema Design: How to Structure Your App’s Data Effectively

#schema

2 min read

DbVisualizer

May 12

Clean SQL with Comments: Syntax and Practices for All Engines

#sql

1 min read

DbVisualizer

May 8

How to Start with Database Migrations

#migration

1

2 min read

DbVisualizer

May 5

Efficient String Splitting in PostgreSQL: 5 Essential Functions

#postgressql #split

1 min read

DbVisualizer

May 1

PostgreSQL CASE: Conditional Logic for Powerful SQL Queries

#postgressql #case

2 min read

DbVisualizer

Apr 28

PostgreSQL CASE: Build Smarter Queries with Conditional Logic

#postgressql #case

1 min read

DbVisualizer

Apr 24

Outer Joins in SQL: The Key to Keeping Unmatched Rows

#join

2 min read

DbVisualizer

Apr 21

SQL DDL Commands Explained: Structuring Your Database

#sql #ddl

2 min read

DbVisualizer

Apr 17

How to Use SQL Views to Simplify Data Access and Reporting

#sqlviews

1 min read

DbVisualizer

Apr 14

Three practical ways to create a database in MySQL

#createtable #mysql

2 min read

DbVisualizer

Apr 10

Essential PostgreSQL Data Types Explained

2 min read

DbVisualizer

Apr 7

Handling Big Data in SQL Databases – Pitfalls to Avoid

#bigdata

2 min read

DbVisualizer

Apr 3

SQL Temporary Tables: A Quick and Practical Guide

#sql

1

2 min read

DbVisualizer

Mar 31

pg_dump PostgreSQL Backups: A Quick and Practical Guide

#pgdump #postgres

2 min read

DbVisualizer

Mar 27

SQL DATEDIFF Explained: Syntax and Database Differences

#date

1 min read

DbVisualizer

Mar 24

PostgreSQL Data Types: An Essential Guide

#datatype #postgres

1 min read

DbVisualizer

Mar 20

Mastering SQL Server CONTAINS for Advanced Text Search

#sql

1 min read

DbVisualizer

Mar 17

SUBSTRING_INDEX in MySQL: A Simple Guide to String Extraction

#mysql

2 min read

DbVisualizer

Mar 13

Getting Started with SQL DISTINCT

#sql #postgres

2 min read

DbVisualizer

Mar 10

Ace Your SQL Interview with These Query Tips

#sql

1 min read

DbVisualizer

Mar 6

Fixing MySQL Shutdown Unexpectedly Error

#mysql

1

2 min read

DbVisualizer

Mar 3

Simplify SQL Queries with COALESCE

#sqlserver

1 min read

DbVisualizer

Feb 27

Mastering MySQL Security: Key Steps to Protect Your Database

#mysql #security

2 min read

DbVisualizer

Feb 24

Database Security Made Simple: Essential Practices

#security

2 min read

Two Year Club

Writing Debut

One Year Club

16 Week Writing Streak

8 Week Writing Streak

4 Week Writing Streak