Timeline for What's the best place to ask this question: "Should I Worry About Modifying a Database that Serves Content on the Fly in ASP.NET"?
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 29, 2013 at 10:26 | history | edited | Sathyajith BhatMod | CC BY-SA 3.0 |
deleted 198 characters in body
|
| Oct 28, 2013 at 23:41 | answer | added | Simon Sheehan | timeline score: 2 | |
| Oct 28, 2013 at 20:38 | comment | added | VoidKing | @allquixotic Thank you for pointing me in the right direction. It seems I have my work cut out for me here... | |
| Oct 28, 2013 at 20:35 | comment | added | allquixotic | Transactions are supported in SQL Server CE (albeit with some limitations). For your use case I don't think the limitations will be a problem. I googled: "SQL Server CE transactions". This was the first hit. | |
| Oct 28, 2013 at 20:31 | comment | added | VoidKing | @allquixotic Well, maybe there are other options? Not sure, but anyway, thank you very much for your help. :) | |
| Oct 28, 2013 at 20:30 | comment | added | VoidKing | @allquixotic Actually, I did, albeit indirectly. Using Web-Pages means I am using SQL server CE | |
| Oct 28, 2013 at 20:28 | comment | added | allquixotic | When in doubt, read Wikipedia. You didn't state which database product you're using, so it's impossible to provide more specific details. It's possible, but very unlikely, that your database implementation doesn't support transactions. | |
| Oct 28, 2013 at 20:26 | comment | added | VoidKing | @allquixotic Okay, I see, well I am only just now hearing about this. I'm not sure what it even is at this point. Do you know of any good sites to introduce me to this? | |
| Oct 28, 2013 at 20:24 | comment | added | allquixotic | I meant "Transactions" as in Database Transactions. Use them. You're right to be cautious about updating a database and creating a potential race condition where a client may be getting wrong data. Transactions are designed to address this. Issue multiple SQL statements in the context of a transaction, and only commit once the state is consistent. This is an okayish question for SuperUser, but you really don't need to ask it -- if you are worried enough to ask "should I be worried about", then the answer is always yes. It's how to deal with it that you need to care about. | |
| Oct 28, 2013 at 20:19 | comment | added | VoidKing | @allquixotic I'm sorry, but I don't see that one on any of the SE sites. Am I really missing it? I clicked all and even used the browser's Ctrl + F function | |
| Oct 28, 2013 at 20:14 | comment | added | allquixotic | Transactions... | |
| Oct 28, 2013 at 20:00 | history | asked | VoidKing | CC BY-SA 3.0 |