#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    Brazil
    Posts
    15
    Rep Power
    0

    Best Database (C++ Builder)


    Hi, Im intending to develop one application which it would work with calculation and data sharing between the tables. Which database would you recommend if you were using C++ Builder ??

    Thank you
  2. #2
  3. I'm Baaaaaaack!
    Devshed God 1st Plane (5500 - 5999 posts)

    Join Date
    Jul 2003
    Location
    Maryland
    Posts
    5,538
    Rep Power
    243
    If you can use ODBC in your code almost all databases support that and you can change databases (almost) at will. If you are on *nix or running cygwin on Windows you can look into Postgresql, an enterprise level free database.

    My blog, The Fount of Useless Information http://sol-biotech.com/wordpress/
    Free code: http://sol-biotech.com/code/.
    Secure Programming: http://sol-biotech.com/code/SecProgFAQ.html.
    Performance Programming: http://sol-biotech.com/code/PerformanceProgramming.html.
    LinkedIn Profile: http://www.linkedin.com/in/keithoxenrider

    It is not that old programmers are any smarter or code better, it is just that they have made the same stupid mistake so many times that it is second nature to fix it.
    --Me, I just made it up

    The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore, all progress depends on the unreasonable man.
    --George Bernard Shaw
  4. #3
  5. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,595
    Rep Power
    4207
    This is more a question of what database engine you prefer. FYI, C++ Builder Enterprise Edition comes with Native Driver Support for
    (via BDE):
    MS SQL Server
    Sybase SQL Server
    Oracle
    DB2
    Informix
    Interbase
    Paradox
    Dbase
    FoxPro
    MS Access
    Any other DB that has an ODBC driver. There is also support for Excel files, Text files and such.

    (via dbExpress):
    MySQL
    Interbase
    MySQL
    Oracle

    (via ADO)
    Any DB driver that has ADO support.

    Note that this is for the Enterprise Edition of 6.0. The professional edition has less features (IIRC, the BDE components only allow ODBC access). See http://www.borland.com/cbuilder/pdf/cb6_feamatrix.pdf for a feature comparision of the various editions. Note that you can use ODBC drivers (which come with most DB engines) as mitakeet mentioned above, if there is no native driver support.
    Last edited by Scorpions4ever; August 27th, 2003 at 07:26 PM.
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    Brazil
    Posts
    15
    Rep Power
    0
    Thank you for your reply, I dont much know about this subjet as you do, but like I saw I could use Paradox to do what I want to, including access to Excel files. Am I right ??
  8. #5
  9. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,595
    Rep Power
    4207
    Here's the deal with Paradox:
    Advantages:
    (a) Extremely fast (possibly the fastest DB engine on Windows) for smaller record sets (couple of million records or so).
    (b) Comes along with Delphi/C++ Builder (so you don't pay extra for it).
    (c) Native Drivers for Delphi and C++ Builder and it integrates very neatly with their data access components.

    Disadvantages:
    (a) Database tends to get corrupted from time to time and needs reindexing.
    (b) No transaction capabilities.
    (c) No stored procs, triggers, views etc.
    (d) You have to jump through a few hoops to make it multiuser capable (One thing you have to do is set up the BDE on each client computer to use a common shared drive for the lock file).

    You might want to consider other DB engines, if you plan to write an enterprise level application.
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
  10. #6
  11. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    Brazil
    Posts
    15
    Rep Power
    0
    I think I got the point. Fortunately, the application is just for something really small... which is good for me according to your explanation. Actually, is there any book or material that I could take a look on the features of each kind o database ??

    But Im already thankful for you answer

IMN logo majestic logo threadwatch logo seochat tools logo