5 replies to this topic

[sessho]

HI, I'm beginner about databases, I'm looking for the best kind of file for build my databases, I mean, the most compatible with the diferent query languages. I would like to use the information inside in other developments in the future but I'm not sure if I have to star in a common excel file or perhaps there are another useful options.

[Orjan]

Databases don't work that way. The database manager/server handles the files totally on it's own, not to be messed with unless you really know how to handle them.

The usual way to use a database is to have a database service running on a computer and the application, whatever programming language is used (more or less) do queries to the database via a special query language, often SQL.

[papabear]

you might be asking for suggestion on what RDBMS(Relational Database Management System)
it is a system that handles databases, you have to learn SQL or Structured Query Language in different websites, once you learned the basic queries.. you are all set, you just need to figure out how to connect your RDBMS often called database..
into your programming language, in connecting you'll meet a friend called ConnectionString good luck

[BlackRabbit]

HI, I'm beginner about databases, I'm looking for the best kind of file for build my databases, I mean, the most compatible with the diferent query languages. I would like to use the information inside in other developments in the future but I'm not sure if I have to star in a common excel file or perhaps there are another useful options.

About database File, Orjan answered it clearly.

About query languages, all Database engines works on SQL, being ANSI-SQL compatible with them all, and then, every engine adds up some proprietary functionality.
If you refer to a file to be commonly taken by databases as data-import source, more than regular xls file, i would say that .csv files ( comma separated ) are easily imported to every database i know.

[sessho]

My main doubt was about in which type of file I have to strat to gather information in tables and avoid to work twice (the less possible) before migrate my info to differents kinds of RDBMS. I'm having a look to w3chools.com, in the SQL section. The info of all of thre have been very useful, thanks

[Orjan]

if you start with one DBMS and want to change later, you can always get your data transfered via SQL statements so it can easily be imported to the new DBMS, as long as they are SQL compatible, which most are.