Chela: Small URL Shortener (opens in new tab)

(github.com)

1 pointssubtract-smiles1y ago2 comments

2 comments

Tangential recommendation: Postgres' "generated always as identity" should be preferred over the "serial" types.

Nice catch! It probably would be good to switch to an IDENTITY column, but it shouldn't make too much of a difference because Chela manages the state of the index manually anyways.

In order to create new IDs it consumes the next value of the index column, and then manually sets the index and the ID in one go.

j / k navigate · click thread line to collapse

2 comments

eddd-ddde1y ago

Tangential recommendation: Postgres' "generated always as identity" should be preferred over the "serial" types.

subtract-smilesOP1y ago

Nice catch! It probably would be good to switch to an IDENTITY column, but it shouldn't make too much of a difference because Chela manages the state of the index manually anyways.

In order to create new IDs it consumes the next value of the index column, and then manually sets the index and the ID in one go.

j / k navigate · click thread line to collapse