By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

newby question

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Nov 23 '05 #2

P: n/a
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 <de*@archonet.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

Nov 23 '05 #3

P: n/a

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 <de*@archonet.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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #4

P: n/a
Scott Frankel <le*****@pacbell.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

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

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

Nov 23 '05 #5

P: n/a

Good to know ...
Scott
On Oct 1, 2004, at 9:08 AM, Doug McNaught wrote:
Scott Frankel <le*****@pacbell.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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.