101
Developer's Corner / Best Approach to store and load a lot of text snippets into a web page
« Last post by BGM on November 14, 2020, 08:58 AM »My project is a web-application that I'm writing using C# webforms.
I have a few hundred small text blocks - (actually prayers) that I want to load into the web page and arrange so the user can easily find what they want.
Now, my question is how to store them.
I could put them in XML or an access database or a sql database, or I can just type them all right into the web page.
The thing is that if I put them in a database, I can enclose everything in the proper divs that the webpage needs to display them with sortable jquery menus and accordians. If I typed them into the webpage, it would be hard to know what is in the page, exactly, and I'd have to type all the divs. So, I'm leaning toward a database or xml for storing the prayers with their titles, imprimaturs, and perhaps comments.
Should I use xml, sql or accdb for storing things? Which would be faster to load and search?
I have a few hundred small text blocks - (actually prayers) that I want to load into the web page and arrange so the user can easily find what they want.
Now, my question is how to store them.
I could put them in XML or an access database or a sql database, or I can just type them all right into the web page.
The thing is that if I put them in a database, I can enclose everything in the proper divs that the webpage needs to display them with sortable jquery menus and accordians. If I typed them into the webpage, it would be hard to know what is in the page, exactly, and I'd have to type all the divs. So, I'm leaning toward a database or xml for storing the prayers with their titles, imprimaturs, and perhaps comments.
Should I use xml, sql or accdb for storing things? Which would be faster to load and search?

Recent Posts
but for this purpose it does sort of make sense to create one. Maybe I'll include it in the download, but specify the reason for it in the readme file and on my website's page (or something like that). However, the program itself will come first, with the install-context-menu item in the GUI, and if I feel froggy enough, I'll make the installer to go with it. But I dont' think this program will be so popular due to it's exclusive nature (for power users, really), so I'm not sure if it's worth the effort of creating an installer.