Hi,

I testing DBISAM, it is a very great database, but I missing RI!
Does anybody know if is implemented in the near future?
Is there DBISAM functions to "simulate" RI?

Greetings

Thomas

Thomas


Only Tim can answer that question, but I doubt it since DBISAM has been superseded by ElevateDB and is, I think, in "maintenance mode".

Have a look at ElevateDB, its a bit more difficult to manage but is much more advanced.

Roy Lambert

I don't think there ever will be a "proper" RI in DBISAM. It was not designed for that.

New ElevateDB product provides all the modern SQL capability so if you're starting a new project you should seriously consider going EDB route.

DBISAM is being maintained in terms of bug fixes and optimizations (and some minor features) but there will not be any major features added.

As to simulating it yes there are number of ways:

- DBISAM does have triggers (though they are engine based) so you can definitely use BeforeInsertTrigger, BeforeDeleteTrigger, etc to achieve data integrity aspects.

See "Customizing the engine" section of manual : http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=r&version=XE&topic=Customizing_Engine

- Also check out server side procedures: they are very useful in some scenarios when you require complex (and possibly long) back-end processing.
http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=r&version=XE&topic=Calling_Server_Procedures

Finally you can of course do it in your client-app - if you design your data access layer properly then it can enforce the RI without you having to worry about it in front-end code

Raul

<<
Thomas wrote:

Hi,

I testing DBISAM, it is a very great database, but I missing RI!
Does anybody know if is implemented in the near future?
Is there DBISAM functions to "simulate" RI?

Greetings

Thomas
>>

Hi Roy,

that is my problem
I develop standard software for the customers I do not know. The installation of the C / S (database) must be run as simply as possible.
I think here the DBISAM is best suited.

Regards


Thomas


Roy Lambert wrote:

Thomas


Only Tim can answer that question, but I doubt it since DBISAM has been superseded by ElevateDB and is, I think, in "maintenance mode".

Have a look at ElevateDB, its a bit more difficult to manage but is much more advanced.

Roy Lambert

Thomas

>that is my problem
>I develop standard software for the customers I do not know. The installation of the C / S (database) must be run as simply as possible.

That means you need to set up an installer and running that should be no different for your customers regardless of wether you use DBISAM or ElevateDB. On the other hand if you expect them to do the setup it will be a little more difficult but not much.

>I think here the DBISAM is best suited.

Its easier in as much as you can just drop the tables in a directory somewhere and you don't need to worry about catalogs or configuration files but your customers shouldn't have to worry about that if you have a decent setup routine.

Roy Lambert [Team Elevate]