tag:blogger.com,1999:blog-9144505959002328789.post5869749412743811106..comments2024-03-29T08:14:29.447+01:00Comments on Karlsson on databases and stuff: Of MySQL 5.1 and Joomla part 1Karlssonhttp://www.blogger.com/profile/04874338187076980133noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-9144505959002328789.post-8782352979118963272009-01-10T12:27:00.000+01:002009-01-10T12:27:00.000+01:00Interesting article Karlsson. If you are up to it,...Interesting article Karlsson. If you are up to it, I'd love to go deeper into any recommendations you have for the API. Drop me a line at andrew DOT eddie AT community.joomla.org<BR/><BR/>I doubt we can do much for 1.5 but 1.6 is a new animal and our options are still open there.Unknownhttps://www.blogger.com/profile/13898810284680440695noreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-16442222571317806652009-01-09T19:11:00.000+01:002009-01-09T19:11:00.000+01:00Oops, I'm sorry that I missed the announcement tha...Oops, I'm sorry that I missed the announcement that Joomla will support MySQL 5+. And make no mistake, I actually LIKE Joomla, quite a bit, and I'm not about to change my view on that.<BR/>But fact remains that using foreign keys is difficult, NULL value implementation is lacking and use of the database partability features (for quoting of names and strings etc etc) that the database library in Joomla supports, is far from complete even in the rest of the library or in the supplied modules.<BR/>I really do think transactions are a good thing, and that they should be used, or at least properly supported.<BR/>That Joomly clearly has made an attempt to be a bit database agnostic is clear, if for no other reason so from the structure of teh database implementation. But as long as things are progressing, I'm happy, and I'll be glad to upgrade to 1.6 eventually.Karlssonhttps://www.blogger.com/profile/04874338187076980133noreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-9360349648839114002009-01-09T15:19:00.000+01:002009-01-09T15:19:00.000+01:00I don't think anyone says Joomla! is database agno...I don't think anyone says Joomla! is database agnostic. In fact there is a project to work towards that goal, but it's a development project not finished.<BR/><BR/>It has already been announced that 1.6 will be php 5.2+ and Mysql 5+. But it is true that Joomla is designed to work on many hosts and meet many needs, from people on shared environments where they don't necessarily have the option to go to the latest stack to people like you who control their own. <BR/><BR/>I will say that the dev team is very, very happy that that the minimum version decisions have been made.opensourcesociologisthttps://www.blogger.com/profile/02925075647840469443noreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-6752292409112516722009-01-08T22:56:00.000+01:002009-01-08T22:56:00.000+01:00I beg to differ. September 3 1967 sweden changed f...I beg to differ. September 3 1967 sweden changed from driving on the left to the right, but today, driving on the left in the name of backwards "compatability" is a bad idea. MySQL 4 is OLD now, get over it!Anders Karlssonhttps://www.blogger.com/profile/16876770672540874610noreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-66162690586570770462009-01-08T21:53:00.000+01:002009-01-08T21:53:00.000+01:00Hi!"in the database mdules, there is a specific "S...Hi!<BR/><BR/>"in the database mdules, there is a specific "SET SQL_MODE = 'MYSQL40'" command."<BR/><BR/>Really - this is not bad at all! Most PHP apps simply assume default settings and err in case your server happens to be configured differntly. You may not like the mode it uses, but at least the took it into account and took the trouble to ensure MySQL was doing what they were expecting...rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-32384544574053789012009-01-08T21:00:00.000+01:002009-01-08T21:00:00.000+01:00Well, you might be right, I just happened to end u...Well, you might be right, I just happened to end up with Joomla. The reason was that when I started, I was under the impression that I could use many more of the CMS features that I ended up using.<BR/>The lesson is to check if you REALLY need a CMS before you get one. And that said, I actually tend to think Joomla is OK.<BR/><BR/>Cheers<BR/>/KarlssonKarlssonhttps://www.blogger.com/profile/04874338187076980133noreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-59335732475934013602009-01-08T20:52:00.000+01:002009-01-08T20:52:00.000+01:00If you need a framework, try ZF. The "figure out t...If you need a framework, try ZF. The "figure out the framework quirks" applies here too, but IMHO the platform is much more powerful.Dadohttps://www.blogger.com/profile/15986125249141652997noreply@blogger.com