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… […]