Click here to Skip to main content
15,612,452 members
Please Sign up or sign in to vote.
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.
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.
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.

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.[^]

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
Share this answer
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.
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:
- 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:[^]
Share this answer
Espen Harlinn 17-Jan-13 16:39pm    
Nice reply :-D
Zoltán Zörgő 17-Jan-13 17:08pm    

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900