Author: Agnieszka Kozubek

Chief Scientist at Vertabelo

How to Develop a PHP+MySQL Application With Propel and Vertabelo

Propel is a popular ORM (Object-Relational Mapping) library for PHP. Recently, the Vertabelo team started to develop VertabeloPropel, a tool which converts your Vertabelo models into Propel’s schema xml. If you want to try using Propel with Vertabelo to develop a simple PHP MySQL application, here is how to do it. The following example uses Composer, a PHP tool for handling project dependencies. Set up Your Project Create the file composer.

How to Generate Propel’s Schema.xml File From a Database Model Created in Vertabelo

If you use Propel, you can now generate a Propel schema file from a database model created in Vertabelo. Propel is a popular ORM (Object-Relational Mapping) library for PHP. In Propel, the datamodel structure is described by a special schema XML file. From this schema Propel generates PHP object model classes which Propel uses to represent rows in your tables. VertabeloPropel is a PHP script which converts a Vertabelo XML file into Propel’s schema.

How Do You Make Your Database Speak Many Languages?

The Scenario You are the owner of an online store, located in Poland. The majority of your customers are from Poland and they speak Polish. But you want to sell your products abroad too and your international customers mainly speak English. So you want your online store to be available in both Polish and English. You also expect that your products will sell well in France, so you anticipate that you’ll have to prepare a French version of the store as well (and maybe Spanish too, because why not?

Vertabelo XML version 2.1

Vertabelo internally stores your model in an XML format. You can download the XML file and use it to extract some information by using a script. Let’s take a look at the structure of this XML file. if (typeof VertabeloEmbededObject === 'undefined') {var VertabeloEmbededObject = "loading";var s=document.createElement("script");s.setAttribute("type","text/javascript");s.setAttribute("src", "https://my.vertabelo.com/js/public-model/v1/api.js");(document.getElementsByTagName("head")[0] || document.documentElement ).appendChild(s);} Here is the XSD file and an example of the XML file for the above sample database model created in Vertabelo.

How to filter tables in the Vertabelo reverse engineering tool

Sometimes you don't want the reverse engineering tool to extract all of the tables in your database. For example, the database may contain technical tables which are logically are not part of the model. This is when the -regexp option comes in handy. Use the -regexp option and the tool will extract all tables and views with names matching the regular expression. The tool prints the regular expression it uses so you can verify that your shell parsed the expression correctly.

Vertabelo at Confitura 2014

Last Saturday, Vertabelo was at Confitura 2014, this year's edition of the largest free Java conference in Poland. As usual, the conference was organized at the main campus of the University of Warsaw (my beloved Alma Mater!). Unusually, the conference was in two buildings: Auditorium Maximum and the Old Library. Splitting the conference between two locations was a very good idea. The halls were not as crowded as in the years before.

Vertabelo at GeeCON 2014

Last week the Vertabelo team visited the GeeCON 2014 conference. GeeCON is a well-known Polish Java conference. This year, it was organized in Kraków, one of the most beautiful Polish cities, which had been the capital of Poland up till the 16th century. There were over 1000 participants and about 100 lectures and lecturers. Hats off to the organizers for managing the crowd because they did it perfectly. We went to GeeCON to promote Vertabelo.

How to delete old records from a database while retaining some history

If the amount of data in your temporary table is growing very fast, you may want to expunge old unnecessary data from your database. The scenario is like this: there is a table backup_data which contains backup data for various resources. The amount of data in the table is growing very fast, so you want to delete old unnecessary data. However, you still want to keep a little bit of historical data.

Date Arithmetic in PostgreSQL

If your default programming language, like mine, is Java, you most likely wince at the very thought of date arithmetic. (It’s changed for the better with Java 8 but Vertabelo is not there yet.) The date arithmetic API in PostgreSQL is like a breath of fresh air. Interval Arithmetic You can represent a time interval: select interval '2 days'; '2 days' select interval '3 hours'; 03:00:00

Vertabelo Challenges: test your database modeling skills!

Today we begin a new series on our blog: Vertabelo Challenges. Once in a while we’ll publish a new database modeling challenge on our blog so you can test your database modeling skills in Vertabelo. Don’t worry – the challenges will be fairly easy. Follow our Database Design 101 series on the blog and on Vertabelo Youtube channel, and you should be able to conquer all of them in no time.