Unix Technical Forum

Wordpress & PostgreSQL ...

This is a discussion on Wordpress & PostgreSQL ... within the Pgsql General forums, part of the PostgreSQL category; --> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Does anyone know of any work being done to get wordpress ported to ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql General

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-09-2008, 12:00 PM
Marc G. Fournier
 
Posts: n/a
Default Wordpress & PostgreSQL ...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Does anyone know of any work being done to get wordpress ported to PostgreSQL?
My search on the web finds emails from March of this year concerning some ppl
more or less "looking into it", but I can't find anything that indicates
they've done much more then talk

- ----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org MSN . scrappy@hub.org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (FreeBSD)

iD8DBQFFOqYQ4QvfyHIvDvMRAtQQAKDdK32B/1d0oc2gJSzFrcsnbGSZewCgm8+6
OIP3fgkNBDQiBhR+kI0TwYI=
=6+Vn
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-09-2008, 12:00 PM
Joshua D. Drake
 
Posts: n/a
Default Re: Wordpress & PostgreSQL ...

Marc G. Fournier wrote:
>
> Does anyone know of any work being done to get wordpress ported to PostgreSQL?
> My search on the web finds emails from March of this year concerning some ppl
> more or less "looking into it", but I can't find anything that indicates
> they've done much more then talk


There was an experimental patch at one time. However the devs don't
really have much interest in PostgreSQL AFAICT.

Joshua D. Drake


>
> ----
> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
> Email . scrappy@hub.org MSN . scrappy@hub.org
> Yahoo . yscrappy Skype: hub.org ICQ . 7615664


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend



--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-09-2008, 12:00 PM
Marc G. Fournier
 
Posts: n/a
Default Re: Wordpress & PostgreSQL ...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Ya, I found the wordpress-pg.sourceforge.org project, but that was for 1.2 ...
major old

I have one client running Blogsom w/ PostgreSQL that works well, but a whack
running MySQL that I'd love nothing more then to get off of it If we ever
have performance problems on our servers, the "fix" is usually (and I mean
99.9% of the time) to restart the mysql processes *sigh*


- --On Saturday, October 21, 2006 20:07:02 -0700 "Joshua D. Drake"
<jd@commandprompt.com> wrote:

> Marc G. Fournier wrote:
>>
>> Does anyone know of any work being done to get wordpress ported to
>> PostgreSQL? My search on the web finds emails from March of this year
>> concerning some ppl more or less "looking into it", but I can't find
>> anything that indicates they've done much more then talk

>
> There was an experimental patch at one time. However the devs don't
> really have much interest in PostgreSQL AFAICT.
>
> Joshua D. Drake
>
>
>>
>> ----
>> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
>> Email . scrappy@hub.org MSN . scrappy@hub.org
>> Yahoo . yscrappy Skype: hub.org ICQ . 7615664

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
>
> --
>
> === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
> Providing the most comprehensive PostgreSQL solutions since 1997
> http://www.commandprompt.com/
>
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
>




- ----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org MSN . scrappy@hub.org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (FreeBSD)

iD8DBQFFOuYV4QvfyHIvDvMRAn2DAKCE1mh1N7Hq/m173zCVgnO2l9nDMQCgwy/X
OoODuGEoMKzkLxkSSkl9pe0=
=id8U
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-09-2008, 12:00 PM
Christopher Browne
 
Posts: n/a
Default Re: Wordpress & PostgreSQL ...

jd@commandprompt.com ("Joshua D. Drake") wrote:
> Marc G. Fournier wrote:
>>
>> Does anyone know of any work being done to get wordpress ported to PostgreSQL?
>> My search on the web finds emails from March of this year concerning some ppl
>> more or less "looking into it", but I can't find anything that indicates
>> they've done much more then talk

>
> There was an experimental patch at one time. However the devs don't
> really have much interest in PostgreSQL AFAICT.


And it seems to me that you could get a *wildly* better blog design by
making an expressly PostgreSQL-oriented design.

Consider:
a) Mapping things like Wiki-style special indicators of formatting
(e.g. - where indentation / * means something) onto some "final form"
using stored procs written in pl/[text-munging-language]

b) Managing the various sorts of objects (users, entries, links to
local entries, links to outside entries) using a stored function API
so that what's visible in the outside language (Perl CGI or whatever)
becomes fairly trivial

c) Allowing the use of intelligent data types. Self-compressing
TOAST, strongly typed URLs, strongly typed and validated email
addresses, all of that sort of thing.
--
(format nil "~S@~S" "cbbrowne" "gmail.com")
http://linuxfinances.info/info/slony.html
I am not a Church numeral!
I am a free variable!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-09-2008, 12:01 PM
=?iso-8859-15?q?Herv=E9_Piedvache?=
 
Posts: n/a
Default Re: Wordpress & PostgreSQL ...

Marc,

We are working on making the port to PostgreSQL ... may be for the end of this
month.
We have wrote to the Wordpress team ... but without any answer for the
moment ... (
When it'll be ready from our part, I'll inform you.

Best regards,

Le dimanche 22 octobre 2006 00:58, Marc G. Fournier a écrit :
> Does anyone know of any work being done to get wordpress ported to
> PostgreSQL? My search on the web finds emails from March of this year
> concerning some ppl more or less "looking into it", but I can't find
> anything that indicates they've done much more then talk
>
> ----
> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
> Email . scrappy@hub.org MSN . scrappy@hub.org
> Yahoo . yscrappy Skype: hub.org ICQ . 7615664
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend


--
Hervé Piedvache

Elma Ingénierie Informatique
Groupe Maximiles S.A.
3 rue d'Uzès
F-75002 - Paris - France
Pho. 33-144949901
Fax. 33-144882747

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-09-2008, 12:03 PM
Robert Treat
 
Posts: n/a
Default Re: Wordpress & PostgreSQL ...

the wordpress guys have basically said they do not want to support postgres,
which is mainly why we swapped to s9y on planetpg. you can read some more
info here:
http://people.planetpostgresql.org/x...Good-Port.html

Robert Treat

On Saturday 21 October 2006 23:31, Marc G. Fournier wrote:
> Ya, I found the wordpress-pg.sourceforge.org project, but that was for 1.2
> ... major old
>
> I have one client running Blogsom w/ PostgreSQL that works well, but a
> whack running MySQL that I'd love nothing more then to get off of it If
> we ever have performance problems on our servers, the "fix" is usually (and
> I mean 99.9% of the time) to restart the mysql processes *sigh*
>
>
> --On Saturday, October 21, 2006 20:07:02 -0700 "Joshua D. Drake"
>
> <jd@commandprompt.com> wrote:
> > Marc G. Fournier wrote:
> >> Does anyone know of any work being done to get wordpress ported to
> >> PostgreSQL? My search on the web finds emails from March of this year
> >> concerning some ppl more or less "looking into it", but I can't find
> >> anything that indicates they've done much more then talk

> >
> > There was an experimental patch at one time. However the devs don't
> > really have much interest in PostgreSQL AFAICT.
> >
> > Joshua D. Drake
> >
> >> ----
> >> Marc G. Fournier Hub.Org Networking Services
> >> (http://www.hub.org) Email . scrappy@hub.org
> >> MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org
> >> ICQ . 7615664

> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend
> >
> >
> >
> > --
> >
> > === The PostgreSQL Company: Command Prompt, Inc. ===
> > Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
> > Providing the most comprehensive PostgreSQL solutions since 1997
> > http://www.commandprompt.com/
> >
> > Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

>
> ----
> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
> Email . scrappy@hub.org MSN . scrappy@hub.org
> Yahoo . yscrappy Skype: hub.org ICQ . 7615664
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match


--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:35 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com