Re: help with a csv import script to searchable database
[email protected] (Smoot Carl-Mitchell via beginners)
| Newsgroups | perl.beginners |
|---|---|
| Message-ID | <[email protected]> |
On Tue, 2026-01-27 at 21:52 +0000, Gomes, Rich via beginners wrote > I am working on a ongoing project with email where I will need to > import daily csv files into perl and create a searchable database of > all the files. > > Is this a good starting place for what I am looking to do:? > > How to read a CSV file using Perl Look at Text::CSV for reading CSV files. As far as a lightweight database to use, I have used sqlite3 successfully. It has support in the DBI module. The nice thing about sqlite3 is the database is just a single file. Its limitation is it does no user authentication or authorization, but is fine for a small project. -- Smoot Carl-Mitchell System/Network Architect voice: +1 480 922-7313 cell: +1 602 421-9005 [email protected]