Which Database do you suggest?

Question

0.00/5 (No votes)

See more:

Hello friends
I want to know which database you may use in a program for storing pictures , sounds, texts, strings and everything, but don't offer me SQL. Its good but i need something to be installed fast and can be used by c#.
and i want to store suppose 500000 pictures with size of 1 to 3 kb in it.
and 30000 mp3 and wave files suppose 1 to 3 mega byte in it.

Posted 17-Jan-13 8:53am

F.moghaddampoor

Add a Solution

Comments

Sergey Alexandrovich Kryukov 17-Jan-13 15:03pm

Do you mean, not any relational databases based on SQL (language)? Or not, say, on MS SQL server? I'm asking because some relational database may provide SQL but be light weight enough for you, I don't know.
It really depends on further detail of your application and requirements. For example, ASP.NET vs some windows application may make considerable difference, deployment model, etc.
—SA

PIEBALDconsult 17-Jan-13 16:03pm

I just use SQL Server (Express or CE for personal projects) for all that, but not in those quantities.
I have to work with a lot of different databases, but I wouldn't choose any other when I have a choice.

2 solutions

Solution 2

Let us not abandon SQL Server for a second: there is a feature called FILESTREAM, that could be exactly what you need. And the SQL Server Express database size limitation does not apply to the FILESTREAM data!
Read these:
- http://www.simple-talk.com/sql/learn-sql-server/an-introduction-to-sql-server-filestream/[^]
- How Do I: Use SQL File Stream[^]

But you don't have to stick to SQL based databases, there is an approach called noSQL[^]. I would suggest you look around here first: http://ravendb.net/docs/client-api/attachments[^]

Posted 17-Jan-13 10:21am

Zoltán Zörgő

Comments

Espen Harlinn 17-Jan-13 16:39pm

Nice reply :-D

Zoltán Zörgő 17-Jan-13 17:08pm

Thanks

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vyacheslav Voronenko · Accepted Answer · 2013-01-17T09:02:00

Solution 1

According to Microsoft Research study, objects smaller than 256K are best stored in a database while objects larger than 1M are best stored in the filesystem. Between 256K and 1M, the read:write ratio and rate of object overwrite or replacement are important factors.
http://research.microsoft.com/apps/pubs/default.aspx?id=64525[^]

Thus, I would recommend to consider mixed approach, or store all files on a file system. You can choose database you are most familiar with. MSSQL Server Express could be a good choice, if your database size does not exceed 4G.

[UPD] as was correctly noted below, DB size limitation is 10G

Posted 17-Jan-13 9:02am

Vyacheslav Voronenko

Updated 17-Jan-13 10:05am

v2

Comments

RedDk 17-Jan-13 15:31pm

linkedserver makes a 4G database irrelevant but ... I concur MS SQL Server 2008 Express R2 with Advanced Services ... all the way!

PIEBALDconsult 17-Jan-13 15:59pm

Isn't it 10GB now?

Vyacheslav Voronenko 17-Jan-13 16:05pm

You are correct, R2 with Advanced Services has 10G limitation now.

Zoltán Zörgő 18-Jan-13 3:24am

Not only AS, but all 2008 and 2012 express editions have 10GB per database file limit.