couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Lehnardt <...@apache.org>
Subject Re: Seeking advice on using couchdb for rewritting a project.
Date Wed, 12 Nov 2008 19:23:33 GMT
You are wrong =)

Cheers
Jan
--

On 12.11.2008, at 17:44, tasman <tasman.main@gmail.com> wrote:

>
> On Nov 11, 2008, at 8:02 PM, Burobjorn wrote:
>
>> Hi everybody,
>>
>> My name is Bjorn Wijers and I recently started to play with couchdb.
>> It's a very interesting project and I would like to use it to  
>> rewrite an
>> older project called Simuze[1], but I wonder if couchdb would be the
>> right tool for the job. Perhaps some of you can help me out in
>> understanding the pro's and con's of using couchdb for this?
>>
>> Simuze is musicplatform (website) for musicians and music fans by
>> non-profit Stichting (=Foundation) Open Media. Artists can upload  
>> their
>> music under a Creative Commons license of their choosing and music
>> lovers can download these songs from the site. It was built quite  
>> some
>> time ago in PHP and MySQL.
>>
>> The basics in this application are:
>>
>> - users
>>
>> - profiles (might be multiple per user, since a user may have more  
>> than
>> one artist persona)
>>
>> - media files (images and audio for now)
>>
>> - media collections (such as a playlist or album)
>>
>> - ratings (every media file or collection)
>>
>> - tags (everything)
>>
>> Our objective is to rewrite Simuze in such a way that we can  
>> distribute
>> it as an 'easy' to install webapplication under a free/open-source
>> license (Affero GPL). We would like to connect all the different  
>> Simuze
>> installs (replication would be very helpful for this, I guess) and
>> create a distributed free (as in CC licensed and PD) music web.  
>> Think of
>> it as a non-suck MySpace built by musicians ;)
>>
>> Some questions that I have are:
>>
>> 1) Would this type of application be suitable for couchdb or is this
>> better suited by using a RDBMS?
> It depends more on "queries", that you will need.
>
>>
>> 2) Could we use the attachment feature for adding media files (FLAC  
>> or
>> WAV or AIFF files roughly 50 MB per file) to couchdb? Or is this not
>> advisable given the size of the files? The reasoning behind this is  
>> that
>> by using replication we can easily backup the whole system or setup  
>> an
>> another node of it. Therefor having everything in one place seems  
>> like a
>> good idea?
>  Saving big attachments into CouchDB sounds like not good idea, i  
> think.  AFAIK your binary attachments store into CouchDB in base64  
> encoding, so their size increase. And replication mechanism isn't  
> too fast yet.
>
> Please correct me, if it's wrong.
>
>>
>> 3) In a RDBMS such as MySQL I can use foreign keys to preserve data
>> integrity. In other words I can delete the user and due to the  
>> foreign
>> keys 'automatically' remove its profile(s), uploaded media etc. How
>> would one solve this with couchdb?
>>
>> Thanks for reading this rather lengthy email. Looking forward to the
>> thoughts and comments on this.
>>
>> All the best,
>>
>> grtz
>> BjornW
>>
>> [1] http://www.simuze.nl
>

Mime
View raw message