Exposed icon indicating copy to clipboard operation
Exposed copied to clipboard

Can Exposed be used with Android SQLite implementation?

Open CommanderTvis opened this issue 6 years ago • 5 comments

I want to access Android SQLite database with a fully-featured ORM (Android Jetpack Room is a too weak one), but as I know, Exposed can be used only with JDBC. What can I do?

CommanderTvis avatar Jan 28 '20 11:01 CommanderTvis

I heard about https://github.com/codersgarage/BelleORM and https://github.com/vincentlauvlwj/Ktorm but I didn't use it.

kortov avatar Jan 28 '20 11:01 kortov

@CommanderTvis , why not to use jdbc driver for SQLite? Or it won't work with Android SQLite implementation?

Tapac avatar Jan 28 '20 14:01 Tapac

@CommanderTvis , why not to use jdbc driver for SQLite? Or it won't work with Android SQLite implementation?

Xenial SQLite is not same as Android SQLite. Android SQLite doesn't provide any JDBC and javax.sql. DataSource support. There is an unofficial solution - SQLDroid, but it is pretty unstable.

Currently, I have to use H2, because it works on Android, and it is compatible with Exposed.

~~Это очень печально.~~

CommanderTvis avatar Jan 28 '20 15:01 CommanderTvis

It's planned in a near (I hope) future. #578

Tapac avatar Jan 28 '20 21:01 Tapac

@CommanderTvis , why not to use jdbc driver for SQLite? Or it won't work with Android SQLite implementation?

Xenial SQLite is not same as Android SQLite. Android SQLite doesn't provide any JDBC and javax.sql. DataSource support. There is an unofficial solution - SQLDroid, but it is pretty unstable.

Currently, I have to use H2, because it works on Android, and it is compatible with Exposed.

~Это очень печально.~

can you show, how you use H2 on andoird?

mrfrosk avatar Nov 28 '24 16:11 mrfrosk