: Checked out the list of database software for Linux at
: http://www.xnet.com/~blatura/linapps.shtml, but I'm having a hard time
: deciding which one to download. I have a DBF (also have a CSV of the
: same), and need to get it into a database system, and be able to query
: the database over the Internet.
: I would like advanced filtering and querying, but I also need it to be
: kinda simple to use (preferably with some kind of X-based interface). I
: am assuming PostgreSQL is a big free one, but does anyone have any
: experience with others, or is Postgre the best one?
You have got strange ideas about what databases are.
most of Linux databases are SQL servers which have no interface except
socket connections. (which are not interfaces for human, of course)
Then you can use various client software to connect database and
only thing which database can do and would do is store and retrieve
It is job to client programs to provide interface to user and/or
foreign file format.
Concerning postgreSQL there is x-based (Motif) client named mxsql
there is Tcl interface which allows you to write customized GUI clients
and CGI scripts, there is perl interface (perl is sometimes better
for CGI than Tcl due to -w and -T options)
Concerning import of DBF and csv files - just write simple Tcl/Perl
script for do so.
About experience with postgres. We are running old version (95) of
postgres behind our WWW server. And constantly have problems with it.
I've read that these problems (mostly memory leaks) are fixed in newer
versions. I have seen that it is now almost ANSI compilant, but
our manager refuses to upgrade postgres, telling me better to switch
to Oracle, which we use in any case (but it is under Solaris).
It is said that Solid and Adabas more stable, but they cost money.
Good databases are all equally simple to use but hardly simple to administer
: Richard Bowman
I have tin news and pine mail...