Forem

DbVisualizer profile picture

DbVisualizer

DbVisualizer is used for development, analytics, maintenance, and more, by database professionals all over the world. It connects to all popular databases and runs on Win, macOS & Linux.

Location Nacka, Sweden Joined Joined on  Personal website https://www.dbvis.com/ github website
MySQL ALTER TABLE: A Developer’s Guide to Schema Changes
Cover image for MySQL ALTER TABLE: A Developer’s Guide to Schema Changes
dbvismarketing profile

MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

#sql #mysql
Comments
2 min read
MySQL Shutdown Unexpectedly: Causes and Fixes for Developers
Cover image for MySQL Shutdown Unexpectedly: Causes and Fixes for Developers
dbvismarketing profile

MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

#mysql #sql
Comments
2 min read
Primary Key vs. Foreign Key in SQL: Explained with Examples
Cover image for Primary Key vs. Foreign Key in SQL: Explained with Examples
dbvismarketing profile

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

#sql #mysql #sqlserver
Comments
2 min read
SQL LIKE Operator: What It Is, How It Works, and Best Practices
Cover image for SQL LIKE Operator: What It Is, How It Works, and Best Practices
dbvismarketing profile

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

#sql #mysql #postgressql
Comments
2 min read
How to Use PostgreSQL Foreign Keys the Right Way
Cover image for How to Use PostgreSQL Foreign Keys the Right Way
dbvismarketing profile

How to Use PostgreSQL Foreign Keys the Right Way

#sql #postgressql
Comments
2 min read
MySQL IFNULL Simplified: Replace NULL Values in Queries
Cover image for MySQL IFNULL Simplified: Replace NULL Values in Queries
dbvismarketing profile

MySQL IFNULL Simplified: Replace NULL Values in Queries

#mysql #ifnull
Comments
2 min read
Secure Sensitive Data: Discovery Practices and Tools That Work
Cover image for Secure Sensitive Data: Discovery Practices and Tools That Work
dbvismarketing profile

Secure Sensitive Data: Discovery Practices and Tools That Work

#security
Comments
1 min read
How to Discover and Protect Sensitive Data Using CLI and SQL Tools
Cover image for How to Discover and Protect Sensitive Data Using CLI and SQL Tools
dbvismarketing profile

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

#security
Comments
2 min read
How to Use SQL Server DATEADD for Real-Time Date Calculations
Cover image for How to Use SQL Server DATEADD for Real-Time Date Calculations
dbvismarketing profile

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

#sql #sqlserver
Comments
2 min read
How to Back Up and Restore MySQL Using mysqldump
Cover image for How to Back Up and Restore MySQL Using mysqldump
dbvismarketing profile

How to Back Up and Restore MySQL Using mysqldump

#sql #mysql #backup
Comments
2 min read
Simplifying SQL DELETE for Developers: Syntax and Best Practices
Cover image for Simplifying SQL DELETE for Developers: Syntax and Best Practices
dbvismarketing profile

Simplifying SQL DELETE for Developers: Syntax and Best Practices

Comments
1 min read
Simplifying SQL Date Data Types with Practical Tips
Cover image for Simplifying SQL Date Data Types with Practical Tips
dbvismarketing profile

Simplifying SQL Date Data Types with Practical Tips

#sql #mysql #oracle #postgressql
Comments
1 min read
SQL HAVING Explained: Filter Grouped Data With Ease
Cover image for SQL HAVING Explained: Filter Grouped Data With Ease
dbvismarketing profile

SQL HAVING Explained: Filter Grouped Data With Ease

#sql
Comments
2 min read
SQL INTERSECT Explained: Find Shared Rows Easily
Cover image for SQL INTERSECT Explained: Find Shared Rows Easily
dbvismarketing profile

SQL INTERSECT Explained: Find Shared Rows Easily

#sql
1
Comments
2 min read
Write Clean SQL: Tools That Format Your Queries for You
Cover image for Write Clean SQL: Tools That Format Your Queries for You
dbvismarketing profile

Write Clean SQL: Tools That Format Your Queries for You

#sql #formatter
Comments
1 min read
Clean and Compare Strings in SQL with TRIM
dbvismarketing profile

Clean and Compare Strings in SQL with TRIM

#sql #mysql #trim
Comments
2 min read
A Developer's Guide to PostgreSQL Full Text Search
Cover image for A Developer's Guide to PostgreSQL Full Text Search
dbvismarketing profile

A Developer's Guide to PostgreSQL Full Text Search

#postgressql #search
Comments
1 min read
SQL UNION ALL: Combine Queries and Keep Duplicates
Cover image for SQL UNION ALL: Combine Queries and Keep Duplicates
dbvismarketing profile

SQL UNION ALL: Combine Queries and Keep Duplicates

#sql #mysql #union
Comments
2 min read
How to Use SQL UNION and UNION ALL to Merge Query Results
Cover image for How to Use SQL UNION and UNION ALL to Merge Query Results
dbvismarketing profile

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

#sql #unionall #sqlserver
1
Comments
2 min read
How to Use SQL CONVERT for Clean Type Conversions
Cover image for How to Use SQL CONVERT for Clean Type Conversions
dbvismarketing profile

How to Use SQL CONVERT for Clean Type Conversions

#convert #dataconversion #mysql #sqlserver
Comments
1 min read
SQL CASE Statement Explained with Real-World Examples
Cover image for SQL CASE Statement Explained with Real-World Examples
dbvismarketing profile

SQL CASE Statement Explained with Real-World Examples

#sql #case
Comments
1 min read
SQL REPLACE Function: Quick Guide with Real Examples
Cover image for SQL REPLACE Function: Quick Guide with Real Examples
dbvismarketing profile

SQL REPLACE Function: Quick Guide with Real Examples

#sql
Comments
2 min read
SQL ORDER BY: Quick Sorting Examples and Tips
Cover image for SQL ORDER BY: Quick Sorting Examples and Tips
dbvismarketing profile

SQL ORDER BY: Quick Sorting Examples and Tips

#sql #mysql
Comments 1
2 min read
SQL EXCEPT: Find the Difference Between Two Tables
Cover image for SQL EXCEPT: Find the Difference Between Two Tables
dbvismarketing profile

SQL EXCEPT: Find the Difference Between Two Tables

#sql
1
Comments
2 min read
How to Add and Subtract Dates in SQL (MySQL, PostgreSQL, SQL Server)
Cover image for How to Add and Subtract Dates in SQL (MySQL, PostgreSQL, SQL Server)
dbvismarketing profile

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

#date #datetime #mysql #postgressql
Comments
2 min read
Essential SQL Commands for Developers (With Code Samples)
Cover image for Essential SQL Commands for Developers (With Code Samples)
dbvismarketing profile

Essential SQL Commands for Developers (With Code Samples)

#sql #mysql #postgressql
Comments
2 min read
Understanding SUBSTRING_INDEX in SQL: Real Use Cases
Cover image for Understanding SUBSTRING_INDEX in SQL: Real Use Cases
dbvismarketing profile

Understanding SUBSTRING_INDEX in SQL: Real Use Cases

#sql #mysql
Comments
2 min read
A Developer’s Guide to SQL NOT IN: Smarter Queries, Faster Results
Cover image for A Developer’s Guide to SQL NOT IN: Smarter Queries, Faster Results
dbvismarketing profile

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

#sql
1
Comments
2 min read
SQL Add to Date: Simple Guide for MySQL, PostgreSQL, SQL Server & Oracle
dbvismarketing profile

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

#sql #mysql #oracle #postgressql
Comments
1 min read
Learn SQL’s CAST Function for Clean Type Conversion
dbvismarketing profile

Learn SQL’s CAST Function for Clean Type Conversion

Comments 1
1 min read
PostgreSQL Upsert: INSERT ON CONFLICT Explained
Cover image for PostgreSQL Upsert: INSERT ON CONFLICT Explained
dbvismarketing profile

PostgreSQL Upsert: INSERT ON CONFLICT Explained

#postgressql #upsert
1
Comments
2 min read
Make Your SQL Cleaner with Common Table Expressions (CTEs)
Cover image for Make Your SQL Cleaner with Common Table Expressions (CTEs)
dbvismarketing profile

Make Your SQL Cleaner with Common Table Expressions (CTEs)

#sql #cte
Comments
2 min read
Enhancing SQL INSERT INTO Performance: Tips and Tools
Cover image for Enhancing SQL INSERT INTO Performance: Tips and Tools
dbvismarketing profile

Enhancing SQL INSERT INTO Performance: Tips and Tools

#insert #sql
Comments
2 min read
Why Data Visualization Tools Matter for Developers, Managers, and Analysts
Cover image for Why Data Visualization Tools Matter for Developers, Managers, and Analysts
dbvismarketing profile

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

#datavisualization
1
Comments 1
1 min read
Postgres TEXT vs VARCHAR: When to Use Which
Cover image for Postgres TEXT vs VARCHAR: When to Use Which
dbvismarketing profile

Postgres TEXT vs VARCHAR: When to Use Which

#postgres #text #varchar
Comments
2 min read
ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools
Cover image for ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools
dbvismarketing profile

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

#sql
Comments
2 min read
Schemas in PostgreSQL: A Practical Guide for Developers
Cover image for Schemas in PostgreSQL: A Practical Guide for Developers
dbvismarketing profile

Schemas in PostgreSQL: A Practical Guide for Developers

#schema #postgressql
Comments
2 min read
Database Schema Design: How to Structure Your App’s Data Effectively
Cover image for Database Schema Design: How to Structure Your App’s Data Effectively
dbvismarketing profile

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

#schema
Comments
2 min read
Clean SQL with Comments: Syntax and Practices for All Engines
Cover image for Clean SQL with Comments: Syntax and Practices for All Engines
dbvismarketing profile

Clean SQL with Comments: Syntax and Practices for All Engines

#sql
Comments
1 min read
How to Start with Database Migrations
Cover image for How to Start with Database Migrations
dbvismarketing profile

How to Start with Database Migrations

#migration
1
Comments 1
2 min read
Efficient String Splitting in PostgreSQL: 5 Essential Functions
Cover image for Efficient String Splitting in PostgreSQL: 5 Essential Functions
dbvismarketing profile

Efficient String Splitting in PostgreSQL: 5 Essential Functions

#postgressql #split
Comments
1 min read
PostgreSQL CASE: Conditional Logic for Powerful SQL Queries
Cover image for PostgreSQL CASE: Conditional Logic for Powerful SQL Queries
dbvismarketing profile

PostgreSQL CASE: Conditional Logic for Powerful SQL Queries

#postgressql #case
Comments
2 min read
PostgreSQL CASE: Build Smarter Queries with Conditional Logic
Cover image for PostgreSQL CASE: Build Smarter Queries with Conditional Logic
dbvismarketing profile

PostgreSQL CASE: Build Smarter Queries with Conditional Logic

#postgressql #case
Comments
1 min read
Outer Joins in SQL: The Key to Keeping Unmatched Rows
Cover image for Outer Joins in SQL: The Key to Keeping Unmatched Rows
dbvismarketing profile

Outer Joins in SQL: The Key to Keeping Unmatched Rows

#join
Comments
2 min read
SQL DDL Commands Explained: Structuring Your Database
Cover image for SQL DDL Commands Explained: Structuring Your Database
dbvismarketing profile

SQL DDL Commands Explained: Structuring Your Database

#sql #ddl
Comments
2 min read
How to Use SQL Views to Simplify Data Access and Reporting
Cover image for How to Use SQL Views to Simplify Data Access and Reporting
dbvismarketing profile

How to Use SQL Views to Simplify Data Access and Reporting

#sqlviews
Comments
1 min read
Three practical ways to create a database in MySQL
Cover image for Three practical ways to create a database in MySQL
dbvismarketing profile

Three practical ways to create a database in MySQL

#createtable #mysql
Comments
2 min read
Essential PostgreSQL Data Types Explained
Cover image for Essential PostgreSQL Data Types Explained
dbvismarketing profile

Essential PostgreSQL Data Types Explained

Comments
2 min read
Handling Big Data in SQL Databases – Pitfalls to Avoid
Cover image for Handling Big Data in SQL Databases – Pitfalls to Avoid
dbvismarketing profile

Handling Big Data in SQL Databases – Pitfalls to Avoid

#bigdata
Comments
2 min read
SQL Temporary Tables: A Quick and Practical Guide
dbvismarketing profile

SQL Temporary Tables: A Quick and Practical Guide

#sql
1
Comments
2 min read
pg_dump PostgreSQL Backups: A Quick and Practical Guide
Cover image for pg_dump PostgreSQL Backups: A Quick and Practical Guide
dbvismarketing profile

pg_dump PostgreSQL Backups: A Quick and Practical Guide

#pgdump #postgres
Comments
2 min read
SQL DATEDIFF Explained: Syntax and Database Differences
Cover image for SQL DATEDIFF Explained: Syntax and Database Differences
dbvismarketing profile

SQL DATEDIFF Explained: Syntax and Database Differences

#date
Comments
1 min read
PostgreSQL Data Types: An Essential Guide
Cover image for PostgreSQL Data Types: An Essential Guide
dbvismarketing profile

PostgreSQL Data Types: An Essential Guide

#datatype #postgres
Comments
1 min read
Mastering SQL Server CONTAINS for Advanced Text Search
Cover image for Mastering SQL Server CONTAINS for Advanced Text Search
dbvismarketing profile

Mastering SQL Server CONTAINS for Advanced Text Search

#sql
Comments
1 min read
SUBSTRING_INDEX in MySQL: A Simple Guide to String Extraction
Cover image for SUBSTRING_INDEX in MySQL: A Simple Guide to String Extraction
dbvismarketing profile

SUBSTRING_INDEX in MySQL: A Simple Guide to String Extraction

#mysql
Comments
2 min read
Getting Started with SQL DISTINCT
Cover image for Getting Started with SQL DISTINCT
dbvismarketing profile

Getting Started with SQL DISTINCT

#sql #postgres
Comments
2 min read
Ace Your SQL Interview with These Query Tips
Cover image for Ace Your SQL Interview with These Query Tips
dbvismarketing profile

Ace Your SQL Interview with These Query Tips

#sql
Comments
1 min read
Fixing MySQL Shutdown Unexpectedly Error
Cover image for Fixing MySQL Shutdown Unexpectedly Error
dbvismarketing profile

Fixing MySQL Shutdown Unexpectedly Error

#mysql
1
Comments
2 min read
Simplify SQL Queries with COALESCE
Cover image for Simplify SQL Queries with COALESCE
dbvismarketing profile

Simplify SQL Queries with COALESCE

#sqlserver
Comments
1 min read
Mastering MySQL Security: Key Steps to Protect Your Database
Cover image for Mastering MySQL Security: Key Steps to Protect Your Database
dbvismarketing profile

Mastering MySQL Security: Key Steps to Protect Your Database

#mysql #security
Comments
2 min read
loading...