I am interested in using iCalendar and vCards with RoR. How are iCalendar and/or vCards stored in tables? Is the information in a vCard, for example, stored in a vCard table with one record per vCard vEvent or should the table structure be normalized with separate tables for name, address, telephone and etc? Or should the data structure be normalized using multiple tables? If they must be normalized tables, is there a recommended structure? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
bcparanj-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2007-Feb-28 07:37 UTC
Re: iCalendar and vCard database structure and RoR
There are several ways to do it as you have mentioned. Each option has its tradeoffs. You have to consider the application requirements and use your judgement to come up with a good solution. If the address, telephone etc are being used in other screens as part of some other model, then you can reuse those tables. Are you using the vpim library for the vCard? On Feb 27, 5:57 pm, "Tony K." <tony.kr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I am interested in using iCalendar and vCards with RoR. How are > iCalendar and/or vCards stored in tables? Is the information in a > vCard, for example, stored in a vCard table with one record per vCard > vEvent or should the table structure be normalized with separate > tables for name, address, telephone and etc? Or should the data > structure be normalized using multiple tables? If they must be > normalized tables, is there a recommended structure?--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I want to use it as a method for users to import their information. I do want to be able to run queries on the data like time associated data like DTSTART and DTEND. I would tend to believe this would be too resource intensive if an entire iCalendar event was stored in one record. One would have to create objects for every iCalendar record before any data comparison could be made. On Feb 28, 2:37 am, "bcpar...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org" <bcpar...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> There are several ways to do it as you have mentioned. Each option has > its tradeoffs. You have to consider the application requirements and > use your judgement to come up with a good solution. If the address, > telephone etc are being used in other screens as part of some other > model, then you can reuse those tables. Are you using the vpim library > for the vCard? > > On Feb 27, 5:57 pm, "Tony K." <tony.kr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I am interested in using iCalendar and vCards with RoR. How are > > iCalendar and/or vCards stored in tables? Is the information in a > > vCard, for example, stored in a vCard table with one record per vCard > > vEvent or should the table structure be normalized with separate > > tables for name, address, telephone and etc? Or should the data > > structure be normalized using multiple tables? If they must be > > normalized tables, is there a recommended structure?--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---