Tag: Mysql
6 Best MySQL Database Design Tools
Are you trying to choose the best database design tool for your next MySQL project? It’s challenging to pick the right tool for your requirements. This article will guide you in choosing the best MySQL database design tool among the many options on the market.
The designing phase is the most critical part of any software project – including database projects. A good database design is like a good building foundation; most project failures are due to the absence of a proper database design.
Top 10 Data Engineering Tools
Want to find out about the role of data engineers and data engineering? What are the top data engineering tools these professionals use? Read on to explore more.
Data engineers create pipelines to facilitate an organization's data analytics by collecting, merging, and transforming data. They create an infrastructure for modern data analytics.
Data engineers' work can be categorized into various sets of requirements that they must fulfill in building the pipeline.
Export SQL DDL From MySQL Workbench for Importing Into Vertabelo
Do you have an existing database model you would like to work with in Vertabelo? If so, you've come to the right place!
In this article, you learn how to export a DDL file from MySQL Workbench and import it into our modeling tool. We also take a look at other ways to import an existing database schema into Vertabelo and organize existing tables.
How to Export a DDL File From MySQL Workbench First, let's see how to export an existing database.
Constraints in MySQL and How to Model Them in Vertabelo
Before you do anything, you start with designing the database. It includes columns, tables, and relationships among them, as well as constraints. Database constraints play a crucial role in that they let you prevent any undesired data from being stored in a column or table. Let’s see how to make use of database constraints in MySQL.
In this article, we’ll go through all database constraints available in a MySQL database:
The Proper Way to Handle Multiple Time Zones in MySQL
In this article, I’ll walk you through some fundamental considerations for working with date- and time-related data in MySQL. We’ll also look at how to handle multiple time zones and daylight saving time changes. Let’s first address some core concepts that will help us understand the underlying complexity of time-related data. It is important to notice that these concepts apply when representing a point in time rather than an absolute duration.
Database Modeling Tips
When you were learning database concepts, data modeling looked pretty easy, didn’t it? You knew all the rules, and modeling seemed like a game: get a challenge, do your best, and eventually solve it. Job well done! Moving up to the next level – and so on. As you continue, though, you’ll see that database modeling is also an art. Many cases require a totally new approach. Everything can be done ‘by the book’, but sometimes you get better results when you go less orthodox.
WordPress – Behind the Scenes, Part 2
In Part 1 of this series, I demonstrated how to install WordPress locally and how to import a WordPress database into Vertabelo. In this article, we’ll take a closer look at the tables in the WordPress database.
A Quick Look at the WordPress Database Model and the Dashboard In the previous part, I imported the WordPress database into our online database modeling tool. For the record, the structure of the database is as follows:
WordPress – Behind the Scenes, Part 1
How often have you wondered about the structure of an existing database? It could be a 5-year-old legacy system or a brand-new open-source project. Let’s take a look at the ERD diagram of the database behind the most famous content management system: WordPress.
What Is WordPress and How Does It Work? WordPress is an open-source CMS (content management system) that was initially released in 2003. It started out as a blogging platform, but it has developed so much that today it can be used for almost anything.
Interesting Changes in MySQL 5.7
The General Availability version of MySQL is still version 5.6, but the development release of MySQL 5.7 definitely introduces some exciting changes to the world of database management systems. Is it worth giving a try? In this article, we’ll have a closer look at a few brand-new features that may help you decide to do so.
Native JSON Support JSON (short for Java Script Object Notation) is a format for storing information which can be a good alternative to XML.
7 Common Database Design Errors
Why Talk About Errors? Model Setup 1 – Using Invalid Names 2 – Insufficient Column Width 3 – Not Indexing Properly 4 – Not Considering Possible Volume or Traffic 5 – Ignoring Time Zones 6 – Missing Audit Trail 7 – Ignoring Collation Why Talk About Errors? The art of designing a good database is like swimming. It is relatively easy to start and difficult to master.
Database engine usage by Vertabelo users
The Vertabelo journey continues … We now have almost 10,000 users and the number of Vertabelo advocates keeps growing strong.
Vertabelo users come from over 100 countries and speak various languages. What unites them?
The relational database.
Let’s see what relational databases they use:
We wanted to determine the most popular database engine among Vertabelo users based on one of three widely-used operating systems: Windows, Linux, Mac OS.
SQL Performance Explained – the must-read book
Some time ago, the Vertabelo Team participated in the PostgreSQL Conference Europe 2013. Some of the talks were really nice. One of them stuck in my head for quite a long time. It was Markus Winand’s lecture titled “Indexes: The neglected performance all-rounder.” Although I had had a solid background in databases, this 50 minutes long talk showed me that not everything concerning indexes was as clear to me as I had thought.
WordPress Database Finally Unveiled!!!
Sorry for that tabloid title, but I couldn’t resist. I’m going to show you how to view the database design of other people’s systems. It will work for legacy systems as well. Of course, you may call show tables and describe table in the database console but that’s a very rudimentary way to examine the structure. You’ll miss a bird’s eye view of the design which is crucial to understanding a system as a whole.
Designing a Database: Should a Primary Key Be Natural or Surrogate?
Suppose we design a database. We’ve created some tables, each one has a few columns. Now we need to choose columns to be primary keys (PK) and make references between tables. And here some inexperienced designers face the dilemma – should a primary key be natural or surrogate?
There’s one and only one answer to that question: it depends. If anyone ever tried to convince you that you should have only natural keys or only surrogate keys, just smile :)
