DbVisualizer

DbVisualizer 26.1 is here! 🦾 Introducing the new AI assistant to help you write SQL, optimize scripts, and troubleshoot faster. We’re also adding a recently used connections view, support for more databases, performance improvements, and more. dbvis.com/whatsnew/

Happy Holidays from all of us to all of you! Wishing you a cozy season and clean, fast queries. 🎄✨

DbVisualizer 25.3 is here! 🚀  This release brings shared database connections with Git support, major MongoDB improvements (including editing documents directly), a new sidebar layout, and much more.  We can’t wait for you to try it!  dbvis.com/whatsnew/

Handling NULL properly is essential for accurate queries, comparisons, and calculations. Let's look into how to recognize and work with NULL in SQL for effective data querying! #SQL #NULL dbvis.com/thetable/deali…

Dig into the so-called “golden backup rule” for databases. Implement the perfect data backup and recovery strategy. Join in! #backup #recovery dbvis.com/thetable/data-…

Let's explore everything you need to know about the FULL OUTER JOIN in SQL and how to use it to fully combine data from two tables! #SQL #JOIN dbvis.com/thetable/a-com…

🕵️‍♂️ Explore and learn the SQL CREATE TABLE command and find out how to use it across the most popular databases! #SQL #CREATE dbvis.com/thetable/a-gui…

Time to look at what the SQL PIVOT clause is and how it is used in changing one table-valued expression into another — let’s get right into it! #SQL #Pivot dbvis.com/thetable/sql-p…

What is the relationship between indexes and partitioned tables? Find out all that in this article on SQL Server indexes on partitioned tables! #SQL #Index dbvis.com/thetable/a-gui…

PostgreSQL is unique in its approach to data types. In this blog, we learn how to approach one of those data types and create arrays with numbers. #PostgreSQL #Arrays dbvis.com/thetable/postg…

Learn what the DROP COLUMN ALTER TABLE statement is and how to use it in MySQL, PostgreSQL, SQL Server, and Oracle. Let’s dive in! #SQL dbvis.com/thetable/a-com…

Say hello to DbVisualizer 25.2 👋 This release introduces integrated Git support, support for Redis, improved data grid views, smarter auto-completion, and more. Give it a spin! 🎉 #DbVisualizer #Redis #Git #Database dbvis.com/whatsnew/

👯‍♂️ Duplicated records in MySQL can significantly hinder your data operations.  Learn the definition of duplicate records and discover how to efficiently retrieve and manage them like a pro! #MySQL #Duplicate dbvis.com/thetable/how-t…

🦄 What Is the SQL UNIQUE Constraint? In this guide, you will find out what the UNIQUE constraint in SQL is, where you can use it, and how to use it in popular database technologies. #SQL #UNIQUE dbvis.com/thetable/under…

Truncating multiple tables in SQL simultaneously can come in handy in many scenarios and for a variety of reasons. In this guide you will learn how to truncate multiple tables in SQL. Let’s dive in! #SQL #Truncate dbvis.com/thetable/how-t…

📊 The SQL GROUP BY statement is used to group rows that have a similar column value together. In this article we’ll figure out what it is, how it works, and what you can do to make it work for you. #SQL dbvis.com/thetable/sql-g…

A SQL formatter, also known as a SQL beautifier, is a tool designed to format SQL code according to specified rules. Let's take an in-depth look at SQL formatting, understanding how it works and why to use it! #SQL #Format dbvis.com/thetable/sql-f…

🔎 Embark on a journey to understand the capabilities of CONTAINS in SQL Server! Explore the power and understand how it works with real-world examples. #SQLServer #SQL dbvis.com/thetable/sql-c…

Say hi to DbVisualizer 25.1 👋 Now supporting @DynamoDB, @DuckDB & @QuestDb, plus a new Files tab, 10x faster diagrams, enhanced encryption, scroll-to-zoom, and more! Try it today 🎉  #DbVisualizer #DynamoDB #DuckDB #QuestDB dbvis.com/whatsnew

📦 What is pg_dump? Let’s learn how to dump a PostgreSQL database with the pg_dump command-line utility! #PostgreSQL #pg_dump dbvis.com/thetable/a-com…