MySQL
PostgreSQL vs MySQL/MariaDB Comparison: Differences, Performance, and Syntax
When it comes to choosing the database management system (DBMS), questions arise. You need the one that will match your needs and deliver the...
MySQL vs MariaDB: Difference, Performance, and Features (Full Comparison)
There are a lot of relational database management systems on the market today, and choosing the proper one might be quite a challenge. The...
Software Development Life Cycle Tutorial with Examples
SDLC (Software Development Life Cycle) is a series of steps for developing, improving, and sustaining a software system. Learn more about the stages and best practices.
https://blog.devart.com/wp-content/uploads/2024/07/ElevenLabs_2024-07-04T06_53_04_Software-Development-Life-Cycle-Tutorial-with-Examples.mp3
Sometimes we cannot...
Topping the Charts Again: dbForge Studios Awarded G2 High Performer & Leader Fall 2021
More good news coming our way!
It is inspiring to see that all the hard work we put into our products pays off as happy...
Data Types in MySQL: Tutorial and Full List With Examples of Data Formats
In this article, we are going to discuss the MySQL data types list, including string, numeric, date and time, spatial, and JSON supported by...
What Is InnoDB in MySQL? Tutorial with Examples and Performance Tuning Tips
There is a number of powerful MySQL storage engines at our disposal, and InnoDB is undoubtedly one of the most popular ones. It is...
How to Create a New User Account in MySQL and Grant Permissions on a Database
This article provides a complete overview of how to create a new user account in MySQL and grant different types of privileges on a...
MariaDB Tutorial: An Introductory Guide With Examples
MariaDB is a popular relational database management system (RDBMS) that has a striking resemblance to MySQL. That is why we decided to compare and...
Introduction to MySQL UPDATE Statement
Most modern websites and applications ground on data collection, storage, and analysis. Databases take an active part in building the entire Web environment. That’s...
dbForge Studio for MySQL Gains More User Recognition with 3 Prestigious Awards
dbForge Studio for MySQL is one of the most famous and valuable Devart products - a comprehensive solution with an intuitive interface for MySQL...
dbForge Studio for MySQL vs MySQL Workbench
Every single year new products and new versions of the leading tools enter the market. Their providers compete, offering database specialists more and more...
Devart Joins the Winners’ Circle of 2020 DBTA Readers’ Choice Awards
For the second year in a row, readers of DBTA — a magazine focusing on data, information management, and analytics — choose Devart products...
Top 10 Reasons Why Users Choose dbForge Studio for MySQL
The overwhelming popularity of MySQL means that people need convenient database tools to work with it. Software providers compete to produce the best MySQL...
How to Convert MySQL Data to PostgreSQL
Today, thousands of teams convert MySQL to PostgreSQL to meet the demands of modern applications. But doing it right requires more than just dumping...
SSL Connection to MySQL From Delphi With UniDAC and SecureBridge
This article explains how to establish an SSL connection to MySQL from Delphi with UniDAC and SecureBridge.
UniDAC has had MySQL SSL (using certificates) connection...
Meet Updated dbForge Tools for MySQL Product Line
We are very glad to tell you about the release of the tools included in dbForge for MySQL product line!
The tools comprising
the release...
How to kill certain connections to a MySQL database
Maintenance of databases or servers is quite often performed by database administrators at night. But these routines sometimes get blocked by long-running queries...
Apply Integrity Constraint to Your MySQL Database With the Help of dbForge Studio!
Our database tools team is pleased to announce the release of our dbForge MySQL products with a CHECK constraint support. We are looking forward...
MySQL Backup Strategies: How to Backup All and Multiple Databases
This article will outline two approaches to performing regular database backups. The first method involves backing up databases specified in a list, while the second entails bulk backing up of all databases. These procedures can be executed on both Linux and Windows platforms using dbForge Studio for MySQL.
Meet MariaDB 10.4 Support in MySQL Database Tools
We are glad to announce the release of the updated dbForge tools for MySQL. To ensure that the users of our MySQL tools can...
Connectivity to MariaDB Keeps Extending in dbForge Studio for MySQL
We are thrilled to inform our MySQL users that fresh and new dbForge Studio for MySQL, v8.1 has been just rolled out!
To ensure that...
Extended Connectivity in dbForge Tools for MySQL
We are excited to inform our users that we have released new versions of dbForge Schema Compare for MySQL, dbForge Data Compare for MySQL,...
MySQL Documenting Has Never Been Easier!
We just love to make our users' life a bit easier. This time, we are excited to treat you with a brand new addition...
Reinvented dbForge Tools for MySQL Have Arrived!
After a grand update of dbForge Studio for MySQL, we haven't forgotten about the rest of the dbForge for MySQL product range. Our developers...
How To Import a .CSV file through the Command Line
In this post, we are going to explore the way of how to import a .csv file through the command line in dbForge Studio...
Using HTTP Tunneling
Summary
This article elaborates on the HTTP Tunneling connection method and explains how to configure it by means of dbForge Studio for MySQL.
Introducing HTTP Tunneling
HTTP...
How to Get a List of Permissions of MySQL Users
In this article Devart describes how you can create a list of privileges of MySQL database users with the help of a data reports tool.
How To: Create a MySQL Database Diagram Using a Sketch Image
With Database Designer database can be created from a sketch without using any external image-viewers. Database Designer tool available in dbForge Studio for MySQL serves for creating database diagrams visually.
How To Create SQL Query in One Shot
In this article we describe how to quickly design a MySQL query visually using a special GUI tool - Query Builder.
How To: Setup Daily MySQL Backup on Windows
Making database backups is one of the most important things in the process of administrating MySQL databases, because some critical data loss can be irreplaceable. To avoid data loss you should make backups of all active databases regularly. If you have a backup, you will be able to restore the whole database or some of its objects easily.
Entity Framework 4 Release Candidate supported!
We have supported new functionality of Entity Framework 4 including Entity Framework v4 Release Candidate for dotConnect for Oracle, dotConnect for MySQL, dotConnect for...
Data Comparison Methods and Techniques
Data comparison is a difficult and resource-intensive process. In the article, we are going to explore algorithms, advantages, and disadvantages of specific data comparison,...
Query Builder for MySQL v 1.10 – unlimited database connectivity and better performance
Devart announced the release of dbForge Query Builder for MySQL v 1.10, a professional tool for quick creation of any queries without code and...
Be careful while using UNSIGNED data type in the routine body
Introduction
MySQL Server (starting from v 5.0), as Oracle and SQL Servers, allows creating stored procedures and functions.
Stored procedures are a set of SQL commands...
How to Save MySQL Database Diagrams as an Image
dbForge Studio for MySQL has the Database Designer functionality that allows you to build and view the structure of your database using the diagrams. You...
Designing Views with MySQL Query Builder
If you often need to create and modify views in your MySQL development you will like dbForge Studio for MySQL in-place query editing feature....
Getting Started with MySQL Database Designer
Contents
What Is Database Designer?
How to Create a Database Diagram
Navigating the Diagram
How to Quickly Print Diagram
Saving and Restoring the Diagram
What...
Synchronizing views between MySQL databases
How to compare and synchronize MySQL views? Recently we discovered some tricks in schema synchronization process of MySQL databases. It's about how MySQL creates...
