Tag: XML

Vertabelo XML Version 2.3

The XML file format for Vertabelo has changed to version 2.3. Read this article to find out what is new. Vertabelo keeps its models in XML format; if you need, you can download the files and extract information from them. Previously, we used XML version 2.1, as discussed in this article . We’ve switched to XML 2.3, and a couple of changes took place. These changesmake no difference for most Vertabelo users

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.Here is the XSD file and an example of the XML file for the above sample database model created in Vertabelo .The root element of the document is the DatabaseModel element with the VersionId attribute. As of today, the current version is 2.1.

Vertabelo API

We’ve added an API to our Vertabelo application to help you incorporate some automation into your build system. Here is a short instruction on how to use the Vertabelo API.First of all, you have to enable access to the API. You’ll need have at least a “Basic” account plan or be a member of a company.1. From the User menu, go to the “My account” page Scroll down to the “Settings” section

How to Count XML Nodes in PostgreSQL 9.1

Recently I was given a task which involved counting, with a single SQL query, all tables in each model version of Vertabelo. Vertabelo internally stores each model version as an XML file (download a sample XML file ). So my task was to count all XML nodes satisfying a certain XPATH expression. Vertabelo runs on PostgreSQL 9.1, so PostgreSQL 9.1 tools were all I could use.To begin at the end, the final query looks like this: