pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedOpen source project using php PostgreSQL functions?
6+ messages / 4 participants
[nested] [flat]
* Open source project using php PostgreSQL functions?
@ 2013-11-21 16:43 Jeff Ross <jross@wykids.org>
0 siblings, 3 replies; 6+ messages in thread
From: Jeff Ross @ 2013-11-21 16:43 UTC (permalink / raw)
To: pgsql-php
Hi all,
I'm looking at moving some code away from the long deprecated PEAR::DB
but I want to move to the standard php Postgresql functions and not
another database abstraction layer like MDB2 or ADODB or even PDO. This
specific project will never use anything but PostgreSQL as its database.
Does anyone know of an open source php based project that I might look
through to see some sample code a little more complex than the examples
in the php documentation?
Thanks,
Jeff Ross
--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Open source project using php PostgreSQL functions?
@ 2013-11-21 17:06 Vincent <vinny@xs4all.nl>
parent: Jeff Ross <jross@wykids.org>
2 siblings, 0 replies; 6+ messages in thread
From: Vincent @ 2013-11-21 17:06 UTC (permalink / raw)
To: pgsql-php
On 21-11-13 17:43, Jeff Ross wrote:
> Hi all,
>
> I'm looking at moving some code away from the long deprecated PEAR::DB
> but I want to move to the standard php Postgresql functions and not
> another database abstraction layer like MDB2 or ADODB or even PDO.
> This specific project will never use anything but PostgreSQL as its
> database.
>
> Does anyone know of an open source php based project that I might look
> through to see some sample code a little more complex than the
> examples in the php documentation?
>
> Thanks,
>
> Jeff Ross
>
>
>
PDO is pretty much standard PHP these days, allthough I don't like it
much myself.
Why not write a simple class that does the database access for you? All
you really need is a method that
executes the query and either returns the result or throws an exception
when something goes wrong.
Anything ready-made is going to be a DAL, because that's what works best
and it's easier to maintain.
--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Open source project using php PostgreSQL functions?
@ 2013-11-21 17:52 Guillaume Lelarge <guillaume@lelarge.info>
parent: Jeff Ross <jross@wykids.org>
2 siblings, 1 reply; 6+ messages in thread
From: Guillaume Lelarge @ 2013-11-21 17:52 UTC (permalink / raw)
To: Jeff Ross <jross@wykids.org>; +Cc: pgsql-php
On Thu, 2013-11-21 at 09:43 -0700, Jeff Ross wrote:
> Hi all,
>
> I'm looking at moving some code away from the long deprecated PEAR::DB
> but I want to move to the standard php Postgresql functions and not
> another database abstraction layer like MDB2 or ADODB or even PDO. This
> specific project will never use anything but PostgreSQL as its database.
>
> Does anyone know of an open source php based project that I might look
> through to see some sample code a little more complex than the examples
> in the php documentation?
>
You should try POMM: http://pomm.coolkeums.org/
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Open source project using php PostgreSQL functions?
@ 2013-11-21 21:10 Jeff Ross <jross@wykids.org>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 6+ messages in thread
From: Jeff Ross @ 2013-11-21 21:10 UTC (permalink / raw)
To: pgsql-php
On 11/21/13, 10:52 AM, Guillaume Lelarge wrote:
> On Thu, 2013-11-21 at 09:43 -0700, Jeff Ross wrote:
>> Hi all,
>>
>> I'm looking at moving some code away from the long deprecated PEAR::DB
>> but I want to move to the standard php Postgresql functions and not
>> another database abstraction layer like MDB2 or ADODB or even PDO. This
>> specific project will never use anything but PostgreSQL as its database.
>>
>> Does anyone know of an open source php based project that I might look
>> through to see some sample code a little more complex than the examples
>> in the php documentation?
>>
> You should try POMM: http://pomm.coolkeums.org/
>
>
Nice--I'll take a look at that.
Thanks!
--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Open source project using php PostgreSQL functions?
@ 2013-11-22 17:57 John DeSoi <desoi@pgedit.com>
parent: Jeff Ross <jross@wykids.org>
2 siblings, 1 reply; 6+ messages in thread
From: John DeSoi @ 2013-11-22 17:57 UTC (permalink / raw)
To: Jeff Ross <jross@wykids.org>; +Cc: pgsql-php
On Nov 21, 2013, at 10:43 AM, Jeff Ross <jross@wykids.org> wrote:
> Does anyone know of an open source php based project that I might look through to see some sample code a little more complex than the examples in the php documentation?
Not a project, but this is a simple abstraction that allows you to call Postgres functions as if they were PHP methods.
http://pgedit.com/resource/php/pgfuncall
John DeSoi, Ph.D.
--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Open source project using php PostgreSQL functions?
@ 2013-11-22 21:21 Jeff Ross <jross@wykids.org>
parent: John DeSoi <desoi@pgedit.com>
0 siblings, 0 replies; 6+ messages in thread
From: Jeff Ross @ 2013-11-22 21:21 UTC (permalink / raw)
To: John DeSoi <desoi@pgedit.com>; +Cc: pgsql-php
On 11/22/13, 10:57 AM, John DeSoi wrote:
> On Nov 21, 2013, at 10:43 AM, Jeff Ross <jross@wykids.org> wrote:
>
>> Does anyone know of an open source php based project that I might look through to see some sample code a little more complex than the examples in the php documentation?
> Not a project, but this is a simple abstraction that allows you to call Postgres functions as if they were PHP methods.
>
>
> http://pgedit.com/resource/php/pgfuncall
>
>
> John DeSoi, Ph.D.
>
Very interesting--thanks! I'll have to also look at the TextMate editor.
Jeff
--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2013-11-22 21:21 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-11-21 16:43 Open source project using php PostgreSQL functions? Jeff Ross <jross@wykids.org>
2013-11-21 17:06 ` Vincent <vinny@xs4all.nl>
2013-11-21 17:52 ` Guillaume Lelarge <guillaume@lelarge.info>
2013-11-21 21:10 ` Jeff Ross <jross@wykids.org>
2013-11-22 17:57 ` John DeSoi <desoi@pgedit.com>
2013-11-22 21:21 ` Jeff Ross <jross@wykids.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox