I've been a developer for 7 years, primarily front-end, and have managed to avoid doing any work with databases up until now because they're just not something I personally find interesting or enjoyable.
But now I've built an ecommerce site that takes customer orders for a product, and I have to set up and manage my own database, and I'm nervous.
I know how easy it is to make a mistake as simple as a typo and screw up your schema or delete records, and with customers' money on the line I'm afraid to be in the position of making such mistakes.
In front-end development, I'm fairly well-versed on best practices and how to build a site that's sturdy and flexible and secure. I have no idea how to do any of those things with a database and am worried about falling into pits I don't know exist yet. SQL injection is the only pit I know to keep an eye out for.
How can I make the best of this? How can I become a competent DBA for myself when money's already on the line without screwing anyone over with amateur mistakes? Just looking for advice from anyone else who's had to do anything similar.
But now I've built an ecommerce site that takes customer orders for a product, and I have to set up and manage my own database, and I'm nervous.
I know how easy it is to make a mistake as simple as a typo and screw up your schema or delete records, and with customers' money on the line I'm afraid to be in the position of making such mistakes.
In front-end development, I'm fairly well-versed on best practices and how to build a site that's sturdy and flexible and secure. I have no idea how to do any of those things with a database and am worried about falling into pits I don't know exist yet. SQL injection is the only pit I know to keep an eye out for.
How can I make the best of this? How can I become a competent DBA for myself when money's already on the line without screwing anyone over with amateur mistakes? Just looking for advice from anyone else who's had to do anything similar.