Register and join over 40,000 other developers!
Recent Topics
-
Print specific values from dictionary with a specific key name
Siten0308 - Jun 20 2019 01:43 PM
-
Learn algorithms and programming concepts
johnnylo - Apr 23 2019 07:49 AM
-
Job Gig PHP Form Needed
PJohnson - Apr 18 2019 03:55 AM
-
How to make code run differently depending on the platform it is running on?
xarzu - Apr 05 2019 09:17 AM
-
How do I set a breakpoint in an attached process in visual studio
xarzu - Apr 04 2019 11:47 AM
Recent Blog Entries
Recent Status Updates
Popular Tags
- networking
- Managed C++
- stream
- console
- database
- authentication
- Visual Basic 4 / 5 / 6
- session
- Connection
- asp.net
- import
- syntax
- hardware
- html5
- array
- mysql
- java
- php
- c++
- string
- C#
- html
- loop
- timer
- jquery
- ajax
- javascript
- programming
- android
- css
- assembly
- c
- form
- vb.net
- xml
- linked list
- login
- encryption
- pseudocode
- calculator
- sql
- python
- setup
- help
- game
- combobox
- binary
- hello world
- grid
- innerHTML

The best type of file for develope databases
Started by sessho, Nov 02 2012 04:13 AM
mysql sql ms sql oracle
5 replies to this topic
#1
Posted 02 November 2012 - 04:13 AM
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.
#2
Posted 02 November 2012 - 05:43 AM
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.
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.
I'm a System developer at XLENT Consultant Group mainly working with SugarCRM.
Please DO NOT send mail or PM to me with programming questions, post them in the appropriate forum instead, where I and others can answer you.
#3
Posted 02 November 2012 - 03:43 PM
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
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

Life has no CTRL+Z
Never Forget To HIT "LIKE" If I Helped
Never Forget To HIT "LIKE" If I Helped
#4
Posted 02 November 2012 - 08:33 PM
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.
#5
Posted 05 November 2012 - 06:32 AM
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
#6
Posted 05 November 2012 - 07:38 AM
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.
I'm a System developer at XLENT Consultant Group mainly working with SugarCRM.
Please DO NOT send mail or PM to me with programming questions, post them in the appropriate forum instead, where I and others can answer you.
Also tagged with one or more of these keywords: mysql, sql, ms sql, oracle
General Forums →
General Programming →
PHP code having some issueStarted by dennypaul, 09 Mar 2019 ![]() |
|
![]() |
||
General Forums →
Game Development →
Include a specific error, task, problem, or question in your titleStarted by Killuah, 04 Jul 2018 ![]() |
|
![]() |
||
Language Forums →
Databases →
Include a specific error, task, problem, or question in your titleStarted by Kriss, 27 Sep 2017 ![]() |
|
![]() |
||
Language Forums →
PHP →
Php Sql Injection Secure TagsStarted by uniqueideaman, 09 Apr 2017 ![]() |
|
![]() |
||
Language Forums →
PHP →
What Is Wrong With Number Of Rows Count Function ?Started by uniqueideaman, 09 Apr 2017 ![]() |
|
![]() |
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download