Porn Stash Database? | Porn Fan Community Forum

Featured New Release

Box cover for Our Forbidden Trio

Our Forbidden Trio
Studio: Team Skeet
Release date: 7/27/2026

all new releases

Participate...

log in
register

Browse...

Etiquette
Active Topics
Popular Topics
Member List
Search

All Forums > Tech Talk > Tech Talk Forum Page 48 > Porn Stash Database?

Author	Post
blackdragontea Senior Member 2322 Posts 2/05	Posted - Jul 16 2005 : 12:31AM This question has probably been raised before; if so, I apologize. Anyway, here it is: any advise on how to construct a good database for a personal porno stash? I have amassed quite a significant collection over the last several years, so much so that by now I'm having trouble keep track of them, like what titles I actually have (versus the ones I merely rented once), and which actresses have appeared in them. I'm trying to put together a searchable database -- something that I can easily search for a title (to see if I have it), or search for an actress so that all the videos that she has appeared in (and are in my possession) can be displayed. Hopefully I can also sort them by some other criteria like genre and so forth. Right now I'm using Microsoft Access. The result is pretty satisfactory, with one exception: I'm not sure how to make it such that the cast will be easily searchable. Currently I basically use a "primitive" method where I establish six "actress" fields (originally I had only 3, planning to shove the rest into an un-searchable "memo" type field -- but pretty soon it became clear that I needed a lot more) for each title so I can enter up to six notable actresses, one in each field. This way I can later use the "Filter by Form" function to "filter" them (basically by asking the software to display all titles that contain, say, "Katsumi" in field 1; or any title that has that name in field 2; or any that has it in field 3; and so on till field 6). But this seems very clumsy to me. First, I have to enter a name to "filter" for six times each time I want to use the database. Second, if there are fewer than six notable actresses, I have to leave some fields blank. But if on the other hand, a movie like Feeding Frenzy 7 (which has about 10 actresses that I'd want to keep track of) comes up, I'll have to either create more fields or leave some out. Is this just the best someone like me, who knows nothing about software programming, can hope for? Or has anyone come up with a better system? Thanks in advance! Edited by - blackdragontea on Jul 16 2005 [Link]
Kperv The Cuddler *struck (She slipped) 1818 Posts 1/04	Posted - Jul 16 2005 : 2:37AM Create a table with one record (row) for each actress. It should have an 'AutoNumber' ID field (column) as primary key. (So should your movie table) Other fields would be her name and any other stats you'd like to keep. Create another table that acts as a 'mapper' table between your movie table and your actress table. It should have two fields. One that contains the ID of a record in your movie table, and one that contains the ID of a record in your actress table. This way you can make as many records in your mapper table as you need, to say which actresses appear in a movie. To make a search query, use Access' graphical query builder to make one that has the mapper table's fields pointing to the movie and actress tables' ID fields, and filter for the name of the actress you're looking for. The mapper table could also have more fields if you want to store information about the part an actress played in a particular movie. Hope that was somewhat intelligible. If not, just ask again (if you dare ). . Perhaps you might also want to take a look at a program called DVD Profiler. A free add sponsored version is available. If I ran Windows, I'm sure I'd be using this program too. [Link]
threesomebody Official BlowBang Judge Would you like my autograph? 2491 Posts 12/04	Posted - Jul 16 2005 : 11:17AM I like that DVD Profiler. I can't seem to find the free version, though. Only a 2 day trial version. [Link]
Kperv The Cuddler *struck (She slipped) 1818 Posts 1/04	Posted - Jul 16 2005 : 11:28AM threesomebody wrote: I like that DVD Profiler. I can't seem to find the free version, though. Only a 2 day trial version. Click to expand It's the same one. Just register it, and it's good to go. For what it's worth, the email addy I used to register some time back, when I tried it out on a old PC I put together, never received any spam. Apart from the adds on the top of the window, the only limitation I can recall is that only the thumbnails of the cover scans are available unless you pay. [Link]
Hurrab Member Denmark, EU 256 Posts 3/03	Posted - Jul 16 2005 : 11:31AM Blackdragontea, you might find inspiration in this thread too. [Link]

threesomebody Official BlowBang Judge Would you like my autograph? 2491 Posts 12/04	Posted - Jul 16 2005 : 11:55AM The best thing about that DVD profiler is all you need to do is enter the UPC code, and the info is automatically filled in from an internet database - cast list, cover art, everything! This includes many porn titles. What a time saver, compared to entering all that data manually. [Link]
Hurrab Member Denmark, EU 256 Posts 3/03	Posted - Jul 16 2005 : 12:10PM Yes, it's good. The Danish translation is far from perfect, though. [Link]
blackdragontea Senior Member 2322 Posts 2/05	Posted - Jul 16 2005 : 5:51PM Thanks for the tips. I'm just learning MS Access so I'm not nearly the expert that you seem to be! But your ideas sound pretty good. I'll try it out and see what happens! Kperv wrote: Create a table with one record (row) for each actress. It should have an 'AutoNumber' ID field (column) as primary key. (So should your movie table) Other fields would be her name and any other stats you'd like to keep. Create another table that acts as a 'mapper' table between your movie table and your actress table. It should have two fields. One that contains the ID of a record in your movie table, and one that contains the ID of a record in your actress table. This way you can make as many records in your mapper table as you need, to say which actresses appear in a movie. To make a search query, use Access' graphical query builder to make one that has the mapper table's fields pointing to the movie and actress tables' ID fields, and filter for the name of the actress you're looking for. The mapper table could also have more fields if you want to store information about the part an actress played in a particular movie. Hope that was somewhat intelligible. If not, just ask again (if you dare ). . Perhaps you might also want to take a look at a program called DVD Profiler. A free add sponsored version is available. If I ran Windows, I'm sure I'd be using this program too. Click to expand [Link]
Tommi Rose Fan Member 161 Posts 4/03	Posted - Jul 16 2005 : 11:57PM simple buddy use cdtree. u will never need anything else. [Link]
MisterNoGood Member 195 Posts 2/04	Posted - Jul 19 2005 : 12:05AM For me the easiest way is to use a small handheld organizer. I just type the info I want to save and it lists the movies alphabetically into any section that I want, and it has built in search features if needed. [Link]

All Forums > Tech Talk > Tech Talk Forum Page 48Porn Stash Database?

Previous topic: Bumping topics w/ new reply
Next topic: Sharp Develops 'Two-Way Viewing-Angle' LCD

Link to this post

Use the code below to link to this topic or a specific post.

URL of this thread

Link to this post with HTML

Link to this post with Forum Code