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