|
The Open Database Camp 2011 is shaping up nicely. The logistics is being defined and local and international volunteers are showing up for help. (Thanks, folks!) If you want to start booking, there is a list of hotels in the Accommodation page. And don't forget to sign up in the Attendees list. Local travel information will be released as soon as we finish cranking up the plan. Open Database camp is free, but we still have expenses to get the job done. We need both official sponsors and … |
Feb
03
2011
Jan
23
2011
Packt Publishing recently sent me a copy of MySQL for Python to review and after reading through the book I must say that I’m rather impressed at the variety of topics that the book covers.
It starts off with the basics of setting up MySQL for your testing/development needs by going over several of the common installation and configuration methods. After that it’s a quick intro for connection methods and simple error reporting for connections. The author gives a quick intro to CRUD and how it relates to databases and python before heading into the common tasks of simple queries. I was surprised to see some database profiling discussion; which is rather handy for a new coder or a person new to MySQL. Once the basics of …
[Read more]
Jan
15
2011
In November a Mark Schonewille posted a blog on when you can't and cannot use the GPL version of MySQL together with your closed source application. The post was a result of actually talking to an Oracle lawyer which makes it valuable information. Unfortunately Mark's blog is now offline (it seems he didn't renew his domain registration?)
This is just a repost of the disappeared blog post. (The small print allows me to copy it verbatim.) There is no commentary from myself, except that what Mark wrote is the same I also heard Oracle say a year ago. That Oracle is being consistent on this point is very welcome and deserves to be kept available online.
Dec
21
2010
As you are probably aware, PHP 5.3.4 does not compile with MySQL 5.5 GA. The details can be seen in
MySQL bug queue. Basically, the problem boils down
to incorrect installation of MySQL headers. MySQL 5.5 build
system does not install the headers under the
include-prefix/mysql directly but instead installs
under the include-prefix directory itself. So, when
the PHP build system
looks for the MySQL headers, it cannot find
<mysql/psi/mysql_thread.h> and so forth.
What is the fix?
The MySQL dev team has committed patches to fix this issue in …
[Read more]
Dec
17
2010
Series
What are the chances for a free software cloud?
- Resolving the contradictions between web services, clouds, and open source
- Defining clouds, web services, and other remote computing
- Why clouds and web services will continue to take over computing
- Why web services should be released as free …
Dec
15
2010
Series
What are the chances for a free software cloud?
- Resolving the contradictions between web services, clouds, and open source
- Defining clouds, web services, and other remote computing
- Why clouds and web services will continue to take over computing
- Why web services should be released as free software (12/20)
- Reaching the pinnacle: truly open web services and clouds (12/22) …
Dec
14
2010
If you are fortunate enough to be in Beijing this week for Oracle Openworld, there are several sessions planned on MySQL to choose from. The English site is somewhat hard to navigate, so I humbly submit a tiny URL that will point you to the appropriate session search results.
Few act from pure motives, and I’m shamelessly plugging my own talks: Improving the Scalability of Web Applications with MySQL Replication, Performance and Scalability Enhancements in MySQL Release 5.5, and MySQL Strategy: What’s Next? (that last I’m merely technical backup for Richard Mason).
There are several other outstanding talks on MySQL migrations, tuning and Cluster as well, and of course an …
[Read more]
Dec
12
2010
I’m back in the blogosphere!
This blog will focus on Smalltalk (mostly Pharo, Squeak, Dolphin, VAST and VW), databases (usually MySQL, PostgreSQL, SQL Server, DB2, InterBase and Firebird), algorithms and open source tools. I’ll throw in some literature, music and mathematics occasionally.
Requirements to enjoy this blog : an interest in problem solving, a database and a Smalltalk environment!
Dec
08
2010
If you are running any GNU/Linux server operating system like RHEL 5 or CentOS 5, you may probably install MySQL server that comes with the operating system packages either during the initial setup or later using yum(8). The advantage being addition/removal of packages either using the GUI package manager or rpm(8), yum(8). Fair enough. But unfortunately the MySQL package (mysql-server) that comes bundled with RHEL 5.5 or CentOS 5.5 is fairly old (5.0.77). What if you want to install the latest stable version of MySQL yet have the advantage of removing/re-installing the software using rpm(8)?
In this blog post, I will guide you with compiling MySQL from source code yet installing the software through rpm(8) so that we tune and configure the software for the target machine and yet uninstall the software using RedHat package manager.
Compiling and Installing MySQL using rpmbuild(8)
First make sure you have sudo(8) access and …
[Read more]
Dec
06
2010
There have been a few great blog posts recently from MySQL bloggers about Postgres, and vice versa, with good comments and follow-on from the real experts in both systems. I think this is wonderful. Learning how other databases solve hard problems is highly educational, especially because ACID databases face some of the hardest problems in computing. Making MySQL better is good for PostgreSQL. The reverse is just as true. And we should also be learning from SQLite, and CouchDB, and others who have overcome tough technical hurdles, built successful companies, created thriving and enthusiastic communities, or whatever their success has been.
Related posts:
[Read more]