InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: xxx$db$tables


Martin

>Is this boundary between system and user tables the only way to separate to
two
>types of tables?

Not quite. You could use DatabaseMetaData.getTables. It has a final field
String[] types. InstantDB recognises the types TABLE and SYSTEM TABLE which
allows you to distinguish between the two.

>I guess that idb adds 1 to the TableID when new tables is created and if
tables
>gets dumped there will be a hole
>in the TableIDs. This is the reason for my boundary at 1040.

Yep - that's exactly how it works.

>You say that system IDs always are the same, is this also true for a once
>created user table that its ID is  fixed ?

The IDs for the various system tables currently are fixed so 1000 is always
...$cols, 1001 is always ...$cols$pKey and so on. IDs for user tables could
be anything though. I keep meaning to document these tables but never seem
to get around to it.

Regards

Pete

To unsubscribe from this list, please an send
email to 'majordomo@smartcard.co.uk' with the text
'unsubscribe instantdb' in the message body.