#1  
Old 27th August 2018, 06:53 AM
Tor
 
Posts: n/a
Default Integrity of tables in database..

Hi,

A long time ago I thought I read something about NexusDB having some
identifier in the table headers that were updated every time the
database was closed. This should help trigger an error if single tables
in the database were replaced with similar (older) tables with different
content.

If this is true, where can I find info about this 'feature'..?

We have lots of apps with embedded server so we need all relevant tips
to ensure that the data is not manipulated some way...

Oh, btw, when can we expect single-table databases from NexusDB..?

Thanks for comments on the above...

best regards Tor
  #2  
Old 27th August 2018, 11:13 AM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Integrity of tables in database..

> A long time ago I thought I read something about NexusDB having some
> identifier in the table headers that were updated every time the
> database was closed. This should help trigger an error if single
> tables in the database were replaced with similar (older) tables with
> different content.


This feature is not directly built in, but you can easily implement
what you need by using a table stream to store the expected table
version into.



--
Eivind Bakkestuen [NDD]
  #3  
Old 27th August 2018, 02:13 PM
Shane Stump
 
Posts: n/a
Default Re: Integrity of tables in database..

Howdy Tor,

As Eivind pointed out, use the Table Stream feature and implement your
own versioning.

I implemented my own versioning in such away and it has been working for
years!

All the best,

Shane
  #4  
Old 27th August 2018, 09:38 PM
Tor
 
Posts: n/a
Default Re: Integrity of tables in database..

Den 27.08.2018 05.13, skrev Shane Stump:
> Howdy Tor,
>
> As Eivind pointed out, use the Table Stream feature and implement your
> own versioning.
>
> I implemented my own versioning in such away and it has been working for
> years!
>
> All the best,
>
> Shane


Ok, thanks a lot.

.... and the TableStream stuff has not been updated / changed / enhanced
since this post:

https://www.nexusdb.com/forums/showt...db84ae&t=17285

...?

Tor
  #5  
Old 28th August 2018, 06:12 PM
jhoehne jhoehne is offline
Junior Member
 
Join Date: Apr 2018
Posts: 10
Default Re: Integrity of tables in database..

Couldn't you simply use the monitor/extender feature mentioned in the documentation? (see "How to create a monitor/extender" in the NexusDB manual). This seems to me like a "clean" approach to the problem.

And yes I know that problem: customer wants data to disappear, so he backups the "logs" table, deletes the records and restores the "logs" table afterwards. The data is gone, but no entry in the "logs"... grrr.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Referential Integrity with protected tables Tony Grant nexusdb.public.support 1 8th May 2010 08:56 AM
Referentual integrity issue. Test tables. Roberto Nicchi Binaries 0 17th November 2008 11:32 PM
Tables for referential integrity Roberto Nicchi Binaries 0 26th April 2008 08:27 AM
looking for example how to create tables with referential integrity using TnxDataDictionary Wina Jansen nexusdb.public.support 6 18th February 2008 09:34 PM
How to identify referential integrity from #META tables ? m.Lupinski nexusdb.public.support 1 23rd September 2005 01:13 PM


All times are GMT +11. The time now is 11:43 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.