<@U0HUJ25V1> I'm doing an SQLite based project and...
# tornadofxe
edvin
11/21/2018, 3:01 PM@thomasnield I'm doing an SQLite based project and wanted to check what JDBC driver you're using - is it the Xerial one?
a
abhinay
11/21/2018, 3:29 PMI have worked with SQLite using Xerial driver. Works pretty well 😉
e
edvin
11/21/2018, 3:37 PMCool. Is see that IDEA is using it by default as well, so I’ll go with that. Considering Hibernate since this app has a lot of simple crud over quite a few tables and not many joins.
edvin
11/21/2018, 3:38 PMHaven’t used Hibernate for many years, I like explicit, but here it would mean a lot more manual code if I were to use MyBatis.
d
danielmcq
11/27/2018, 6:01 AM@edvin any thoughts on how you're mapping objects to tables? Are you using an ORM library, written one yourself, just manually mapping sql query results to model properties, etc?
danielmcq
11/27/2018, 6:03 AM(Or is that what Hibernate buys you?)
danielmcq
11/27/2018, 6:17 AMI don't know Reiki but I will be sure to send you a ton of positive Reiki waves if you ever post a best practices example of a TornadoFX app using sqlite and mapping domain model classes via an ORM.
e
edvin
11/27/2018, 2:45 PM@danielmcq As long as my domain objects have getters/setters (via property delegates) it's easy to use just about any ORM I guess. I ended up using MyBatis for this project, I'll open source the project in a couple of days 🙂
d
danielmcq
11/27/2018, 8:25 PM@edvin Awesome. Looking forward t it. Thanks.
e
edvin
11/28/2018, 3:40 PMI gotta say that though it's a little more work to use MyBatis, having 100% control over your SQL statements are really worth it as a system grows.
4 Views