I need to use it as a database solution for a small grocery delivery ecommerce service in my area.
An Account has multiple shopping Carts.
Some Shopping Carts will transform in Orders.
Both Carts and Shopping Carts will have many items/products.
...
So you will need to have one to many or many to many relations. It is easier to do it with relational database in my own opinion.
I prefer to use PostgreSQL. It is easy to install and works great for majority of cases. But you can also use MySQL. It will get the job done.
Both are well supported in most programming languages.
I