Thread: 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
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
>
> 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
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
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/ ------------
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