Database help

Get help on databases - MySQL, Oracle, Access, etc.
Bladerunner
Registered User
Posts: 14338
Joined: 04 Sep 2004, 02:00
Processor: i386DX Sooper
Motherboard: A blue one
Graphics card: A red one
Memory: Hard drive
Location: On a Möbius strip
Contact:

Database help

Post by Bladerunner »

Howdy :)

I'm currently coding an application that indexes all the files on your PC and allows you to search using that index. (Using C#)

What I need is a database in which to store basic string information, such as the filename, file path, file size, etc. Nothing extravagant. About 5 properties for each file.

I'm not sure what database type to use though. Databases is a module I'll be taking next year at university, but currently I'm still a newbie to it. I have worked with SQL before though.

I need a database solution that is very small and fast. I want to be able to keep the basic information of about 500 000 files under 10MB.

Any help appreciated :)

EDIT:
A screenshot to give you an idea
Image
If I weren't insane: I couldn't be so brilliant! - The Joker
doo_much
Registered User
Posts: 26022
Joined: 13 May 2004, 02:00
Location: Getting there...
Contact:

Re: Database help

Post by doo_much »

Only advice I can give is stay away from Access! :shock:

Maybe MySQL? What're you using currently?
MOOD - Thirsty

A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Database help

Post by Tribble »

Hey! I love Access.

I may be being stupid here - but couldn't you just write the info to a text file and use that? I do that with database changes and edits and it works well - though I do not use C#
Image
Sojourn
Registered User
Posts: 5649
Joined: 02 Sep 2004, 02:00
Location: Still looking...

Re: Database help

Post by Sojourn »

doo_much
Registered User
Posts: 26022
Joined: 13 May 2004, 02:00
Location: Getting there...
Contact:

Re: Database help

Post by doo_much »

Tribble wrote:Hey! I love Access.

I may be being stupid here - but couldn't you just write the info to a text file and use that? I do that with database changes and edits and it works well - though I do not use C#

500 000 records to a txt file? :shock:
MOOD - Thirsty

A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
Bladerunner
Registered User
Posts: 14338
Joined: 04 Sep 2004, 02:00
Processor: i386DX Sooper
Motherboard: A blue one
Graphics card: A red one
Memory: Hard drive
Location: On a Möbius strip
Contact:

Re: Database help

Post by Bladerunner »

Well I've heard of Oracle and Paradox too... Any opinion on those? :)

(I won't be using Access don't worry! :lol: )
If I weren't insane: I couldn't be so brilliant! - The Joker
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Database help

Post by Tribble »

His screenshot only shows 1589 :shock:
Image
Bladerunner
Registered User
Posts: 14338
Joined: 04 Sep 2004, 02:00
Processor: i386DX Sooper
Motherboard: A blue one
Graphics card: A red one
Memory: Hard drive
Location: On a Möbius strip
Contact:

Re: Database help

Post by Bladerunner »

Tribble wrote:Hey! I love Access.

I may be being stupid here - but couldn't you just write the info to a text file and use that? I do that with database changes and edits and it works well - though I do not use C#
Because database queries are faster, and when you're searching through 500 000 - 2 million files, you want speed :mrgreen:
If I weren't insane: I couldn't be so brilliant! - The Joker
Bladerunner
Registered User
Posts: 14338
Joined: 04 Sep 2004, 02:00
Processor: i386DX Sooper
Motherboard: A blue one
Graphics card: A red one
Memory: Hard drive
Location: On a Möbius strip
Contact:

Re: Database help

Post by Bladerunner »

Tribble wrote:His screenshot only shows 1589 :shock:
It's a single folder :lol: You can select which folders/drives to index.
If I weren't insane: I couldn't be so brilliant! - The Joker
doo_much
Registered User
Posts: 26022
Joined: 13 May 2004, 02:00
Location: Getting there...
Contact:

Re: Database help

Post by doo_much »

Tribble wrote:His screenshot only shows 1589 :shock:

*sigh

Lemmetjie wrote:I need a database solution that is very small and fast. I want to be able to keep the basic information of about 500 000 files under 10MB.
Last edited by doo_much on 27 Nov 2009, 11:51, edited 1 time in total.
MOOD - Thirsty

A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Database help

Post by Tribble »

Ah I see - then I recommend SQL or MySql :wink:
Image
Sojourn
Registered User
Posts: 5649
Joined: 02 Sep 2004, 02:00
Location: Still looking...

Re: Database help

Post by Sojourn »

Tribble wrote:Hey! I love Access.

I may be being stupid here - but couldn't you just write the info to a text file and use that? I do that with database changes and edits and it works well - though I do not use C#
He is doing this for studies. For the love of future complex database solutions, lets not taint the stream where it exits the mountain.
Sojourn
Registered User
Posts: 5649
Joined: 02 Sep 2004, 02:00
Location: Still looking...

Re: Database help

Post by Sojourn »

Bladerunner wrote:Well I've heard of Oracle and Paradox too... Any opinion on those? :)

(I won't be using Access don't worry! :lol: )
Paradox = spawn from hell ... stay away. :x
doo_much
Registered User
Posts: 26022
Joined: 13 May 2004, 02:00
Location: Getting there...
Contact:

Re: Database help

Post by doo_much »

Sojourn wrote:
Tribble wrote:Hey! I love Access.

I may be being stupid here - but couldn't you just write the info to a text file and use that? I do that with database changes and edits and it works well - though I do not use C#
He is doing this for studies. For the love of future complex database solutions, lets not taint the stream where it exits the mountain.
Then you should be glad he didn't study with me at NWU. We weren't allowed to use MySQL. :?
MOOD - Thirsty

A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
Bladerunner
Registered User
Posts: 14338
Joined: 04 Sep 2004, 02:00
Processor: i386DX Sooper
Motherboard: A blue one
Graphics card: A red one
Memory: Hard drive
Location: On a Möbius strip
Contact:

Re: Database help

Post by Bladerunner »

Sojourn wrote:
Tribble wrote:Hey! I love Access.

I may be being stupid here - but couldn't you just write the info to a text file and use that? I do that with database changes and edits and it works well - though I do not use C#
He is doing this for studies. For the love of future complex database solutions, lets not taint the stream where it exits the mountain.
No not for studies. This is merely for fun. :wink:

So any opinions on Paradox or Oracle? (I know I can wiki/google. I want people's opinions and thoughts.)

EDIT: Saw your reply on paradox, thanks. :)
Last edited by Bladerunner on 27 Nov 2009, 11:54, edited 1 time in total.
If I weren't insane: I couldn't be so brilliant! - The Joker
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Database help

Post by Tribble »

doo_much, so when I am tired I don't read every word. Blame my dreams.
Image
doo_much
Registered User
Posts: 26022
Joined: 13 May 2004, 02:00
Location: Getting there...
Contact:

Re: Database help

Post by doo_much »

Sorry - no experience with either.

Only once needed to report off Oracle, couldn't get proper drivers and they exported data to Access for me. And this was ~10 years ago...
MOOD - Thirsty

A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
doo_much
Registered User
Posts: 26022
Joined: 13 May 2004, 02:00
Location: Getting there...
Contact:

Re: Database help

Post by doo_much »

Tribble wrote:doo_much, so when I am tired I don't read every word. Blame my dreams.
Prime's a tiring one then, is he? :twisted:
MOOD - Thirsty

A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
Sojourn
Registered User
Posts: 5649
Joined: 02 Sep 2004, 02:00
Location: Still looking...

Re: Database help

Post by Sojourn »

I saw the "student in bloem" on the screenshot and assumed.
User avatar
rustypup
Registered User
Posts: 8872
Joined: 13 Dec 2004, 02:00
Location: nullus pixius demonica
Contact:

Re: Database help

Post by rustypup »

if you're looking for a tiny embedded solution, check Derby...

if you're looking to learn about relational databases, you could do worse than PostGRE or MySql... keeping in mind that both are hopelessly over-designed for your requirements... (both are designed for multi-user environments...)
Most people would sooner die than think; in fact, they do so - Bertrand Russel
Bladerunner
Registered User
Posts: 14338
Joined: 04 Sep 2004, 02:00
Processor: i386DX Sooper
Motherboard: A blue one
Graphics card: A red one
Memory: Hard drive
Location: On a Möbius strip
Contact:

Re: Database help

Post by Bladerunner »

Sojourn wrote:I saw the "student in bloem" on the screenshot and assumed.
*Cough cough* That's because initially I created it to scan for illegal music and movies on the university network :lol: :lol:
If I weren't insane: I couldn't be so brilliant! - The Joker
Bladerunner
Registered User
Posts: 14338
Joined: 04 Sep 2004, 02:00
Processor: i386DX Sooper
Motherboard: A blue one
Graphics card: A red one
Memory: Hard drive
Location: On a Möbius strip
Contact:

Re: Database help

Post by Bladerunner »

rustypup wrote:if you're looking for a tiny embedded solution, check Derby...

if you're looking to learn about relational databases, you could do worse than PostGRE or MySql... keeping in mind that both are hopelessly over-designed for your requirements... (both are designed for multi-user environments...)
Thanks rusty. Yes I was thinking there had to be a smaller solution. I'll read up on that one then :)
If I weren't insane: I couldn't be so brilliant! - The Joker
User avatar
rustypup
Registered User
Posts: 8872
Joined: 13 Dec 2004, 02:00
Location: nullus pixius demonica
Contact:

Re: Database help

Post by rustypup »

hmm... looks as if there is no readily available c# connection utility for derby, though... surprising given that derby was/is cloudscape... :|

<edit>
connecting via ADO... still requires that you start the driver externally, but not dramatically complicated...
Most people would sooner die than think; in fact, they do so - Bertrand Russel
Bladerunner
Registered User
Posts: 14338
Joined: 04 Sep 2004, 02:00
Processor: i386DX Sooper
Motherboard: A blue one
Graphics card: A red one
Memory: Hard drive
Location: On a Möbius strip
Contact:

Re: Database help

Post by Bladerunner »

rustypup wrote:hmm... looks as if there is no readily available c# connection utility for derby, though... surprising given that derby was/is cloudscape... :|
With DB2 Run-Time Client's ODBC support, client developers who work with Cloudscape or Derby are not limited to using the Java™programming language. You can access data in other programming languages such as C/C++, Perl, and .NET using the ODBC interface.
http://www.ibm.com/developerworks/data/ ... index.html
If I weren't insane: I couldn't be so brilliant! - The Joker
User avatar
rustypup
Registered User
Posts: 8872
Joined: 13 Dec 2004, 02:00
Location: nullus pixius demonica
Contact:

Re: Database help

Post by rustypup »

:lol: found at the same time... the downside is the external launch approach means this isn't a truly embedded solution... :/...
Most people would sooner die than think; in fact, they do so - Bertrand Russel
Post Reply