Creating a database of links

Posted on 2013-06-10
Medium Priority
Last Modified: 2013-06-14
My wife wants to create a database of links for her various different classes.  She is a university instructor.  She keeps a word file full of categorized URLs, which she uses in her classes.  She only uses some in each class.  I know I could easily make his into a database, but I'm wondering if someone has already done this - I don't want to recreate the wheel.
Question by:Thomas Zucker-Scharff
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 23

Expert Comment

ID: 39236188
I would think something like http://delicio.us/ is what you want to use.

She just needs to tag each saved bookmark accordingly, like "classes" and "XY320", then search for these tags when teaching class "XY320".
LVL 29

Author Comment

by:Thomas Zucker-Scharff
ID: 39236617
thought  of that but she wants something standalone that can generate reports based on the attributes of each link.  delicious might work otherwise.   also she would like to be able to import an existing word file.
LVL 23

Expert Comment

ID: 39236643
The import is a tall order. Even with Delicio.us, you need to add the tags and there's no easy way of doing that that I know of.

Bit.ly does URL tracking and graphing. She might need to generate bit.ly urls for all her other urls, but she can track the usage of her links then.

Eve if she's got 100+ links, it wouldn't take more than a couple hours to do all this setup.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 13

Assisted Solution

sameer2010 earned 800 total points
ID: 39237074
How about putting it into a simple xls having columns to identify categories and links?

E.g. Category1, Category2, Category3, Link, Other Related Categories i.e. 3 prominent categories per link and all other go to Others. You can change this to suit your needs.

Excel would be light, very easy to maintain, found across devices.
LVL 29

Author Comment

by:Thomas Zucker-Scharff
ID: 39237887
Already started trying the excel solution. She isn't comfortable with using delicious.  Started to develop an app on the ipad.
LVL 23

Accepted Solution

nemws1 earned 1200 total points
ID: 39237904
Delicio.us too open? (you can make your links all private, but then they are hard to share with others).

I teach as well (and work at a University as well), so I'm just curious.  It sounds like she's put a lot of work into generating this list of links and wants to more easily maintain and share it.  That screams 'web-based solution'.  An iPad app *has* to be 10x more work than using an online solution and 10x less-usable (not everybody can afford one or wants to use an Apple product).  Maybe one of these (although Delicio.us is in this list) would be usable:


Or maybe a home-brew solution - if you're willing to develop an iPad app, maybe you'd be willing to develop a PHP/web-based app instead?
LVL 29

Author Closing Comment

by:Thomas Zucker-Scharff
ID: 39248834
Thanks for all the feedback.  I haven't gotten back to you because I felt this was unresolved.  Thanks for the suggestions, I loved the lifehacker article and I used the idea of putting it into a spreadsheet to convert to spreadsheet then to database.  I'm creating a database for her to enter the info (almost done).

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question