jayrave / falkon

[DEPRECATED] Clean & simple API to talk with the database (for Android & Kotlin)
Apache License 2.0
12 stars 2 forks source link

QueryBuilder DSL & cia discussion #23

Open Hazer opened 7 years ago

Hazer commented 7 years ago

Hi,

I was working in a similar approach, mostly experimenting and finding an API I would like to use. My base was x2bool/kuery lib. Never got it to an alpha stage.

Then I found yours, really nice library, similar to my experimentations but better, the only thing I am missing right now, are using Kuery QueryBuilder approach. It feels more natural for me.

I am not against your QueryBuilder, insert and update builders are pretty cool, but I would like to maybe have another optional module, that enables some Kuery like API. The reason is that for a complex query, involving multiple entities, I think having a DSL closer to pure SQL, its easier to use. My struggle with ORMLite was, for example, fighting with its Builder, that for complex queries, wasn't really helpful and always got a little clunky.

So I would like that you take a look at Kuery and tell me what you think, I case of liking the idea to use something like this, I could help you out if needed. Next month I am planning in using Falkon in a home project, with or without a Kuery like DSL, and see what can I get, and what needs to be done, so I can contribute to your project.

I really believe we need a good DB API for Android, and I really like Kotlin.

Thank you for your hard work!

jayrave commented 7 years ago

Hey Hazer, i see where you are coming from. Now that I am using Falkon in a large project, I also see that the builders could some improvements to get out of the way & make building complex statements easier. I will definitely take a look into kuery's builder & get back to you

Hazer commented 7 years ago

Thanks!