Re: OK, it's the matter of database structure rather

ZB escreveu:
Dnia 16.09.2007 Cesar Rabak <csrabak@xxxxxxxxxxxx> napisał/a:

Once you go the database engine, you've to employ a db schema apropriate to the db you choose.

I'm not sure, what you mean. Of course, the schema (structures) must be in
some way be taken into consideration by the script. So...?


Once you decide to use the db engine, you'll design the schema and use the Tcl interface to fetch or add/update data in the db.

Or you still insist in getting a lot of data, cache it in structures coded in Tcl to manipulate them?

Only in the last case your phrase '...must be in some way be take into consideration..." would make sense (at least to me :-).

So the discussion on arrays, etc. in Tcl becomes moot.

Well, usually discussions are led because of moots. And there are some
interesting conclusions.

For the sake of the discussion, sure! For the sake of coming with the finished job, it depends!


But reading the paper...

http://www.tcl.tk/community/tcl2004/Papers/D.RichardHipp/drh.html

...I'm wondering - after all this discussion - whether can be possible
action (almost) directly on the database contents. Although up to now I was
always fetching the data from SQL-server into some structure, the tight
integration of SQLite with Tcl perhaps allows to omit such step? I'm not
sure about influence on performance - even using :memory: there must be
some influence - but maybe it'll be fast enough anyway?


Without knowing a little bit about your data and the volume of it, answering this would be guessing.
.

Relevant Pages

  • What are some useful tools in profiling where a specific Tcl command is spending time [Was: Re: Rege
    ... implications of the language's commands (or libraries). ... meaning to harp on Tcl, b/c it's true for other languages as well. ... would find it useful when thinking about design considerations. ... Remember that the wiki is a community collaboration effort. ...
    (comp.lang.tcl)
  • JOB: incr tcl Software Egineer
    ... develop advanced Tcl application system. ... Substantial experience in design, programming, and testing apps ...
    (comp.lang.tcl)
  • Re: Random Number
    ... scripting language. ... My own very first contact with TCL in a production environment, ... and/or the design as a whole (being just another ... components in the testbench that didn't have that complete isolation. ...
    (comp.lang.tcl)
  • Re: Help would be greatly appreciated...
    ... >> My design was to make a GUI in Tcl and all scripts behind in Perl. ...
    (comp.lang.tcl)
  • Re: ttk::checkbutton - I think, its a bug
    ... Not that Tk is the pinacle of design, ... Way, translated to Tcl: ... the command automatically sets a trace on the variable, ... widget receives some input or need to update its contents. ...
    (comp.lang.tcl)