Trey Gruel wrote:
Well, I think this comment can confuse. Basically Postgresql is (was?) a much more feature rich database than MySQL including triggers, a rich sql language and overall a piece of art transaction system that many commercial databases still lack.
sorry..
i didn't really know the specifics for either mysql or postgresql, aside from postgresql being more feature rich while mysql was speedier and more popular.
Recently SAP announced its development support for MySQL so thinks could change fast.
mysql and sap are working together on maxdb (formerly sapdb) which, is separate from the normal mysql, and more along the lines of firebird (feature rich; was commercial, now opensource). they are taking features from maxdb and putting them into mysql, so it should be getting more of the "high end" features faster.. sorry I think is due to all posters who answered my badly posed question.
The reason I asked about the comparisons of the databases against M$ Access is that I have used it to create a database of some 20000 http links and I am looking at moving it toward a linux solution. HOWEVER the winner must have a decent user GUI interface to add records/create forms etc ie something that is close to the look and feel, without the BSOD :), to M$ Access for the storing of large tables and being able to produce reports/forms on a certain portion of the records. Comments please, but do be kind... -- The Little Helper ======================================================================== Hylton Conacher - Licenced ex-Windows user (apart from Quicken) Registered Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 ========================================================================