Submitted by jsolka on 2009/03/11 11:35
I was just wondering where items are "really" stored, and in what format (.xml)? I realize that this might be a totally stupid question, but maybe you understand what I mean -- it's  probably about so called back-end, maybe?
This would help me to understand more about software in general and IQ in particular.
Thanks,
Jay

Comments

Many back-end will be possible. Currently, Jet 4.0 is used (same as MSAccess). It is a file-database which is simpler to setup than a server-database, hence the choice.
  • Each item is stored in an Items table
  • Each filed value is stored in type specific Values table
  • Links (parent-child) are stored in a Links table
  • Each grid is saved as a query, which allows other apps to read the grid content
To maintain performance as the number of items grows, XML is not used. Jet is a true DBMS system with content indexing.

jsolka

2009/03/11 16:26

Permalink

Thanks. This probably mean that using Access for presentation of IQ databases should be relatively easy to do -- I hope I could learn how to do it one day.
Take care,
Jay