|
FAO: MySQL Developers (if there are any)
|
View this Thread in Original format
| Lira |
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? |
|
|
| Cloudburst |
| I'd say it's a bad idea since DB's are optimized for small quick reads. |
|
|
| DJ Mikey Mike |
| Seems massively pointless. |
|
|
| gehzumteufel |
| 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. |
|
|
| Lira |
| 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. |
|
|
| Cloudburst |
| 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. |
|
|
| Swamper |
| 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 |
|
|
| Lira |
Looks interesting. Obrigado, Del :) |
|
|
| 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? |
|
|
| LeopoldStotch |
| 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? |
|
|
| ziptnf |
| 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. |
|
|
| Lira |
| 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. |
|
|
|
|
