Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using Phonegap-SQLitePlugin i.e. real Sqlite3, not localstorage (webSQLite / indexDB) #6

Open
ns-1m opened this issue Mar 20, 2012 · 4 comments

Comments

@ns-1m
Copy link

ns-1m commented Mar 20, 2012

By any chance we can use real sqlite3 database for SenchaTouch-v2-SqliteProxy?

https://github.com/davibe/Phonegap-SQLitePlugin

I think this can be easily done, by replacing this line ( in SqliteConnection.js):

me.dbConn = openDatabase(me.dbName,me.dbVersion, me.dbDescription, me.dbSize);

to:

me.dbConn = new PGSQLitePlugin("test_native.sqlite3");

@tomalex0
Copy link
Owner

It can be done like that, does android support this?

@ns-1m
Copy link
Author

ns-1m commented Mar 23, 2012

Android should suppose to easy (in theory) since it support SQLite as well. Some Android guys even manage to port Spatialite (GIS extension for SQLite3) library in Android.

PhoneGap SQLiteplugin is right now for iOS devices only (i.e. Objective-C + Javascript).

Hopefully, some guys would translate the Objective-C to Java (Android SDK) and use the existing Javascipt (PGSQLitePlugin.js from iOS).

@ns-1m
Copy link
Author

ns-1m commented Mar 23, 2012

This one is just copy an paste method, not real SQLite3 for Android.

I just place one here so people who might be interested in porting the Android PhoneGap SQLiteplugin can use this info.
http://stackoverflow.com/questions/9803606/phonegap-android-java-moving-a-pre-populated-sqlite-database-assets-folde

@ns-1m
Copy link
Author

ns-1m commented Mar 23, 2012

This project has the necessary files Java Android SDK for SQLite3/Spatialite.

https://github.com/mrenouf/android-spatialite

Somebody would like to knit pick those functions and assembly a Android PhoneGap SQLite plugin.

https://github.com/mrenouf/android-spatialite/tree/master/src/jsqlite

For sure this one of the file.
https://github.com/mrenouf/android-spatialite/blob/master/src/jsqlite/Database.java

Noli

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants