Example ER Diagrams
New Features in Vertabelo Released in April 2015
by Jack Polkowski
11 May 2015
Tell us what you want! If you have your own ideas for new features or you think that something could be improved in our application, do not hesitate to share your opinion. Send your suggestions to us via our Support Service. There, you can upvote or downvote new feature requests placed by other users. That way, you can have a significant impact on the development of our application. Go to Vertabelo's Support Service »
OLAP for OLTP Practitioners
by Jeffrey Edison
28 Apr 2015
I am currently working on a project where we need to create a database that will be primarily used to store data for reporting and forecasting. In the past, I have mostly worked with databases used for typical CRUD (create, retrieve, update, and delete) operations of data with some limited reporting features. When performing CRUD operations, normalization is important; while in analytics, a de-normalized structure is generally preferred.
Database Modeling in Scrum Teams
by Piotr Guzik
22 Apr 2015
Welcome! This is my first blog entry. I would like to invite you to explore the world of Scrum and databases. I’m a professional Scrum master. During my work, I’ve frequently encountered difficulties when collaborating with others to model a database. I would like to present crucial elements of applying Scrum. I will prove that Scrum is a perfect solution for plenty of teams. A Long Time Ago, in a Galaxy Far Far Away – Waterfall A lot of development teams use waterfall or combine waterfall with iterations.
Basing Database Models in Reality: A Blogger’s Challenge
by Jeffrey Edison
10 Apr 2015
When writing a blog post on database modeling, you must be prepared that your abstract model doesn’t meet the needs of most readers. The reason is simple. Real-life database models are usually created in close relation to specific business and development requirements while the blog models are not. For the last few weeks, I have been writing blog posts about creating database models. Topics ranged from a general approach to database modeling through a simple online forum to a model for a more complex online survey.
Side by Side: Doctrine2 and Propel 2
by Patrycja Dybka
8 Apr 2015
When you start working with data in an application, you may need to use an object-relational mapper (ORM), a layer between the database and application. For PHP the two most frequently used ORM’s are Doctrine and Propel. That’s why I decided to compare the main features of Doctrine in version 2.4.7 and Propel in version 2.0. At this point, I must strongly emphasize that this article is not to indicate which ORM is better and should be used.
“Concise Guide to Databases” – briefly about everything
by Konrad Zdanowski
31 Mar 2015
There are books that you plan to read. Then, there are books that you actually started reading and then stopped. Then, there are books you started reading and you hope to finish sometime. The last database book I did read was “Concise Guide to Databases” by Peter Lake and Paul Crowther. As title suggests this is not a book that dwells deeply into one specific aspect of DB theory or technology, quite the opposite.
5 Must-Read Database Modeling Books?
by Agnieszka Kozubek
16 Feb 2015
I recently realized that our database modeling library could use a few more advanced titles. So I headed over to Amazon to see what they had on offer. There are plenty of introductory books for beginners that tell you how to normalize data, and introduce you to indexes, but what about something for the professional, grown-up database modeler? Here are 5 of the best database modeling books I found (listed in no particular order) that go beyond the basics and come highly recommended by Amazon reviewers.
How to Trigger a Crude CRUD Database Prank
by Rafał Strzaliński
10 Feb 2015
Learning new things should be fun. I’ve read about database triggers multiple times but I didn’t have a chance to use them. Triggers are not popular these days especially in web development. Let’s mix learning and making fun (of others). What is a trigger for? It’s a kind of aspect of programming, an extra business logic executed on a given action. With triggers you can do complex validation, update balance on summary tables, record the who, what and when of changes to data and so on.
Chrome’s Monopoly Is Broken! Vertabelo Now Supports Safari
by Michał Kołodziejski
6 Feb 2015
Yes, I know that’s a tabloid-style headline but I couldn’t resist. The day has finally come. Now, you can create your database models in the Safari browser. I think it’s a good time to say a few words about why we restrict access to Vertabelo from most browsers and why we let Safari in. Our lack of support for browsers other than Chrome has been one of the most commented topics since Vertabelo came online.
How I Use the Vertabelo API With Gradle
by Maciej Matysiak
27 Jan 2015
What is Gradle? Gradle is an open source build automation system. It can automate the building, testing, publishing, deployment and more of software packages or other types of projects such as generated static websites, generated documentation or indeed anything else. Learn more about what makes Gradle a compelling choice for build automation. One of the exciting moments in a programmer’s life is to leave legacy code behind and have fun with some new, fresh and cool tools.