Best way to host large amount of text/forum
Thread Starter
Spicy Meatball
Joined: Jan 2004
Posts: 1,115
Likes: 0
From: Liverpool UK
Best way to host large amount of text/forum
Hi Guys
A while back, I finished making my PPL diary here on Prune. I have this saved as a Word doc (one having all posts, and one having just my own).
What I would like to do is build a website to hold all my diary posts. Now the thing is - I am wondering what the best way to do this is?
A static website or a database driven one? How are the posts here on Prune stored?
I am competent with SQL Server etc....
Thanks for any advice,
Maz
PS - I have considered a free Blog site, but would ideally like to have my own.
A while back, I finished making my PPL diary here on Prune. I have this saved as a Word doc (one having all posts, and one having just my own).
What I would like to do is build a website to hold all my diary posts. Now the thing is - I am wondering what the best way to do this is?
A static website or a database driven one? How are the posts here on Prune stored?
I am competent with SQL Server etc....
Thanks for any advice,
Maz
PS - I have considered a free Blog site, but would ideally like to have my own.
Administrator
Joined: Mar 2001
Aviation Qualifications: PPL
Posts: 8,121
Likes: 686
From: Twickenham, home of rugby
VBulletin is the Forum software. It has a MySQL database.
VB is not expensive - but I'm sure that there are other Opensource offerings that don't cost anything.
SD
VB is not expensive - but I'm sure that there are other Opensource offerings that don't cost anything.
SD
Joined: Jun 2006
Posts: 526
Likes: 0
From: BRISTOL!
Hey, a free offering of VB Forum is PHPBB, more or less the same, think you can get plugins to make it identical, just its php and not asp...
I think a blog may be a good idea, you can add the articles by date, etc...
Wordpress is my choice of blog...
I think a blog would be the way...
I have sent you a PM too...
I think a blog may be a good idea, you can add the articles by date, etc...
Wordpress is my choice of blog...
I think a blog would be the way...
I have sent you a PM too...
Thread Starter
Spicy Meatball
Joined: Jan 2004
Posts: 1,115
Likes: 0
From: Liverpool UK
Here's a little thought:
I'm not sure exactly how pprune is stored on the server (SQL database?) but would it be possible (mods?) for someone to download a thread directly from the back-end database I.E. (Ignore the [] they are for ease of reading)
SELECT [Date], [UserName], [PostText] FROM [Thread]
WHERE [Thread] = "Thread Name" AND [UserName] = "mazzy1026"
Or thereabouts
Other than that I have tried every possible way under the sun to save my thread as a readable file (csv, excel, SQL database - even Access) other than go through them all manually and save them to a table individually
I'm not sure exactly how pprune is stored on the server (SQL database?) but would it be possible (mods?) for someone to download a thread directly from the back-end database I.E. (Ignore the [] they are for ease of reading)
SELECT [Date], [UserName], [PostText] FROM [Thread]
WHERE [Thread] = "Thread Name" AND [UserName] = "mazzy1026"
Or thereabouts
Other than that I have tried every possible way under the sun to save my thread as a readable file (csv, excel, SQL database - even Access) other than go through them all manually and save them to a table individually




