473,320 Members | 2,146 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

ASP design question

If I wanted to write my own blog application, what functionality should it
contain?

TIA...

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
Jul 22 '05 #1
4 1399
Most of the work for the functionality is admin, IMHO.

The necessary things client-facing should be:

- view posts (maybe broken down by topic area / author)
- view archives
- post comments (anonymous or register/login)
- subscribe to RSS

I built one last week that had the above functions, and it took all of two
days. Yes, there is existing software out there, but I prefer to have
ownership and design choices on the schema. I also don't like the learning
curve of someone else's software, if I can avoid it, and the ability to move
my software to another web server with minimal impact (e.g. uninstall and
reinstall some blogger crap) was pretty important.

Optional features include things like allowing users to pick frilly CSS
things like color scheme or even overall template style.

For the admin side, authors need to:

- create / edit posts (and this should automatically update the RSS feed...
you can have the RSS feed be dynamic, but I prefer to rebuild the XML file
whenever a change is made... this is much less taxing on the server)
- remove comments (I know, censorship is bad, but if anonymous posts are
allowed, they could be callous, slanderous, etc. depends on the type of
blog and whom it represents, I suppose)
- view statistics

--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.


"Roland Hall" <nobody@nowhere> wrote in message
news:Ox**************@TK2MSFTNGP10.phx.gbl...
If I wanted to write my own blog application, what functionality should it
contain?

TIA...

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp

Jul 22 '05 #2
"Aaron [SQL Server MVP]" wrote in message
news:OR**************@TK2MSFTNGP09.phx.gbl...
: Most of the work for the functionality is admin, IMHO.
:
: The necessary things client-facing should be:
:
: - view posts (maybe broken down by topic area / author)
: - view archives
: - post comments (anonymous or register/login)
: - subscribe to RSS

I've seen some that end discussions and no longer allow posts. I've seen
some end after a few days. What do you think would be the reasoning for
ending a discussion that soon or at all? Unless the info is outdated, I'm
at a loss.

: I built one last week that had the above functions, and it took all of two
: days.

ASP/SQL? All SPs?

: Yes, there is existing software out there, but I prefer to have
: ownership and design choices on the schema.

I agree. Why be limited and why follow a design you may not agree with.
Then there are copyright issues.

: I also don't like the learning
: curve of someone else's software, if I can avoid it, and the ability to
move
: my software to another web server with minimal impact (e.g. uninstall and
: reinstall some blogger crap) was pretty important.

Did you add, or would it be advisable to add an index for new comments
within a certain time frame?

: Optional features include things like allowing users to pick frilly CSS
: things like color scheme or even overall template style.
:
: For the admin side, authors need to:
:
: - create / edit posts (and this should automatically update the RSS
feed...
: you can have the RSS feed be dynamic, but I prefer to rebuild the XML file
: whenever a change is made... this is much less taxing on the server)

Not ever having produced an RSS feed, I'll need to research.

: - remove comments (I know, censorship is bad, but if anonymous posts are
: allowed, they could be callous, slanderous, etc. depends on the type of
: blog and whom it represents, I suppose)

Should you require a registration to post?

: - view statistics

What statistical processing should be included?

: --
: Please post DDL, sample data and desired results.
: See http://www.aspfaq.com/5006 for info.

Not sure what at 5006 is relevant here.

Do you have a working example online?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
Jul 22 '05 #3
> What do you think would be the reasoning for
ending a discussion that soon or at all?
- keep focus on current articles?
- keep the database small (e.g. delete comments for older articles)?
ASP/SQL? All SPs?
Yes, about 80 lines of ASP/HTML code I think, and a half dozen stored
procedures. Mail me offline and I'll show you... I'm a little afraid of
what joe public will do to it, since I'm not exactly a fan favorite around
here. The admin side is a little more complex, but only because I'm an
overachiever. :-)
Did you add, or would it be advisable to add an index for new comments
within a certain time frame?
I don't know what you mean. Comments are associated with a posting/article
whatever you want to call it, and are displayed after the article in either
ascending or descending order. So if you want to index performance, maybe
you have this:

CREATE TABLE dbo.BlogPosts
(
BlogPostID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
dt SMALLDATETIME NOT NULL DEFAULT GETDATE(),
title VARCHAR(255) NOT NULL,
body TEXT
--, other columns yadda yadda
)
GO

CREATE INDEX dt ON dbo.BlogPosts(dt)
GO

CREATE TABLE dbo.BlogPostComments
(
BlogPostCommentID INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED,
-- not necessary for the IDENTITY column, but makes it easier
-- from a management perspective, e.g. Delete comment x
BlogPostID INT NOT NULL
FOREIGN KEY REFERENCES dbo.BlogPosts(BlogPostID),
dt SMALLDATETIME NOT NULL DEFAULT GETDATE()
--, name, email, body yadda yadda
)
GO

CREATE CLUSTERED INDEX id_dt ON dbo.BlogPostComments
(
BlogPostID,
dt -- DESC if you want last comment listed first
)
GO

Now, you could get more complicated than that, for example you could show
replies in a threaded fashion like a newsgroup, so I could reply to a
comment and it would visually show me that I replied to the comment, not to
the original article. Most blogs, I think, don't require that level of
sophistication -- this can lead to recursive queries and poor performance if
the nesting gets too deep.
Not ever having produced an RSS feed, I'll need to research.
It's really not a lot of work. Basically you just have an XML entry for
each post, or maybe your feed only shows the most recent 20 articles, or
only those that were posted or have comments that were posted in the last 3
days. It can be that dynamic and then some...
Should you require a registration to post?
I think it's a bad idea, unless the user is really going to get something
out of registering. People tend to shy away from sites that require
registration.

Of course, if you don't have registration, there is no accountability, and
you will become a moderator / babysitter for those that can't keep their
temper in check or just like to cause problems.
What statistical processing should be included?
I have article views by date range (e.g. What were the top 5 most popular
articles viewed this week), which articles have the most comments, the most
recent comments, etc.
Not sure what at 5006 is relevant here.


That's just my signature in Outlook Express on my PC at work. (See the --,
that's a sig separator.)

--
Aaron

Jul 22 '05 #4
> I'm a little afraid of what joe public will do to it,
since I'm not exactly a fan favorite around here.


Tell em all to GFT!! <g>

Strange isn't it...... not a fan favourite, but when they need something, your site is most often the first one they go to :o\

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message news:BE677EF2.46D8%te*****@dnartreb.noraa...
What do you think would be the reasoning for
ending a discussion that soon or at all?


- keep focus on current articles?
- keep the database small (e.g. delete comments for older articles)?
ASP/SQL? All SPs?


Yes, about 80 lines of ASP/HTML code I think, and a half dozen stored
procedures. Mail me offline and I'll show you... I'm a little afraid of
what joe public will do to it, since I'm not exactly a fan favorite around
here. The admin side is a little more complex, but only because I'm an
overachiever. :-)
Did you add, or would it be advisable to add an index for new comments
within a certain time frame?


I don't know what you mean. Comments are associated with a posting/article
whatever you want to call it, and are displayed after the article in either
ascending or descending order. So if you want to index performance, maybe
you have this:

CREATE TABLE dbo.BlogPosts
(
BlogPostID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
dt SMALLDATETIME NOT NULL DEFAULT GETDATE(),
title VARCHAR(255) NOT NULL,
body TEXT
--, other columns yadda yadda
)
GO

CREATE INDEX dt ON dbo.BlogPosts(dt)
GO

CREATE TABLE dbo.BlogPostComments
(
BlogPostCommentID INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED,
-- not necessary for the IDENTITY column, but makes it easier
-- from a management perspective, e.g. Delete comment x
BlogPostID INT NOT NULL
FOREIGN KEY REFERENCES dbo.BlogPosts(BlogPostID),
dt SMALLDATETIME NOT NULL DEFAULT GETDATE()
--, name, email, body yadda yadda
)
GO

CREATE CLUSTERED INDEX id_dt ON dbo.BlogPostComments
(
BlogPostID,
dt -- DESC if you want last comment listed first
)
GO

Now, you could get more complicated than that, for example you could show
replies in a threaded fashion like a newsgroup, so I could reply to a
comment and it would visually show me that I replied to the comment, not to
the original article. Most blogs, I think, don't require that level of
sophistication -- this can lead to recursive queries and poor performance if
the nesting gets too deep.
Not ever having produced an RSS feed, I'll need to research.


It's really not a lot of work. Basically you just have an XML entry for
each post, or maybe your feed only shows the most recent 20 articles, or
only those that were posted or have comments that were posted in the last 3
days. It can be that dynamic and then some...
Should you require a registration to post?


I think it's a bad idea, unless the user is really going to get something
out of registering. People tend to shy away from sites that require
registration.

Of course, if you don't have registration, there is no accountability, and
you will become a moderator / babysitter for those that can't keep their
temper in check or just like to cause problems.
What statistical processing should be included?


I have article views by date range (e.g. What were the top 5 most popular
articles viewed this week), which articles have the most comments, the most
recent comments, etc.
Not sure what at 5006 is relevant here.


That's just my signature in Outlook Express on my PC at work. (See the --,
that's a sig separator.)

--
Aaron


Jul 22 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Don Vaillancourt | last post by:
Hello all, Over the years as I design more database schemas the more I come up with patterns in database design. The more patterns I recognize the more I want to try to design some kind of...
9
by: sk | last post by:
I have an applicaton in which I collect data for different parameters for a set of devices. The data are entered into a single table, each set of name, value pairs time-stamped and associated with...
2
by: Test User | last post by:
Hi all, (please excuse the crosspost as I'm trying to reach as many people as possible) I am somewhat familiar with Access 2000, but my latest project has me stumped. So, I defer to you...
6
by: rodchar | last post by:
Hey all, I'm trying to understand Master/Detail concepts in VB.NET. If I do a data adapter fill for both customer and orders from Northwind where should that dataset live? What client is...
17
by: tshad | last post by:
Many (if not most) have said that code-behind is best if working in teams - which does seem logical. How do you deal with the flow of the work? I have someone who is good at designing, but...
17
by: roN | last post by:
Hi, I'm creating a Website with divs and i do have some troubles, to make it looking the same way in Firefox and IE (tested with IE7). I checked it with the e3c validator and it says: " This...
6
by: JoeC | last post by:
I have a question about designing objects and programming. What is the best way to design objects? Create objects debug them and later if you need some new features just use inhereitance. Often...
0
by: | last post by:
I have a question about spawning and displaying subordinate list controls within a list control. I'm also interested in feedback about the design of my search application. Lots of code is at the...
19
by: neelsmail | last post by:
Hi, I have been working on C++ for some time now, and I think I have a flair for design (which just might be only my imagination over- stretched.. :) ). So, I tried to find a design...
8
by: indrawati.yahya | last post by:
In a recent job interview, the interviewer asked me how I'd design classes for the following problem: let's consider a hypothetical firewall, which filters network packets by either IP address,...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.