... you should consider non-integer approaches; one such approach would be UUIDs.

Possible, but then you might hit this:

biginteger-vs-uuid inserts (image)

There are ways to avoid that but let's wait till the OP gets a site up, and reaches, say, 10 tps. It may never happen, 'beginners'* often have unrealistically high hopes for their unborn brainchild.

Well-trodden paths are boring, and often safest.

*) Obviously, 'beginner' here in the sense of beginning a system (as OP says: 'a website from scratch')