Re: Standard Database Interface?

On Oct 16, 9:57 pm, Sean Woods <y...@xxxxxxxxxx> wrote:
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

Where can I find the examples on how to use taodbi? I need plenty of
examples because I'm not that smart. What databases are supported? Do
I need install packages for postgres, oracle and tclodbc?

Thanks.

.

Relevant Pages

  • Re: Standard Database Interface?
    ... I really like tcl/tk but I don't want to be in hot water in the ... interface and tcl database bindings for popular database would deter ... this is an issue that we are aware of in the Tcl ... Give a consistent interface to database engines. ...
    (comp.lang.tcl)
  • SQLite and Tcl/Tk
    ... SQLite is a small but fully-functional, embedded SQL database ... to every Tcl and Tcl/Tk programmers toolbox. ...
    (comp.lang.tcl)
  • Re: Beginning C# Q
    ... starting out with a network app0lication, you have an awful lot to swallow. ... Designing your database is therefore, not quite the first step, particularly ... Groups table, which defines which Groups users belong to, and a Permissions ... That is why an Interface is called an Interface. ...
    (microsoft.public.dotnet.framework)
  • Re: Transaction Oriented Architecture (TOA)
    ... If one builds the application around the database view, ... The problem solution should not have to know about mechanisms like SQL query construction, optimizations like anticipatory caches, or encoding/decoding of dataset formats. ... Note that the CRUD/USER environments already provide exactly that encapsulation by providing a Data Layer that is isolated from the rest of the application through an interface. ... TOA/TOP proposes the database and its application domain stored procedures are the only persistence mechanism necessary, and that the benefits of a focused, single, data-permeable gateway between application and database far exceed the benefits of O/R mappings--regardless of abstraction--and that its lightweight appearance shouldn't be dismissed as missing heavyweight kick. ...
    (comp.object)
  • Re: Transaction Oriented Architecture (TOA)
    ... I don't think the issue is ignoring the database; it is recognizing that the database is a different subject matter applying different business rules than the problem solution. ... There is nothing to prevent abstracting the database subject matter in a classic OO manner with objects like Schema, Table, Tuple, and Query. ... I'm of the opinion that the more obvious the database (or at least its interface) is the more easily maintainable an application becomes. ... I've nothing against creating frameworks and patterns to facilitate those programming activities, but prefer the concept of a problem domain transaction to language-specific expressions mapping 1:1 with anything physically present in the database. ...
    (comp.object)