TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- FAO: MySQL Developers (if there are any)
Pages (2): [1] 2 »

FAO: MySQL Developers (if there are any)

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?

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

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 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.

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.

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

quote:

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

Looks interesting. Obrigado, Del

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.

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.

Are you going to index the PDFs to make them searchable?

Hire a mexican?

I'm a "Mexican"

quote:

Originally posted by gehzumteufel Are you going to index the PDFs to make them searchable?

I intend to do that... but I don't know how I can do that without uploading them to the database... I'm not really a programmer, you know? I just like to play with fancy toys

edit: Oh, I found this. Any of you ever used the XPDF package?

quote:

Originally posted by Lira I'm a "Mexican" I intend to do that... but I don't know how I can do that without uploading them to the database... I'm not really a programmer, you know? I just like to play with fancy toys edit: Oh, I found this. Any of you ever used the XPDF package?

nah. There's the core PDF API Package. Have you checked that out?

You don't need to upload files to a database; you can merely organize the file structure in the database, and retrieve the files from their position via the database.

quote:

Originally posted by LeopoldStotch nah. There's the core PDF API Package. Have you checked that out?

No, not yet. But I'm reading the manual now, thanks

quote:

Originally posted by DJ Shibby You don't need to upload files to a database; you can merely organize the file structure in the database, and retrieve the files from their position via the database.

The more I read, the more I see I'll end up doing that

I would just store references to the files in the database. Like someone else mentioned, for the most part random access databases are better at pulling back small bits.

Then again, if you store all the meta-data in one table and the PDFs/Files in another and just relate them then it wouldn't be that bad.

Blob blob blob...

quote:

Originally posted by Lira No, not yet. But I'm reading the manual now, thanks The more I read, the more I see I'll end up doing that

Happy coding!

Re: FAO: MySQL Developers (if there are any)

quote:

Originally posted by 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?

So your going to install a web server , mysql and prob php or asp on your PC just so you can find files ? whats wrong with using VISTA indexing tool or Google desktop ? , also what is the point of storing files within a database ? your windows file system is practically a database ? maybe im missing something...

Re: Re: FAO: MySQL Developers (if there are any)

Thanks, Shibby

quote:

Originally posted by Rostros whats wrong with using VISTA indexing tool or Google desktop ?

I can't use tags in either, can I? I can only add tags to MS Office files on Vista

You can add keywords to PDFs in Vista. Right Click -> Properties -> PDF tab -> Keywords.

tag2find helps you to find everything on your desktop by simply using tags. Directories & folders were the structure of the 20th century. Now it's time for something new - TAG IT!

http://www.tag2find.com/

-Create your own world of information.
-Tag files to be easily and quickly accesible.
-Forget about the traditional structures.


How about this ?

quote:

Originally posted by DJ Mikey Mike You can add keywords to PDFs in Vista. Right Click -> Properties -> PDF tab -> Keywords.

Oh. I'm going to check it out later today then (the computer I'm using right now is running Win XP), and I'm downloading tag2find as I type.

Thanks, guys

Powered by: vBulletin
Copyright © 2000-2021, Jelsoft Enterprises Ltd.