Migrate to Postgresql

[ndelvalle]

After doing some research I think I will give https://github.com/SeaQL/sea-orm a try and implement it.

Interesting reads about different ORM options:

• https://www.shuttle.rs/blog/2024/01/16/best-orm-rust
• https://www.sea-ql.org/SeaORM/docs/internal-design/diesel/

[opeolluwa]

Do you want help with this?

[ndelvalle]

@opeolluwa Yes, but I still haven’t decided what to use for PostgreSQL. I’m leaning more towards Diesel over SeaORM—it seems simpler and doesn’t clutter the code with ORM-related elements everywhere. I also need to put more effort into my #458 PR to make it more stable so that others can contribute, as it’s currently a bit messy.
Do you have strong opinions about these ORMs?

[opeolluwa]

yes, I've used both in production environment.
My opinion is that, diesel is more battle tested than SeaORM, especially looking at the stats, on the other end, SeaORM seems more promising.

Also on the other end, Diesel isn't async-first unlike, SeaORM.

[opeolluwa]

Do you want me to look at this

[ndelvalle]

@opeolluwa I’m currently using diesel-async for async support, and it seems to be working correctly. If you’re interested in continuing the work, that would be fantastic. I haven’t had much time lately to make progress, so any help would be greatly appreciated!

[opeolluwa]

I'll see what can be done

[opeolluwa]

@ndelvalle do you want to use diese-async or I should revamp with sea-orm

[ndelvalle]

@opeolluwa i think using async diesel is the best idea.

[opeolluwa]

alright

[opeolluwa]

I'll put it up locally tomorrow!

[opeolluwa]

@ndelvalle would you be kind to tag the branch you're working on

[ndelvalle]

@ndelvalle would you be kind to tag the branch you're working on

I just added you as a collaborator, feel free to keep working on the same branch or tag it.