Thread: Slashdot and PostgreSQL

Slashdot and PostgreSQL

From
Bruce Momjian
Date:
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

Re: Slashdot and PostgreSQL

From
Hunter Hillegas
Date:
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
>


Re: Slashdot and PostgreSQL

From
Bruce Momjian
Date:
> 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

Re: Slashdot and PostgreSQL

From
Alessio Bragadini
Date:
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

Re: Slashdot and PostgreSQL

From
"Robert B. Easter"
Date:
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/ ------------

Re: Slashdot and PostgreSQL

From
Giulio Orsero
Date:
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