Question that may not have an answer

------=_Part_12372_9744734.1190059449858
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_12372_9744734.1190059449858--

Re: Question that may not have an answer

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/SQ Lite.pm

Alex

RE: Question that may not have an answer

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
=20
=20
=20

-----Original Message-----
From: Scott Mohnkern [mailto:mohnkern@gmail.com]=20
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

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/SQ Lite.pm

Re: Question that may not have an answer

> 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
ron@savage.net.au
http://savage.net.au/index.html