Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Creating a database of links

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.
0
Thomas Zucker-Scharff
Asked:
Thomas Zucker-Scharff
  • 3
  • 3
2 Solutions
 
nemws1Database AdministratorCommented:
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".
0
 
Thomas Zucker-ScharffSystems AnalystAuthor Commented:
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.
0
 
nemws1Database AdministratorCommented:
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.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
sameer2010Commented:
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.
0
 
Thomas Zucker-ScharffSystems AnalystAuthor Commented:
Already started trying the excel solution. She isn't comfortable with using delicious.  Started to develop an app on the ipad.
0
 
nemws1Database AdministratorCommented:
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:

http://lifehacker.com/5540019/five-best-bookmark-management-tools

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?
0
 
Thomas Zucker-ScharffSystems AnalystAuthor Commented:
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).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now