Perl script for a Hollywood Sqlite database

Let’s analyze the following perl scripta “cinema.pl”, to create and populate a simple database about  movies, and “query_hollywood.pl” to execute a simple SELECT-FROM-WHERE query on it. —————————————cinema.pl———————————————————— #!/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… […]

Discovering Sqlite by Banshee media player

Banshee is the standard media player software in Ubuntu 11.04 and OpenSuse 11.4. It’s a cross-platform application, but it’s basically currently running on “unixoide” operative systems only. It’s written in C# and and it’s build upon Mono and GTK+ (GIMP Toolkit) and the GStreamer frawework, that is used to create media handling components like audio […]