I've been thinking of developing a personal database in my computer to retrieve and organise files similar to the way I think. I wonder how stupid it would be to upload huge files to a MySQL database, though (by huge I mean +100mb big files).

Thoughts?

___________________
Indiana Clones Upcoming Sets
[ I May Upload Something Someday ]

I'd say it's a bad idea since DB's are optimized for small quick reads.

___________________



insignificant cor member alliance

Seems massively pointless.

quote:

Originally posted by Cloudburst I'd say it's a bad idea since DB's are optimized for small quick reads.

Relational databases tend to be quite massive.

quote:

Originally posted by DJ Mikey Mike Seems massively pointless.

I would have to agree.

___________________

quote:

Originally posted by bas Dual exhaust tips on dual exhaust = QUAD EXHAUST = 300 gain in horsepower. Duh

quote:

Originally posted by bas Undies with a dickhole aren't good for guys. Your balls can get caught in them. That's why I prefer to go over the gate instead of through the fence.

quote:

Originally posted by DJ Mikey Mike Seems massively pointless.

It's just that I need a better way to retrieve the tons of PDF files I've got... something like Google Desktop and a book cataloguing system combined.

Do you know of a program I could use?

Edit: I could also simply just have the files automatically copied to a particular folder in my computer... but I thought it wouldn't be a bad idea to upload them to a database for security reasons.

___________________
Indiana Clones Upcoming Sets
[ I May Upload Something Someday ]

quote:

Originally posted by gehzumteufel Relational databases tend to be quite massive.

Yeah, but each post usually isn't more than a number or line of text.

___________________



insignificant cor member alliance

quote:

Originally posted by Lira Edit: I could also simply just have the files automatically copied to a particular folder in my computer... but I thought it wouldn't be a bad idea to upload them to a database for security reasons.

http://www.truecrypt.org

___________________

"In a world of illusion you only see what you feel"

quote:

Originally posted by Swamper http://www.truecrypt.org

Looks interesting. Obrigado, Del

___________________
Indiana Clones Upcoming Sets
[ I May Upload Something Someday ]

I'm still not clear on what you are trying to do.

You want to upload PDFs to your database for quick searching through them?

quote:

Originally posted by Scottaculous I'm still not clear on what you are trying to do. You want to upload PDFs to your database for quick searching through them?

That's what I'm getting from what Lira posted. If that's the case, a database is not the right way to go. You need some kind of index app that will do quick searches on your hdd for you, if you say your PDFs are spread throughout your hdd. Also sounds like we could be talking about multiple HDDs too right?

___________________

If you want something to index your files, Google Desktop will do the trick, but truecrypt looks like something up your alley if you're just looking to protect your files.

___________________

Set Archive | TA DJ Challenge

quote:

Originally posted by Scottaculous I'm still not clear on what you are trying to do. You want to upload PDFs to your database for quick searching through them?

Well, here's what I'm going to do: I'm going to create a relational database to organise my books/articles, most of which are PDFs.

For example, Language, by Edward Sapir. It's a linguistics book, so I could just put it in a proper folder, right? But, I want to build some relationships between this work and the context in which it was written, so I can look for similar books/authors more easily. For example, it's a pioneering work of a 'school' called "American Structuralism", and Sapir is behind the "Sapir-Whorf Hypothesis". So I'd tag the book under "American Structuralism" and its author under "Sapir-Whort Hypothesis". Finally, I'd want to be able to take notes and be able to retrieve them along with the book (just like comments in a blog). That's almost done.

But, I was wondering whether or not it would be a good idea to upload not just the information, but also the pdf files themselves to the database. Nothing vital, I just thought it would be safer (and more practical) to have them all in one (somewhat hidden) place rather than scattered all around.

___________________
Indiana Clones Upcoming Sets
[ I May Upload Something Someday ]

Last edited by Lira on Jan-23-2009 at 00:44