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 | | 1 Comments