Database help
-
- 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
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
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
If I weren't insane: I couldn't be so brilliant! - The Joker
-
- Registered User
- Posts: 26022
- Joined: 13 May 2004, 02:00
- Location: Getting there...
- Contact:
Re: Database help
Only advice I can give is stay away from Access!
Maybe MySQL? What're you using currently?
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
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
- 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
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#
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#
-
- Registered User
- Posts: 26022
- Joined: 13 May 2004, 02:00
- Location: Getting there...
- Contact:
Re: Database help
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?
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
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
-
- 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
Well I've heard of Oracle and Paradox too... Any opinion on those?
(I won't be using Access don't worry! )
(I won't be using Access don't worry! )
If I weren't insane: I couldn't be so brilliant! - The Joker
- 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
His screenshot only shows 1589
-
- 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
Because database queries are faster, and when you're searching through 500 000 - 2 million files, you want speedTribble 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#
If I weren't insane: I couldn't be so brilliant! - The Joker
-
- 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
It's a single folder You can select which folders/drives to index.Tribble wrote:His screenshot only shows 1589
If I weren't insane: I couldn't be so brilliant! - The Joker
-
- Registered User
- Posts: 26022
- Joined: 13 May 2004, 02:00
- Location: Getting there...
- Contact:
Re: Database help
Tribble wrote:His screenshot only shows 1589
*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
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
- 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
Ah I see - then I recommend SQL or MySql
Re: Database help
He is doing this for studies. For the love of future complex database solutions, lets not taint the stream where it exits the mountain.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#
Re: Database help
Paradox = spawn from hell ... stay away.Bladerunner wrote:Well I've heard of Oracle and Paradox too... Any opinion on those?
(I won't be using Access don't worry! )
-
- Registered User
- Posts: 26022
- Joined: 13 May 2004, 02:00
- Location: Getting there...
- Contact:
Re: Database help
Then you should be glad he didn't study with me at NWU. We weren't allowed to use MySQL.Sojourn wrote:He is doing this for studies. For the love of future complex database solutions, lets not taint the stream where it exits the mountain.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#
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
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
-
- 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
No not for studies. This is merely for fun.Sojourn wrote:He is doing this for studies. For the love of future complex database solutions, lets not taint the stream where it exits the mountain.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#
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
- 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
doo_much, so when I am tired I don't read every word. Blame my dreams.
-
- Registered User
- Posts: 26022
- Joined: 13 May 2004, 02:00
- Location: Getting there...
- Contact:
Re: Database help
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...
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
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
-
- Registered User
- Posts: 26022
- Joined: 13 May 2004, 02:00
- Location: Getting there...
- Contact:
Re: Database help
Prime's a tiring one then, is he?Tribble wrote:doo_much, so when I am tired I don't read every word. Blame my dreams.
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
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
Re: Database help
I saw the "student in bloem" on the screenshot and assumed.
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Database help
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...)
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
-
- 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
*Cough cough* That's because initially I created it to scan for illegal music and movies on the university networkSojourn wrote:I saw the "student in bloem" on the screenshot and assumed.
If I weren't insane: I couldn't be so brilliant! - The Joker
-
- 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
Thanks rusty. Yes I was thinking there had to be a smaller solution. I'll read up on that one thenrustypup 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...)
If I weren't insane: I couldn't be so brilliant! - The Joker
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Database help
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...
<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
-
- 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
rustypup wrote:hmm... looks as if there is no readily available c# connection utility for derby, though... surprising given that derby was/is cloudscape...
http://www.ibm.com/developerworks/data/ ... index.htmlWith 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.
If I weren't insane: I couldn't be so brilliant! - The Joker
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Database help
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