Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: database
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 9:53am
Comments
Sergey Alexandrovich Kryukov at 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 at 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.
Rate this: bad
good
Please Sign up or sign in to vote.

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
  Permalink  
v2
Comments
RedDK at 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 at 17-Jan-13 15:59pm
   
Isn't it 10GB now?
Vyacheslav Voronenko at 17-Jan-13 16:05pm
   
You are correct, R2 with Advanced Services has 10G limitation now.
Zoltán Zörgő at 18-Jan-13 3:24am
   
Not only AS, but all 2008 and 2012 express editions have 10GB per database file limit.
Rate this: bad
good
Please Sign up or sign in to vote.

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[^]
  Permalink  
Comments
Espen Harlinn at 17-Jan-13 16:39pm
   
Nice reply :-D
Zoltán Zörgő at 17-Jan-13 17:08pm
   
Thanks

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 565
1 Maciej Los 359
2 Kornfeld Eliyahu Peter 309
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,303
1 DamithSL 4,764
2 Maciej Los 4,306
3 Kornfeld Eliyahu Peter 3,914
4 Sergey Alexandrovich Kryukov 3,538


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 17 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100