Anvil Transactions add a transaction ID

[owen.campbell]

This is possibly a relevant discussion from a couple of years back:

[ANSWERED] Auto Incrementing Field

I was also wondering about using a sequence generator, but it would still have to do something similar when the app starts.

You’ve also prompted me to to get around to making a feature request that’s been at the back of my mind for some while:

Python API for Postgresql Sequences

Could we have a Python API for creating and using Postgresql sequences? Something like: anvil.tables.create_sequence("my_sequence", 101) print(anvil.tables.sequence.my_sequence.next()) print(anvil.tables.sequence.my_sequence.next()) anvil.tables.sequence.my_sequence.drop() >>> 101 >>> 102 to wrap: CREATE SEQUENCE my_sequence START 101; SELECT nextval('my_sequence'); SELECT nextval('my_sequence'); DROP SEQUENCE my_sequence; Use Case At present, I use a ‘sequences’ table with columns for th…