Hey everyone! I’m new to the forum.
I’m currently starting an e-commerce project with a subscription system, and I’d like to hear some opinions from people who have experience building this kind of infrastructure.
I’m planning to run everything on a Linux server, and I’m currently deciding on the best database setup.
The system will handle things like:
Would you recommend PostgreSQL, MySQL/MariaDB, or another solution?
My initial idea is to use an SQL database, mainly because of the relationships between customers, orders, payments, and subscriptions.
I’d also appreciate any advice on best practices for security, backups, database structure, indexing, and scalability from the beginning.
I’m still designing the architecture, so any recommendations or experiences with e-commerce + subscription systems would be really helpful.
Thanks!
I’m currently starting an e-commerce project with a subscription system, and I’d like to hear some opinions from people who have experience building this kind of infrastructure.
I’m planning to run everything on a Linux server, and I’m currently deciding on the best database setup.
The system will handle things like:
- Users/customers
- Products
- Orders
- Payments
- Recurring subscriptions
- Subscription plans
- Billing history
- Coupons/discounts
- Transaction and webhook logs
Would you recommend PostgreSQL, MySQL/MariaDB, or another solution?
My initial idea is to use an SQL database, mainly because of the relationships between customers, orders, payments, and subscriptions.
I’d also appreciate any advice on best practices for security, backups, database structure, indexing, and scalability from the beginning.
I’m still designing the architecture, so any recommendations or experiences with e-commerce + subscription systems would be really helpful.
Thanks!
