Archive for September, 2006

Upgrade your PostgreSQL databases to UNICODE

Monday, September 25th, 2006

Upgrade your PostgreSQL databases to UNICODE

A Week in the Valley: Hyperic

Monday, September 25th, 2006

O’Reilly Radar > A Week in the Valley: Hyperic

Awstats with virtual hosts on Apache

Sunday, September 24th, 2006

dotvoid.com - Awstats with virtual hosts on Apache

Un bon petit coup de main pour installer et automatiser AWStats avec des virtual hosts.

Lenteurs inexpliquées sur des insert

Thursday, September 21st, 2006

Lenteurs inexpliquées sur des insert.

je ne suis donc pas le seul a avoir des soucis .. ca me rassure je me pensais seul au monnnnnndeeeeeeeeeeeee :D

merci Shasha pour le thread !

Postgres : Terminating Idle Connections

Thursday, September 21st, 2006

Terminating Idle Connections

oui … que faire ? :)

How to optimize PostgreSQL database size

Wednesday, September 20th, 2006

How to optimize PostgreSQL database size | linux.inet.hr

c’est parti pour un dump/restore !

Buy.com Web Services - Where?

Wednesday, September 20th, 2006

Next Generation Shopping » Buy.com Web Services - Where?

PostgreSQL function (PL/pgSQL) to validate UPC (EAN) barcode

Wednesday, September 20th, 2006

PostgreSQL function (PL/pgSQL) to validate UPC (EAN) barcode - O’Reilly ONLamp Blog

CREATE OR REPLACE FUNCTION valid_barcode(barcode text) RETURNS boolean AS $function$ DECLARE b text; odd int; even int; s int; BEGIN IF barcode IS NULL THEN return NULL; END IF; IF LENGTH(barcode) < 12 OR LENGTH(barcode) > 13 THEN return false; END IF; — normalize UPC and EAN to both be 13 digits IF LENGTH(barcode) = 12 THEN b = ‘0′ || barcode; ELSE b = barcode; END IF; — sum of odd digits times 3, plus sum of even digits even = CAST(SUBSTR(b, 1, 1) AS int) CAST(SUBSTR(b, 3, 1) AS int) CAST(SUBSTR(b, 5, 1) AS int) CAST(SUBSTR(b, 7, 1) AS int) CAST(SUBSTR(b, 9, 1) AS int) CAST(SUBSTR(b, 11, 1) AS int); odd = CAST(SUBSTR(b, 2, 1) AS int) CAST(SUBSTR(b, 4, 1) AS int) CAST(SUBSTR(b, 6, 1) AS int) CAST(SUBSTR(b, 8, 1) AS int) CAST(SUBSTR(b, 10, 1) AS int) CAST(SUBSTR(b, 12, 1) AS int); s = (3 * odd) even; — remainder to nearest 10 should be same as last check digit IF (CAST((CEIL(CAST(s AS float8) / 10) * 10) AS int) % s) = CAST(SUBSTR(b, 13, 1) AS int) THEN return true; ELSE return false; END IF; END; $function$ LANGUAGE plpgsql;

i4giveu

Sunday, September 17th, 2006

Techcrunch

Use Gmail Generate Unlimited E-mail Addresses

Thursday, September 7th, 2006

Use Gmail Generate Unlimited E-mail Addresses - Modern Day Alchemist