Re: Standard Database Interface?

On Oct 15, 1:30 am, tcltk...@xxxxxxx wrote:

I really like tcl/tk but I don't want to be in hot water in the
future. I really hope someone will do something about this. I know
that tcl/tk is used for many things but for I make a living by
developing business applications and w/o a standardize database
interface and tcl database bindings for popular database would deter
me and others from using tcl/tk for this purpose.


Just so you know, this is an issue that we are aware of in the Tcl
Community,
and we have a few projects that are underway that are designed to do
exactly
what you have in mind:

Give a consistent interface to database engines.

I presented a paper at this year's conference about my current
approach,
TDIF (Tcl Data Interface Framework). TDIF is a which is a script
level
wrapper around the various binary drivers and sql dialects. There is
also
some talk amoungst the database driver maintainers about exchanging
notes
on how the APIs should be designed. Look for some TIPs on the subject
this year.

I presently maintain several MySql, MSSQL, Sqlite, and LDAP databases.
The
layer I've written is essentially laziness on my part. I like to write
in
pseudocode, and I think in terms of "query" "cmnd" or "query_flat".
(Though
the sqlite eval that will sub the data into a script is going to be
adapted
for the rest.)

The library I'm working on is being cleaned up for submission into
Tcllib.
You can download snapshots from my website:

http://www.etoyoc.com/tao/

(It uses an OOP system I wrote called Tao. The database level stuff
would
probably do better in Will's SNIT.)

--Sean

.

Relevant Pages

  • TIP#308 Published: Tcl Database Connectivity (TDBC)
    ... This TIP defines a common database access interface for Tcl scripts. ... regarding the need for a "Tcl database connectivity layer" in the Tcl ...
    (comp.lang.tcl)
  • ANNOUNCE: moodss-18.0 and moomps-3.0
    ... - started to progressively abandon Tcl/Tk 8.3 version support, ... compatible with Tcl/Tk 8.3 for several months, ... (please read database HTML documentation for complete information) ... (incompatibility with existing dashboards including viewers, ...
    (comp.lang.tcl)
  • Re: Standard Database Interface?
    ... interface and tcl database bindings for popular database would deter ... me and others from using tcl/tk for this purpose. ... this is an issue that we are aware of in the Tcl ... Give a consistent interface to database engines. ...
    (comp.lang.tcl)
  • Re: Need help on tablelist
    ... How to populate tablelist with data from database ... I thoroughly recommend you to read the Tablelist Programmer's Guide ... Do you think Tcl/Tk is suitable for this project? ... For the first steps with TclODBC, ...
    (comp.lang.tcl)
  • Re: DBMS clients
    ... The man says that when there is single man in a database ... connectivity project, ... > enterprise level Tcl/Tk based systems would just stop working. ...
    (comp.lang.tcl)