Re: cities, databases parallel thread

From: Amara Graps (amara@amara.com)
Date: Tue Sep 12 2000 - 15:45:22 MDT


From: "Emlyn O'Regan" <emlyn@one.net.au>, Tue, 12 Sep 2000

>I'd be kind of surprised if Spike has a full client/server database kicking
>around, just waiting for great gobs of data to be pumped into it. He is a
>geek, true, but maybe not quite that particular brand.

... yes ... but we can all help expand Spike's Geek horizons, don'tcha think?

How about this, Spike.

Get MySQL (because it's SQL and it's free)

Load your data into the database.

Get Perl (because it's cool and it's free)

Get DBI Perl library (because it's Perl and because it's free and great code)

Speed up your Web server with mod_perl

And ... voila!

You can access your database from any networked computer with a Web browswer
and then see and manipulate your data... PLUS you can show your Geek friends
your neat-o Geek code

$dbHandle = DBI->connect($dbName,$dbUserName,$dbPassword, { RaiseError => 1 });
#Prepare the SQL command
$sql = "SELECT * from spikeysneatosnotes";
#Send to database via database handle
$statementHandle = $dbHandle->prepare($sql);
$statementHandle->execute();
etc

and feel proud that you've mastered this phase of Geekdom.

(And sometimes you might even find this useful...)

Amara

********************************************************************
Amara Graps email: amara@amara.com
Computational Physics vita: finger agraps@shell5.ba.best.com
Multiplex Answers URL: http://www.amara.com/
********************************************************************
"Sometimes I think I understand everything. Then I regain
consciousness." --Ashleigh Brilliant



This archive was generated by hypermail 2b29 : Mon Oct 02 2000 - 17:37:46 MDT