What kind of database are suitable for this system ??

[EsKiMo]

I'm developing a Audio Management system for my Final Year Project. Any

suggestion for what kind of database should i use whn storing audio files and

retrieve it and play .... the system is a standalone system .Need help

desperately

[PGP_Protector]

Do you have to store your Audio Files in the database itself, or can you just store the location of the file?

[Orjan]

how big elements are you going to save? is this a web based system, a windows application or what is it based on? how will it be distributed?
as it is a standalone system, I believe that a rdbms in general speaking of a database server is out of scale here, so more of a file database system would suit you better, maybe sqlite if your programming language supports it. what language are you going to do this in?

[EsKiMo]

I'm using VB.Net .... and its a window based system... i wanted to store the

audio files itself..hmm hmmm~~

[Orjan]

you could do it with for example sql server express, so any client it is installed on, needs such an installation, or mysql installation if you want that. another method is to use access databases, but those would many not reccomend I assume. normally, windows applications do better with savefiles instead of databases, unless it is many many posts to be searchable etc...

[PGP_Protector]

Well MySQL will allow you to store BLOBS, and you can put any binary info into them, so if you want to install an Actual SQL Server MySQL would handle that.

Or you can use SQLite, this is a single File Solution (I.E. No Database Server itself) and you can also use BLOBS using version 3.0 or greater (Current version is 3.6.21)

But Your Database Files will get quite large and with SQLite, they don't shrink even if you delete data out of them (or at least last time I checked, they don't shrink) so if you're storing a lot of music, you're going to end up with a single massive File.


SQLite Home Page

[EsKiMo]

Hmm~ thx for those ideas.... i'll see wat i can do bout it

Thanks Orjan & PGP_Protector