The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Database/Catalog with Pictures?

    Discussion in 'Windows OS and Software' started by stewie, Jul 9, 2008.

  1. stewie

    stewie What the deuce?

    Reputations:
    3,666
    Messages:
    2,174
    Likes Received:
    0
    Trophy Points:
    55
    Any good suggestions on a local(preferably not online) database software that can also add/hold pictures? I want to create a database/catalog for many different items, but when I pull up the information by the item# for example, I also want a picture in it on top of the description. I know M$ Access 2007 has added the picture capability, but I want to see if there are better options.

    Thanks.
     
    stewie, Jul 9, 2008
    #1
  2. Greg

    Greg Notebook Nobel Laureate

    Reputations:
    7,857
    Messages:
    16,212
    Likes Received:
    58
    Trophy Points:
    466
    What is the front end application going to be? I'm thinking you might be able to serialize the bits and store it in MySQL (which can be configured to work locally) directly.

    Depending on the app, either that will work or just storing a file location in the database program which your app will retrieve.
     
    Greg, Jul 9, 2008
    #2
  3. stewie

    stewie What the deuce?

    Reputations:
    3,666
    Messages:
    2,174
    Likes Received:
    0
    Trophy Points:
    55
    Thanks for the reply, Greg.

    You see, that's the thing, I actually need a complete software package, I'm not sure what front end to use. Products like Quicken can also do inventory, but problem is it cannot store pictures.

    As for MySQL, I played with Gallery2 and Coppermine before, they're an online photo gallery, which can actually work in my case. But I'm not sure how easy it is to install MySQL locally since I've never done it myself, and don't know how heavy MySQL is to run in a regular PC or notebook.

    Something like Quicken with pictures would be perfect I think.

    :)
     
    stewie, Jul 9, 2008
    #3
  4. stewie

    stewie What the deuce?

    Reputations:
    3,666
    Messages:
    2,174
    Likes Received:
    0
    Trophy Points:
    55
    Just found out that Quicken has a home inventory product, but can only hold hundreds of items according to their FAQ. :confused2:
     
    stewie, Jul 9, 2008
    #4