What sequence do you use for your (Primary) Key

Classic Servoy
1

Hi,

I am currently adding true import to the data plugin.

As a result you will be able to script an import to your backend database with or without a dialog. This new functionality will become available to all file types that the plugin supports including the new iCalendar class.

However, to use this you need to use database sequences instead of Servoy sequence. I am curious how many of you use one or the other…

Please add your vote here: Servoy Components – Plugins, Beans, Web Components, Angular Services & Servoy Developer Consulting

2

I don’t understand in deep the difference.
Could you explain the implications of each choise?

It seems servoyans ever suggest to use servoy sequence, but doing so is very difficult to work with the database outside Servoy.

What are benefits and limits of each?

3

I completely forgot about it but googeling for ‘servoy sequence’ gave me the following link: Why do you use Servoy or DB managed sequences??? - Classic Servoy - Servoy Community

BTW I absolutely disagree with your statement that Servoyans always suggest Servoy Sequence. As with everything it is a matter of what, when and how (or whatever :) )…

4

I use and prefer database managed sequences.

My reason for this is two-fold:

  1. I’m a strong believer that the database engine should manage these and not an application.
  2. I usually have other applications (web/etc.) adding data to the same database and therefore can’t use Servoy managed sequences.
5

I usually use Servoy sequences… but If I find a comfortable tool for data import I would absolutely find reasonable the use of the internal db sequence for the primary key. BTW that is what I already use when importing data directly with the db tools…