Hey, to make it clear this is not about how to make a sqlite file. It's more about what steps to take to make the SQL backed app future proof
To make my question simple, an example I wana use is to make a todo app. (it's not that actually)
Here's what I want to do:
Add new todos,
Edit todos
Share todos via(email , social sites)
Import todos
Export/backup todos
Every new added todo wil have primarykey or ID in sqlite.
Resetting or deleting todos. I don't want the pkey to auto increment.
If a new todo with pkey 2 is created and the deleted, then the 2 pkey will remain unused and over a long period, there may be IDs in 3 digits.
I need a way to make IDs with fixed number of digits and kinda unique to the device.
I'm confused what mechanism should I work out. Any help is appreciated.
To make my question simple, an example I wana use is to make a todo app. (it's not that actually)
Here's what I want to do:
Add new todos,
Edit todos
Share todos via(email , social sites)
Import todos
Export/backup todos
Every new added todo wil have primarykey or ID in sqlite.
Resetting or deleting todos. I don't want the pkey to auto increment.
If a new todo with pkey 2 is created and the deleted, then the 2 pkey will remain unused and over a long period, there may be IDs in 3 digits.
I need a way to make IDs with fixed number of digits and kinda unique to the device.
I'm confused what mechanism should I work out. Any help is appreciated.
Last edited: