Modelling the database

A minimal implementation would consist of the following:

Tables:

Feeds
ID : int (auto incrementing)
FeedName : varchar(256)
FeedURI : varchar(256)
IsActive : boolean

Stored Procedures:

UpdateFeed - manages feed records in the database
ID : int { 0 if this is a new feed, otherwise the number of the feed to update }
FeedName : varchar(256) { name to use to label the feed },
FeedURI : varchar(256) { pointer to the RSS feed },
IsActive : boolean { false will hide the feed from searches }

PseudoSQL :

IF NOT EXISTS ( SELECT ID FROM FEEDS WHERE ID = @ID )
SET @ID = 0

IF @ID=0

INSERT INTO Feeds
(FeedName, FeedURI, IsActive)
VALUES (@FeedName, @FeedURI, True)

ELSE

UPDATE Feeds SET
FeedName = CASE WHEN ISNOTNULL(@FeedName) THEN @FeedName ELSE FeedName END,
FeedURI = CASE WHEN ISNOTNULL(@FeedURI) THEN @FeedURI ELSE FeedURI END,
IsActive = CASE WHEN ISNOTNULL(@IsActive) THEN @IsActive ELSE IsActive END


FindFeed - retrieves a set of feed records from the database
Filter : varchar(50) nullable { if not null then used as a search pattern }

PseudoSQL:

SELECT FeedName, FeedURI
FROM Feeds
WHERE
(IsActive = True) AND
((ISNOTNULL(@Filter)) AND (FeedName LIKE '%' & @Filter & '%'))