SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: mySQL

  1. #1
    SitePoint Member
    Join Date
    Jul 2002
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mySQL

    Hi everybody,

    I am thinking to develop my first project with PHP and mySQL. There must be a relational database and a datawarehouse. I have made a little search on the net about mySQL whether it is a relational database and whether it is good enough to support a datawarehouse application but I couldn't find satisfactory answers.

    Can anybody tell me that, whether mySQL is a full relational database or should I use another database.

    Thanks,

    Tony.

  2. #2
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Moved to a more appropriate forum

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  3. #3
    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)
    Strictly speaking, mySQL is not a "full" relational database. It lacks things like foreign key support. It is also very fast at reads, but much slower at database writes due to its table-level locking.

    If relational data integrity, transaction support etc are important, have a look at Postgres (or DB2/Sybase/Oracle) instead. There's a free Linux version of Sybase ASE that might do the job.

    Comments, MattR?
    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
  •