Hey everyone! I'm working on a website for my parents' business and I could really use some guidance on selecting a Database Management System (DBMS). I have some experience with SQL Server, and next semester I'll be diving into NoSQL and NewSQL, but they don't seem to fit what I need for this project.
The database is going to be pretty simple; it will mainly list products and allow for filtering. I'm thinking I'll only need a few tables, along with views, UDFs, and stored procedures. Indexes will be important since there will be a few hundred products, but insertions won't happen often after the initial setup—my parents aren't planning to add new products from the website.
I'm considering PostgreSQL or SQLite because they are widely used and seem different enough from SQL Server to help me learn something new, yet similar enough that I won't have to learn everything from scratch. I'd love your recommendations, and if you have other suggestions, I'm open to those too! Also, it would be great if I could code the DB on Linux without needing a VM since I'm on Arch.
3 Answers
I personally love PostgreSQL! It's incredibly versatile, supports a lot of features, and can handle multiple clients efficiently. That said, NoSQL can be great for certain types of projects, so it really depends on your long-term goals.
If you’re just exploring, why not stick with SQL Server? SQL Server Express is free and readily available. Plus, check if your school's computer lab has a version installed—it might save you some setup time!
Have you thought about what framework you’re using? My recommendation would be MySQL—it's solid and straightforward to work with for your needs.
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically