Model $casts: Dates, Enum and More

Unfortunately I don't think there's a possible solution if postgres just doesn't support it.

okay thank you

With newer Laravel version, the encryption came as casts. But it's a ONE-WAY encryption, without decryption.

Can you suggest me some encryption and decription package for this senario. As we all are dealing with larage user data there might be chances of the datbase hacke and data leak.

Yes, but from the other hand, if you want to encrypt/decrypt data on every query, it would MASSIVELY slow down the application. Do you really want that?

Can you point me in the right direction with some article link or video, to understand the Best practices.

Encryption in general is a huge topic, not sure which articles or videos I can point you to. In my experience, I've never used real database encryption except for fields like passwords, because I never cared about data security more than performance, and data security comes from the fact that the server itself is protectec enough.

But if you have other opinion, you may start any bigger tutorial/course on database encryption.