Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old November 23rd, 2005, 02:22 AM
Bernd Buldt
Guest
 
Posts: n/a
Default 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

  #2  
Old November 23rd, 2005, 02:22 AM
Richard Huxton
Guest
 
Posts: n/a
Default Re: newby question

Bernd Buldt wrote:[color=blue]
> 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[/color]

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

  #3  
Old November 23rd, 2005, 02:22 AM
Kevin Barnard
Guest
 
Posts: n/a
Default Re: newby question

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@archonet.com> wrote:[color=blue]
> Bernd Buldt wrote:[color=green]
> > 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[/color]
>
> 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
>[/color]

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

  #4  
Old November 23rd, 2005, 02:22 AM
Scott Frankel
Guest
 
Posts: n/a
Default Re: newby question


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:
[color=blue]
> 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@archonet.com>
> wrote:[color=green]
>> Bernd Buldt wrote:[color=darkred]
>>> 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[/color]
>>
>> 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
>>[/color]
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>[/color]


---------------------------(end of broadcast)---------------------------
TIP 3: 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

  #5  
Old November 23rd, 2005, 02:22 AM
Doug McNaught
Guest
 
Posts: n/a
Default Re: newby question

Scott Frankel <leknarf@pacbell.net> writes:
[color=blue]
> 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.[/color]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

  #6  
Old November 23rd, 2005, 02:22 AM
Scott Frankel
Guest
 
Posts: n/a
Default Re: newby question


Good to know ...
Scott


On Oct 1, 2004, at 9:08 AM, Doug McNaught wrote:
[color=blue]
> Scott Frankel <leknarf@pacbell.net> writes:
>[color=green]
>> 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.[/color]
>
> 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
>[/color]


---------------------------(end of broadcast)---------------------------
TIP 3: 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

 

Bookmarks

Thread Tools

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

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles