From owner-freebsd-questions@FreeBSD.ORG Mon Jun 14 01:12:06 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 7EE4E16A4CE for ; Mon, 14 Jun 2004 01:12:06 +0000 (GMT) Received: from swan.mail.pas.earthlink.net (swan.mail.pas.earthlink.net [207.217.120.123]) by mx1.FreeBSD.org (Postfix) with ESMTP id 64D0E43D41 for ; Mon, 14 Jun 2004 01:12:06 +0000 (GMT) (envelope-from rperry4@earthlink.net) Received: from dialup-4.250.42.232.dial1.weehawken1.level3.net ([4.250.42.232] helo=sphinx.alpha.domain) by swan.mail.pas.earthlink.net with esmtp (Exim 3.33 #1) id 1BZg0x-00057u-00; Sun, 13 Jun 2004 18:11:55 -0700 Received: from sphinx.alpha.domain (localhost [127.0.0.1]) by sphinx.alpha.domain (8.12.9p2/8.12.9) with ESMTP id i5E1DhWn001303; Sun, 13 Jun 2004 21:13:43 -0400 (EDT) (envelope-from rperry4@earthlink.net) Received: (from rperry@localhost) by sphinx.alpha.domain (8.12.9p2/8.12.9/Submit) id i5E1Dflp001300; Sun, 13 Jun 2004 21:13:41 -0400 (EDT) (envelope-from rperry4@earthlink.net) X-Authentication-Warning: sphinx.alpha.domain: rperry set sender to rperry4@earthlink.net using -f Date: Sun, 13 Jun 2004 21:13:40 -0400 From: Bob Perry To: "Andrew L. Gould" Message-ID: <20040614011340.GC283@sphinx.alpha.domain> References: <20040613234821.GB283@sphinx.alpha.domain> <20040613192452.7499e92e.algould@datawok.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040613192452.7499e92e.algould@datawok.com> User-Agent: Mutt/1.4.2.1i 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 01:12:06 -0000 On (06/13/04 19:24), Andrew L. Gould wrote: > Date: Sun, 13 Jun 2004 19:24:52 -0500 > From: "Andrew L. Gould" > To: Bob Perry > Cc: freebsd-questions@FreeBSD.org > Subject: Re: Help With Selection of Database Application > X-Mailer: Sylpheed version 0.9.9-gtk2-20040229 (GTK+ 2.4.0; i386-portbld-freebsd4.10) > > 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 Andrew, This is exactly the type of information I was looking for. Thanks so much for taking the time. The Kexi project is what I was hoping for however, I'm not running KDE and the project, as you say, is not soup yet. I like the PgAdmin III project and intend to give it a good look see. Thanks again for your help. Bob Perry -- I've learned that whatever hits the fan will not be evenly distributed. FreeBSD 4.9-RELEASE-p2 #0