G'day beka,
Welcome to the monastery.
"hello everyone , i'm writing a programm to extract data from csv files into a database ,wich database form should i use , access or sql , thank you"
Firstly, maybe check what you've written doesn't have some major typos because, from what you have there, I'd have to recommend that you spend some time researching what a database is.
While I can guess "access" refers to MS Access, which is a database management system; my best guess at "sql" is SQL (Structured Query Language), which is a programming language used for interacting with database systems.
Your choice of database system will depend on a number of factors, such as usage requirements and what's actually available to you.
From a Perl perspective, I suggest you look at these (as a starting point):
-
Text::CSV (and related modules) for extracting data from your CSV files.
-
DBI - Database independent interface for Perl.
-
DBD:: - the namespace for DataBase Drivers for use with DBI.
(That link provides a very long list: you'll want something like DBD::YourChosenDatabaseSystem.)
| [reply]
[d/l]
[select] |
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
| [reply] |
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] |
thank you , but i was referring to ms access and ms sql server , i'm starting in perl so it's a bit slow at the begining
| [reply] |