I'm not sure if this goes here or in the tech talk section, but I think here would be the place since it deals with porn. I was wondering if anyone had a program or knew of one that can be used to catalogue my porn collection. To keep a database of my porn movies.
I was looking for one this week and finally gave up. I ended up making my own. One nice feature was I set it up to allow me to automatically search for the title in Adult DVD Empire and FivestarDVD. Wish I could link to automatically search for reviews on ADT.
[Link]
DenverDon Benevolent
Firmly Embedded in Depravity 5914 Posts 7/02
Posted - May 2 2005 : 9:19PM
This does belong in Tech Talk.
There has been other threads regarding this, I just can't find it right now.
I didn't look for a program, but created my own using MS Access.
I use a nifty little disc cataloger called Diskbase 5.11. It has really done the job for me to keep track of all of the 3,000 or so CD and DVD's I have burned over the last few years.
I think you can get it for about $20 (the trial is free for 30 days and then the nag screens start up).
I'm glad you brought this up. Some time ago, someone else mentioned using db software, and I asked what they were using. Never got a reply. I'm looking forward to seeing what can be learned this time. :)
I've played around with the database in Microsoft Works. Seems to work fine. I'm not in love with it - the only reason I'm experimenting with it is because it is handy.
Again, I'm looking forward to seeing what others say here, and maybe finding something better. Anybody have any comments on Works and/or db software like it?
Um, DD already said he's using Access, and I'm using Paradox. I was able to purchase Paradox as part of the Corel WordPerfect Office suite for a ridiculously low price. Furthermore, I used to build Paradox databases, so it was a no-brainer for me.
I'm not familiar with MS Access. A quick search, and it looks like it is another MS db app. True? If so, and if you are familiar with the old Works suite and its db, am I missing much by trying to use the Works db?
Also, I see you were asked, "how do you go about making your own...?". When you reply to that, would you mind telling us some of the fields you use? I suppose something like 'Movie Name' is one. :) But what other info do you find useful?
Thanks
[Link]
DenverDon Benevolent
Firmly Embedded in Depravity 5914 Posts 7/02
Posted - May 3 2005 : 1:42PM
willy,
I haven't used works, but there is probably a lot of similarity in the two, Access being perhaps a bit more robust.
I had already done a few things in Access, so it was no problem creating one for me. I haven't used other db software, so I can't compare.
Mine doesn't have all the bells and whistles that other programs may have, especially if a Drew Black worked on it, but it satisfied my needs.
That looks familiar. I may have used it, or something with similar features, once upon a time. But at the time I was needing to keep track of a bunch of zip files. In other words, it was not the just the whole disk itself I needed to keep track of, but the files on each disk too. For that sort of job, it worked great. For cataloging movies - dvds - though, I'm not sure I'd like it as well as a plain old database.
Let me know if I misunderstood the description of DiskBase at that site.
I use Diskbase (yep you got the site correct) because I burn so many movies from usenet on my own as well as a large collection of DVD's.
It does a great job of reading the directories and allowing fields to add sizeable descriptions of the disk. For my DVD's with the title as the disk label it reads the disk label as the default. If no label you can type the name of the movie as the disk label.
For my collection I log the title of the movie, stars and significant action in the directory where I have the movie file(s). Anything extra I want to use I put in the customizable fields. The search features work great and it exports comma delimited reports to excel, access, etc.
D/L the trial version and give it a quick shot. Cheap, works great and nothing to lose!
Newer, no doubt. Makes sense.Similar to me then. I'd done some simple stuff with the Works db, some time ago. Just wondered if I was missing out on something super-duper. :) For what we are trying to do, maybe the newest and bestest is not necessary.He's the db guru? Maybe he will see this and jump in and give some tips and/or ideas. :)
When you have time, describe some of the fields you use.
Hardware: If you are seeing this, can you tell us a few of the fields you use too, please?
By now, if you've been reading this thread and maybe checked out some of the programs mentioned, you've probably got the idea that:
DVDProfiler is not free, and some things are automated for you. Same for DiskBase. You can try DiskBase for a while for free. I think you can with DVDProfiler too... I'd have to go back and check to be sure.
Paradox is commercial software from Corel. Apparently it is a database program. Same for Access. Same for what I've experimented with - MS Works. Works is just old though. :)
Your question: How difficult is it? Depends on a few things. :) I'll say this - If I can do it, it must not be too difficult.
Your first job is picking out which software you want to use. I think you and I are getting good info here and as this thread continues, will continue to get good input.
For now, I'm leaning towards staying with my plain old Works database software for a couple of reasons.
I already have it - no expenditure.
A few others here have already said that they are using database software, making their own databases. Hmm... with their experience, it must not be an all bad idea. :)
I may experiment with DiskBase and DVDProfiler though, just to see if I'm missing out on some feature that I'd really like, that makes it worth it to me. I'm going to keep watch on this thread to see what else I may learn.
To all that have already replied/commented - Thank you!
Looks like we're tracking different things. No surprise there, I suppose. The focus of my database is the actress and her movies, not so much where and when I got a particular DVD.
I have three different tables linked together on a single form. The tables and their fields are: Stars: - Name - DOB - URL (to her website, if any)
Movies: - Star Name - Movie - Studio - Release date (which I rarely bother to fill in)
Pictures: - Star Name - Picture # - Picture
Using the form, I can view a star and see the complete list of her movies, plus browse a selection of her pics. That's assuming I loaded any pics in the db, of course.
Regarding the layout, I opted for a single record from the "Stars" table, with a multi-record list from the "Movies" table below that, and a single record from the "Pictures" table beside the two. This format allows me to peruse the list of an actress' movies while dedicating a large amount of real estate to her pictures.
Since that format means I can only move through the "Stars" table sequentially, I also put in a Search button so I can jump to the record of any star just by typing in her name.
I'd post a screenshot for you but I don't have any webspace and I'm too lazy to sign up for ImageShack, et al, just for the occasional pic.
if there's really a serious interest in this I'll build one and set it up so it integrates with seller's adultdvdmarketplace and adultdvdempire used product listings. (possibly even adultdvdtrader if there's interest)
At present, I have no idea if I can do anything with this, with my old software.
hmm.. hmmm....
I wonder.... some kinda variable .... hmm....
Well - you've given me something to think about. I'm going to root around in the Help section a bit, and see what features I can discover.
Thanks! :)
p.s. If you are familiar with the old software I'm using, and you already know that it is a waste of my time to try, please let me know. :)
[Link]
DenverDon Benevolent
Firmly Embedded in Depravity 5914 Posts 7/02
Posted - May 3 2005 : 3:22PM
I have a main table with a couple of other tables that I can combine in a reporting function. Fields in the main table are:
Title Code (SPC code) Studio Director Status (own or waitlist, and can produce a waitlist report for ordering) Review (links to reviews, but not necessarily ALL reviews) Production Date MY rating 1-5 Remarks DocComp (is my documentation for the film complete or pending) Cost (what I paid for it.
Secondary Table: Starlets and some of their Bio data. I use this to link together with data from the main table, using the SPC code to create the link in a report function.
In my report it will list the movie, a rating, and the stars in the movie. From this I have also made it so I can click on a stars name and then pull up a secondary report of all the movies for THAT starlet that I own. I don't list all the movies she has made but am interested only in what I own in case I want to pull another movie out to watch one of her scenes.
Like I indicated, nothing too fancy but it serves my needs.
I built my simple catalog application in Delphi which is not a particularly common tool but powerful and fast. A more common choice would be to use Access. The database is actually an Access database. Access supports a field type of OLE Object if you want to store cover art or other graphics along with the dvd information.
I created a number of buttons that link into site search engines to look up titles on the web. The primary trick is to replace characters that cannot be allowed in the site link. For example:
This takes the title in my database and replaces spaces with + and # with %23 and generates a search in a browser for the title on the ADE web site. The replacement is needed to allow for the search to work properly. In VB my ReplaceString function is called Replace(). This is fairly technical but the same thing can be done in Access or other tools. I will try to build the correct code if someone needs it.
Since this is a standard link to ADE I do not think that I am doing anything inappropriate to link to them. The same approach can be used to access ADE sample screens, Fivestar, and other sites that are linked by the ADE web site. I would like to automatically pull down the cover art into my database. You have to be careful because if you pull down the graphic directly (bypassing the web page) it may be considered a violation by the site owner. I would also need permission to use the graphics which are watermarked.
I can also use this feature to look up a title I want to buy from my application. Hopefully I will add the DVDTalk links shortly to my list.
I can post some sample screen shots if someone can tell me how.
Thanks for the link Drew. Only thing I needed to do was to eliminate the # or %23 to successfully find most titles.
Do you have a link for the price search to allow me to get prices for other titles in a series? I want to be able to view a title, strip the number off it and search for the full series.
The process of converting text strings to URL format is known as 'URL encoding'. You should be able to find a function/script on the internet to easily accomodate this for you.
DVDProfiler is free with Ads and low res images, pay for no ads and high res images.
To an extent what you have written for it works. All the entries in the database are done by the users, so if someone has entered the disc (or disc ID for ROM entry) the info pops right up. If no one has yet, then you have to enter the title and get no info for it.
I've found that most older adult films from the major studios are entered, new ones take a while to get entered though.
It's not bad, it takes up a chunk of storage space though.
Well I just tried DVDProfiler on the 2 day trial. Unfortunately it doesnt seem to recognize Adult DVDs when I put them in my DVD drive, so I have to enter the manually. Yet it recognized the majority of my mainstream DVDs.
Using technology to fix all the problems technology has caused will doom us all!
The only information that I like to catalogue is the movie title and the babes in the movie. Creating a program always seemed like too much trouble since I dont know that much about computors, so for years I have used a small handheld organizer. I just type in the info I need and it automatically lists the movies into alphabetical order in any section that I want and it has built in search features when needed.
great thread folks! up til now i've just been using windoze to disk and fibre lto tape in a homemade san raid. as I'm up to a couple terabytes at this point it sure would help to be able to search my database using different criteria. anybody know what size a movie in the hd format will be?