davibe
commented
12 years ago The string you pass to the PGSQLitePlugin constructor is a the db filename. This filename is joined with the appData directory to create a full db path.
Then sqlite3_open gets called with the full db path. This function automatically creates a new db if the file does not exsists otherwise it opens the existing one.
see https://github.com/davibe/Phonegap-SQLitePlugin/blob/master/Plugins/PGSQLitePlugin.m#L42
Davide Bertola
On Mar 18, 2012, at 12:36 AM, Noli Sicad wrote:
In WebSQL / indexDB:
var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);
http://www.tutorialspoint.com/html5/html5_web_sql.htm
############
Now, how to we open a database (i.e. openDatabase) with the existing sqlite database (e.g. myLocation.sqlite3)
var db = openDatabase ( )
#############
In the example Readme.
var db; db = new PGSQLitePlugin("test_native.sqlite3");
Is the "test_native.sqlite3" would be created in the above snippet (i.e new) or can be existing database?
How can we open an existing Sqlite3 database (e.g. myOldLocation..sqlite3)?
Reply to this email directly or view it on GitHub: https://github.com/davibe/Phonegap-SQLitePlugin/issues/13
ns-1m
In WebSQL / indexDB:
var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);
http://www.tutorialspoint.com/html5/html5_web_sql.htm
Now, how to we open a database (i.e. openDatabase) with the existing sqlite database (e.g. myLocation.sqlite3)
var db = openDatabase ( )
In the example Readme.
var db; db = new PGSQLitePlugin("test_native.sqlite3");
Is the "test_native.sqlite3" would be created in the above snippet (i.e new) or can be existing database?
db.executeSql('DROP TABLE IF EXISTS test_table');
It seems also extisting (noticing the above line).
Anyway, I just like to make it sure, how to open existing databases.