My personal preference is to have a thorough list (actor, actresses, director etc), Roshan but if it makes things more complex, i guess we can exclude it.
________________________________ From: Roshan <[email protected]> To: [email protected] Sent: Tue, 24 August, 2010 0:17:05 Subject: Re: [arr] Song Database Structure do we need the actors information and all ? not sure.. they don't mean anything to music. just my opinion. but if you all think it is useful, let's keep it. On Mon, Aug 23, 2010 at 10:18 PM, Vinayakam Murugan <[email protected]> wrote: >[Attachment(s) from Vinayakam Murugan included below] >I have switched the Movie name and Song Name column in the sheet sent by >ARRvind. > > >Warm Regards >~~~~~~~~~~~~~~~ >Vinayak > >http://www.flickr.com/photos/rightplacerighttime/ > > > >On Mon, Aug 23, 2010 at 10:15 PM, Vinayakam Murugan ><[email protected]> >wrote: > >Sorry, I thought I had added Movie Name. ARRvind has added both of your >requests. >> >> >>Thanks, ARRvind. >> >>Warm Regards >>~~~~~~~~~~~~~~~ >>Vinayak >> >>http://www.flickr.com/photos/rightplacerighttime/ >> >> >> >>On Mon, Aug 23, 2010 at 10:07 PM, Vinayakam Murugan >><[email protected]> >>wrote: >> >>Hey Raj >>> >>>Movie Name is already there. I will add Raga to the same. >>> >>> >>> >>>Warm Regards >>>~~~~~~~~~~~~~~~ >>>Vinayak >>> >>>http://www.flickr.com/photos/rightplacerighttime/ >>> >>> >>> >>>On Mon, Aug 23, 2010 at 6:50 AM, raj <[email protected]> wrote: >>> >>> >>>>Hi Vinayagam Murugan, >>>> >>>>The format is ok. Please add the following columns on the songs sheet. >>>> >>>>> movie_name >>>>> Ragaa >>>> >>>>Please upload the same to google docs as it can be edited online by the >>>>group >>>>members. >>>> >>>> >>>>--- In [email protected], Roshan <c.pix...@...> wrote: >>>>> >>>>> sorry.. scratch that. opened it. >>>>> >>>>> I think it is a good format. let's start using it and probably add some >more >>>>> columns. >>>>> >>>> >>>>> On Mon, Aug 23, 2010 at 1:44 AM, Roshan <c.pix...@...> wrote: >>>>> >>>>> > Vinayak, >>>>> > >>>>> > I am not able to open it on iWork Numbers. it usually opens all the >>>>> > spreadsheet formats including .xls. but i can't open this one. >>>>> > >>>>> > what do you think is the problem ? I don't have windows. I can try it on >>>>> > Ubuntu later. >>>>> > >>>>> > >>>>> > >>>>> > On Sat, Aug 21, 2010 at 3:56 PM, Vinayakam Murugan < >>>> > > mvinayakam.li...@...> wrote: >>>>> > >>>>> >> >>>>> >> [Attachment(s) <#12a9b6fdb7b61031_12a94d62ec0198a1_TopText> from >>>> >>>>> >> Vinayakam Murugan included below] >>>>> >> >>>>> >> Hello Friends >>>>> >> >>>>> >> I decided to change the Subject line to make it more relevant. >>>>> >> >>>>> >> Here is a scratch Db Structure. Like I have seperated Films / Albums >from >>>>> >> Songs, we should seperate Singers & Awards also from Songs. However that >>>>> >> could be better achieved through a Db than excel. This sheet is for >>>>> >> illustration purposes only. Further Db normalization is required. >>>>> >> >>>>> >> >>>>> >> Warm Regards >>>>> >> ~~~~~~~~~~~~~~~ >>>>> >> Vinayak >>>>> >> >>>>> >> http://www.flickr.com/photos/rightplacerighttime/ >>>>> >> >>>>> >> >>>> >>>>> >> On Fri, Aug 20, 2010 at 8:02 AM, raj <arr_naga...@...> wrote: >>>>> >> >>>>> >>> >>>>> >>> >>>>> >>> Ok..I make a living by Databases and Databases only :) >>>>> >>> I am a DBA. So yes..I can help. As a first step, it would be great >>>>> >>> if someone can comeup with a excel containing the following fields. >>>>> >>> >>>>> >>> 1) Film_name >>>>> >>> 2) Song_name >>>>> >>> 3) Singers_name ( comma seperated ) >>>>> >>> 4) date of release >>>>> >>> 5) Genre of the song ( Western,fusion,carnatic classical,quawalli ) >>>>> >>> 6) Director of the film >>>>> >>> 7) Lead actor >>>>> >>> 8) Actress >>>>> >>> 9) Ragaa of the song ( if possible ) >>>>> >>> 10) Language >>>>> >>> 11) is_dubbed_film ( yes/no) >>>>> >>> 12) Producer of the film >>>>> >>> 13) Lyricst. >>>>> >>> 14) Miscellaneous. >>>>> >>> >>>>> >>> You can add few more fields if you feel like. I am keeping it simple >>>>> >>> as of now and we can change the DB design( (De)Normalize ) depending >>upon >>>>> >>> our needs. As a first step, someone can create a document on google >>>>> >>> docs >>>>>and >>>>> >>> start updating the same. As its on Google docs, most of us can >>contribute >>>>> >>> and we can get these details soon. Once the data >>>>> >>> collection is complete, DB design can be adjusted and we can start >>>>> >>> working on the application. >>>>> >>> >>>>> >>> >>>> > >>> --- In [email protected] <arrahmanfans%40yahoogroups.com>, >>>> >>>>> >>> Indmov Buff <indmovbuff@> wrote: >>>>> >>> > >>>>> >>> > Fantastic! The majority vote is for a database it seems. >>>>> >>> > >>>>> >>> > I don't have any skills in database but open to learning. Also, I'd >be >>>>> >>> happy to >>>>> >>> > allocate time to sit through the group mails for the information that >>>>> >>> will make >>>>> >>> > it a good database. I am mainly interested in the research aspects of >>>>> >>> the work >>>>> >>> > involved in finishing this database that we are after. So happy to >>>>> >>> contribute in >>>>> >>> > the form getting the data together , more on the creative side rather >>>>> >>> than the >>>>> >>> > technical side. So I guess, we should start off with a list of people >>>>> >>> who are >>>>> >>> > willing to help. And this has got to be a bit of a commitment given >>>>> >>> that we will >>>>> >>> > need to co-ordinate with members around the world with different work >>>>> >>> and social >>>>> >>> > commitments. I am up for it! >>>>> >>> > >>>>> >>> > >>>>> >>> > >>>>> >>> > ________________________________ >>>>> >>> > From: Gopal Srinivasan <catchgops@> >>>>> >>> >>>> > >>> > To: [email protected] <arrahmanfans%40yahoogroups.com> >>>> >>>>> >>> > Sent: Wed, 18 August, 2010 16:51:43 >>>>> >>> > Subject: Re: [arr] Database for group of contents from useful e-mails >>>>> >>> > >>>>> >>> > >>>>> >>> > Glad to see this outpouring of enthusiasm. Hopefully, it will >sustain. >>>>> >>> I, among >>>>> >>> > others, have tried various forms of this previously that did not >>>>> >>> culminate in >>>>> >>> > anything (beyond my discography, which too hasn't been updated in a >>>>> >>> year) as >>>>> >>> > time turned out to be a major constraint. Some of the modes we have >>>>> >>> considered >>>>> >>> > includes static web lists, wikis and databases. In my opinion, a >>>>> >>> database at the >>>>> >>> > backend is probably the best with front end forms for querying. >>>>> >>> Depending on how >>>>> >>> > simple or complex it turns out, something like Zoho Creator might >work >>>>> >>> too. >>>>> >>> > What's needed is the involvement of people who are well versed with >>>>> >>> database >>>>> >>> > design AND those that can source information. If we can do a good >>>>> >>> enough job of >>>>> >>> > this there is potential to make it official. Next steps perhaps >>include >>>>> >>> forming >>>>> >>> > a core team, identifying the types of information we want stored, >>>>> >>> design the >>>>> >>> > schema and then create and populate. >>>>> >>> > >>>>> >>> > >>>>> >>> > On Wed, Aug 18, 2010 at 06:31, Roshan <c.pixels@> wrote: >>>>> >>> > >>>>> >>> > >>>>> >>> > > >>>>> >>> > >I can work on the technical side of it. (Development and design). >But >>>>> >>> will >>>>> >>> > >really appreciate if someone can assist as well. I will need some >>help >>>>> >>> from you >>>>> >>> > >guys about collecting the info from the group. it seems like a lot. >>>>> >>> but if we >>>>> >>> > >collectively do it, we can finish it in within a month or two >>>>> >>> (including the >>>>> >>> > >development). >>>>> >>> > > >>>>> >>> > >I will also need some input in choosing the domain >>>>> >>> > > >>>>> >>> > >I thought of some >>>>> >>> > > >>>>> >>> > >ARDB.in >>>>> >>> > > >>>>> >>> > >arrinfo.org >>>>> >>> > > >>>>> >>> > >i tried some domains that has ar rahman in the name, but they all >>seem >>>>> >>> to have >>>>> >>> > >been taken. >>>>> >>> > > >>>>> >>> > >As for hosting and domain, I don't mind paying for it. I have a >>>>> >>> dedicated server >>>>> >>> > >where I host my clients. >>>>> >>> > > >>>>> >>> > >so, to sum it up >>>>> >>> > > >>>>> >>> > >1. website as a database of information on ar rahman and his music. >>>>> >>> > > >>>>> >>> > >2. categorized, search-able contents like Reviews, Information, >>>>> >>> Singers, >>>>> >>> > >Instrumentalists, Instruments Used, Places performed, Debuts, >quotes, >>>>> >>> interviews >>>>> >>> > >etc. >>>>> >>> > > >>>>> >>> > >3. Quality contents from the group. like awesome reviews of AJ and >>>>> >>> Gayathri and >>>>> >>> > >the rest of those people who write good contents. of course, with >>>>> >>> credits and >>>>> >>> > >links to their blogs / websites etc, if they have any. >>>>> >>> > > >>>>> >>> > >please contribute your suggestions. >>>>> >>> > > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > >On Wed, Aug 18, 2010 at 4:14 AM, Indmov Buff <indmovbuff@> wrote: >>>>> >>> > > >>>>> >>> > > >>>>> >>> > >>Me too! Like where we can sort by singer name or raaga name etc. >>Just >>>>> >>> info. IT >>>>> >>> > >>savvy people out there- what's the best way to go about this? >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > ________________________________ >>>>> >>> > From: Roshan <c.pixels@> >>>>> >>> >>>> > >>> > >>To: [email protected] <arrahmanfans%40yahoogroups.com> >>>> >>>>> >>> > >>Sent: Tue, 17 August, 2010 21:45:59 >>>>> >>> > >>Subject: Re: [arr] Database for group of contents from useful >>e-mails >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >>That gives me another idea. how about a website with all the info >>>>> >>> about AR >>>>> >>> > >>Rahman, his singers, his songs, Genres, and all the other info we >>>>> >>> find from our >>>>> >>> > >>group ? we can make it as an extension of this group. there won't >be >>>>> >>> any forum >>>>> >>> > >>or anything.. just info. >>>>> >>> > >> >>>>> >>> > >>I would love to do it. >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >>On Tue, Aug 17, 2010 at 6:53 PM, ARRvind <arr_arvind@> wrote: >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >>>Nice initiative.! Would mean a lot to this group.! Lets get Gopal >>>>> >>> bro's comment >>>>> >>> > >>>on this! >>>>> >>> > >>> >>>>> >>> > >>>--- On Tue, 8/17/10, Indmov Buff <indmovbuff@> wrote: >>>>> >>> > >>> >>>>> >>> > >>> >>>>> >>> > >>>>From: Indmov Buff <indmovbuff@> >>>>> >>> >>>>> >>> > >>>>Subject: [arr] Database for group of contents from useful e-mails >>>> > >>> > >>>>To: "A R" ><[email protected]<arrahmanfans%40yahoogroups.com> >>>> >>>>> >>> > >>>>> >>> > >>>>Date: Tuesday, August 17, 2010, 12:54 PM >>>>> >>> > >>>> >>>>> >>> > >>>> >>>>> >>> > >>>> >>>>> >>> > >>>> >>>>> >>> > >>>>Hi Gopal and the rest, >>>>> >>> > >>>> >>>>> >>> > >>>> >>>>> >>> > >>>>I have read many e-mails containing useful data in this group >>>>> >>> before. Just like >>>>> >>> > >>>>Arvind's unique list of intro songs for singers there have been >>>>> >>> other lists such >>>>> >>> > >>>>as Mother songs, child singers lists, raaga based lists and >>several >>>>> >>> other >>>>> >>> > >>>>extremely interesting lists. I strongly feel that we should have >>>>> >>> all of this >>>>> >>> > >>>>documented as part of the group? Any suggestions on how this >>>>> >>> > >>>>can >>be >>>>> >>> done? >>>>> >>> > >>>>Database? I am happy to put in time to dig out useful data from >>old >>>>> >>> e-mails. >>>>> >>> > >>>> >>>>> >>> > >>>> >>>>> >>> > >>>> >>>>> >>> > >>>> >>>>> >>> > >>>> >>>>> >>> > >>> >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >>-- >>>>> >>> > >>----------------------------------- >>>>> >>> > >>http://roshanravi.com >>>>> >>> > >>http://ramblingsoul.com >>>>> >>> > >>http://cssheaven.org >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > >> >>>>> >>> > > >>>>> >>> > > >>>>> >>> > >-- >>>>> >>> > >----------------------------------- >>>>> >>> > >http://roshanravi.com >>>>> >>> > >http://ramblingsoul.com >>>>> >>> > >http://cssheaven.org >>>>> >>> > > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > >>>>> >>> >>>>> >>> >>>>> >> >>>>> >> >>>>> > >>>>> > >>>>> > >>>> > > -- >>>> >>>>> > ----------------------------------- >>>>> > http://roshanravi.com >>>>> > http://ramblingsoul.com >>>>> > http://cssheaven.org >>>>> > >>>>> > >>>>> >>>>> >>>>> -- >>>>> ----------------------------------- >>>>> http://roshanravi.com >>>>> http://ramblingsoul.com >>>>> http://cssheaven.org >>>>> >>>> >>>> >>> >> > -- ----------------------------------- http://roshanravi.com http://ramblingsoul.com http://cssheaven.org
