MySQL CHECK constraint alternative: triggers!

Yesterday I discovered the powerful hibernate check constraint (@org.hibernate.annotations.Check) , which can be directly added in your entity class like this: Unfortunately, as you can read in the official MySQL docs, “the CHECK clause is parsed but ignored by all storage engines”. Yesterday I found out that MySql 5.X doesn´t support the SQL CHECK constraint. […]

Perl script for a Hollywood Sqlite database

Let’s analyze the following perl scripta “”, to create and populate a simple database about  movies, and “” to execute a simple SELECT-FROM-WHERE query on it. ————————————————————————————————— #!/usr/bin/perl -w use DBI; use strict; # CONFIG VARIABLES my $platform = “SQLite”; my $database = “hollywood.db”; my $host = “localhost”; my $port = “3306”; my $user = […]

First steps in Sqlite and Perl

Sqlite is useful to create a database (one file, .db extension) used to store configuration data, used Miicrosoft, Skype, Banshee… Smart Phone applications…. The file extension .db stands for a whole database: it’s made by the software C library called Sqlite… This is a great opportunity to learn about SQLITE and the Perl scripting languages… […]