Become a part of the TranceAddict community!Frequently Asked Questions - Please read this if you haven'tSearch the forums
TranceAddict Forums > Main Forums > Chill Out Room > FAO: MySQL Developers (if there are any)
Pages (3): [1] 2 3 »   Last Thread   Next Thread
Share
Author
Thread    Post A Reply
Lira
Ancient BassAddict



Registered: Nov 2001
Location: Brasilia, Brazil
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?


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

Old Post Jan-22-2009 18:21  Brazil
Click Here to See the Profile for Lira Click here to Send Lira a Private Message Visit Lira's homepage! Add Lira to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Cloudburst
I am the maximum



Registered: Oct 2003
Location: Jötebårj

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


___________________



insignificant cor member alliance

Old Post Jan-22-2009 18:35  Finland
Click Here to See the Profile for Cloudburst Click here to Send Cloudburst a Private Message Visit Cloudburst's homepage! Add Cloudburst to your buddy list Report this Post Reply w/Quote Edit/Delete Message
DJ Mikey Mike
Your mum's face



Registered: Jan 2002
Location: I'm at your mums'

Seems massively pointless.

Old Post Jan-22-2009 18:36 
Click Here to See the Profile for DJ Mikey Mike Click here to Send DJ Mikey Mike a Private Message Add DJ Mikey Mike to your buddy list Report this Post Reply w/Quote Edit/Delete Message
gehzumteufel
In your ass



Registered: Nov 2005
Location: so cal

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.

Old Post Jan-22-2009 18:49  Russia
Click Here to See the Profile for gehzumteufel Click here to Send gehzumteufel a Private Message Add gehzumteufel to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Lira
Ancient BassAddict



Registered: Nov 2001
Location: Brasilia, Brazil

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 ]

Old Post Jan-22-2009 18:54  Brazil
Click Here to See the Profile for Lira Click here to Send Lira a Private Message Visit Lira's homepage! Add Lira to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Cloudburst
I am the maximum



Registered: Oct 2003
Location: Jötebårj

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

Old Post Jan-22-2009 18:58  Finland
Click Here to See the Profile for Cloudburst Click here to Send Cloudburst a Private Message Visit Cloudburst's homepage! Add Cloudburst to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Swamper
Webmonstah



Registered: Jan 2000
Location: Toronto, Canada

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"

Old Post Jan-22-2009 22:36  Canada
Click Here to See the Profile for Swamper Click here to Send Swamper a Private Message Visit Swamper's homepage! Add Swamper to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Lira
Ancient BassAddict



Registered: Nov 2001
Location: Brasilia, Brazil

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

Looks interesting. Obrigado, Del


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

Old Post Jan-22-2009 22:46  Brazil
Click Here to See the Profile for Lira Click here to Send Lira a Private Message Visit Lira's homepage! Add Lira to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Scottaculous
habitual line crosser



Registered: Mar 2001
Location: On a plane

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?

Old Post Jan-22-2009 22:50 
Click Here to See the Profile for Scottaculous Click here to Send Scottaculous a Private Message Add Scottaculous to your buddy list Report this Post Reply w/Quote Edit/Delete Message
LeopoldStotch
Suapremae tranecadictt



Registered: Jan 2005
Location: Yawbs,Giaks,and Automobiles

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?


___________________

Old Post Jan-22-2009 23:15  United States
Click Here to See the Profile for LeopoldStotch Click here to Send LeopoldStotch a Private Message Visit LeopoldStotch's homepage! Add LeopoldStotch to your buddy list Report this Post Reply w/Quote Edit/Delete Message
ziptnf
Programming your future



Registered: Jun 2008
Location: Louisville, KY

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

Old Post Jan-22-2009 23:25 
Click Here to See the Profile for ziptnf Click here to Send ziptnf a Private Message Visit ziptnf's homepage! Add ziptnf to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Lira
Ancient BassAddict



Registered: Nov 2001
Location: Brasilia, Brazil

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

Old Post Jan-23-2009 00:36  Brazil
Click Here to See the Profile for Lira Click here to Send Lira a Private Message Visit Lira's homepage! Add Lira to your buddy list Report this Post Reply w/Quote Edit/Delete Message

TranceAddict Forums > Main Forums > Chill Out Room > FAO: MySQL Developers (if there are any)
Post New Thread    Post A Reply

Pages (3): [1] 2 3 »  
Last Thread   Next Thread
Click here to listen to the sample!Pause playbackID Needed 3! [2004] [5]

Click here to listen to the sample!Pause playbackMoogwai - "The Labyrinth" (Part 2) [2003]

Show Printable Version | Subscribe to this Thread
Forum Jump:

All times are GMT. The time now is 09:04.

Forum Rules:
You may not post new threads
You may not post replies
You may not edit your posts
HTML code is ON
vB code is ON
[IMG] code is ON
 
Search this Thread:

 
Contact Us - return to tranceaddict

Powered by: Trance Music & vBulletin Forums
Copyright ©2000-2026, Jelsoft Enterprises Ltd.
Privacy Statement / DMCA
Support TA!