Read more

User-defined Order in SQL

Henning Koch
March 21, 2018Software engineer at makandra GmbH

The attached article Show archive.org snapshot explains options you have to store the order of items in a database table.

Illustration UI/UX Design

UI/UX Design by makandra brand

We make sure that your target audience has the best possible experience with your digital product. You get:

  • Design tailored to your audience
  • Proven processes customized to your needs
  • An expert team of experienced designers
Read more Show archive.org snapshot

The simplest solution of course is to use a position column. However the author explores some alternatives where you don't need to update multiple rows when you move a single item.

Posted by Henning Koch to makandra dev (2018-03-21 15:46)