Site uses cookies to provide basic functionality.
Javascript rendering is set to off by default when visiting the site via .onion and .i2p domains. It can be enabled back again in user's settings section. Javascript rendering set to off means, that you can disable javascript in your browser now and the site will remain functional.
There is also IRC server now available via native IRC clients or non javascript web based one.
Fonts can be adjusted in user's settings section as well.
Check FAQ for more.

OK

A while back I was doing some performance tuning on MySQL 5 for a customer. A SELECT was counting the number of rows in the table. I always use COUNT(*) for that but I know a lot of people, including the customer, use COUNT(pk_col). The query was taking a long time (a few minutes). I analyzed that the problem came from the usage of COUNT(pk_col) instead of COUNT(*). With COUNT(*) it was instantaneous.

Couple of years ago an interesting fact floated up in Oracle-L – a regular user with only SELECT privilege on a table can successfully execute a SELECT FOR UPDATE against it, locking all rows and even lock the whole table using LOCK TABLE command. Locking a table in exclusive mode would stall all changes and selects against that table – effectively hanging all applications using that table. Pete Finnigan wrote a review of the issue in this..

Couple of years ago an interesting fact floated up in Oracle-L – a regular user with only SELECT privilege on a table can successfully execute a SELECT FOR UPDATE against it, locking all rows and even lock the whole table using LOCK TABLE command. Locking a table in exclusive mode would stall all changes and selects against that table – effectively hanging all applications using that table. Pete Finnigan wrote a review of the issue in this..

Since I’m taking the Computational Physics module in my third year at IC, we’re using some libraries like GSL to provide “better-than-default” random number generators and such like. It turns out that those of us using a Mac don’t get GSL installed by default with Xcode, or under OS X - and unlike Windows and Linux - there’s no instructions on the course site. Here’s a really quick way to ensure that you can link against it:

Since I’m taking the Computational Physics module in my third year at IC, we’re using some libraries like GSL to provide “better-than-default” random number generators and such like. It turns out that those of us using a Mac don’t get GSL installed by default with Xcode, or under OS X - and unlike Windows and Linux - there’s no instructions on the course site. Here’s a really quick way to ensure that you can link against it:

Do you remember the dawn of the Internet in the mid 1990s? Everyone was talking about the “Information Superhighway” (a cheesy term for the Internet back then) and how it would change everyone’s life. Then people starting talking about the World Wide Web (WWW) and email and facebook. Still today, many people don’t know how to properly define the World Wide Web and the Internet. At dinner parties with non-geek friends, I like to bring t..

Do you remember the dawn of the Internet in the mid 1990s? Everyone was talking about the “Information Superhighway” (a cheesy term for the Internet back then) and how it would change everyone’s life. Then people starting talking about the World Wide Web (WWW) and email and facebook. Still today, many people don’t know how to properly define the World Wide Web and the Internet. At dinner parties with non-geek friends, I like to bring t..

I’m having some busy times, so can’t blog anything more serious than another sqlplus trick (which likely has value only to some hardcore sqlplus geeks though). Ever wanted to load a sqlplus parameter (like linesize, pagesize or arraysize) into a sqlplus define variable? This can sometimes be helpful for customizing your everyday DBA scripts to output (or not output) some columns based on linesize. Or you may want to use the SQL error co..

I’m having some busy times, so can’t blog anything more serious than another sqlplus trick (which likely has value only to some hardcore sqlplus geeks though). Ever wanted to load a sqlplus parameter (like linesize, pagesize or arraysize) into a sqlplus define variable? This can sometimes be helpful for customizing your everyday DBA scripts to output (or not output) some columns based on linesize. Or you may want to use the SQL error co..

What is a good measurement of the quality of your architecture? The length of your documentation. The shorter, the better. There are three purposes of documentation that can be important to a project for its long time survival. First: How does a new developer get started working on the project. Second: How do you install the projects executable on a brand new server. Third: What do you have to know to monitor and operate the system.

New Look - rob.sh - 18 years ago - eng
As it turns out - it’s pretty easy to code up a very basic blog application and integrate it with your existing flat-file site in Django. In fact, it fits very nicely into the 20 minute gap that you’re taking to try and make sure that you can sleep! There’s also some semblance of a design here now.

New Look - rob.sh - 18 years ago - eng
As it turns out - it’s pretty easy to code up a very basic blog application and integrate it with your existing flat-file site in Django. In fact, it fits very nicely into the 20 minute gap that you’re taking to try and make sure that you can sleep! There’s also some semblance of a design here now.

I installed Macintosh OS X 10.5 Leopard on all my Macs today. When you upgrade an OS, you always expect to lose some system settings and have some applications that don’t like the new OS. As a result, I chose to install Leopard on my PowerBook G4 first. It has tons of software and I customized it to the max, so I naturally expected to spend a while tweaking it after the upgrade to get an idea of what I can expect when I upgrade my other ..

I installed Macintosh OS X 10.5 Leopard on all my Macs today. When you upgrade an OS, you always expect to lose some system settings and have some applications that don’t like the new OS. As a result, I chose to install Leopard on my PowerBook G4 first. It has tons of software and I customized it to the max, so I naturally expected to spend a while tweaking it after the upgrade to get an idea of what I can expect when I upgrade my other ..

I realized I never finished the story about Sony laptop Support. The laptop was returned after about 5 weeks, and it did work. In the mean-time some plastic is coming a bit detached around the screen (that was one of the things they replaced), but if you handle it gently, it’s OK. It was returned to the wrong place. Well I asked them to call me before they returned it, as they picked it up from one of the offices I work in, but I work i..


I went to Simula Research Lab’s seminar on estimation today. My conclusion is that despite many years of practice and research, we don’t know how to make estimates for even moderate projects correct within an order of magnitude. I think a new approach is needed! I wish I could’ve said that I learned something fundamental, but instead, I got my preconceptions confirmed. I think I understood the underlying causes better, however.



Question: How to check instance parameter values in Oracle? Answer: show parameter xyz WRONG! Answer: select value from v$parameter where name = ‘xyz’ WRONG! These commands show the session level parameter values, which are separate from instance level parameters: SQL> show parameter session_cached_cursors NAME TYPE VALUE ------------------------------------ ----------- -------------------------------- session_cached_cu..

Question: How to check instance parameter values in Oracle? Answer: show parameter xyz WRONG! Answer: select value from v$parameter where name = ‘xyz’ WRONG! These commands show the session level parameter values, which are separate from instance level parameters: SQL> show parameter session_cached_cursors NAME TYPE VALUE ------------------------------------ ----------- -------------------------------- session_cached_cu..



Yesterday, I teamed up with and old friend of mine (Scott Elliott) and went to the Ontario Linux Fest at the Toronto Congress Centre. For those who do not know Scott, he is a VMWare guru (you can join his Southwestern Ontario VMWare user’s group @ www.vmware.com ), as well as a master in the 8th layer of the OSI Model (the political layer). Although he won’t admit it, he knows UNIX very well and is an advocate of the Open Source movement..

Yesterday, I teamed up with and old friend of mine (Scott Elliott) and went to the Ontario Linux Fest at the Toronto Congress Centre. For those who do not know Scott, he is a VMWare guru (you can join his Southwestern Ontario VMWare user’s group @ www.vmware.com ), as well as a master in the 8th layer of the OSI Model (the political layer). Although he won’t admit it, he knows UNIX very well and is an advocate of the Open Source movement..

The Norwegian word “smidig” means “agile”. So when we wanted to make a Norwegian conference for the Oslo Agile community, “smidig 2007” (November 26th and 27th) was a natural choice for a title. The seed of the conference was idea by Nils Christian Haugen and Aslak Hellesøy to have a whole day devoted to open spaces. Meanwhile, I had been experimenting with “lightning talks” on Oslo XP meetup, a user group that meets in Oslo every month.





In light of the upcoming Ontario Linux Fest, I decided to use this blog entry to reflect on Open Source Software and Linux. Free Software and the Free Software Foundation (FSF) were pioneered by the famous Richard Stallman. Free Software does not mean “at no monetary cost”……..it means that the source code is free to anyone who wants to use it (source code freedom). In the words of Stallman, think “free” as in “freedom”, not “free” as in..

On my stereo at home it plays fine (although it doesn’t work on my Windows computer ) but put it into my girlfriend’s DVD player and it reports itself to have 17 tracks even though the cover says it only has 15. I hadn’t looked closely at the reported track count on the DVD player and just played the disk. After the peaceful ending of the last track on the CD i.e. the 15th, the speakers just erupted in loud white noise. I suppose that was ..

In light of the upcoming Ontario Linux Fest, I decided to use this blog entry to reflect on Open Source Software and Linux. Free Software and the Free Software Foundation (FSF) were pioneered by the famous Richard Stallman. Free Software does not mean “at no monetary cost”……..it means that the source code is free to anyone who wants to use it (source code freedom). In the words of Stallman, think “free” as in “freedom”, not “free” as in..

I’m using Windows, and it seems that in one new aspect, I discover that Windows just doesn’t work. (Or maybe it’s the CD that doesn’t work?) Ideally I would have put the CD in the computer’s drive and it would have just played it. This was Bill Gates’ vision once. I think prior to Windows 95’s launch, he said “I imagine a day when you can just put a Beethoven CD in the drive and Windows will play the song”. (Although I couldn’t find that ..







Update: As this original article is from 2007, there are better options available in the modern times – for example DBMS_UTILITY.EXPAND_SQL_TEXT as explained by Maria Colgan’s blog entry here . If you have been involved in tuning SQL code which you have never seen before, you are probably familiar with the challenges of understanding what the code is trying to do. This can be especially time consuming when the SQL references lots of vi....

Update: As this original article is from 2007, there are better options available in the modern times – for example DBMS_UTILITY.EXPAND_SQL_TEXT as explained by Maria Colgan’s blog entry here . If you have been involved in tuning SQL code which you have never seen before, you are probably familiar with the challenges of understanding what the code is trying to do. This can be especially time consuming when the SQL references lots of vi....

My presentation at JavaZone was riddled with technical difficulties this year. To make a long story short: I learned five minutes before the presentation the the projector would be inoperative for a while (turned out to be 30 minutes). This threw a wrench into my plans, as I had planned to open with a demo. I have read many times on presentation zen about presenting without slides. But before I stood in front of four hundred people with not..

My talk at JavaZone went surprisingly well. The fact that the projector went dead and that I was planning on opening with a demo raised my pulse, but I felt I managed to get my message across and that people were happy. The talk was about how we use Jetty to manage the full deployment life cycle of our application. I explained how we had implemented this and what problems we had solved.

1 visitor online