ALX
Well-known member
'Need a little advice...
I'm preparing an MVC web site that will accept user input such as Name, E-Mail, Date, Payment Amount and a unique User ID. From my site the user is redirected to PayPal to handle a secure transaction and return all variables back to my site. I began thinking I'd need a small database without a user interface to keep track of these transactions. Since my previous experience with database programming was back in the XP days with SQL CE, I quickly learned how out of touch I had become. So I began looking into Microsoft's SQL Server Express, which mentioned that I'd also need to download SSDT to implement SQL Server. At this point, I'm thinking that this is overkill for the task of simply storing the data returned from PayPal. After all, I could conceivably store this data in a simple text file, download it periodically and add the data to an offline in house database. That option is of course very vulnerable to hackers while the data sits online in a text file, but I'm not too sure that a database would be much more secure. The bright side is that there is no sensitive data being stored but I really can't afford to lose the data either.
From here I stumbled across CRUD as a possible medium which led me to WAMP which would mean that I'd need to become proficient in PHP programming (Not a deal breaker as I'm sure I could handle it, given the time...) I'm just looking for some advice from folks who may have used these methods in the past and point me to the simplest plan. I'm trying to keep this end of my project as light weight as possible. I can't see deploying an omnipotent database that takes a gig of disk space for such a simple task.
I'm preparing an MVC web site that will accept user input such as Name, E-Mail, Date, Payment Amount and a unique User ID. From my site the user is redirected to PayPal to handle a secure transaction and return all variables back to my site. I began thinking I'd need a small database without a user interface to keep track of these transactions. Since my previous experience with database programming was back in the XP days with SQL CE, I quickly learned how out of touch I had become. So I began looking into Microsoft's SQL Server Express, which mentioned that I'd also need to download SSDT to implement SQL Server. At this point, I'm thinking that this is overkill for the task of simply storing the data returned from PayPal. After all, I could conceivably store this data in a simple text file, download it periodically and add the data to an offline in house database. That option is of course very vulnerable to hackers while the data sits online in a text file, but I'm not too sure that a database would be much more secure. The bright side is that there is no sensitive data being stored but I really can't afford to lose the data either.
From here I stumbled across CRUD as a possible medium which led me to WAMP which would mean that I'd need to become proficient in PHP programming (Not a deal breaker as I'm sure I could handle it, given the time...) I'm just looking for some advice from folks who may have used these methods in the past and point me to the simplest plan. I'm trying to keep this end of my project as light weight as possible. I can't see deploying an omnipotent database that takes a gig of disk space for such a simple task.