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

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

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.

I'm afraid, you're identifying a database (an abstract) with a database
storage (a real thing). SQLite-file can be such storage, or just "plain
text file".

I suspect you're willing to discuss too much theoretical aspects and going farther from the problem you need to solve...

For what purposes should we discuss 'abstract databases' in c.l.tcl?

Doing "select" I'm fetching the necessary data from such
storage.

In theory yes, in practice at a[n] (intellectual) smaller cost w.r.t doing it yourself using records and storing in flat file.


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

Why "or"? I can't see any contradictions(?) in your two paragraphs above.

I'm considering only the implementation aspects.


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

...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.

How - in your opinion - it's depending on the kind and volume of data?

Because in engineering that's the way things are.
.

Relevant Pages

  • Re: OK, its the matter of database structure rather
    ... the Tcl interface to fetch or add/update data in the db. ... you're identifying a database with a database ... SQLite-file can be such storage, ...
    (comp.lang.tcl)
  • ANNOUNCE: tclstorage and stgvfs
    ... The Storage package is Tcl extension that adds a 'storage' command to ... Notable users of structured storages are Microsoft Word and Excel. ... A virtual filesystem based upon the Storage extension is also provided ...
    (comp.lang.tcl)
  • Re: returning C structure to tcl
    ... at what Tcl does with something called "handles". ... storage is implemented, and as the structures are created, they are ... returns to Tcl this numeric string handle. ... invoked which needs access to the FILE structure, ...
    (comp.lang.tcl)