Tag: Postgresql
7 Best PostgreSQL Database Design Tools
Database design is the most important part of any database project, and choosing the best tools for your database project is crucial to its success. In this article, we’ll explore the features of the best design tools for your PostgreSQL database.
As we all know, database design or data modeling is the first step in building a database. Data modeling is the methodical process of identifying, classifying, and graphically presenting all the relevant data in an information system.
Support for New Versions of PostgreSQL and MS SQL Server in Vertabelo
With the latest release of Vertabelo in 2021, we have overhauled the UI for a better experience in database modeling. We’ve also added a lot of new features requested by our customers.
We’re happy to announce we now support the latest versions of PostgreSQL and MS SQL Server. You can now define partitions, specify data types for sequences, and add identity columns in PostgreSQL. Similarly, you can create DDLs for the latest versions of MS SQL Server.
Converting an Analytics System from Postgres to Redshift
Online systems tend to track user’s actions. Gathering information about users’ behavior can increase the quality of their experience, which can lead to increased business income. In this article, we will show how to reimplement an existing Postgres database to a more complex analytics database like Amazon Redshift.
The solution we want to reengineer is a tracking system for an online SQL learning platform like LearnSQL.com.
The source implementation is built on a PostgreSQL database and contains two main tables:
What’s the Best ER Diagram Tool for PostgreSQL?
Data modeling for PostgreSQL is no longer a challenge. Read on and learn about the best tool for PostgreSQL ER diagrams.
PostgreSQL, a.k.a. Postgres, is a free and open-source relational database management system (RDBMS). It has become popular for database development among major organizations such as Instagram, Skype, and Netflix.
Since the ERD (Entity Relationship Diagram) is an essential tool in data modeling, it’s worth the effort to find the perfect ERD tools that support Postgres.
Constraints in PostgreSQL and How to Model Them in Vertabelo
Database constraints allow you to give a certain shape to your data, tables, and columns. Are you planning to use PostgreSQL as your database? Check out what PostgreSQL constraints can do!
In this article, we will go over PostgreSQL’s database constraints and see how to model them in Vertabelo. For each of the constraints, I’ll provide:
A definition of the constraint. A usage example. Instructions on how to model the constraint in Vertabelo.
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.
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.
Designing & Deploying a PostgreSQL Database in the Cloud
Our users sometimes say to us: “Vertabelo is awesome but... how can I add the data?” Oh, come on! Vertabelo is not a database engine or a database administration tool. At least not at the moment. For now, Vertabelo is intended mainly to design database models. This doesn't mean that we don’t care about what you can do next with models created in our application. Of course, we do! That’s why we provide our users with some useful tools on our website and in our GitHub repository.
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.
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 :)
