Design fundamentals
When Normal Forms are Not Enough
22 Nov 2013
A real-life example:
Let’s assume that we have a system which stores data for distributors who sell products manufactured by some company. Each distributor receives points for selling products and may redeem a specified number of points to obtain a discount or extra bonus. Points are calculated by an external system and updated very frequently – after processing of each order placed by the distributor himself, a member of the distributor group, or a customer assigned to the distributor.
Others
Good news: we now support views
20 Nov 2013
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.
Quick overview of views Let's take a look at how simple it is to create a new view in our editor.
Our goal is to make a view which joins three tables as follows:
Database internals
Oracle VARCHAR2 Column Size
14 Nov 2013
Recently a fellow database architect claimed that in Oracle the type VARCHAR2(255) means a string of 255 bytes, not characters. There is not much difference between the two in the English-speaking world. It matters though if you want to handle people with names like Kołłątaj. (Not that Hugo Kołłątaj – a famous Polish 18th century politician – would ever use any of our systems, but he became our byword for all non-pure-ASCII names).
Others
Vertabelo in Dublin: PGConf EU 2013
8 Nov 2013
As those following our Twitter feed know, last week we were in Dublin, Ireland at the PostgreSQL Conference Europe 2013 as a Silver Sponsor. Since this conference and the host country were new to me, I thought I'd share some quick reflections on the experience.
The conference All of us on the Vertabelo Team are intimately involved with databases. Not only do we routinely design and use databases, we even built a tool to create database models.
Database internals
Why Doesn’t SQL*Plus Execute My Script?
29 Oct 2013
The question: Why doesn’t my script create tables? The other day I was testing Oracle SQL scripts generated by Vertabelo. Roughly, this is the code that was generated:
... -- Table: book CREATE TABLE book ( id integer NOT NULL, title varchar2(120) NOT NULL, isbn varchar2(15) NOT NULL, PRIMARY KEY (id) ) ; ... I used sqlplus to execute my script and see if it’s correct.
sqlplus (database-details) The script run without errors but the tables where NOT created.
Others
JDD 2013 – What we found out about databases?
23 Oct 2013
A week ago we were in Kraków at Java Developers Days, one of the biggest annual Java conferences in Poland. For the first time we showed Vertabelo live to a wider audience.
It was a pleasure to meet all the Java developers and talk about their projects, technologies and tools they use. We had a strong team at the conference and it allowed us to talk anyone interested - more than one hundred talks.
Others
Five reasons why we built Vertabelo
9 Oct 2013
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 are rather big - think about hundreds of tables in a database and hundreds of screens in a UI.
Others
33rd Degree Conference
1 Jan 1977
We're back to our quite chill office after attending the 33rd Degree Conference. I was wondering why they call it the 33rd Degree Conference. In three days, I had a chance to experience all 33 degrees ... in Celsius. It was hot - very hot! Even Californian iPads hung up (ha ha).
This time, we brought along a smaller team: Ania, Jarek and me. All of us are heavily involved in Vertabelo, so I sometimes forgot that we also went to the conference to promote our company, e-point.
Docs
How to use promotional codes?
1 Jan 1977
Here you find how to use our promotional coupon codes to buy our paid services. You can get promotional codes at developer conferences or similar events that we sponsor. If you already have a Vertabelo account go to step 2.
1. Create Vertabelo account If you don't have the Vertabelo account, please go to our simple registration form and fill in it. After clicking Create account button we will send you an email with confirmation link.
