Upgrade your PostgreSQL databases to UNICODE

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

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.

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 !

Terminating Idle Connections

oui … que faire ? :)

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

c’est parti pour un dump/restore !

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

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;

Techcrunch

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