Re: CSV database creation via DBI?

[Jeff Zucker]

David Wilson wrote:

Is is possible to create a database through CSV, or is DBI primarily
for accessing established databases?  If possible, how do I create
a local database via DBI?  If not, how do I manually create an empty
CSV database?
 

DBI works with database-drivers (DBDs) to communicate with specific data 
sources.  The DBD you want is called DBD::CSV.  It provides a complete 
DBI/SQL interface for creating, modifying, and querying CSV files.  It 
can work with CSV files in a variety of formats so it shouldn't be too 
hard to work with your existing data.  For example, you may have to 
specify the end-of-line characters,  the column names or other features.

So:

1. Download and install DBI
2. Download and install DBD::CSV
3. Read up on DBI (in its documentation or in the O'Reilly book)
4. Read up on DBD::CSV (in its documentation)
5. Away you go
All modules are available on CPAN and/or ActiveState.

--
Jeff