SQL Back End
Thomas Ronayne
trona at ameritech.net
Wed Sep 13 12:24:30 MDT 2006
If I may make a suggestion...
I've been doing SQL data base design, administration and programming for
over 25 years; in my opinion, MySQL would be the best choice for an
SQL-based back end for Tellico.
Given that Tellico is a Linux-based system, and that MySQL is, usually,
part of every Linux distribution (either installed by default or
available on the distribution media or download sites), and that MySQL
is ANSI/ISO standard and more or less a de facto world standard (KDE's
data base is most definitely not ANSI/ISO standard), I would strongly
suggest that you give serious -- real serious -- consideration to MySQL
as a data base engine. All the function you need is installed with
MySQL, including the function library that you can call, simply and
easily, from a C program (and, what the heck, Java or Javascript as
well). Tellico, already darned useful and nicely done, could become a
serious contender as a LAMP application (that's Linux-Apache-MySQL-PHP)
with a browser-based user interface or continue as a Java-based
application without too much trouble.
Although there are other open source DBMS; e.g., Berkeley's DB3 and DB4,
PostgreSQL, and some also-rans -- MySQL has the broadest support around
the world and, in my experience, is rock solid and dependable
irrespective of the size or complexity of the data base(s) used with it
-- this is no "toy."
--
Everything works -- if you let it.
More information about the tellico-users
mailing list