Archive for the ‘Databases’ Category

MySQLi Converter Tool, ext/mysqli against MySQL 5.0.26 released

Some interesting things happened today…

We released a new MySQL server a few days ago, and that consequently means we’ve got a new Connector/PHP available for download. Go get ext/mysqli and ext/mysql against 5.0.26 while its hot.

And while we do support ext/mysql, we’d rather you (and your applications) used ext/mysqli. After all, wouldn’t you like to be able to use the new, much touted features that came post MySQL 4.1, like Views, Stored Procedures, Triggers, Precision Math, and so on?

So to make it a complete no brainer, we released a MySQLi Converter Tool. Its also available via subversion. The tool is branched off Revision 11 (in where support for the error functions were added!), and if you wanted an easy, HOWTO styled guide for using it (i.e. the great GUI web interface wasn’t enough), here’s a step-by-step guide to getting WordPress 2.0.4 using the mysqli converter in almost no time!

Yes, read Converting to MySQLi and do provide feedback. This is really just to whet your appetite, developer documentation will probably be next. All on the MySQL Forge Wiki, of course.

Happy PHP-ing.

Technorati Tags: ,

Interview with Si Chen, of opentaps

Si Chen, lead/core developer for opentaps (formerly known as Sequioa ERP), talked with us recently, and there’s an interview available. opentaps is an Enterprise Resource Planning solution, which is rather scalable and has a lot of functionality. It uses MySQL, of course. Give it a twirl!

Do you use MySQL for your application that you develop? Want to talk about it? Drop me a line at colin[AT]mysql.com.

MySQL Connector/PHP for MySQL 5.0.24 and PHP 5.1.5 released

We interrupt this scheduled viewing, for our faithful Windows users…

We have a new release of the MySQL Connector/PHP. MySQL has released 5.0.24 for a bit, and PHP themselves have released 5.1.5. The PHP release actually fixes some security related issues. Be sure to check the forums out if you encounter issues and if you fancy, the usual announce message.

Now back to your regular scheduled programming…

Technorati Tags: , , , , ,

Community Contributed Documentation – Tamil sees some

Open source projects have a lot of documentation. Some professionally written, others community contributed. One thing that community contributed documentation has going for it is the passionate users that write localized content.

Localization of documentation is important. While we take it for granted that we all speak/read/write/understand the English language, a lot of people just starting out in non-English speaking areas might find it useful to read some localized content. Hook them based on their interests, and slowly they can be weaned off to other non-localized documentation, and might contribute to the localizing cause eventually, even.

Localization is also not easy. If you tried to localize the MySQL Documentation, its recommended you start with something smaller like the GUI tools, rather than the entire user manual. This because of its sheer size. I dare say, we have one of the best user manuals for any open source project out there. Its cogent, its concise.

Tamil (Indian) Documentation
But the point of this post, was really to encourage more community contributed documentation. Of late, we’ve had some Tamil documentation, that I myself can’t review, but I’m sure the collaborative and distributed nature of the Internet will enable us to find some Tamil reading people, who can write better, and longer descriptions about what’s there.

I’m sorry its a Word document. I didn’t want to convert it to a PDF because I have no idea if the fonts will break. For what it is worth, there is a supplied font that you might find useful, if you were reading it. Now, who wants to review it?

Blogs via Planet MySQL
If you read Planet MySQL, you’ll realize that quite a lot of the content there is high-quality MySQL related content. What you will also realize is that these are on individual user blogs, and its all fed based on topic and regex searches (thanks Arjen, for this!). But content within Planet MySQL disappears from the front of the page after 10 entries.

To fix this, there are the Planet MySQL Archives. If you notice, these are actually cached on Planet MySQL itself, so the content will be preserved if you move blog host, or somehow manage to be taken off the Internet. However, this isn’t a hundred percent solution, as not all the content on the Planet are actually “article material”.

So wouldn’t it be nice if all the article material were on the MySQL Forge Wiki? This way, we would have a community-based data store, with available information for all to draw on.

What are your thoughts? Is publishing on the wiki too difficult? I’m interested in hearing your comments (or even better, tell me what your blog posting workflow is like). colin AT mysql dot com works too.

Camps, and WWDC2006

Just as Jay writes about an upcoming MySQL Barcamp, I’m all stoked to head to the 2006 inagural WordCamp. After that, I’ll be at Apple’s WWDC 2006.

There’s one thing there that interests me greatly is the My Agenda tool – you can pre-plan what you’re going for, have it printed or subscribed to in the webcal (iCal) format.

So, anyone want to catch up in San Francisco? I’ll be around from the 4th right till the 12th (though I leave later in the evening then). Drop me an email or just comment here…

Forge wiki

Just a quick note to say that the MySQL Forge Wiki looks like the rest of the Forge, and there’s now SpamBlacklist installed. If spam still persists (you know you’re popular when spam’s abound, right?), we might have to install captchas. From an accessibility perspective, I don’t quite like this idea, so lets hope the spam stays under control nonetheless.

Maybe inflammatory, but I don’t quite remember spam on the Fedora Project wiki. Do Python-based wikis suffer less spam (or no spam) than the PHP-based ones? (otherwise known as MoinMoin vs. MediaWiki)


i