Re: newby question

Howdy! I'd like to set up a database (mostly a bibliography), which
I'd like to connect to a webpage such that simple queries to the
database can be made by visitors of my homepage. I seem to remember
that FileMaker allows for this, but I'd prefer a UNIX-based solution
(under MacOS X). Hence my question (before I start digging): Can
anyone on the list confirm that this is doable (w/o too much hassles
) with PostGresQL? Thx for your time! Best, Bernd

Bernd Buldt wrote:
> Howdy! I'd like to set up a database (mostly a bibliography), which
> I'd like to connect to a webpage such that simple queries to the
> database can be made by visitors of my homepage. I seem to remember
> that FileMaker allows for this, but I'd prefer a UNIX-based solution
> (under MacOS X). Hence my question (before I start digging): Can
> anyone on the list confirm that this is doable (w/o too much hassles )
> with PostGresQL? Thx for your time! Best, Bernd

Can't say I've done it with MacOS-X, but Apache+PHP+PostgreSQL are a
common combination. Worth checking sourforge.net / freshmeat.net and see
if there are any projects doing what you want before starting your own
though.

--
Richard Huxton
Archonet Ltd

Apache/PHP are already prebuilt on Mac OS X. All you need to do is
donwload the postgres tarball config and compile.

Small notte on the compile. When you compile postgres either turn off
readline support or download readline from GNU and compile the static
lib.

I don't remember off hand but I think an older version of Postgres is
compiled into the standard Mac PHP. If not it is fairly easy to
recomiple PHP on the Mac. If you have any further questions about
compiling ask I can walk you though it if you need.

On Fri, 01 Oct 2004 11:45:18 +0100, Richard Huxton <dev(at)archonet(dot)com> wrote:
> Bernd Buldt wrote:
> > Howdy! I'd like to set up a database (mostly a bibliography), which
> > I'd like to connect to a webpage such that simple queries to the
> > database can be made by visitors of my homepage. I seem to remember
> > that FileMaker allows for this, but I'd prefer a UNIX-based solution
> > (under MacOS X). Hence my question (before I start digging): Can
> > anyone on the list confirm that this is doable (w/o too much hassles )
> > with PostGresQL? Thx for your time! Best, Bernd
>
> Can't say I've done it with MacOS-X, but Apache+PHP+PostgreSQL are a
> common combination. Worth checking sourforge.net / freshmeat.net and see
> if there are any projects doing what you want before starting your own
> though.
>
> --
> Richard Huxton
> Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

Additional note: configure warned of an old version of bison when I
attempted an install of postgresql7.4.5 the other day. Seems the
version
that comes with OSX 10.3.x is too old for postgres.

Only trick I encountered in installing bison from tarball was locating
the
install product in /usr/local/bin and copying it to /usr/bin (either
because
that's where postgres wants to find it, or because my path does not
include
/usr/local).

Scott

On Oct 1, 2004, at 7:26 AM, Kevin Barnard wrote:

> Apache/PHP are already prebuilt on Mac OS X. All you need to do is
> donwload the postgres tarball config and compile.
>
> Small notte on the compile. When you compile postgres either turn off
> readline support or download readline from GNU and compile the static
> lib.
>
> I don't remember off hand but I think an older version of Postgres is
> compiled into the standard Mac PHP. If not it is fairly easy to
> recomiple PHP on the Mac. If you have any further questions about
> compiling ask I can walk you though it if you need.
>
>
> On Fri, 01 Oct 2004 11:45:18 +0100, Richard Huxton <dev(at)archonet(dot)com>
> wrote:
>> Bernd Buldt wrote:
>>> Howdy! I'd like to set up a database (mostly a bibliography), which
>>> I'd like to connect to a webpage such that simple queries to the
>>> database can be made by visitors of my homepage. I seem to remember
>>> that FileMaker allows for this, but I'd prefer a UNIX-based solution
>>> (under MacOS X). Hence my question (before I start digging): Can
>>> anyone on the list confirm that this is doable (w/o too much hassles
>>> )
>>> with PostGresQL? Thx for your time! Best, Bernd
>>
>> Can't say I've done it with MacOS-X, but Apache+PHP+PostgreSQL are a
>> common combination. Worth checking sourforge.net / freshmeat.net and
>> see
>> if there are any projects doing what you want before starting your own
>> though.
>>
>> --
>> Richard Huxton
>> Archonet Ltd
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faqs/FAQ.html
>>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

Scott Frankel <leknarf(at)pacbell(dot)net> writes:

> Additional note: configure warned of an old version of bison when I
> attempted an install of postgresql7.4.5 the other day. Seems the
> version
> that comes with OSX 10.3.x is too old for postgres.

You only actually need Bison if you are building from CVS--the release
tarballs are pre-Bisonated, so you can ignore that warning. :)

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

Good to know ...
Scott

On Oct 1, 2004, at 9:08 AM, Doug McNaught wrote:

> Scott Frankel <leknarf(at)pacbell(dot)net> writes:
>
>> Additional note: configure warned of an old version of bison when I
>> attempted an install of postgresql7.4.5 the other day. Seems the
>> version
>> that comes with OSX 10.3.x is too old for postgres.
>
> You only actually need Bison if you are building from CVS--the release
> tarballs are pre-Bisonated, so you can ignore that warning. :)
>
> -Doug
> --
> Let us cross over the river, and rest under the shade of the trees.
> --T. J. Jackson, 1863
>