Hi Josh, That's a bummer with the lost message. Don't you hate when that happens? Thanks for trying again and summarising your thoughts.
2014-09-03 22:17 GMT+02:00 Josh Padnick <[email protected]>: > Sigh, I had a whole set of inline responses written out, but Google didn't > post them and I've lost the message. Anyway, summary of what I just wrote: > > - Lukas, thanks as always for your response > > You're welcome, of course! > > - I hadn't considered writing a custom generator. The only snag here > is that we add annotations to certain methods depending on how we want > these POJOs concerted to JSON. Will look into this; a cool idea toward > automating! > > Can you show a couple of examples? Maybe, we'll be able to factor out a new feature request. > > - Regarding PostgreSQL inheritance, I was initially excited about > this, but I was scared off by many of the limitations and edge cases that > we will inevitably run into. For example, foreign key relationships get > inherited but the relationship itself doesn't appear to be enforced in a > child table. Do you have jOOQ customers using Oracle or Postgres > inheritance with success? Do you see this as a strong option for > supporting inheritance in jOOQ or just one option? > > I agree that relational inheritance is a door that, once opened, will give way to a myriad of edge cases. I wasn't aware of the ones you've mentioned. Personally, I don't have any experience with PostgreSQL ORDBMS features. Our integration partner UWS is using it to implement partitioning in their projects: http://blog.jooq.org/2014/08/26/integrating-jooq-with-postgresql-partitioning That might be a different use-case from yours, though. I do have some experience with Oracle's object-oriented features, though and I would not recommend using that, as DDL will be set in stone forever. There's virtually no way to run any ALTER TABLE statements once you make your tables depend on OBJECT types. That may be fine for temporary tables (like queues, etc.) but certainly not for regular data. Our Oracle customers thus far have not been asking for support of ORDBMS features in Oracle, although some of them are very happy with object-oriented PL/SQL support, where this makes much more sense. Best, Lukas -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
