Re^2: database problem

Perhaps by "sql" beka meant Microsoft SQL Server which would be a natural product to compare to Microsoft Access.

If you're doing this with Perl, of the two I'd choose SQL Server - it's relatively easy to get Perl to talk to a SQL Server database using either DBD::ODBC or DBD::Sybase. (I'd recommend the former if you're using Windows, and the latter if you're on Linux/Unix.) Microsoft Access is probably workable with DBD::ODBC.

However, if I weren't restricted in my choice and could choose from any relational database software at all, I'd go with SQLite (for smaller databases) or PostgreSQL (for larger ones).

use Moops; class Cow :rw { has name => (default => 'Ermintrude') }; say Cow->new->name

Comment on Re^2: database problem

Replies are listed 'Best First'.
Re^3: database problem by beka (Initiate) on Mar 27, 2014 at 09:53 UTC
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	[reply]
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]