Saturday
19
Nov 2005

Creating a UTF8 Postgres database

(7:35 pm) Tags: [Software, How do I...]

initdb -D /var/lib/pgsql/data --locale=en_US.utf8 -E UTF8

Popularity: 21%

Comments: (0)
Wednesday
16
Nov 2005

Search and replace in MySQL

(9:40 am) Tags: [Sysadmin]

From padawan.info:

This made some data munging easy:

update tablename set field = replace(field,'search_for_this','replace_with_this');

Popularity: 20%

Comments: (1)
Sunday
13
Nov 2005

MySQL BLACKHOLE Storage Engine

(10:42 am) Tags: [Software, Sysadmin]

“You see, it’s a show about: Nothing”

http://dev.mysql.com/doc/refman/5.0/en/blackhole-storage-engine.html

Popularity: 21%

Comments: (0)

No reading feeds for the feed reader developer

(9:30 am) Tags: [Life, FeedLounge]

I have noticed in the past year while working on FeedLounge, that I just cannot keep up with my old reading list. This may sound crazy, but I am down to actually reading about 12-15 feeds, and skimming a couple dozen more. The rest are lost to my feature development, and just simple testing of the server and the new features.

Just a random though to start my morning…

Popularity: 32%

Comments: (3)
Wednesday
9
Nov 2005

Insanity says all web services should be free

(5:51 pm) Tags: [Rants]

One remark to the crazy types out there that think everything on the internet should be free: It isn’t, and it won’t ever be, so get over it already. Do you honestly thinking hosting and maintaining any web service/application is free? Think again. It just happens to be subsidized in some way as to make you pay somewhere you wouldn’t notice. Think about it for a bit. Every web service out there has to sustain itself somehow. I repeat, think about it.

Popularity: 22%

Comments: (3)
Tuesday
8
Nov 2005

Self-modifying file

(12:30 pm) Tags: [How do I...]

Working with Shelby today, he had written an XSLT that created a SQL script, with embedded search and replace statements (he was calculating parent ids on the fly). So, now we have a SQL script that contains commands to run. So, something like this:

sed -e "`grep SED: test.txt | awk -F" " '{print $2}'`" < test.txt | grep -v SED:

And the file modifies itself. This is why Unix will live forever! GUIs be damned, full command line speed ahead…

Popularity: 20%

Comments: (0)
Thursday
3
Nov 2005

Great email template for feature request responses

(11:56 am) Tags: [Quotes]

From the jaxen-user list, in a response to someone asking for XPath 2.0 support (a HUGE amount of work), from baz:

To sum up: its hard, we’re lazy, and you’re the first person who’s asked…

This begs to be a standard email response template…

Popularity: 22%

Comments: (3)