New answers tagged database-agnostic
(sorry for english. i'm study) Is wery simple. You need have "cardinality hole" structure you need to have 2 column 1) pk = 32bit int 2) order = 64bit bigint (BIGINT, NOT DOUBLE!!!) insert/update 1) when you insert first new record you must set order = round(max_bigint / 2). 2) if you insert in beginning of the table you must set order = round("order ...
Top 50 recent answers are included