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!
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 = […]
Let’s go on mastering our sqlite3 knowledge. SQLite database is really just a file: a backup it’s as simple as copying one file. The .dump command shows information about all the changes performed onto the database. Less pieces of information to the hidden file can be found in your home/user typing: $ ~/.sqlite_history. $ sqlite3 […]
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… […]
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 […]