Movie database



    I have, for some years now, been downloading and curating videos, mostly movies, covering the last 120 years.

   There is a lot of work in acquiring and managing the collection. Methods of acquistion that were valid ten years ago, do not work today. Continual adaptation to the current technology is needed.

   But I digress. During work with my system, I discovered the router was building a hidden database of  the contents of drives connected to the router. The file format is SQLite.

   The online movie database IMDB, allows users to download the dataset. I did, and used a Python script, I discovered online, to create an IMDB database file in SQLite format.

   For years, I've been cataloging all my disks using a small but fast cataloger named Cathy. All my movie drives are included. I hope to connect the databases together. Cathy can export a text file of a drive's contents.

   There are two Movie database catalogers I know of that can export data to a csv format text file. This can easily be imported into an SQLite database and then connected to another database. This would be the SQLite database of my collection.

1. IMDB database via a Python script and IMDB

2. My collection database via my TP-Link router

3. database connecting my collection to the IMDB database via a movie cataloger or a Cathy text file export.

   Eventually, detailed information about each movie in the collection will be available from my laptop. 


  

Comments

Post a Comment

Popular posts from this blog

Drive rack, ventilation and wiring.

 My drives have a new rack to hold them. Hot glue and square wood dowels provided the materials with which to build the rack. I used zip ties and a small computer fan attached to the end of the rack to provide cooling air ventilation for the drives. This will increase the lifetime of the drives. Previously the were stacked on top of each other and became noticeably warm during use. The wiring really was bad. Too many cables/wires held together with zip ties. I added a surge protected outlet strip of a newer, more sophisticated design. I rearranged the system wiring to minimize the number of outlet strips and the disarrayed wires. Two strips were screwed to the wall. One was removed. The circular strip was moved from the entertainment center to a work table beside the other two strips and combined with them to supply all devices attached to the system. The strip removed replaced the circular strip in the entertainment system.  Overall, the current setup works better. Both syste...
Read more

Philips Hue lights Updated

 Philips Hue lights are known for the ability to program brightness, saturation, and hue using software. Most people use one or more cellphone apps to control their Hue lights. I've a history in computrer science and electronic technology and engineering, so took this up as a new interest. WiFi control of light bulbs' colors has interested me ever since I read aboout the topic some years ago. There happened to be seven Hue bulbs available from one eBay seller and for a reaosnable fee, approximately $20. A bridge device is used to communicate with the bulbs, so I waited for a good deal on eBay and got one. Philips has evolved a developer community and resources for those who want to explore the possibilities in lamp light control. The user joins the communnity and gets a temporary API key, formerly referred to as a 'username', good for one session. Then a browser or app, can be used to send commands to the bulbs. There are other avenues of communication. Python libraries...
Read more

Jellyfin media server

 The owner of Emby has blocked my using the WebOS access method of using Emby. I discovered the method and posted on the product's forum. That software is no longer my media server and has been removed from my computers. I replaced Emby with Jellyfin. Jellyfin is the evolved Emby open sourced. Emby was originally open source (and free) but was privatized and monetized by the creator. Many considered that move unethical.  The last open source version became the basis for Jellyfin,  easily competitive with Emby and almost, if not equally, well known. I've been using Jellyfin for about a year, perhaps more. The software has issues but is in constant development but is very useful in the current state, version 10.8.5.
Read more