SitePoint Sponsor

User Tag List

Results 1 to 9 of 9

Thread: Good RDBMS?

Hybrid View

  1. #1
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)

    Good RDBMS?

    I have begun laying out my business model and the tools that I will use. I have decided that MySQL and PostgreSQL will fit my needs for all of the web stuff.... But I need a database that runs on Windows (as well as a Linux/FreeBSD version) that is inexpensive.... Any suggestions? I am trying to stay away from MS SQL.

  2. #2
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i would stay away from mysql if you plan on using transactions or using robust xml applications. i would go for postgresql.

    its robust, has triggers, pk, fk, etc.

    dlg

  3. #3
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    Well I am going to use a mix of MySQL and PostgreSQL for web stuff.... I need a database for client side things. Something small that can run on a small server and handle transactions.

    My company will be handling web applications as well as software apps.

  4. #4
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    so it will not all be on the web?

    i think that i would go for postgresql....as you know mysql doesn't handle transactions (commit, rollback, etc.) it's fast for queries, but not robust enough for serious things.


    does anyone else agree/disagree?


    dlg

  5. #5
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    No not all of the products will be web based... And there is only one version of PostgreSQL that will run on Windows correctly and I can never get it to download!

    I was thinking about Sybase, Informix, DB2, etc.... but I don't know how Python connects to Sybase and I cannot find any info on it.

  6. #6
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    db2 is always a great rdbms, but what are your cost constraints?

  7. #7
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    btw, your db can be on a linux machine and you can still query this info from a win box.

    so you don't have a problem.

  8. #8
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    Well let me lay out the business philosophy and maybe that will help.

    I want to offer programming services to small businesses around the area at a cheaper price than the big boys do. I want to develop software that can be used by these small businesses to help them with their jobs but I don't want the products to cost an arm and a leg. Since most small businesses have never heard of Linux I will definitely suggest it and give them reasons why.... But if they are Windows centered then I don't want to lose business

    The databases would need to sit @ the place where the server is (the customer's office). So a small database that can handle about 10 to no more than 100 employees accessing it at the same time would not bring it down.

  9. #9
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It may be a bit lightweight, but what about Gadfly?
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •