Query failed: connection to localhost:9312 failed (errno=111, msg=Connection refused). What's better - MySQL, 4D or other databases? - Mac Software Discussions on AppleInsider Forums Toggle navigation All Forums Recent Posts Sign In What's better - MySQL, 4D or other databases? haderach Posted: November 8, 2002 1:48PM in Mac Software edited January 2014 I think the title almost says it all.I'm especially looking for benchmarks (MySQL vs 4D) as one of my friends claims that 4D is much more powerful than MySQL.Is that true? Comments Reply 1 of 3 amorph Posts: 7,112member November 8, 2002 1:55PM I don't know much about 4D, but MySQL is a light database. It's really not hard to find a more powerful one - postgreSQL comes to mind, among the open source stuff.They're working on beefing it up somewhat - does it have ACID compliance yet? - but from the way 4D is pitched it looks a lot more powerful than MySQL is.(For those wondering, ACID compliance has nothing to do with corrosiveness. It's a measure of the database's ability to make sure that a row isn't being read as it's being written to, for example. It's a list of design features that ensure that the database has the data you wrote to it, and serves you the data you ask it for, and there are no boundary cases that could result in clobbered or outdated data. For most of its existence, MySQL was not ACID compliant.)[ 11-08-2002: Message edited by: Amorph ]</p> Reply 2 of 3 ghost_user_name Posts: 22,667member November 8, 2002 6:05PM MySQL is also free, and 4D isn't. Now, there is a lot of good free software out there, but when it comes down to it, you get what you pay for.To find out which is the best... well, that all depends on your budget really. It also depends on what you need the database to do. OpenBase and FrontBase are a couple of other systems to look at. FrontBase in particular is a personal favorite of mine. Reply 3 of 3 belle Posts: 1,574member November 9, 2002 6:05AM I'd certainly choose PostgreSQL over MySQL for the reasons Amorph outlines.I'm currently working on my own little database project, and am using MySQL because the CMS I prefer (<a href="http://www.movabletype.org/" target="_blank">Movable Type</a>) doesn't support PostgreSQL yet. (It's in progress, and I'll switch as soon as it's available.) Sign In or Register to comment.