Disapprove with me!

Okey, you know Oracle. A very good database, a very old database, a very solid rock. Not famous for its error messages. I have already stumbled upon a misleading error on the old rock.

This error anyway is incredible. If you try to push a very long text in a varchar2, you can end up with a

Read More

I stumbled upon a very brain-f**k error on Oracle 10g on these days.

Context: the following query [sql]SELECT * FROM (
SELECT TO_NUMBER(CUSTOMER_ID) AS SNDG FROM BAD_CODES_TABLE WHERE
AND I_LIKE=UPPER(‘STATIC_CONDITION’) AND CUSTOMER_ID NOT LIKE ‘%P%’ ) S WHERE TO_NUMBER(S.SNDG) >2000[/sql] could trigger a Invalid number if CUSTOMER_ID column contains invalid numbers.

Why?

Well…if you ask to “explain plan”, you will get something like

• a table full scan
  • Filter Predicates AND
    • I_LIKE=UPPER('STATIC_CONDITION')
    • TO_NUMBER(S.SNDG) >2000
    • CUSTOMER_ID NOT LIKE '%P%'

Read More

Sometimes, a client-based refresh of the session is the only viable option.

Anyway, we must define this a “bad idea”, because you can end up stuffing even more problems on your architecture…

Now this is something that may or may not be useful to a lot of people, depending on you situation, you may want the user to elect to refresh their Session or not (like banks usually do); but this is for applications that may have a lot of idle time and users are annoyed with their Sessions dying... considering most users don't know what a Session is, but they know that the application stops working correctly.

It uses jQuery and is incredibly simple, just a few lines of code, and no screen flicker or any annoyance to the user at all; ignorance is bliss. First I include the following in the code-behind in any page you need to keep refreshed (works on masterpages as well)[…]

via Automatically refresh your user’s Session behind the scenes using jQuery and Asp.Net.

Read More

I have used Google in the past 8 years (I know, I am a bit old). Then I was annoyed because of a bad behavior of Google with my AdSense account (shutdown without being able to talk back to someone for explanation).

Read More

About Diaspora, we read from Ars Technica (underline is our):

Diaspora emerged as a response to the privacy concerns raised by mainstream social networking services. The aim of Diaspora is to create an open source social network alternative with decentralized architecture, giving end users more control over their private information and how it is shared with other people. [...]

When the first Diaspora code was first published in September, independent reviewers found some serious technical defects, including a number of security weaknesses. […]

Read More

iPhone is the brand-new Apple product which has changed the way Apple thinks. Because of iPhone, Apple strip the word "Computers" from its brand name. And because of iPods and iPhone products, Lepoard developmenet slip a bit, blurring the focus on pure technology.
To be true, I do not beat on  the iPhone success, but the product success is at least  bright this year. And the iPod touch has also added value to the iPods product catalog. But I am an IT-man, damn you boy! So I want to buy it to play with it, to program with it!

Read More

Hi all, dear readers (and spammers too... you delight me with your poor tatics)!
Because my job is getting very very boring, and my private life is full of fantastic nights, I have decided to write a bunch of new articles, and stack them on objectsroot.com.

Read More

My first webcam video....
See and have fun: http://www.youtube.com/watch?v=53CIgqpD0S8

The Story
I have just bought a new fantastic Mac computer. So I tried my webcam, and in the same evening a friend of mine give me a cigarette (I  don't smoke so I tried it in front of my webcam).

Read More

Celeste

Celeste is a mail reading and organizing program. The name "Celeste" is a reference to an earlier mail reader named Baba, which was written at Xerox PARC by Steve Putz and John Maloney.

Nowadays, Celeste is maintained by Giovanni Giorgi (me).

Latest Feature

A new revision is planned for the end of September 2006, and code name will be "Sonic". Sonic will include a smart mailing-list filter and a better "leave message on server" option. I implemented years ago an auto-filtering system in AppleScript. The filtering engine used the RFC2369 and some other tricks to detect yahoo mailing list. Sonic will have also an auto-filter for google mailing list too.

The leave message on server option is quite bad now. It creates a lot of duplicated messages.
The new implementation will avoid dowloading twice a message, using a mix of messageId and timestamp to detect duplicated messages.

Read More