Greetings all..

I believe I am coming to the point where I may need a relatively simple database to keep track of files and their corresponding MD5 strings:

 

Currently my server stores 1000+ DVD’s as ISO’s.

 

I currently use an EXCEL spreadsheet to keep track of the MD5 strings associated with each ISO.

 

I should like a small database to reside on, and run on my unRAID server: it should be scriptable.

 

Initial thoughts have led me to think / hope / believe that SQLite may be what I require for the following reasons:

 

1 – Can be controlled from the CLI , therefore scriptable

2 – Windows, Linux and OSX GUI Managers are freely & widely available

3 – If things get WAY bigger database-wise, there is an upgrade path to a more powerful SQL engine / application.

 

But from what little I have been able to ascertain it seems that SQLite needs PYTHON.

 

Is there a PYTHON package I can run on unRAID?

Is there an SQLite package I can run on unRAID?

 

Please bear in mind I am a complete NOOB when it comes to LINUX.

 

UnRAID Specs:  Celeron 3.6GHz – 4GB RAM –  SAMSUNG 1TB x 5 & SAMSUNG 750GB x 5 – PRO Licence (no cache disk)

 

Any thoughts or recommendations greatly appreciated.

 

DRCHIPS

If all you have is 1000+ records, and only a few fields (date, filename, path, MD5) you don't need SQL... just use a flatfile. 

 

You could even do the whole thing as a bash script.

DVD Profiler. Host the db on Unraid. Brilliant cataloging of video. Barcode scanner to scan media barcodes. Add by movie title, EAN (like an ISBN code), media. Details can then be exported (xml), printed for hard copies. Includes cover art, description, dates, actors and actresses.

 

I dont generally recommend software but DVD profiler is very good. Free trial for upto 50 titles I think. I used to use it as a catalog. Now I use it to easily add new titles to my Cinemar system and provide a backup of my collections details.

 

I'd add the MD5 in personal information notes field. Not sure it meets your CLI requirements but XML export should be easy to use in python.