Others

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 »
Read more
Others

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.
Read more
Others

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.
Read more
Others

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.
Read more
Others

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.
Read more
Others

“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.
Read more
Others

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.
Read more
Others

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.
Read more
Others

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.
Read more
Others

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.
Read more