Sqlite in chrome

Question

Is it possible to make chrome extension that interacts with sqlite database similarly as firefox extension  Could you give me some advise or link where is more info about developing chrome extension interacting with sqlite   thank you

User · Answer

I m not quite sure if you mean  can i use sqlite  websql  in chrome  or  can i use sqlite  websql  in firefox   so I ll answer both    You cannot use WebSQL in Firefox   sql js is an option  but really  1 5 mb of js for a database   You can definitely use WebSQL in a chrome extension  See for instance the webkit window openDatabase docs for an introduction   Note that WebSQL is not a full-access pipe into an  sqlite database  It s WebSQL  You will not be able to run some specific queries like VACUUM  It s awesome for Create   Read   Update   Delete though  I made a little library that helps with all the annoying nitty gritty like creating tables and querying and a provides a little ORM ActiveRecord pattern with relations and all and a huge stack of examples that should get you started in no-time  you can check that here  Also  be aware that if you want to build a FireFox extension  Their extension format is about to change  Make sure you want to invest the time twice   While the WebSQL spec has been deprecated for years  even now in 2017 still does not look like it will be be removed from Chrome for the foreseeable time  They are tracking usage statistics and there are still a large number of chrome extensions and websites out there in the real world implementing the spec

User · Answer

You can use Web SQL API which is an ordinary SQLite database in your browser and you can open modify it like any other SQLite databases for example with Lita   Chrome locates databases automatically according to domain names or extension id  A few months ago I posted on my blog short article on how to delete Chrome s database because when you re testing some functionality it s quite useful

User · Answer

Chrome supports WebDatabase API  which is powered by sqlite   but looks like W3C stopped its development

User · Answer

You might be able to make use of sql js      sql js is a port of SQLite to JavaScript  by compiling the SQLite C code with Emscripten  no C bindings or node-gyp compilation here     lt script src  js sql js  gt  lt  script gt   lt script gt        Create the database     var db   new SQL Database           Run a query without reading the results     db run  CREATE TABLE test  col1  col2             Insert two rows   1 111  and  2 222      db run  INSERT INTO test VALUES                 1 111 2 222            Prepare a statement     var stmt   db prepare  SELECT   FROM test WHERE col1 BETWEEN  start AND  end        stmt getAsObject   start 1   end 1        col1 1  col2 111          Bind new values     stmt bind   start 1   end 2        while stmt step                 var row   stmt getAsObject                     do something with the row of result        lt  script gt    sql js is a single JavaScript file and is about 1 5MiB in size currently  While this could be a problem in a web-page  the size is probably acceptable for an extension

[javascript] Sqlite in chrome

Examples related to javascript

Examples related to sqlite

Examples related to google-chrome-extension