Re: Question that may not have an answer

2007-09-17 Thread Ron Savage

Scott Mohnkern wrote:


Hi Scott


I recall talking to someone about perl having an internal database file


Your Perl should have come with: AnyDBM_File.html

--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html


RE: Question that may not have an answer

2007-09-17 Thread Fong, Anna
You can keep the data in CSV format and use DBD::CSV to access the data.

http://search.cpan.org/~jzucker/DBD-CSV-0.22/lib/DBD/CSV.pm


Anna Q. Fong, Chief  Phone: (916)
574-2632
Flood Operations, Decision Support
Division of Flood Management   Fax: (916) 574-2767
CA Dept of Water Resources  Pager: (916) 762-2669
 
 
 

-Original Message-
From: Scott Mohnkern [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 17, 2007 1:04 PM
To: dbi-users@perl.org
Subject: Question that may not have an answer

I'm working on a project where we have data stored in arrays that we
need to
put into a database.  We'd started with CSV (it was easiest), but it's
become unmanagable.

However, I don't want to go through the pain of getting a mysql database
or
other database server set up to put the data into.

I recall talking to someone about perl having an internal database file
where you could store the data in a file, and access it relatively
easily,
without having to set up an interface to an external database server.

Or am I completely wrong, and there isn't such a thing?


Scott Mohnkern




Re: Question that may not have an answer

2007-09-17 Thread Bill Kurland

Scott Mohnkern wrote:

I'm working on a project where we have data stored in arrays that we need to
put into a database.  We'd started with CSV (it was easiest), but it's
become unmanagable.

However, I don't want to go through the pain of getting a mysql database or
other database server set up to put the data into.

I recall talking to someone about perl having an internal database file
where you could store the data in a file, and access it relatively easily,
without having to set up an interface to an external database server.

Or am I completely wrong, and there isn't such a thing?


Scott Mohnkern

  

You're probably thinking of SQLite

http://search.cpan.org/~msergeant/DBD-SQLite-1.13/lib/DBD/SQLite.pm




Question that may not have an answer

2007-09-17 Thread Scott Mohnkern
I'm working on a project where we have data stored in arrays that we need to
put into a database.  We'd started with CSV (it was easiest), but it's
become unmanagable.

However, I don't want to go through the pain of getting a mysql database or
other database server set up to put the data into.

I recall talking to someone about perl having an internal database file
where you could store the data in a file, and access it relatively easily,
without having to set up an interface to an external database server.

Or am I completely wrong, and there isn't such a thing?


Scott Mohnkern


Re: Question that may not have an answer

2007-09-17 Thread Alex Teslik
On Mon, 17 Sep 2007 16:04:09 -0400, Scott Mohnkern wrote
> I'm working on a project where we have data stored in arrays that we 
> need to put into a database.  We'd started with CSV (it was easiest),
>  but it's become unmanagable.
> 
> However, I don't want to go through the pain of getting a mysql 
> database or other database server set up to put the data into.
> 
> I recall talking to someone about perl having an internal database file
> where you could store the data in a file, and access it relatively 
> easily, without having to set up an interface to an external 
> database server.
> 
> Or am I completely wrong, and there isn't such a thing?
> 
> Scott Mohnkern


You're looking for SQLite:

http://www.sqlite.org/

and

http://search.cpan.org/~msergeant/DBD-SQLite-1.13/lib/DBD/SQLite.pm

Alex