Add SQL storage adapter postgres implementation

[deanefrati]

No description provided.

[Lutherwaves]

Check out https://github.com/tink3rlabs/example-app/blob/main/internal/storage/sql.go

[Lutherwaves]

Gorm also has auto-migrate, which is why I picked it https://github.com/tink3rlabs/example-app/blob/main/internal/storage/client.go#L70

[deanefrati]

Yes i saw gorm's auto-migrate but i would like to have the ability to do migrations for other adaptors as well so am not sure that using it would be cross platform enough.

[Lutherwaves]

Which platforms do we aim to support? I think having an sql and no-sql adapter is close enough, we can't support everything.

I do plan on using MongoDB for example. Do we implement a mongodb adapter or a nosql adapter? Right now we have an sql adapter, but postgres is the focus, is it not a postgresadapter?

[deanefrati]

You're right I aim to support Postgres and Mysql in the SQL adapter but didn't implement the MySQL yet. I'll rename this to Postgres adapter and create a new issue for MySQL.

Generally speaking i agree we can't support everything so my plan for now is to support:

• memory
• SQL (postgres and mysql)
• DynamoDB
• Cassandra

Added #16 for mysql

[Lutherwaves]

As long as we are set up for scale (sql vs no-sql) we should be good. I've done some research and would probably contribute with a mongodb adapter - any concerns?

The reason for MongoDB and not cassandra is primarily tactical, it is just super simple to setup mongodb

[deanefrati]

Definitely no concerns mongo is a popular option and would be good to have