Database Project: Bookmarks Database

This project reads the bookmarks from your browser and stores it in a database. The bookmark database consists of:

users table

  • userid
  • name
  • email

Bookmarks table

  • UserId
  • Title
  • URL
  • tags ( a list of comma separated tags)
  • Share (boolean - Yes or No)

This can be a desktop application or a web application:

0. User logs in (uses email and password previously assigned)

1. Application displays a text box with a browse button

2. User can locate the bookmark and upload it

3. All the bookmarks are displayed in a table

4. Each bookmark has two check boxes - one to import another to share

5. User marks the bookmarks to be imported (and a subset of them to be shared with others) and chooses Store in database

6. These bookmarks are written to the database with the user id. If it can be shared, the shared column is set to true

References:

1. Netscape bookmarks file format

2. Exporting Favorites/Bookmarks from Internet Explorer

3. Locating bookmarks file in Netscape, Mozilla, Firefox

Posted in bookmarks, dbproject, nttf, rdb on August 27th, 2007 by Dorai | |

One Response to ' Database Project: Bookmarks Database '

Subscribe to comments with RSS or TrackBack to ' Database Project: Bookmarks Database '.

  1. Dorai Thodla said,

    on September 21st, 2008 at 1:41 pm

    It will be better to have richer tags as name value pairs (project:iic or project=iic). Users can define their own tags. May be like machine tags in Flickr (I have not looked at them closely).

    Also the tag space can be divided into:
    Private Space
    Group Space
    Public Space

    Private is only for you.
    Group is for your designated groups.
    Public for every one.

Leave a reply