web log architecture

Printable View

Jul 25th, 2003, 07:48 PM
PT Exorcist

web log architecture

i am going to make a kind of mini forum..i can create a topic and then create replys..but how will i implement this in a database? i dont know much about databases but how do u guys usually do it? i am just trying to think of the best way possible to do this

tks :D
Jul 25th, 2003, 08:42 PM
DevGrp

Gimmie a day and I'll post the code to mine which can be found here http://blog.pjwc.com I use SQL Server 2000 to store my articles and comments. You can use Access or MSDE.
Jul 25th, 2003, 08:48 PM
PT Exorcist

oh tks cant wait..i've looked at ur weblog and is very very cool..i made a small one that was inspired by yours :D but it had some downs in the architecture thats why i stopped making it

tks!
Jul 25th, 2003, 11:14 PM
gearbolt

I would really like to see the Database design also

Thanks.
By the way I like your site.
Jul 26th, 2003, 06:10 AM
DevGrp

Thanks for the compliments. I havent really been posting that much. I've been really busy, but I made the weblog just as an experiment. I just want to see if I could do it. And it was'nt really that hard. It took me a week to write all the code and about 2 days to tweak it.
Also the database design is'nt that special. I have 2 tables blog and comment with a primary key and a secondary key. The primary key in the blog table links to a column in the comment table. I'll post the code when I get home from work.
Jul 26th, 2003, 09:51 AM
PT Exorcist

ok
Jul 26th, 2003, 10:10 PM
DevGrp

I've upload the program. Here is the link. http://www.pjwc.com/files/blog.zip
Jul 26th, 2003, 10:13 PM
PT Exorcist

tks im downloadint it
Sep 21st, 2003, 06:34 AM
andfa

connection string

Quote:

Originally posted by DevGrp
I've upload the program. Here is the link. http://www.pjwc.com/files/blog.zip

I've downloaded and installed your blog app. but I have problems understanding how and where to define the connection string. I've installed MSDE and your blog.sql file has executed without problems so there are a number of tables in the database. Do I have to create a suitable user or do I have to adjust the connection string somewhere?

Thanks in advance!

Best regards,
Anders
Sep 21st, 2003, 07:59 AM
DevGrp

The connection string is defined in the web.config file.
Sep 21st, 2003, 09:33 AM
andfa

GREAT

It works now!

Thanks!

/Anders
Sep 21st, 2003, 11:08 AM
hellswraith

http://www.msdn.microsoft.com/msdnma...g/default.aspx

There was a article in the last MSDN magazine about blogging and shows you how to do it.
Sep 21st, 2003, 01:03 PM
andfa

Blogging

Thanks!

It looks interesting. I'll read the article tomorrow.

/Anders