Forum: Ruby on Rails iCalendar and vCard database structure and RoR

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
2e2518ad224cf5aa9db204464335b709?d=identicon&s=25 Tony K. (Guest)
on 2007-02-27 23:58
(Received via mailing list)
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?
E3640176765dae2465d33ef6eb114691?d=identicon&s=25 bcparanj@gmail.com (Guest)
on 2007-02-28 08:47
(Received via mailing list)
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?
2e2518ad224cf5aa9db204464335b709?d=identicon&s=25 TonyK (Guest)
on 2007-02-28 15:08
(Received via mailing list)
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.
This topic is locked and can not be replied to.