Creating a simple database, for personal use, what to use?

Discussion in 'OT Technology' started by Marcos, Mar 20, 2008.

  1. Marcos

    Marcos OT Supporter

    Joined:
    Sep 24, 2002
    Messages:
    38,122
    Likes Received:
    0
    Location:
    Great Britain
    I have tons of movies and tv series spread out over several drives and flightboxes etc, just looking to create a simple database that has about 4 bits of info per entry.

    eg. Title, Location, size, season

    i dont mind how i do the data entry so much, but in the end i want a list/view which makes it easy to browse and search, but also want to be able to sort the list by location as well as title. Kinda like most shopping websites let you search and list results in a certain order etc :dunno:

    Do you know of simple way for me to do this?
     
  2. cmsurfer

    cmsurfer ºllllllº

    Joined:
    Jun 6, 2003
    Messages:
    5,079
    Likes Received:
    0
    Location:
    NJ
    I used to use this program http://www.collectorz.com/movie/ to catalog my DVD's. Very simple to use and track what you have. I'm not sure on the location part though.

    You could use MS Access and then use queries to search/sort. You could also just use Excel and use the auto filter function to sort, etc...
     
  3. deusexaethera

    deusexaethera OT Supporter

    Joined:
    Jan 27, 2005
    Messages:
    19,712
    Likes Received:
    0
    Microsoft Access. Alternately, OpenOffice Base. You could use Excel, but it's harder to search through a spreadsheet than it is to search through a real database.
     
  4. dissonance

    dissonance reset OT Supporter

    Joined:
    May 23, 2006
    Messages:
    5,652
    Likes Received:
    1
    Location:
    KS
    I keep an Excel file for mine as well as a catalog website type thing with cover images and imdb links for each title. Sort of a way for friends to also know what I have if they want to borrow one.
     
  5. Marcos

    Marcos OT Supporter

    Joined:
    Sep 24, 2002
    Messages:
    38,122
    Likes Received:
    0
    Location:
    Great Britain
    how did you make it? is there a template or script? thats exactly what i want
     
  6. piratepenguin

    piratepenguin New Member

    Joined:
    Jun 18, 2006
    Messages:
    1,067
    Likes Received:
    0
    Location:
    Ireland
    sqlite would be pretty cool for something small like this, except that I don't know of any great tools that can work with it. Unless Access and OOo Base do? Any other good ones?

    There is a web-based sqlitemanager, never tried it before though. I guess it could do the job.
     
  7. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    if you have a webhost, just throw together a simple mysql/php app. Otherwise, ms access is fine for local use. if you know .net, sqllite works fine.
     
  8. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    not sure if they still do, but back in around 97 or 2000 access did have a "CD Library" template. I'm sure if you check the MS template site they have something.
     
  9. Marcos

    Marcos OT Supporter

    Joined:
    Sep 24, 2002
    Messages:
    38,122
    Likes Received:
    0
    Location:
    Great Britain
    i dont know anything more than basic html and basic dreamweaver, i dont know scripting or PHP etc.

    but something simple like celerondude's uploader but for text would be great.

    would be great if i can make a little offline website out of it too for browsing
     
  10. dissonance

    dissonance reset OT Supporter

    Joined:
    May 23, 2006
    Messages:
    5,652
    Likes Received:
    1
    Location:
    KS
    It's 100% typed in notepad using simple HTML and CSS (the CSS wasn't necessary but I just used it because I already had a similar one for something else). It was time consuming to start, but beyond that the updating takes 1-2 minutes max. I take all of my cover images from amazon.com and then crop/resize in Fireworks.

    Here are a few screens of it (and yes, I've been doing HTML since I was 12 and I still like and find use out of frames):

    click the image for a larger one....
    [​IMG]

    [​IMG]

    and the code for the "A" movies
    [​IMG]



    And all you web coders... bite me about my coding methods. I like it, I know they do not validate according to W3Schools standards. The way I do it has never had a single loading issue in any browser since the mid 90s and I prefer the legibilty of it.
     
  11. Marcos

    Marcos OT Supporter

    Joined:
    Sep 24, 2002
    Messages:
    38,122
    Likes Received:
    0
    Location:
    Great Britain
    its cool :coold: and very close to what i need, but i need something pre-scripted and hopefully with a data-entry form of some sort for adding new items etc
     
  12. dissonance

    dissonance reset OT Supporter

    Joined:
    May 23, 2006
    Messages:
    5,652
    Likes Received:
    1
    Location:
    KS
    All I do is the good ol copy/paste and change a few words and done.
     
  13. Marcos

    Marcos OT Supporter

    Joined:
    Sep 24, 2002
    Messages:
    38,122
    Likes Received:
    0
    Location:
    Great Britain
    yeah but the adding images and all that, plus i want 4 or so different bits of sortable information :hs:

    i need a true database, simple, but working
     
  14. mobbarley

    mobbarley Active Member

    Joined:
    Mar 4, 2005
    Messages:
    9,256
    Likes Received:
    2
    Location:
    Sydney
    If you have access, use that. there are plenty of tutorials on the net to get you going.
     
  15. Pork Chop Sandwiches

    Pork Chop Sandwiches Extraordinary Member

    Joined:
    Feb 25, 2005
    Messages:
    7,217
    Likes Received:
    0
    Location:
    TGP
    The only time I recommend Access is for stuff like this. If you're unfamiliar with RDBMSes, it has wizards for setting yours up. It has wizards for every step. You can achieve the 'offline website' by creating web reports from your reports/queries.
     

Share This Page