Thread: 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-----
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
-----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-----
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!
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@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
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@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
On 10/26/06, Robert Treat <xzilla@users.sourceforge.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.
Dawid Kuroczko wrote:
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
On 10/26/06, Robert Treat <xzilla@users.sourceforge.net> wrote: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 :-)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.
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 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
On 10/30/06, Ashley Moran <work@ashleymoran.me.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@ashleymoran.me.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@ashleymoran.me.uk> wrote: > ... <sarcasm bitterness="10"/>clean, elegant nature > of PHP seems taken from MySQL</sarcarsm>. > > Ashley > XML parsing failed (2 errors) :-) -- Best regards, Nikolay