LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 11-23-2011, 09:15 AM   #1
tauro_kpo
Member
 
Registered: Feb 2007
Distribution: Debian
Posts: 91

Rep: Reputation: 15
Question How can I organize this data? Using a database?


Hello everyone,

I have a lot of texts and books I've read here on my house, and what I want is to systematise them in a list or database (I don't know how should it be called). In order to be able to type the name of the author, and get all the names of the books that I have from this author, their years of publication, and other complementary data that belongs to each book. Or maybe type a year, and get a list of all the books that I have, that have been published in that year.

How can I do this? I ask this here because I have never used databases, nor I have any clue of how should I do this.

Can anybody please help?

Thank you very much in advance!
 
Old 11-23-2011, 11:56 AM   #2
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,541

Rep: Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060
You can certainly design a data base, such as using MySQL or PostgreSQL and develop a web page incorporating PHP for data entry and viewing. That is doable but there is a learning curve curve involved.

Alternately, you could use a collection manager program, such as Tellico http://tellico-project.org/, which is specifically designed for book, CD, video and other collections (and works beautifully).

The one downside? You'll need to install KDE -- it looks like you're using Ubuntu, which uses Gnome, and Tellico is built on KDE libraries (and I don't know if KDE is available for Ubuntu, but my guess would be that it is).

An alternative would be Google for "book collection manager" which turns up a bunch of them for you to evaluate, some aimed at libraries some aimed at individual collectors. One that appears to be quite popular for Gnome users is Alexandria (http://alexandria.rubyforge.org/); probably worth a look-see.

Hope this helps some.

Last edited by tronayne; 11-23-2011 at 12:00 PM.
 
Old 11-23-2011, 08:58 PM   #3
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Debian, Mageia, and whatever VMs I happen to be playing with
Posts: 12,490
Blog Entries: 16

Rep: Reputation: 3208Reputation: 3208Reputation: 3208Reputation: 3208Reputation: 3208Reputation: 3208Reputation: 3208Reputation: 3208Reputation: 3208Reputation: 3208Reputation: 3208
This would be a great way to learn sql. I am convinced that having a real-time problem to solve is the best motivator for learning.

If you need a short-term solution, a spreadsheet would be one option.
 
Old 11-25-2011, 05:02 AM   #4
salasi
Senior Member
 
Registered: Jul 2007
Location: Directly above centre of the earth, UK
Distribution: SuSE, plus some hopping
Posts: 4,062

Rep: Reputation: 893Reputation: 893Reputation: 893Reputation: 893Reputation: 893Reputation: 893Reputation: 893
Quote:
Originally Posted by tauro_kpo View Post
I have a lot of texts and books I've read here on my house...
If this really is a large number, be sure that you do not underestimate the data entry problem. Repeatedly entering author details, isbn, date of publication (and edition(s) you have) can get quite old quite rapidly, and checking the data, particularly spellings of author names is non-trivial, too. You might consider a system which allows you to get the data from a publicly-accessible database and import it (eg, a bibliography manager), because that might save you the most boring part. On the other hand, if you think that twenty is a large number of books, then that wouldn't be worth bothering with
 
Old 11-25-2011, 09:04 AM   #5
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,541

Rep: Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060
The reason that I suggested Alexandria, a GNOME application, is that you enter your books using the ISBN and Alexandria searches Amazon.com, the Library of Congress and a number of other sources for all of the other information about the book and download that data for you; e.g., the title, author(s), copyright date, publishing date, publisher, Dewey Decimal Number, LOC number, etc., etc. -- even an image of the cover. Take a look at the features page at http://alexandria.rubyforge.org/features.html to see what I mean.

I've been doing data base design and engineering for over 30 years and, although I thought, "Gee, it would be pretty easy to just do a data base for this stuff," it occurred to me that entering all the information by hand (or designing the functions for searching and downloading the various data formats from public sources) would be a real pain. As it happens I have a library of over 2,500 books and believe me, I did not want to do them by hand! I elected to use Tellico because I do use KDE rather than GNOME but I believe Alexandria and Tellico are functionally similar.

The only down-side I can see is that Alexandria will not run right now on Ubuntu 11.10:
Quote:
Due to changes in the latest ruby-gnome2, packaged with Ubuntu 11.10 (oneiric), Alexandria no longer works on that platform. A new bugfix release is planned to fix this issue.
I would anticipate that will be fixed post-haste see http://alexandria.rubyforge.org/.

Hope this helps some.
 
Old 11-26-2011, 10:46 AM   #6
makyo
Member
 
Registered: Aug 2006
Location: Saint Paul, MN, USA
Distribution: {Free,Open}BSD, CentOS, Debian, Fedora, Solaris, SuSE
Posts: 729

Rep: Reputation: 75
Hi.

See also responses at http://www.linuxforums.org/forum/new...-database.html ... cheers, makyo
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
xml: is it useful to organize my personal data collection? xri Programming 5 12-19-2010 06:15 PM
Processing data from a 'foreign' database with mysql, or tools to pre-process data. linker3000 Linux - Software 1 08-14-2007 08:36 PM
Database or Spreadsheet solution to Organize/Inventory CD collection? sidewalking General 2 05-31-2007 12:52 PM
adding data to mysql database ? rharris72 Programming 6 01-30-2006 03:07 PM
pulling data from mysql database zuessh Linux - Software 5 05-29-2003 09:13 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:42 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration