Author: Agnieszka Kozubek

Chief Scientist at Vertabelo

How to Store Authentication Data in a Database. Part 1

How difficult is it to program a user login function for an application? Novice developers think it’s very easy. Experienced developers know better: it is the mostsensitiveprocess in your application. Errors in login screens can lead to serious security issues. In this article we take a look at how to store authentication data in your database.The most common way to authenticate users nowadays is withuser nameandpassword. How do you store this information in a database? Obviously, you should store login info in one table. The name of the table is up to you. My advice is to

Who Will Get the Turing Award in 2030?

TheTuring Awardis an annual prize given by the Association for Computing Machinery (ACM) “for contributions of a technical nature made to the computing community.”  It is sometimes referred to as the “Nobel Prize” in Computing. Currently, the prize is 1 million dollars with funding provided by Google. The 2014 Turing Award – announced just three weeks ago on March 25, 2015 – was given to Michael Stonebraker , who earned the award for “fundamental contributions to database systems, which are one of the critical applications of computers today.” So I decided to take a look at what other Turing Awards were given for databases in the award’s 50 year history.

My Weirdest Database Experience

Back in the day when I was still a PhD student, I helped to organize two scientific conferences that took place in my institute. If you’ve ever been to a big 1000-person developers’ conference, scientific conferences are nothing like them. They usually have around 100 participants; a 300-person conference is considered big. Scientific conferences are organized by the faculty of the university where the event takes place, with some help from interested students or PhD students.

5 Must-Read Database Modeling Books?

I recently realized that ourdatabase modeling librarycould use a fewmore advancedtitles. 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. Go ahead and add them to your wishlists!

Time Zones in Databases

Anyone who had to schedule an intercontinental phone call knows that there is no such thing as a simpletimecallednow. What you should rather think about is a time comprised ofhere and now.The Earth rotates around its own axis. When it’ssolar noon(the sun is at its highest position) in one place, it’s already past noon in places to the east and it’s still before noon in places to the west.To make communication easier, at the end of the 19th century, the Earth was divided into 24 hour-wide

Data Dictionary Support: Generate Comments for Your Database

Most relational databases allow you to define comments for their tables, columns, views, and so on. These additional pieces of information are called databasemeta dataordata dictionary. Meta data may be useful for developers or other database users. Meta data allow the development team to understand what various tables or columns are for without having to ask database designer what their intentions were.Generating meta data in SQL scripts is one of the most often requested Vertabelo features and it’s finally here. Here’s how you can take advantage of the feature.

MySQL Collations

List CollationsTo list all collations available in MySQL, useYou can filter the list to show only collations for charset ‘latin1’:The convention for a collation name in MySQL: first character set name, then the name of the language, finally the type of the collation (ci stands for case-insensitive, cs for case-sensitive, bin for binary collation). So ‘latin1_danish_ci’ is a collation for charset ‘latin1’, for the Danish language and is case-insensitive.Every collation in MySQL is assigned to exactly one character set. Every character set has one default collation which is used if the collation is not specified explicitly. MySQL checks if the collation and the character set match. If they don’t match, an error is raised.

How Does a Database Sort Strings?

Different languages have different alphabets and different ways to order letters within those alphabets. For example, a Polish character Ł comes right after L and before M. In Swedish, a letter Å comes almost at the end, right after Z. In French diacritics marks have no impact on the alphabetical order, so the letters À, Á and  are treated as the letter A when sorting strings.Acollationis a set of rules that defines how to compare and sort character strings. A collation tells you what the order of characters is and which characters should be treated as the same.

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 ProjectCreate the file composer.json which describes your project dependencies. You will use at least Propel (package propel/propel) and VertabeloPropel (vertabelo/vertabelo-propel) as your project dependencies.

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.xml file.