Re: help with a csv import script to searchable database

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.
> =C2=A0
> Is this a good starting place for what I am looking to do:?
> =C2=A0
> 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.


--=20
Smoot Carl-Mitchell
System/Network Architect
voice: +1 480 922-7313
cell: +1 602 421-9005
[email protected]