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