Check out Anko Sqlite <https://github.com/Kotlin/anko/blob/master/doc/SQLITE.md> I know that it is n...

# android

[jakub.dyszkiewicz]

Check out Anko Sqlite https://github.com/Kotlin/anko/blob/master/doc/SQLITE.md I know that it is not ORM, but I implemented first database table just yesterday and I’m happy with it. I love that I have full controll over mapping. I work with Hibernate daily so you know… it’s refreshing 😄

[anthonyeef]

jakub.dyszkiewicz: Looks great, thx! I will search to see if there is any demo. BTW can this work with Java? It doesn’t seems like that

[jakub.dyszkiewicz]

No, it’s only for Kotlin.

[anthonyeef]

got it

[kenkyee]

Requery.io is also nice fyi...I like the type safe dsl

[anthonyeef]

I met some problem I think...

[anthonyeef]

The code from anko doc produce some error

[anthonyeef]

db?.createTable("Customer", ifNotExists = true, 
                    "_id" to INTEGER + PRIMARY_KEY + UNIQUE,
                    "name" to TEXT,
                    "photo" to BLOB)

[anthonyeef]

And IDE shows that mixing name and arguments is not allowed

[anthonyeef]

Requery.io looks nice 😸

[jakub.dyszkiewicz]

yeah, that must be error in documentation

[jakub.dyszkiewicz]

because I had the same problem with mixing names and arguments

[anthonyeef]

BTW Requery.io also looks.... difficult to understand how to actually use it in Android project...

[cedric]

@jakub.dyszkiewicz I wonder: why use their template syntax with {} and pairs in parameters instead of Kotlin's string interpolation?

[cedric]

Does it do extra processing like adding quotes around strings, that kind of thing?

[jakub.dyszkiewicz]

yeah, probably protecting from sqlinjection?

[kenkyee]

Requery isn't bad on an Android project. It's similar to a lot of other orm frameworks...And a bit like JPA server side