D&C Lug - Home Page
Devon & Cornwall Linux Users' Group

[ Date Index ][ Thread Index ]
[ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] DATABASE FOR LINUX



On Wed, 03 Nov 2004 10:52:38 +0000
Craig <craig@xxxxxxxxxxxxxxxx> wrote:

Have moved over to Linux on everything but my 6 year old's games and
Databases.  Don't look for much luck on the first but would like some
help with the last.  I use MS Access at work and home, looking for a
Linux database program that I could move to.  Preferably something
with the same structure as Access. Any help suggestions appreciated. 
-- 
Your original email has brought up some interesting replies. Anyway here
is my final say.

I have written many databases for small companies, originally DOS based
then later Windows based. I have tried out very many programs and I
finally settled on Borland Paradox. I found this to be the easiest to
set up and it was rock solid (as far as any Windows program can be). No
client ever had any problems with it. One of the things that I liked
most about it was the search facility which was very powerful yet easy
for clients to use.

Since moving to Linux I have found that the one area where there is not
at the moment anything to compare with Windows programs is an equivalent
to Paradox or Access. It simply does not exist. There are database
programs, of course, some of them very powerful, but as far as I have
been able to discover none of them is self-contained.

What do I mean by that? Well, Rekall for example can be set up as a
front end to Mysql or Postgresql. So you have to have two database
programs running on your computer. All the Linux databases I have found
so far seem to be the same if you want a GUI front end. You can set up
Mysql for example to run by itself but it will not have a GUI. No way
could any of my clients use that setup.

Access and Paradox however are complete in that the GUI and the database
engine are all included in the one program. You do not need anything
else. To me this seems the obvious way to be. 

I am talking here about databases for small companies, remember, which
will not have many records. None of my clients so far have more than
about 100,000 records. And all clients will expect a GUI front end. If
anyone has found such a program for Linux I would be very grateful to
hear about it.

Meanwhile I will continue searching, and hoping one day.......


Neil Winchurst

--
The Mailing List for the Devon & Cornwall LUG
Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the
message body to unsubscribe.



Lynx friendly