Open Query blog

I’ll say beforehand that the following is not very clean – for a number of reasons. I’ll discuss some issues after the query. The query returns all indexes in a db where the cardinality is lower than 30% of the rows, thus making it unlikely that the server will ever use that index.

SELECT s.table_name,
[...]

Filed under: Uncategorized | by arjen
15 Comments »

Compared to SQL*Plus (Oracle’s cmdline client) which can as I understand produce complete paginated reports, the ‘mysql’ tool has fairly simple output formatting. I’m not generally fussed about that, as there are perfectly good other tools do make snazzy reports with. Some very cross platform (like web based), output PDF, not a problem. You can [...]

Filed under: Uncategorized | by arjen
5 Comments »

Peter Zaitsev wrote an interesting item on front-end performance of a website.
I’ve always tried to look at the front-end from the user perspective, rather than purely technical. Once you weed out what’s not really necessary for the user, and also deal with issues like “how important is it that this number is live”, you generally [...]

Filed under: Uncategorized | by arjen
4 Comments »

This fellow is pretty amazing: http://beta.ivancover.com/wiki/index.php/Eee_PC_Internal_Upgrades. To the already tiny Eee PC, he added (internally!):

USB hub
GPS with antenna
Bluetooth
Card reader w/ additioal SSD
Power switch (10 dip) for switching all extra foo on/off
Wifi upgrade 802.11n
FM transmitter
Modem (admittedly there’s design space for that)
Touch screen
Temperature sensor
Heatsink

That’s pretty cool…

Filed under: Uncategorized | by arjen
No Comments »

Grand, I got my personal copy from the courier today!
Many people kept asking me over recent months “when is it coming, when can I get it”… so now you can. Officially out, and available.
Click on the book pic if you want to grab your copy via Amazon (which is probably one of the cheapest sources, [...]

Filed under: Uncategorized | by arjen
6 Comments »

Since a few months, sellers can no longer provide neutral or negative feedback to buyers. Not sure if I completely agree with this as I reckon buyers can be quite dodgy and how else to capture that. But the objective was to weed out retaliatory feedback. I.e. buyer has a bad experience, provides neutral or [...]

Filed under: Uncategorized | by arjen
No Comments »

I spent some time today on that, it had gone increasingly gaga after some software and POI updates, then lost the plot completely, and then didn’t want to boot anymore. The usual reset/restore procedures didn’t improve things, so I invented my own which did not involve a restore procedure. I basically formatted the flash and [...]

Filed under: Uncategorized | by arjen
2 Comments »

Horay! Thank goodness, and about time too!
On the latter, I do appreciate that any such switch is a serious change for a development team, I was involved with this while at MySQL so I’m well aware of the issues
Nevertheless, it was high time as it once again allows the rest of the world (outside [...]

Filed under: Uncategorized | by arjen
No Comments »

Is your child not quite ready for proper typing, but does she love “typing stories” on the keyboard The trick is finding a program that allows them to muck around without the possibility of triggering special functions through some keypress or mouse movement. With the help from Greg Black & James McPherson on the #humbug [...]

Filed under: Uncategorized | by arjen
No Comments »

I acquired an Eee PC for my Phoebs. On special somewhere, unfortunately not a pink one
While I see that lots of people are replacing the Asus/Xandros OS with Ubuntu for Eee or other distros, I’ve decided to stick with the default for now. It’s a very easy desktop to use, with all clutter, confusion [...]

Filed under: Uncategorized | by arjen
1 Comment »