(by Gerardo Narvaja)

We do run on all platforms supported by Microsoft, embedded platforms not tested. We do support all communication protocols supported by Windows. Minimum disk space: 200MB, basically enough to unpack, install and create a few test DBs. We do run on all filesystems supported by Windows, for tables larger than 4GB NTFS is necessary. We do support a lot of DB access frameworks: ODBC, .NET (1.1 or newer), JDBC (1.4.2 or larger to develop, 1.3.0 or newer to run).

Packages are named a bit differently than on Unix.
Continue reading "MySQL on Windows for DBAs"

Session by Laura Thomson.

Less than 7% of the sites currently using PHP are using PHP 5. Why is everybody skipping it?

PHP 5 has a few central cool features, and is much less incompatible than you may think. Try it. Watch out for the mysqli and PDO extensions and the new OO model. Also handy: Exceptions, Improved XML Handling, SOAP, Iterators and more.


Continue reading "MySQL UC: Upgrading to PHP 5 - Why and How?"

Being a consultant for MySQL means that I need a lot of instances of MySQL running on my desktop, all different versions and different configurations for different customers. It also means that I need to create instances on the fly to show off a configuration option to a customer or to try something out for a customer.

My system is a SuSE Linux 10.0, and I keep the SuSE MySQL binaries on the system for reference. I also need to have the different 4.0, 4.1 and 5.0 versions ready on my machine. In order to not to disturb SuSE's rpm setup, I installed the MySQL binaries as tarballs into /usr/local. It looks just like this:


Continue reading "Instances"

IE More Secure Than Mozilla? Just reading this thread on our favorite unbiased source of “news” for nerds. The poster would like us to examine some valid points, namely IE’s integration with the OS, and the higher “caliber” if you want to use that term, of bugs or flaws. Secondly, the point about the ability to uninstall firefox. He goes on to say that the report uses extremely flawed logic, and that Symantec is shilling for MS. I’d say a little bit of both is happening, and it’s happening by Symantec AND the poster.

My beef, I guess is with the statement that because it’s open source, the large number of eyeballs will make the code more secure. Sure, for the next version.. but who will upgrade ? How do you force someone to upgrade ? Sure, the latest and greatest is secure, but I have to routinely upgrade FF for my friends and …

IE More Secure Than Mozilla? Just reading this thread on our favorite unbiased source of "news" for nerds. The poster would like us to examine some valid points, namely IE's integration with the OS, and the higher "caliber" if you want to use that term, of bugs or flaws. Secondly, the point about the ability to uninstall firefox. He goes on to say that the report uses extremely flawed logic, and that Symantec is shilling for MS. I'd say a little bit of both is happening, and it's happening by Symantec AND the poster.

My beef, I guess is with the statement that because it's open source, the large number of eyeballs will make the code more secure. Sure, for the next version.. but who will upgrade ? How do you force someone to upgrade ? Sure, the latest and greatest is secure, but I have to routinely upgrade FF for my friends and family all the time. …

So, I’ve been tasked to write an application at work, from scratch. This is really cool, as currently I spend 90% of my time fixing bugs, or adding features to a really old PHP 4 code base with register_globals ON.
So, now my question is.. do I use PHP 5 or 4 ? I think the answer to this is pretty simple, as I want to learn how to do things in PHP 5, but this app needs a database, and I am going to use MySQL. It’s already in beta, and by the time I’m done with my development (2-3 months), we may reach GA. So, what do you guys think ?

The app in question, is basically a Document Management System. We’re going to have Documents with Sections and Subsections, all of which will be converted well formed XML when deployed. The whole point of this app, is to prevent the “business” side manage the content of the documents, rather than us software engineers. Currently, the “business” makes changes to the XML document in MS …

I’ve written a simple web frontend for the perror utility which is provided by MySQL. Some distributions, or some systems running older versions of MySQL do not have this utility, and sometimes, I don’t have access to a shell, I ran into this very problem over the weekend when I was on vacation, so I needed a quick way to be able to lookup these errors. Long story short, I now have this utility working and it’s available to all. I figured I’m not alone, so I’d let everyone hit it if they needed to.
You can get to it by just going to http://www.phpcult.com/mysql/123. Replace the last thing with 123, 111, 122, 120 whatever and it will give you the meaning. Hope this helps people.