[odb-users] Hand coded schema

[Bruce Cresanta]

Boris,

	Hi.  Thanks for the reply.   I’m just old school.   I have a rigorous requirement for any relational system and might need to have a good degree of control.   I haven’t totally read-up yet, so I’ll wait to share the specifics later. 

Thanks,

Bruce


On Jun 11, 2014, at 6:21 AM, Boris Kolpackov <boris at codesynthesis.com> wrote:

> Hi Bruce,
> 
> Bruce Cresanta <cresanta at me.com> writes:
> 
>> I like to write my schemas by hand.
> 
> You realize you will then have to do schema migration by hand as well
> (which is a real PITA)? 
> 
> 
>> What is the best way to do this with ODB? I have a rather large system
>> that I’m designing and would like to prove it out before I worry about
>> mappings and things of that nature. Any recommendations on how to learn?
> 
> I actually would strongly suggest that you start with automatic schema
> generation, at least initially. This will allow you to iterate/prove
> your system out much faster since you only need to focus on one thing
> (object model design) instead of three things (object model, relational
> model, and mapping between the two). You can always keep an eye on the
> generate database schema to see if it satisfies your requirements (always
> a good idea). Though ODB generates pretty idiomatic SQL (one guy from a
> big shop told me their Oracle DBA was quite impressed after seeing ODB-
> generated database schema).
> 
> This way you will also learn how ODB maps various C++ constructs
> (containers, pointers to objects, class hierarchies, etc) to SQL so
> when/if you decide to go the manual schema route, you will have a pretty
> good idea how to map it back to C++ classes (I assume that's what you
> meant by "leaning").
> 
> Boris