2017-03-01 23:14 GMT+01:00 Jan Lessner <[email protected]>: > > The reason for using an Exadata is not the Java-based operative system but > the analytical data warehouse. But we are currently in preparation for a > massive redesign to expand the business, and we will probably split the > analytical and operative database so that the Exadata is no longer our > basis. >
Yes, that's never a bad idea. Combining OLTP and OLAP in a single system works only "for so long" i.e. until you grow to some size. I've created a feature request for this: >> https://github.com/jOOQ/jOOQ/issues/5930 >> > Thanks a lot. Maybe we can help in the future :-) > You definitely can: The more details we know about your use-case and the features you'd like to see, the better this feature will get. Out of curiosity: What's your development database? >> > At the moment the developers are working on locally installed Oracle XEs. > But in case we moved to JOOQ (coming from PriDE) we would probably change > that to make use of JOOQ's open source edition. As we have almost no > Oracle-specific aspects in our code, we could dare to use different > databases in development and production. > I see, indeed Oracle XE is quite compatible with SE and EE, at least from a developer perspective. However, I generally recommend not using a database for development that you're not also targeting for production systems. There are a lot of differences, e.g. in transaction models and in many subtle differences of behaviour that are not covered / abstracted in the SQL language per se. In recent years, Oracle has made working with its database really easy for developers by providing out-of-the-box docker images for Oracle 11g and 12c: https://github.com/oracle/docker-images/tree/master/OracleDatabase Just a thought :) 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.
