I'm trying to create a script that can be used back-end to add, delete, modify, etc. news items that would then be read front-end by the user. I know this would take some sort of databasing, but I don't know anything about databasing. Can anyone suggest a way to do this, or a specific resource that I can go to to learn what I need to know to complete this project? Also, I've read about SQL and Microsoft Access databases- will my server only support one, if so, how do I know which, and is there a specific place I have to put a database (like in a cgi-bin) for it to work on the server? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Backend News-Add/Delete script and SQL vs. access
- Thread starter dbromberg
- Start date
Q1: how much MONEY can you afford to spend?
If the answer is LOTS I suggest buying (or even better, getting the client to buy!) SQL Server 2000. If money is an issue and the database is only going to be accessed by a very few connections simultaneously, then MS Access or even MSDE is a possibility.
There's also dbs like mySQL, but if you're new to dbs I'd suggest not. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
If the answer is LOTS I suggest buying (or even better, getting the client to buy!) SQL Server 2000. If money is an issue and the database is only going to be accessed by a very few connections simultaneously, then MS Access or even MSDE is a possibility.
There's also dbs like mySQL, but if you're new to dbs I'd suggest not. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
- Thread starter
- #3
It occurs to me that I can use text files, which would be a lot easier than using databases. However, although I can easily addend, or write, or read to the text file, I don't know how to snip a news entry out of the text file. Can anyone suggest anything, or a resource I can go to?
-dbromberg
-dbromberg
If simplicity/low learning curve is the target, then the best bet is flat files with some functions to manage accessing and modifying them - very inefficient, but easiest.
If you're against databases, you could look into a simple XML parser (say Microsoft's MSXML4.dll) which will allow you to read in XML files (as opposed to flat files), manipulate them in the parser (e.g. remove a 'newsitem' node), and save them back into the XML file. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
If you're against databases, you could look into a simple XML parser (say Microsoft's MSXML4.dll) which will allow you to read in XML files (as opposed to flat files), manipulate them in the parser (e.g. remove a 'newsitem' node), and save them back into the XML file. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question