Re^3: database problem

yes that's what i meant exactly , in fact , i have several technologies available to work with , i have never tried on perl , so it a little bit slow now , i think i'll go with sql server too ,thanks tobyink

Comment on Re^3: database problem

Replies are listed 'Best First'.
Re^4: database problem by Tux (Canon) on Mar 27, 2014 at 16:44 UTC
So the title is not really what the post is about. A bit misleading. As the others already pointed you to DBI to connect to M$ SQL Server, I assume you will need to get acquainted with DBI/DBD syntax anyway, and reading from CSV - though fast and simple with Text::CSV and/or Text::CSV_XS - would be easiest to do with DBD::CSV. Just open two database handles from the same script and on you go. FWIW, Postgres and MariaDB also run fine on Windows, and those are free and OpenSource. Enjoy, Have FUN! H.Merijn	[reply]

Replies are listed 'Best First'.

Re^4: database problem
by Tux (Canon) on Mar 27, 2014 at 16:44 UTC

So the title is not really what the post is about. A bit misleading.

As the others already pointed you to DBI to connect to M$ SQL Server, I assume you will need to get acquainted with DBI/DBD syntax anyway, and reading from CSV - though fast and simple with Text::CSV and/or Text::CSV_XS - would be easiest to do with DBD::CSV. Just open two database handles from the same script and on you go.

FWIW, Postgres and MariaDB also run fine on Windows, and those are free and OpenSource.

Enjoy, Have FUN! H.Merijn

[reply]