dauersuchti Posted February 22, 2008 Share Posted February 22, 2008 Hello, I would like to generate my own forum and for this I'm searching for an alternative way to save the posts. At the moment every posts is saved in the database as an blob, but I'm a bit afraid that this will go beyond the scope of the aviable storage space and to save alle the answer inside various .txt files isn't the best idea ... If any body has an alternative proposal please just answer ;-) bye bye dauersuchti PS: sry if my english is to bad. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 22, 2008 Share Posted February 22, 2008 Why not use TEXT fields? Quote Link to comment Share on other sites More sharing options...
dauersuchti Posted February 22, 2008 Author Share Posted February 22, 2008 beacuse the readout takes a long time, it's circular and you've got a problem if two persons send an article at the same time, then only one of them gets saved. Additionally to that I'm not realy sure how to structure the text fields, if you use one file per topice and one folder per category you have plenty a lot of files and one file per category takes realy a long time to read them out. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 22, 2008 Share Posted February 22, 2008 I'm talking about one record per POST... some all of the post goes into a single field. Two people = 2 posts. Quote Link to comment Share on other sites More sharing options...
dauersuchti Posted February 22, 2008 Author Share Posted February 22, 2008 and how can I keep an overview above all the records ? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 22, 2008 Share Posted February 22, 2008 What do you mean by overview? Quote Link to comment Share on other sites More sharing options...
dauersuchti Posted February 22, 2008 Author Share Posted February 22, 2008 well I need to know which record is linked with which topic ... or do you mean to create one table inside the database with one record per post ? to be honest I'm not sure if you mean to create records inside files or inside an database Quote Link to comment Share on other sites More sharing options...
fenway Posted February 22, 2008 Share Posted February 22, 2008 I assume you're dealing with a proper database here.... and that you have a table of topics and a table of posts. But seriously, there is plenty of good forum software out there... why roll your own? Quote Link to comment Share on other sites More sharing options...
dauersuchti Posted February 22, 2008 Author Share Posted February 22, 2008 because I need a new project and a forum software contains many aspects so I can train my abilities as a programmer. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 22, 2008 Share Posted February 22, 2008 because I need a new project and a forum software contains many aspects so I can train my abilities as a programmer. Go right ahead... but just consider the timeline for the project. Quote Link to comment Share on other sites More sharing options...
dauersuchti Posted February 22, 2008 Author Share Posted February 22, 2008 Go right ahead... but just consider the timeline for the project. how do you mean this ? for sure the project has a timeline, but why is it important to consider it ? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 22, 2008 Share Posted February 22, 2008 No need to re-invent the wheel, that's all I'm saying. Quote Link to comment Share on other sites More sharing options...
dauersuchti Posted February 22, 2008 Author Share Posted February 22, 2008 but then there would be no need to write new communities and no need of most of the programms. Everything is going to be re-invent or advanced and as long as it's just an avocation there is nothing wrong about it. But that's my point of view ... Quote Link to comment Share on other sites More sharing options...
fenway Posted February 22, 2008 Share Posted February 22, 2008 Agreed... but if you have a paying customer, I'm not sure that they'd be interested in your learning curve. Regardless, if you need any help with design further to your original post, let me know. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.