Kotlin / Kotlin/dataframe

Add Android Databases IO support

Open
#1,725 0 comments 1 reaction 0 assignees View on GitHub
Android databases examples
Dominant language
Kotlin
Stars
1.1k
Forks
83
Avg merge
4d 12h
Merged PRs (30d)
30

Description

`dataframe-jdbc` methods don’t work on Android because Android doesn’t properly support JDBC (`java.sql.*` is incomplete), so calling `DataFrame.readSqlQuery` may crash at runtime (see #1014).

We need to add Android Databases IO support. Ideally, we can keep an API similar to `dataframe-jdbc`, but the implementation should be **Android-native**, not JDBC-based.

Possible implementation direction:

- Use raw SQLite.
- Use Room —can be performed using DAO or Cursor.

Contributor guide

Open the contributing guide

Research direction

Start by reading the existing dataframe-jdbc methods and the DataFrame.readSqlQuery entry point, then review the runtime failure described in #1014. Compare the raw SQLite and Room directions, and define Android-native database support with an API similar to dataframe-jdbc that works without java.sql.*.

Written by the indexing model from the issue text.

Assessment

Tech stack
android, kotlin, sqlite
Domain
databases, mobile-dev
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.