From owner-freebsd-questions@FreeBSD.ORG Mon Jun 14 00:24:31 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4F5FD16A4CE for ; Mon, 14 Jun 2004 00:24:31 +0000 (GMT) Received: from invasion.mail.pas.earthlink.net (invasion.mail.pas.earthlink.net [207.217.120.254]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0A6D443D45 for ; Mon, 14 Jun 2004 00:24:29 +0000 (GMT) (envelope-from algould@datawok.com) Received: from 20-74.lctv-b4.cablelynx.com ([24.204.20.74] helo=yoda.datawok.com) by invasion.mail.pas.earthlink.net with asmtp (TLSv1:AES256-SHA:256) (Exim 3.36 #4) id 1BZfGc-0003dJ-00; Sun, 13 Jun 2004 17:24:02 -0700 Date: Sun, 13 Jun 2004 19:24:52 -0500 From: "Andrew L. Gould" To: Bob Perry Message-Id: <20040613192452.7499e92e.algould@datawok.com> In-Reply-To: <20040613234821.GB283@sphinx.alpha.domain> References: <20040613234821.GB283@sphinx.alpha.domain> X-Mailer: Sylpheed version 0.9.9-gtk2-20040229 (GTK+ 2.4.0; i386-portbld-freebsd4.10) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-ELNK-Trace: ee791d459e3d6817d780f4a490ca69564776905774d2ac4b3485828c3208bf7156af4b5e86f06546350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c cc: freebsd-questions@FreeBSD.org Subject: Re: Help With Selection of Database Application X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 14 Jun 2004 00:24:31 -0000 On Sun, 13 Jun 2004 19:48:21 -0400 Bob Perry wrote: > I've had extensive experience with MS Access as a user > and would like to port a comparable system into my FreeBSD > box. Can anyone recommend a database application similar to > Access? I've looked through the ports but can't seem > to readily make that distinction without the expertise > of a DBA. > > If this is not the type of question supported by this > mailing list, please disregard. > > Bob Perry I also use MS Access extensively at work. MS Access has many facets; so the answer to you're question depends upon how you use MS Access: 1. If you've been using MS Access as a database server, I think you'll be much happier with the likes of PostgreSQL, MySQL or Firebird. All 3 are available in the ports. 2. If you're looking for a database application with GUI RAD capabilities similar to MS Access, there are some applications available; but most focus on database administration (simple queries) rather than end-user application development. You might take a look at PgAdmin III, which is crossplatform, but requires PostgreSQL as the back-end server. You can find it in the ports (/usr/ports/databases/pgadmin3) or at: http://www.pgadmin.org/pgadmin3/index.php There is also a KDE project called "Kexi", which looks promising; but I don't think it's soup yet: http://www.kexi-project.org 3. If you're looking for a GUI that facilitates joining/analyzing tables from different servers (PostgreSQL and MySQL tables, for example), I think you're out of luck. I run a PostgreSQL server on FreeBSD at work. It supplements the Decision Support System and handles the back-end for a few MS Access applications. The combo works very well as long as your binary fields (boolean, etc) are defined as "not null" with default values. Best of luck, Andrew Gould