How do I save data that doesn't need to be saved to a DB, or would only have 1 row in the DB?

Question

0.00/5 (No votes)

See more:

I am working on a personal C# website, and I have an about section that I would like to perform read, write and update operations on. However, I do NOT want to pollute the database with multiple rows of different about blurbs that I added previously. What are some good ways in going about implementing something like this?

What I have tried:

I would assume that it would just be a single row in the DB that just gets changed without anymore rows proceeding it, but like I said, I am curious about other better options in approaching a problem like this.

Posted 10-Jul-24 4:58am

Baraiboapex

Add a Solution

Comments

Richard Deeming 10-Jul-24 11:04am

Would a static HTML file stored in the server's file-system work? Assuming you can get write access to a folder somewhere in your site...

Baraiboapex 10-Jul-24 11:35am

Hmmm, I would be worried about security then for things like XSS, although I could just scrub the HTML with regex replacements and stringify or escape the dangerous characters in the text input. (I would be the only one to have access to this website to be honest, but practicing good security is always good ;) ) Perhaps a text file or something would be best? I also thought about this, but was just wondering if there was probably a better way to doing it. However, if there is not, then I guess the text file would work. Thanks for the tip!

Richard Deeming 11-Jul-24 4:38am

If you're worried about someone editing the details to insert malicious scripts, then that concern would apply whether you stored the data in a file on disk or in the database. :)

PIEBALDconsult 10-Jul-24 22:47pm

More detail is required.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pete O'Hanlon · Accepted Answer · 2024-07-10T05:16:00

It sounds like you are talking about keeping an archive of old entries. One way to accomplish this would be to use a database trigger tied to an update that saved a copy of the record you have just changed into an archive table. With that approach, your master table would only need to have one row, and the history of the record could be maintained in the old archive table. Add in details about when the change occurred and you have a complete audit trail of changes, along with the ability to rollback changes if you needed to.