Archive for May, 2008
Thursday, May 29th, 2008
There's a weird behavior in Python when dealing with Mutable types such as dictionaries, that when you modify a variable defined as a class attribute, you're actually modifying a shared dictionary amongst all the classes. This seemed weird to me. You can read the lovely discussion about it, ...
Posted in python | No Comments »
Thursday, May 15th, 2008
Altering a big table sucks, and to make it worse you have no idea what's happening or how long it will take. I'd like a progress bar, or some status output, or something that gives me the feeling like my server didn't die.
Posted in mysql | 6 Comments »
Tuesday, May 13th, 2008
I was poking around the MySQL Worklog again over the weekend, and found a request for materialized views for MySQL. This feature has existed in Oracle for a while, in DB2 as a materialized query table, and appeared in MS SQL Server 2000 and 2005 as indexed views.
What is ...
Posted in db2, mssql, mysql, oracle | 10 Comments »
Thursday, May 8th, 2008
I'll keep it short. In the last few days, login on our dev server broke. We hadn't changed anything related to it, and everything looked good code wise. What we finally figured out was that our session cookie was set to expire 2 days into the future, ...
Posted in php, vmware | No Comments »
Wednesday, May 7th, 2008
I was cruising the MySQL Forge Worklog when I came across the idea of Time Delayed Replication. I had never considered the benefits of deliberately keeping a slave server behind a master.
Kristian Koehntopp gives a good example:
Kristian Koehntopp writes:
TDS: Time delayed SQL_THREAD (Have a replication slave that is ...
Posted in mysql | 6 Comments »
Monday, May 5th, 2008
I was curious how many lines of code were in PHPBB 3. I only wanted to know about the .php files.
find . -name '*.php' -exec wc -l {} \; | awk '{ SUM += $1 } END {print SUM}'
The downside to this is that it includes whitespace ...
Posted in linux | 1 Comment »
Thursday, May 1st, 2008
I posted a complaint a while ago about BBEdit complaining about a few things. I moved onto TextMate for a few weeks, but it lacked some of the powerful BBEdit features I've gotten used to.
Then I discovered ctags. I set up a cron on my PHP dev site ...
Posted in bbedit | No Comments »