I need a database program

Discussion in 'Mac Apps and Mac App Store' started by x704, Oct 1, 2006.

  1. x704 macrumors regular


    Apr 15, 2006
    I need to link some text with a file in OS X, I would also need to search that text and find the file I am searching for. It looks like I can do this in spotlight... Is there a better or easier way to go about this in OS X?

    I could also use a windows version or something similar that will run in wondows. Only the one that needs to run in windows needs to handle much larger quantities of files.

    It would be nice if they are free too.
  2. iGary Guest


    May 26, 2004
    Randy's House
    I can't think of anything better than Spotlight.
  3. MisterMe macrumors G4


    Jul 17, 2002
    Your original request is indecipherable. It might help if you clearly ask for what you want--concentrating on the specific use of the data in the database.
  4. x704 thread starter macrumors regular


    Apr 15, 2006
    I would like to be able to type some text that will relate with a file and then in this database connect the text with the file so later when I search the database with key words be able to find that file.
    If there is nothing then I could make something myself but it would be nice if I did not have to.
  5. MisterMe macrumors G4


    Jul 17, 2002
    Essentially repeating your indecipherable original post does not make it any clearer. If you cannot explain what it is you want to do, perhaps you should do your own search for database at VersionTracker.com and MacUpdate.com.
  6. iSaint macrumors 603


    May 26, 2004
    South Mississippi y'all, near the water!
    Spotlight works. You can also add comments to a files Information to include that in your Spotlight search.
  7. snickelfritz macrumors 65816


    Oct 24, 2003
    Tucson AZ
    You're describing the Spotlight function...

    Select the file in the Finder.
    Choose File>Get Info.
    In the "Spotlight Comments" section of the Get Info panel, type your keywords.
    Press enter, then close the panel.

    Search for your keyword in Spotlight.
  8. generik macrumors 601


    Aug 5, 2005
    Spotlight is pretty bad actually, you can't do a search for something like "lunch appointment" NOT betty
  9. disconap macrumors 68000


    Oct 29, 2005
    Portland, OR
    Small point, but are you actually asking for a database app, because it doesn't seem like it...
  10. plinden macrumors 68040


    Apr 8, 2004
    Well, apparently Spotlight has the APIs to be better (supporting all kinds of complex searches) but OS X's frontend definitely has limitations. But there are third party applications out there that improve on Spotlight. Over at MacWorld, they've reviewed a couple recently:
  11. stcanard macrumors 65816


    Oct 19, 2003
    mdfind "(lunch appointment) (-betty)"


    BTW I know this will come up, so lets get it out of the way -- yes, you can do this without mdfind, from the little hourglass (that most people call "spotlight)"

    Just use the same syntax:

    (lunch appointment) (-betty)

    Hmm, not sure the bracket work, they're supposed to. Works well without them though.
  12. Vinnie_vw macrumors 6502

    Sep 16, 2005
    the Netherlands
  13. Eniregnat macrumors 68000


    Jan 22, 2003
    In your head.
    I think I understand what your looking for. I need an application that will do the following:
    • Organize my files automaticly/semi-automaticly
    • Allow me to index and link documents
    • Author documents on the fly
    • And control media (movie, audio, picts) clutter and accumulation.
    • Export to future versions, as well as to a web compatable format.

    I think what your looking for is something like this. I don't know what to call it, other than an OS database and organizer. As noted above, OSX allows for notes to be added to a file, but not as quickly as with these products.

    Yojimbo by BareBone makers of BBEDIT costs about $30 U.S..

    [http://www.devon-technologies.com/products/devonthink/index.html]DEVONthink[/URL] by Deavon Technolgies. Cost $30 for about the same abilities as Yojimbo, and $75 for the pro version which can export to a lot more formats (like OmniNote). It also interfaces with DEVON's other apps.

    So far, and I have only played with the products for a day, DEVONthink is very powerful, but is a little harder to use and has lots and lots of plug-ins, scripts, and droplets. Admittedly it is a more versatile product, as it has the ability to find concordance between data (notes, pictures, titles, content etc...) and the ability to refine searches. It interfaces with QT easily and directly, and is based off the Safari engine. The Applescripts are neat, but a little cumbersome.

    Yojimbo is very easy to use and has a single tab that appears to the right. Adding data, files, etc is very easy, but it doesn’t play audio or video clips, unlike DEVONthink Pro. I deal with a lot of different media files and creative snips of information.

    Each of these have a 30 day trial, and I think they offer a second 30 day extension.

    The other option is to get a Scrapbook program (like the nifty application in OS 9, not a scrap booking program). xPad is a kind of document orgnizer/scrapbook. iClip which offers clipboard management and can act as a scrapbook (including links to documents) or , a focused media/data scrapbook might also work, but I think your looking for something like I mentioned above.

    I haven’t seen any good reviews of DEVONthink or Yojimbo here. Right now I am really torn between the two products, so any feedback from users of the products would be nice.

Share This Page