{"action":"created","issue":{"url":"https://api.github.com/repos/geopaparazzi/libjsqlite-spatialite-android/issues/12","labels_url":"https://api.github.com/repos/geopaparazzi/libjsqlite-spatialite-android/issues/12/labels{/name}","comments_url":"https://api.github.com/repos/geopaparazzi/libjsqlite-spatialite-android/issues/12/comments","events_url":"https://api.github.com/repos/geopaparazzi/libjsqlite-spatialite-android/issues/12/events","html_url":"https://github.com/geopaparazzi/libjsqlite-spatialite-android/issues/12","id":104606243,"number":12,"title":"Example (Current) \"hello world\" usage of this library / libjsqlite?","user":{"login":"kristina-hager","id":5302056,"avatar_url":"https://avatars.githubusercontent.com/u/5302056?v=3","gravatar_id":"","url":"https://api.github.com/users/kristina-hager","html_url":"https://github.com/kristina-hager","followers_url":"https://api.github.com/users/kristina-hager/followers","following_url":"https://api.github.com/users/kristina-hager/following{/other_user}","gists_url":"https://api.github.com/users/kristina-hager/gists{/gist_id}","starred_url":"https://api.github.com/users/kristina-hager/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kristina-hager/subscriptions","organizations_url":"https://api.github.com/users/kristina-hager/orgs","repos_url":"https://api.github.com/users/kristina-hager/repos","events_url":"https://api.github.com/users/kristina-hager/events{/privacy}","received_events_url":"https://api.github.com/users/kristina-hager/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-09-03T01:57:46Z","updated_at":"2015-09-03T05:22:31Z","closed_at":null,"body":"Hi there, I'm hoping to use spatialite on android for a [school project](https://fahrradlercode.wordpress.com/2015/08/25/an-about-face-on-my-project-time-to-save-salamanders-with-gis/). I have some experience developing android apps. However, I've never used this sort of library before in android.\r\n\r\nDo you know of any recent, simple, android app using these libraries? I've been digging through the geopaparazzi app source/structure lately, but I am not having luck imitating that apps setup since it is so complex. I've found some simpler examples such as [android-spatialite](https://github.com/mrenouf/android-spatialite), but those are using a very old spatialite version and also an old Android development environment.\r\n\r\nMost online articlces indicate that to use an 'android library' you should have some *.jar or *.aar file. I've not managed to find such a thing for as recent spatialite/android as is here. I have tried just adding the 'libjsqlite.so' directly to an app with no luck. Lately, I am trying to use the libjsqlite.so and the SQLite java sources to create an android module, also with no luck.\r\n\r\nOr do you have any tips on how to set up a hello world example with these libs? Btw, I am perfectly willing to take on the effort to create such a hello world example to go with these libs and make it open source of course. However, I could just use some help [getting started](http://stackoverflow.com/questions/32290214/call-function-from-a-shared-lib-in-an-android-application)."},"comment":{"url":"https://api.github.com/repos/geopaparazzi/libjsqlite-spatialite-android/issues/comments/137334804","html_url":"https://github.com/geopaparazzi/libjsqlite-spatialite-android/issues/12#issuecomment-137334804","issue_url":"https://api.github.com/repos/geopaparazzi/libjsqlite-spatialite-android/issues/12","id":137334804,"user":{"login":"mj10777","id":4899405,"avatar_url":"https://avatars.githubusercontent.com/u/4899405?v=3","gravatar_id":"","url":"https://api.github.com/users/mj10777","html_url":"https://github.com/mj10777","followers_url":"https://api.github.com/users/mj10777/followers","following_url":"https://api.github.com/users/mj10777/following{/other_user}","gists_url":"https://api.github.com/users/mj10777/gists{/gist_id}","starred_url":"https://api.github.com/users/mj10777/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mj10777/subscriptions","organizations_url":"https://api.github.com/users/mj10777/orgs","repos_url":"https://api.github.com/users/mj10777/repos","events_url":"https://api.github.com/users/mj10777/events{/privacy}","received_events_url":"https://api.github.com/users/mj10777/received_events","type":"User","site_admin":false},"created_at":"2015-09-03T05:22:31Z","updated_at":"2015-09-03T05:22:31Z","body":"After getting the basic `jsqlite.Database` working correctly\r\n* try to extend it to include\r\n   * `src/com/vividsolutions` \r\n\r\nwhich would add the functionality\r\n* to display / Paint the geometries retrieved by `jsqlite.Database`\r\n   * based on the code found, in the above meantioned\r\n      * `drawFromSpatialite()`\r\n\r\n---\r\nHope this helps"}}