in reply to database problem

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):

-- Ken

Replies are listed 'Best First'.
Re^2: database problem
by tobyink (Canon) on Mar 26, 2014 at 17:51 UTC

    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]

        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]
Re^2: database problem
by beka (Initiate) on Mar 27, 2014 at 10:15 UTC
    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]

In Section Seekers of Perl Wisdom