Re: 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(at)hub(dot)org MSN . scrappy(at)hub(dot)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-----

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(at)hub(dot)org MSN . scrappy(at)hub(dot)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

-----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(at)commandprompt(dot)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(at)hub(dot)org MSN . scrappy(at)hub(dot)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(at)hub(dot)org MSN . scrappy(at)hub(dot)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-----

jd(at)commandprompt(dot)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(at)~S" "cbbrowne" "gmail.com")
http://linuxfinances.info/info/slony.html
I am not a Church numeral!
I am a free variable!

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 ... :o(
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(at)hub(dot)org MSN . scrappy(at)hub(dot)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

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/xzilla/index.php?/archives/13-One-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(at)commandprompt(dot)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(at)hub(dot)org
> >> MSN . scrappy(at)hub(dot)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(at)hub(dot)org MSN . scrappy(at)hub(dot)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

On 10/26/06, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> wrote:
> 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/xzilla/index.php?/archives/13-One-Good-Port.html

Suppose one would like to create a WordPress workalike, i.e. a blogging
engine sharing look&feel of WordPress but written from scratch. What
language/framework do you think would be the best?

I mean -- one could code that in PHP and simply use PostgreSQL, but
PHP is probably the most popular language, but I don't think it's the best.

Ruby on Rails perhaps? I have not written a single line in Ruby, but
I've read on the list here that it has very good PostgreSQL interface...

Python? Perl? Something different?

The reason I'm asking this question is that I would like to hear personal
experiences with alternative to PHP environments, how do they "feel",
how do they scale, in order to boost my knowledge a bit.

Regards,
Dawid

Dawid Kuroczko wrote:
> Suppose one would like to create a WordPress workalike, i.e. a blogging
> engine sharing look&feel of WordPress but written from scratch. What
> language/framework do you think would be the best?

Try Squeak/Seaside (www.seaside.st). The continuation stuff
is optional, you can use it just for the great development
environment, html generation framework, fairly decent VM
(or very speeding commercial VM available via Cincom Smalltalk),
and a bunch of other reasons.

On Oct 29, 2006, at 10:00 pm, Dawid Kuroczko wrote:
> Ruby on Rails perhaps? I have not written a single line in Ruby, but
> I've read on the list here that it has very good PostgreSQL
> interface...

Dawid,

The Rails postgres adapter works great. In fact, by and large you
don't need to care about which DBMS you are running on because
ActiveRecord is a good abstraction layer (the code for each database
adapter is not that huge). Rails users seem to have less of a MySQL
bias than PHP users. Arguably that's because Ruby and Rails share
more of the design philosophy of Postgres, whereas PHP's design
rigour seems to be inspired by MySQL.

If you are interested in Rails-based blogging engines, check out
Mephisto ( http://www.mephistoblog.com/ ), which seems to be the best.

Ashley

Dawid Kuroczko wrote:
> On 10/26/06, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> wrote:
>> 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/xzilla/index.php?/archives/13-One-Good-Port.html
>>
>
> Suppose one would like to create a WordPress workalike, i.e. a blogging
> engine sharing look&feel of WordPress but written from scratch. What
> language/framework do you think would be the best?
>
> I mean -- one could code that in PHP and simply use PostgreSQL, but
> PHP is probably the most popular language, but I don't think it's the
> best.
>
> Ruby on Rails perhaps? I have not written a single line in Ruby, but
> I've read on the list here that it has very good PostgreSQL interface...
>
> Python? Perl? Something different?
>
> The reason I'm asking this question is that I would like to hear personal
> experiences with alternative to PHP environments, how do they "feel",
> how do they scale, in order to boost my knowledge a bit.
If you want a mature alternative to PHP then take a look at Whitebeam
(http://www.whitebeam.org). This uses the Mozilla 'Spidermonkey'
JavaScript engine for server-side JS and uses Postgres as the back-end
database. At the moment it doesn't interface with any other databases -
but then not really much of a need :-)

I've used Whitebeam for my own blogging software as well other
communications functions (newsletters, discussion forums, e-zines,
e-commerce and I know others that have used the Postgres Interface for
some equally sophisticated applications. Take a look at
http://www.gadgetspeak.com as an example of what's possible. That latest
release of Spidermonkey even gives you a native 'XML' type so you can do
things like:
var myDoc = <doc><title>my title</title></doc>

Brilliant for putting together things like RSS feeds and for
implementing the SOAP/ XML-RPC blogging APIs

Pete
> Regards,
> Dawid
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
------------------------------------------------------------------------
Peter Wilson
T: 01414 160505
M: 07796 656566
http://www.yellowhawk.co.uk The information in this email is
confidential and is intended for the addressee/s only. Access to this
email by anyone else is unauthorised. If you are not the intended
recipient, you must not read, use or disseminate the information
contained in or attached to this email.

On 10/30/06, Ashley Moran <work(at)ashleymoran(dot)me(dot)uk> wrote:
> Arguably that's because Ruby and Rails share
> more of the design philosophy of Postgres, whereas PHP's design
> rigour seems to be inspired by MySQL.

Could you please give some example of such "inspired by MySQL features
of PHP design"?

--
Best regards,
Nikolay

Nikolay Samokhvalov wrote:
> On 10/30/06, Ashley Moran <work(at)ashleymoran(dot)me(dot)uk> wrote:
>> Arguably that's because Ruby and Rails share
>> more of the design philosophy of Postgres, whereas PHP's design
>> rigour seems to be inspired by MySQL.
>
> Could you please give some example of such "inspired by MySQL features
> of PHP design"?
>

Speed, simple to use..

A huge thing is also that mysql support was originally built into php by
default (way back in v3 at least, not sure how far back it went), a lot
of people didn't realise other databases worked with php, or didn't want
to use other databases. No other languages took that particular approach
(that I'm aware of, I'm sure I'll be informed if I'm incorrect).

So it became the "standard" by default.

Plus most hosts only set up php / mysql and not postgres (or other
db's), though I'm sure that's changing.

--
Postgresql & php tutorials
http://www.designmagick.com/

On 30 Oct 2006, at 06:15, Nikolay Samokhvalov wrote:

> Could you please give some example of such "inspired by MySQL features
> of PHP design"?

Sorry... perhaps I should have wrapped my comment in <sarcasm
bitterness="10"/> </sarcarsm> to make it more clear what I meant. I
didn't mean that MySQL literally inspired features of PHP (maybe it
did?) - just that the <sarcasm bitterness="10"/>clean, elegant nature
of PHP seems taken from MySQL</sarcarsm>.

Ashley

On Monday 30. October 2006 10:31, Ashley Moran wrote:
>On 30 Oct 2006, at 06:15, Nikolay Samokhvalov wrote:
>> Could you please give some example of such "inspired by MySQL
>> features of PHP design"?
>
>Sorry... perhaps I should have wrapped my comment in <sarcasm
>bitterness="10"/> </sarcarsm> to make it more clear what I meant. I
>didn't mean that MySQL literally inspired features of PHP (maybe it
>did?) - just that the <sarcasm bitterness="10"/>clean, elegant nature
>of PHP seems taken from MySQL</sarcarsm>.

I don't find it particularly hard to write clean code in PHP. But then,
most of my PHP codebase involves two inbuilt functions: pg_query() and
echo. The more PHP code I write, the more do I find that almost all of
it can be reduced to those two commands. But of course, I write a lot
of wrappers and abstractions on top of it.

I do most of my internal database logic as views and functions in
PostgreSQL, which can be easily interfaced with some very innocent
looking queries from PHP.

Writing PHP to interface with (at least pre-5.0) MySQL is quite another
matter, because you have to incorporate so much of the db logic in PHP.
I won't touch that combination again if it can be helped.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE

On 10/30/06, Ashley Moran <work(at)ashleymoran(dot)me(dot)uk> wrote:
> ... <sarcasm bitterness="10"/>clean, elegant nature
> of PHP seems taken from MySQL</sarcarsm>.
>
> Ashley
>

XML parsing failed (2 errors) :-)

--
Best regards,
Nikolay