Re: [LUG] DATABASE FOR LINUX

[dclug@xxxxxxxxxx]

On Mon, 8 Nov 2004, Neil Winchurst wrote:
> 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.......

You want SQLite, it works nicely with Perl and its (unmatched IMHO) DBI 
database abstraction layer. It is a simple fullfeatured library that can 
be integrated into any standalone application (in a decent language).

You can then deploy the application as a .exe on windows using PAR, in 
fact I think you could knock out a QT/Perl application almost as quickly 
as the equivilient in VB but with a lot more power and easier programming 
(assuming you know how to program).

cheers,

A.

--
Aaron J Trevena - Perl Hacker, Kung Fu Geek, Internet Consultant
AutoDia --- Automatic UML and HTML Specifications from Perl, C++ 
and Any Datasource with a Handler.     http://droogs.org/autodia

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