I see on Slashdot that:

  Slashcode 2.0 ("Bender") is officially in beta. We now have themes,
  plugins, an abstacted database layer (MySQL support is beta, PostreSQL
  is alpha, so finally the rivalry can be settled ;) 

So, while Sourceforge has moved to PostgreSQL, seems like Slashdot may
well too.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 16 Jan 2001 21:54:37 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Slashdot and PostgreSQL
I don't think they're moving the actual Slashdot site to PostgreSQL... They
paid a bunch of money to the mySQL folks to add replication support to
mySQL...

I think other sites based on Slashcode wanted to be able to use PostgreSQL
though...

Hunter

> From: Bruce Momjian <pgman@candle.pha.pa.us>
> Date: Tue, 16 Jan 2001 21:54:37 -0500 (EST)
> To: PostgreSQL-general <pgsql-general@postgresql.org>
> Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
> Subject: [GENERAL] Slashdot and PostgreSQL
> 
> I see on Slashdot that:
> 
> Slashcode 2.0 ("Bender") is officially in beta. We now have themes,
> plugins, an abstacted database layer (MySQL support is beta, PostreSQL
> is alpha, so finally the rivalry can be settled ;)
> 
> So, while Sourceforge has moved to PostgreSQL, seems like Slashdot may
> well too.
> 
> -- 
> Bruce Momjian                        |  http://candle.pha.pa.us
> pgman@candle.pha.pa.us               |  (610) 853-3000
> +  If your life is a hard drive,     |  830 Blythe Avenue
> +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 


Tue, 16 Jan 2001 19:03:57 -0800
Hunter Hillegas <hunter@lastonepicked.com>
Re: Slashdot and PostgreSQL
> I don't think they're moving the actual Slashdot site to PostgreSQL... They
> paid a bunch of money to the mySQL folks to add replication support to
> mySQL...
> 
> I think other sites based on Slashcode wanted to be able to use PostgreSQL
> though...

You are probably correct, but I never expected Sourceforge to move to
PostgreSQL either.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 16 Jan 2001 22:08:14 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Slashdot and PostgreSQL
Hunter Hillegas wrote:

> I don't think they're moving the actual Slashdot site to PostgreSQL...

So do I.

> I think other sites based on Slashcode wanted to be able to use PostgreSQL
> though...

That's what I will do as soon as possible, and I am trying to be
involved as much as possible in the current development. I am also
waiting for 7.1 to have a cleaner environment to test it.

-- 
Alessio F. Bragadini		alessio@albourne.com
APL Financial Services		http://village.albourne.com
Nicosia, Cyprus		 	phone: +357-2-755750

"It is more complicated than you think"
		-- The Eighth Networking Truth from RFC 1925

Wed, 17 Jan 2001 09:53:35 +0200
Alessio Bragadini <alessio@albourne.com>
Re: Slashdot and PostgreSQL
On Wednesday 17 January 2001 02:53, Alessio Bragadini wrote:
> Hunter Hillegas wrote:
> > I don't think they're moving the actual Slashdot site to PostgreSQL...
>
> So do I.
>
> > I think other sites based on Slashcode wanted to be able to use
> > PostgreSQL though...
>
> That's what I will do as soon as possible, and I am trying to be
> involved as much as possible in the current development. I am also
> waiting for 7.1 to have a cleaner environment to test it.

I made a board with php and postgresql. It's *terrible* code but is working 
at www.comptechnews.com.  If anyone is interested in playing with it, I can 
make it available.  Who knows, the code might have bugs that are very 
compromising! :)  People might like to improve it. It consists of one php 
file and three sql files (tables, data, & procedures).  It uses PL/pgSQL and 
PL/TcL.  You just run the tables sql, load data, then run procedures sql.  
Put the php file in a directory and change the pg_pconnect line to connect to 
the right db.  The php file is 3638 lines.  It tries fairly hard to be 
automatically moderated and to have good protection from users trying to do 
bad things.  Code in the php and in the trigger procs provide two layers of 
logic that tries to ensure only correct things happen.  It takes good 
advantage of transactions.  The RAISE EXCEPTION PL/pgSQL call is used to 
rollback/abort things that shouldn't happen ... stuff like that.  The trigger 
procs do recursive stuff to manage the threaded messages and topics. Again 
the php code is an embarrassment, but I don't care! :)


-- 
-------- Robert B. Easter  reaster@comptechnews.com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------

Wed, 17 Jan 2001 16:46:57 -0500
"Robert B. Easter" <reaster@comptechnews.com>
Re: Slashdot and PostgreSQL
On Tue, 16 Jan 2001 21:54:37 -0500 (EST), you wrote:

>So, while Sourceforge has moved to PostgreSQL, seems like Slashdot may
>well too.

Please, ask sourceforge to correct this web page
http://sourceforge.net/docman/display_doc.php?docid=755&group_id=1

:-)

-- 
giulioo@pobox.com

Fri, 19 Jan 2001 20:52:16 +0100
Giulio Orsero <giulioo@pobox.com>
Re: Slashdot and PostgreSQL