You can download “Perl Scripting for SQLite”. It’s a pdf of the slides I’ve made for the “Linux day 2011” in my hometown. Have fun!
Library FOR WWW in Perl (LWP) In Linux you can istall all the perl modules about the web (LWP, URI, URL, HTTP…) at once: :~$ sudo apt-get install libwww-perl LWP is the most used Perl module for accessing data on the web. LWP::Simple – module to get document by http its functions don’t support cookies […]
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 = […]
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… […]