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... Read more
First part of our Database Design 101 series that brings you an easy-to-understand introduction to databases. Read more
A good data modeling exercise for beginners is to create a data model of an online store. Every time I give this exercise to my students, I'm surprised at how difficult it is for them.
Let's see how it can be done. We know we have to create a table for every concept in... Read more
The newest Vertabelo feature is Reverse Engineering: a way to import an existing database into Vertabelo. The Reverse Engineering tool is a simple command-line Java application that you can download from our website. It connects to your database, reads the table and view details and stores the info in an XML file. Import the... Read more
So I’m sitting here thinking to myself: How should I share a new Vertabelo feature with you?
Should I write an over-hyped article full of industry jargon and marketing-speak?
Hmmm. Tried and failed.
I’ve just gotta show you the feature straight up and how simple it is to use. More meat, little fat, no fluff :). Read more
I recently discovered the JTBD framework at Business of Software: what I learnt made me swear that I’ll use it from now on in every customer interview I need to do in order to understand their underlying needs and support our product pipeline. It is that brilliant. It’s like a targeted, systematic guided interview... Read more
Many people wonder why relational databases are called "relational.” Some think that it's because of a logical entity-relationship model you often start your design with. Or, because you have tables and relationships (aka foreign keys) between them. But that's not the case.
The name comes from the mathematical notion of "relation." It all started with... Read more
Today we are happy to announce that Vertabelo has a new feature we've been working on for some time – views. Now you can easily add them to the diagram, change their definition and other properties and have them generated in your SQL scripts. Read more
We are launching a new product on a market, so let me tell you the short story about how and why Vertabelo was born.
e-point and I personally have more than fifteen years of experience in building business applications. All of them use relational databases as a storage for their data. Most of those applications... Read more
Writing HTML can be a chore – making sure elements are closed properly can be annoying without proper IDE support, and CSS markup often requires repeated patterns of nested divs and spans in order to get the layout working properly. There are various templating languages and engines available for dealing with this problem. Probably... Read more
