I just implemented a script-cache for MySQL Proxy and had to learn a bit more about lua internals. As a result I wrote two functions which are generic enough for general consumption:

• luaL_loadfile_factory()
• luaL_loadstring_factory()

They also show how to write a lua_Reader for lua_load().

The #lua channel on freenode was a great help, as always.

LUA provide several loaders:

• luaL_loadstring
• luaL_loadbuffer
• luaL_loadfile

and you can create your own if you have to.

Now, why the need for a new loader ?

The proxy we have

• a global scope caches the scripts
• this cache reloads the scripts if they changed on disk
• each thread executes the same script
• each thread has its own …

Damien Katz and the CouchDB development team are proud to announce:

CouchDB version 0.7.0 is now available.

This release is a major milestone in the project’s history.

Key features include:

• a REST API using JSON instead of XML for data transport,
• a JavaScript view engine based on Mozilla Spidermonkey,
• a GNU Autotools build system supporting most POSIX systems (Noah Slater),
• a built-in …

So, I got my new MacBook 13" - since Apple updated the chipset. That ups the speed to 2.2GHz (it's a Core 2 Duo), has better graphics (apparently, don't think I care too much for that), but most importantly, it can now handle up to 4GB of RAM. Not that you should get the 2x2GB from Apple directly (the other ram upgrades are not that expensive with them actually) but here they decided to ask for a whopping $1250 or so. Daft. Got the memory sticks from elsewhere, of course. The 4GB is glorious! No swapping, very responsive, even with lots of stuff open. Great.
Note that I ordered the MacBook directly from the Apple store, because the local shops in AU didn't have the new model yet (different warehouse apparently).

New Macs come with OS X 10.5 (Leopard). Very shiny. Time Machine is particularly cool, as is the GUI profiler that's part of Xcode. Lots of other little things improved and fixed. Although I'm not sure I like the new …

Welcome to the 71st edition of Log Buffer, the weekly review of database blogs. There were so many blogs covering this week’s Oracle Open World that I could have devoted this entire edition only to that. But that would not be fair to those other DBMSs, all of which are fine DBMSs in their own [...]

Background Knowledge

The MySQL database v4.0.23 is using the default character set of “Latin1″. When the database was created I had no knowledge of character sets other wise it would have been “UTF-8″.
The web pages are using a character set of “UTF-8″.

Problem

Data being queried from a MySQL database that contains French accent characters will not render correctly in the browser even after applying PHP htmlentities().

Example code: $string = htmlentities($string , ENT_QUOTES, “UTF-8″);

Solution

The queried data from the database was inputted using the character set “ISO-8859-1″. I …

Quick... You have to let everyone (boss, biz dev, customer service, and random bean counters) know why everything is moving slowly! Of course, rarely do people define what "everything" is, and what type of slowness is occuring. But, in the face of customer service agents that cannot work because their pages will not render, generally all eyes are on the famed-dba-of-the-minute.So, with 7 people

Use MySQL? On Leopard/OS X 10.5? Yes, the current available packages from dev.mysql.com don’t work very well. I track “mysql” on Twitter, and boy, are there heaps of complaints.

So its nice to see, Dan Benjamin, a member of the MySQL community, stepping up, and creating the amazing Installing MySQL on Mac OS X article. The Preference Pane will obviously still not be there, and I don’t know why he thinks Mantorg (?) will build it, but I believe this is something MySQL needs to fix for the next release.

Tracking mysql#28854 will be useful.

Mark Pilgrim decided that it would be cool to poke fun at OS X, because it “just works” on Ubuntu. While what he …

As I sat watching Larry Ellison’s keynote at Oracle OpenWorld on Wednesday it occurred to me that something was not quite right. This is the end of a year in which Oracle released a major new version of its flagship Database product and made a number of acquisitions, including Hyperion, Agile and Coherence, not to mention bidding for BEA. This is also the start of the year in which Oracle will roll-out its first Fusion Applications following its acquisitions of PeopleSoft, Siebel et al. And yet here was Ellison talking about Linux.

Granted, the fact that Oracle had gathered 1,500 customers in the first year of its Unbreakable Linux offering is a sign of success, but enough to overshadow everything else and form the starting …

I am heading back to Zaragoza to speak and attend at the 2nd Open Innovation event on the 20th, and I certainly am excited about it for a number of reasons, not least because of the great entrepreneurship the country currently is providing.

Secondly Spain seems to have disproportionate amount of open source developers compared to many other countries.

I don’t quite understand the reason for this, but I hope to find out, as well as very thriving entrepreneurship scene as Ignacio has already noted and good number of young Open Source businesses as Stephen has commented on. I am looking forward to talking to as many of them as possible.

Disclaimer: I am on the board of Ebox & have …

So a bit more of the engine now works :)

mysql> CREATE TABLE `m` (
     ->   `a` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     ->   `b` varchar(100) DEFAULT NULL,
     ->   `c` int(11) DEFAULT NULL,
     ->   UNIQUE KEY `a` (`a`)
     -> ) ENGINE=MEMCACHE DEFAULT CHARSET=latin1 CONNECTION='localhost,piggy,bitters' ;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into m VALUES (0, "this is mine", 23);
Query OK, 1 row affected (0.01 sec)

mysql> insert into m VALUES (0, "this yours mine", 42);
Query OK, 1 row affected (0.00 sec)

mysql> insert into m VALUES (0, "this ours mine", 67);
Query OK, 1 row affected (0.00 sec)

mysql> select * from m;
+---+-----------------+------+
| a | b               | c    |
+---+-----------------+------+
| 1 | this is mine    |   23 |
| 2 | this yours mine |   42 |
| 3 | this ours mine  |   67 | …