最終更新:2019-03-13 (水) 20:10:43 (1832d)
Web SQL Database
Top / Web SQL Database
http://www.w3.org/TR/webdatabase/
SQLiteベース。Chrome,Opera,Safariで実装。Firefoxではサポートされない
上限
Mobile Safari 8? 5,10,25,50MB WKWebView iOS 9までは動かないらしい UIWebView 50MB Mobile Safari 50MB Android 4.3 200MB~ Android 5.0 up to quota
クラスとか
- Database? db = window.openDatabase(....);
- db.transaction(
- transaction.executeSql
- db.transaction(
window.openDatabase
interface WindowDatabase { Database openDatabase(in DOMString name, in DOMString version, in DOMString displayName, in unsigned long estimatedSize, in optional DatabaseCallback creationCallback); };
Web SQL Database/Database?
interface Database { void transaction(in SQLTransactionCallback callback, in optional SQLTransactionErrorCallback errorCallback, in optional SQLVoidCallback successCallback); void readTransaction(in SQLTransactionCallback callback, in optional SQLTransactionErrorCallback errorCallback, in optional SQLVoidCallback successCallback); readonly attribute DOMString version; void changeVersion(in DOMString oldVersion, in DOMString newVersion, in optional SQLTransactionCallback callback, in optional SQLTransactionErrorCallback errorCallback, in optional SQLVoidCallback successCallback); };
Web SQL Database/SQLTransaction?
interface SQLTransaction { void executeSql(in DOMString sqlStatement, in optional ObjectArray arguments, in optional SQLStatementCallback callback, in optional SQLStatementErrorCallback errorCallback); }; [Callback=FunctionOnly, NoInterfaceObject] interface SQLStatementCallback { void handleEvent(in SQLTransaction transaction, in SQLResultSet resultSet); }; [Callback=FunctionOnly, NoInterfaceObject] interface SQLStatementErrorCallback { boolean handleEvent(in SQLTransaction transaction, in SQLError error); };
メモ
- 2010年11月18日、W3C はWeb SQL Database は廃止仕様とした