By publishing this post I try to help people who want to get access to popular and simple database engine sqlite through perl script. I use sqlite to store e-mails statistics at small mail server in order to retrieve information about users’ mail activity like average response time, sent and received messages and etc. There is perl script that is used to get this data per every user or get summary statistics. This script is to be run by web server (I use Apache) and has name index.cgi in my case.
Here is part of it:
#!/usr/bin/perl
use DBI;
print “Content-type: text/html\n\n”;
print “<html><head><title>perl and sqlite example script</title></head><body>”;
$dbh = DBI->connect( “dbi:SQLite:dbname=/tmp/mail_data.db”,”", “”, { RaiseError => 1, AutoCommit => 0 });
my $fst = $dbh->selectall_arrayref(“SELECT min(time_1),max(time_1) FROM mail_data”);
foreach my $row (@$fst) {
my ($fst_pr,$lst_pr) = @$row;
print “oldest entry in database: “.gmtime($fst_pr).” gmt<br>newest entry in database: “.gmtime($lst_pr);
}
print “</body>”;
print “</html>”;
$dbh->disconnect;
After you load this example through any web browser (please read your web server’s manual on how to allow cgi/perl script exec, for example here), script will read sqlite database that is located at /tmp/mail_data.db and display minimal and maximal values of field time_1 from mail_data table.
In order to run this script it’s necessary to install perl, sqlite3 and perl-DBI-SQLite cpan module.
You may also be interested in:
CGI Perl scripts debugging (solve 500 Internal Server Error)
???????? ncr http://www.partstrain.ru ???????,NCR,????????? ?????????????,????? ??? and Wincor ? ????????????? ? ??? .....???. (813) 414-10-92 ???????? ??? ?????????? NCR ???????? ??? ??????????, ????????, ??? ??????, ??? ????? NCR, Diebold,Wincor, ?????????, ????????? ?????????,???????? wincor,???????? diebold, ???????? ncr
Hiya, I am really glad I've found this info. Today bloggers publish only about gossip and web stuff and this is actually annoying. A good blog with interesting content, that is what I need. Thank you for making this site, and I'll be visiting again. Do you do newsletters? I Cant find it.
I have recently started a site, and the information you offer on this site has helped me a lot. Thank you for all of your time & work.
well written article, you did a good job of describing the article in a simple manner
Hello People! Just wanted to tell you that I found tickets to the Jersey Boys concert on Nov 24th. In this site you can find tickets for other dates too. It's astonishing their performance on stage, this is my fourth time and I'm still so excited about listening them live! On this page you can see the section where you're buying the ticket, so it's very recommended!
Hello People! Just wanted to tell you that I found tickets to the Usher concert on May 18th. In this site you can find tickets for other dates too. It's wonderful Usher and his crew performance, this is my third time and I'm still so excited about listening him live! On this page you can see the section where you're buying the ticket, so it's very recommended!
????????? ??????? ??? ? ?????? 3 ?????, 700 ??.?. ??????????? ?????? ????? ?
????????. ???????? ?? ????. ?? ???? 500 ??????. ??? ????????? ????????????: ????, ????, ???, ???????????, ?????????? ??????? ?????.
500 000 usd
?????? ???????????? ?? ???
????????????. ?????????? ????. ????? ???? ?????????? ???????? ????????????? ????: ??? ? ??????????? gps ? glonass
Merely wish to say your article is as tonishing. The clearness in your put up is just spectacular and i can assume you might be an knowledgeable on this subject. Well together with your permission permit me to seize your rss feed to keep up to date with forthcoming post. Thanks 1,000,000 and please sustain the gratifying work.
?????? ????????? ?????????????????????? ?????? ?????? ??????? ? ???????????????????? ? ?????? ??????????????? ??? ????? ???????? ??? ????????? ? ?????????????? ??????? ??? ??????????????? ????????????.?????? ?.????? ??? ????? ????????? ??????? ??? ???????????? ??? ????????? ?? ???????? ???????????????? ????? ????????????? ??? ???????? ??????????? ? ????????????????????????? ??????????? ?????? ? ???????????? ??? ?????????? ?????????? ???????? ???????? ??? ????? 159 ?? ? ???? 54????? ???????? ????????????????????? ???????? ? ??????????? ?????????????????????? ????? ??? ???????? ?????????????? ????????? ???????? ??? ??? ??????? ????? ?? ?????????
hi there amazing post we have going here.
Hi nice thread we have going here.
Hi amazing topic you have going here!
???????? ??? Windows Xp ??????? usb ??????? ??? ???????? samsung 3650. ??????? usb ??????? ??? ???????? samsung c100, ??????? usb ??????? ??? ???????? samsung c110.
??????? usb ??????? ??? ???????? samsung sgh e250. ??????? usb ??????? ??? ???????? samsung sgh e360, ??????? usb ??????? ??? ???????? samsung sgh x510. ???????? ??? ??????? ?????
Among the Air Jordan Line, Jordan 4 (IV), Jordan 5 (V) and Jordan 6 (VI) were outstanding fashions and amidst the highest commerce. During the shoes designs, Michael Jordan played an Noted role as well.
The Air Jordan IV was made public in 1989, which was the ahead in the line that had an surplus-molded mesh. The mesh was coated in a soft plastic and blew wind in and out it to clear out the plastic mesh in the seam. This brought about the shoes Outstanding
for breath out the high temperature during baskeball matches. Although people disfavor the shoes and thought they were ignoble when it was released, Jordan 4 grew on a lot of people supplementary. Succeeding Air Jordan 4 Laser package was also most loved by the people.
The Air Jordan 5 was released in February 1990 to the citizens. Two models which were the Black/Black-Metallic Silver and White/Fire Red-Black had MJs number “23? on the edge. The Air Jordan V was the first off in the Air Jordan array to have a transparent rubber sole. They had bright molding which allowed light to come through. Also the AJ 5 was the first time anyone had ever molded foam into a shoe upper and the flames on the side, which indicated the fire Michael Jordan delighted in NBA matches.
Came out in 1991, Air Jordan VI was doubtless Triumphant . Michael Jordan wanted a precise toe. So it was designed to have backup around the toe. The Air Jordan 6 was the next model to retain the clear rubber sole. The sole was affixed a higher solid rubber later as public complained on it. The shoes were also desired by Michael to locate his heel. So it was the ahead shoes to have molded arrangement on the aback. Surely a 23 number was also on the shoes to remark it as one of the shoes for Michael Jordan.
The Air Jordan Lines carried out great success. It should be victorious as they have in hand great designers and also the a-1 basketball player, who state the designers what he desired and what was not agreeable after he tried the shoes.
Coral StoneUSA is an creator and importer of Coral Stone. Our stone is selected from the subdue quarries in the Dominican Republic and we submit gold coral stone as well as milky coral stone. Its color and weave makes it a darned facile concrete as a service to interiors and exteriors.
Coral Stone - http://www.coralstonepavers.com/
Coral Stone Pavers, Coral Tiles, Coral Stone Copings, Coral Stone Bullnose Copings, Coral Stone Columns, Coral Stone Slabs. Coral Stone Columns, Coral Stone balustrades, Coral Stone handrails, Coral Stone moldings, Coral Stone corbels, Coral Stone fountains and more.
Hi,
do you know where i can download this movie : http://download-kino.de/24-twenty-four-400-p-m-500-p-m/
Links in this site is broken. Need movie in German
For german members:
Hallo zusammen,
weisst du, wo ich diesen Film zum Download(Link oben) oder diese :http://download-kino.de/30-rock-sandwich-day/
Links auf dieser Seite ist gebrochen. Brauchen Film in deutscher Sprache
Hi Everyone,
Thank you for providing this great community.
I've been looking for a community like this for a while now.
It's great to find a place with like minded users who are entrepreneurs online.
I hope we can all help each other by providing information and all have great success
-Mack
Yes... Likely... The easier, the better... All ingenipus is simlpe.
I can not participate now in discussion - there is no free time. uBt I will be released - I will necessarily write that I think.
What charming idea
I will not begin to speak on this theme.
Your Great Mom! Posted on I really msiesd you! Don't do that to me again. You have posted some great stuff and I will continue to check your site at least a couple of times each week.
best credit cards 1480 free auto insurance quotes webg
Welcome to NHL Heaven! MLB is a professional baseball league, consisting of teams that play in the American League and the National League. As of the 2012 season, NFL is divided into the American League 14 teams and the National League 16 teams. Currently, each league is further subdivided into three divisions - labeled East, Central, and West.
The NBA All-Star Game, also known as the "Midsummer Classic", is an annual game between players from the National League and the American League, currently selected by a combination of fans, players, coaches, and managers. From the first All-Star Game, players have worn their regular team uniforms and caps. NHL caps are popular among the fans. The 2011 All-Star Game was played at Chase Field in Phoenix, Arizona, home of the Arizona Diamondbacks; the 2012 All-Star Game will be played at Kauffman Stadium in Kansas City, Missouri, home of the Kansas City Royals. It has been officially announced that the 2013 All-Star Game will be played at Citi Field in Queens, New York, home of the the New York Mets. NFL caps are like hot cakes all over the world.
Our company are ready to offer you the latest fashion mlb caps. They have been highly speaking of by the fans. With its special design and style, mlb hats has stepped out of sport series,and have widely welcomed by the hip-hop lovers and sports leisure travelers. It has been the fashion forward index and tide symbol. If you like the perfect combination of fashion trends and sports, what are you waiting for? New Era MLB hats are looking forward to your discovery. If you are big fans of the NHL, you are here the right place——the NHL Heaven, buy mlb hats to support your favorite teams.
http://www.mlbrundown.com/blogs/5/