From owner-freebsd-questions Wed Sep 2 13:09:41 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id NAA24811 for freebsd-questions-outgoing; Wed, 2 Sep 1998 13:09:41 -0700 (PDT) (envelope-from owner-freebsd-questions@FreeBSD.ORG) Received: from witch.xtra.co.nz (witch.xtra.co.nz [202.27.184.8]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id NAA24805 for ; Wed, 2 Sep 1998 13:09:35 -0700 (PDT) (envelope-from junkmale@pop3.xtra.co.nz) Received: from wocker (210-55-210-87.ipnets.xtra.co.nz [210.55.210.87]) by witch.xtra.co.nz (8.9.1/8.9.1) with SMTP id IAA20834; Thu, 3 Sep 1998 08:08:25 +1200 (NZST) Message-Id: <199809022008.IAA20834@witch.xtra.co.nz> From: "Dan Langille" Organization: DVL Software Limited To: David Chamberlain Date: Thu, 3 Sep 1998 08:08:26 +1200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: FreeBSD, Apache and databases Reply-to: junkmale@xtra.co.nz CC: freebsd-questions@FreeBSD.ORG In-reply-to: <35ED92A7.2FD591D1@ibm.net> X-mailer: Pegasus Mail for Win32 (v3.01b) Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On 2 Sep 98, at 11:47, David Chamberlain wrote: > OK, so back to the original question. How do I do it? > > I saw a product called MySQL, which looks pretty good. I can probably > figure out how to install that and make it work from the instructions. > > How do I get the data from the SQL server to the Web page. I've never written code to do the above. But I do have experience in writing client server database applications. Specifically, accessing relational databases via a C/API which is what I assume you will be using with MySQL. There will be a list of functions which you call. This will allow you to access the database. I'm sure there's a user manual there somewhere. SQL is a complex language. But if all you want to do is create a simple CRUD (create, read, update, delete) interface, it should be straight forward. Database schema creation (tables, indexes, etc) is considered, by some, to be an art form. If you have new to either SQL or database schemas, it may pay dividends to get in some professional help, depending on how critical this database will be. See next paragraph. On a side note, this sounds like a good topic for my diary. I'd like to see how good MySQL stacks up against other systems I've used. Especially after all the good things I've heard it. Given that I want to do this, it helps to have a real application to go against. How complex is your situation? If it's a weekend job, I may be interested in helping you out. I already have apache installed. -- Dan Langille DVL Software Limited The FreeBSD Diary - my [mis]adventures http://www.dvl-software.com/freebsd To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message