Hello and thank you for your interest in jOOQ > I've done a review of jOOQ already, and am fairly pleased with what I see, > - Support of Postgres + PostGIS
Unfortunately, that's not true. The PostGIS extension isn't really well supported by jOOQ. This has been on the roadmap for a while now: https://github.com/jOOQ/jOOQ/issues/982 > - Support new dynamic query options What are these, according to you? > - Cleaner, more obvious DB API > - Support for functions (PostGIS has a lot) Yes. > - Support for PGobject (and thus PGhstore, PGgeometry, and PGgeometryLW) They *might* work, but jOOQ doesn't guarantee anything > 1. I was trying to use a PostGIS routine st_intersects(geom1, geom2) -> > boolean, but jOOQ tries to cast the inputs: Unfortunately, as I said, with jOOQ 2.6 you will probably not be able to properly use PostGIS. It will probably work as long as you avoid variable binding of PG* objects, though. > 2. WIth this refactoring of the Java, I'm trying to figure out how I could > implement table partitioning - suggestions? > > Table partitioning in Postgres is implemented via table inheritance. > Partitioning tables in Postgres can make working with the data more > complicated and slower though. To avoid some of the slowdown I plan to use > jOOQ's ability to dynamically build queries, assigning inserts, updates, and > deletes to the correct table(s) avoiding using triggers and other Postgres > magic functions - I'm wondering if you have any suggestions on this... Postgres' table inheritance feature currently isn't supported explicitly, either. This was discussed a long time ago on the user group: https://groups.google.com/d/topic/jooq-user/YuTp9-5K9fs/discussion I haven't followed up on that discussion yet. In order to see how suggestions could be made, could you explain a bit more about your partitioning use case? Cheers 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/groups/opt_out.
