Showing entries 41711 to 41720 of 44030
« 10 Newer Entries | 10 Older Entries »
Designing web applications for "end users" (the death of perl for webhosts)

I give up. The PHP users are right, I can't use perl anymore for writing "web applications".

About once a year I try to update my hideously programmed software, doekaki. It's a picture board with a java applet for the actual arting. The code sucks, since it's a pile of hacks upon hacks on a six year old codebase.

What's great about it is how most users who try a PHP based oekaki application and then try doekaki are floored at how easy it is to set up. That was the idea; you upload a small number of files, change permissions on two directories and two files, and then run it in your browser. The application installs itself and goes, no need for a mysql database.

Writing this code sucks. I'm denied from using any CPAN modules, and often a lot of standard perl libs don't work cross-site.

I can't do it anymore. There's a …

[Read more]
Selling freedom, not free

As the open source business ecosystem grows and matures, I'm finding it increasingly important for me to not only pitch my company's paid version, but also others'. Were I true Adam Smith, I'd argue that

...every individual necessarily labours to render the annual revenue of the society as great as he can. He generally, indeed, neither intends to promote the public interest, nor knows how much he is promoting it. By preferring the support of domestic to that of foreign industry, he intends only his own security; and by directing that industry in such a manner as its produce may be of the greatest value, he intends only his own gain, and he is in this, as in many other cases, led by an invisible hand to promote an end which was no part of his intention. Nor is it always the worse for the society that it was no part of it. By pursuing his own interest he frequently promotes that of the society more effectually than when he really intends to …

[Read more]
adnarim_abroad making me homesick

adnarim_abroad: I know it’s controversial to say, but i’

I now want to be bumming around Melbourne city during the games. My house is 2mins walk from a  train station that’s less than 30mins to the middle of town. But never spend enough time there.

It’ll be good to get home.

Although i think the tired and hungover thing isn’t helping.

My WordPress backup and restore process

As I am writing and publishing more and more blog entries, it becomes important that I have good and reliable backups. I know that if something happens and I cannot recover my entries and comments, I would be terribly upset. So I want to share my process here. Please feel free to share your backup methods by commenting. Hopefully somebody will find it useful.

Backup comprises two parts:

1. File backup

On a Linux machine with Apache, the default web files and directories reside in /var/www/html. Yours may be different. This include all php files and sub-directories like wp-content, wp-include, etc.

The easiest way to do it is to use tar command with -z to compress them. My post here gives you a pointer on tar.

These files are fairly static, so you do not need to back them up …

[Read more]
Just how many articles are at Planet MySQL?

I was trying to find an old article at Planet MySQL. One about a MySQL UDF to write to /var/log/messages. No luck.

Anyway, there is no search option on the site, and the latest addition of 10 entries per page makes it difficult to review pages. The RSS feed doesn’t give me a full option.

Anyway, it led me to look back in time to just how many articles are listed on Planet MySQL, and read some old stuff. I only came across it after I stumbled across the Brisbane MySQL Users Group back in Sep 2005.

Anyway the count was 2146. I’d like to see a stat on the home page of how many articles, and perhaps how many, last day, last week, last month.

MySQL Forge

I was reading Zack Urlocker’s MySQL Workbench Beta article and was keen to look at the Extensible architecture. Not much detail yet in the Figure Stylesheets, Scripts and Plugins, which will be good when it’s there, however it lead me to another secret.

The MySQL Forge. This was mentioned at the Brisbane MySQL Users Group Meeting with Brian Aker in January. There isn’t much content at present, but there is a Call for Content.

[Read more]
Duelling developers

Hakan vs. Andrey at the Devcon 2006

Tips: Hacking MySQL Server

Hacking the latest storage engine? Working on a fancy new SHOW command? Hunting for a bug in mysqld? This is for you!

Once you’ve got MySQL compiled, how do you test your mysqld binary? You’ll need to get it started. Stop! Don’t make install it!

  1. Set up your sandbox
    $ mkdir ~/t
    $ vi ~/t/my.cnf
    

    Add the following to ~/t/my.cnf (modify to taste):

    [mysqld]
    basedir=sql
    datadir=/Users/jcole/t
    port=3307
    socket=/Users/jcole/t/mysql.sock
    skip-grant
    skip-innodb
    skip-bdb
            
    [client]
    port=3307
    socket=/Users/jcole/t/mysql.sock
    
  2. Build your source
  3. Set up a symlink for share
    $ ln -s . sql/share/mysql
    

    This, combined with the basedir=sql in my.cnf means that MySQL will be able to find its error message and character set files, so that the release you’re building doesn’t have to match the release installed on the …

[Read more]
Change of plans

I'll be coming to the MySQL User Conference next month, then hanging around a little while longer for a support group meet.

After booking various things my bank called me about possible fraudulent charges on my credit card. Apparently I wasn't supposed to go?

MySQL merchandise - what would you like!

We know that people are pretty interested in "stuff" with the MySQL logo/name on it. Like, last year's anniversary mug was pretty popular, as are the t-shirts we hand out at various conferences. So we're working on more! We're the only ones who can make this happen, since it involves our trademarks.

This is your chance to tell the MySQL community team what kind of stuff you would like to see, and do feel free to be quite specific (like colour for t-shirts, etc). Tell what you would like: geek wear, baby wear, underwear?, mugs, caps, stickers, ...

The photo on the left is of my daughter Phoebe (10 months old now), with possibly the smallest MySQL shirt in existence (this one was custom printed). This just to give your creativity a nudge.

Also, if you have any cool/funny sloguns in mind, now is the time …

[Read more]
Showing entries 41711 to 41720 of 44030
« 10 Newer Entries | 10 Older Entries »