| SitePoint Sponsor |
|
|
User Tag List
Results 1 to 3 of 3
Thread: mySQL
-
Jul 10, 2002, 11:36 #1SitePoint 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.
-
Jul 10, 2002, 12:32 #2Mlle. Ledoyen
- 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
-
Jul 10, 2002, 12:53 #3Yugo full of anvils
- 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?
Bookmarks