From owner-freebsd-database Thu Dec 17 20:25:28 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA12828 for freebsd-database-outgoing; Thu, 17 Dec 1998 20:25:28 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from WEBBSD1.turnaround.com.au (webbsd1.turnaround.com.au [203.39.138.49]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id UAA12816 for ; Thu, 17 Dec 1998 20:25:23 -0800 (PST) (envelope-from J_Shevland@TurnAround.com.au) Received: from simbarchi (dhcp110.turnaround.com.au [192.168.1.110] (may be forged)) by WEBBSD1.turnaround.com.au (8.8.7/8.8.7) with SMTP id PAA08626; Fri, 18 Dec 1998 15:28:04 +1100 (EST) (envelope-from J_Shevland@TurnAround.com.au) Reply-To: From: "Joe Shevland" To: "jonathan michaels" , Subject: RE: conversion from asksam Date: Fri, 18 Dec 1998 15:23:20 +1100 Message-ID: <001601be2a3e$24ba4a40$6e01a8c0@simbarchi.turnaround.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <19981218152005.A411@caamora.com.au> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Importance: Normal Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk I'd look into MySQL or PostgreSQL, depending on your needs. MySQL is lightning fast but doesn't support more complex RDBMS features (last I checked) like triggers and stored procedures. I like PostgreSQL personally... it installs nicely, is easy to maintain, and is as powerful as I need a SQL server to be. There's also ODBC drivers for it and (I vomit to say it) a Win32 admin tool. I think this'd handle what you're after... you may need to look into full text indexing though, I'm sure there's many ways of doing this with these products. HTH, joe. > -----Original Message----- > From: owner-freebsd-database@FreeBSD.ORG > [mailto:owner-freebsd-database@FreeBSD.ORG]On Behalf Of jonathan > michaels > Sent: Friday, December 18, 1998 3:20 PM > To: freebsd-database@FreeBSD.ORG > Subject: conversion from asksam > > > all, > > hello, and best wishes of christmass and new year. > > i have recently, taken over a task that involves maintaining an > asksam (for > dos) database. i was thinking that it would be much easier to > have an office > distributable database, as opposed to teh one machine and having > to update teh > two others on an ad hoc basis. > > i realise that schemas are going to have to be built and teh > asksam database > exported .. this isn't a problem or an issue. what i need to know > is wether or > not thier is a sql (assuming sql is up to the task) based methodology to > handle purely text based information and or wether or not it is > possible to > get text information fields to be searcable ? > > sorry, this is not a really formated question. my database experience is > limited to fiddling dbase3 flatfiles with clipper built engines doing teh > searching. > > any assistance would be apreciated by this sql know-nothing. well > this is not > strictly true, i know sql exists .. grin. > > regards > > jonathan > > -- > ================================================================== > ============= > Jonathan Michaels > PO Box 144, Rosebery, NSW 1445 Australia > =========================================================== amora.com.au> > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message