CODEWITHSUNDEEP
javascriptajaxsqlitegoogle-chrome-extension
Don P
Don P

Reputation: 63567

Run a query on a local SQLite file, from JavaScript

I want to execute queries against a local SQLite file, from JavaScript. How can this be done?

By local, I mean a .sqlite file on the user's computer. I do not need storage for an application, so suggestions about WebSQL are not helpful.

The use-case is, I have many local SQLite files that I use as a database for other applications. I am trying to build a Chrome Extension that lets me query the SQLite files so I can see data contents without having to use my SQLlite workbench app, which sucks.

Upvotes: 0

Views: 1355

Answers (1)

Xan
Xan

Reputation: 77482

An extension would not be able to do that. While you can "upload" a file to an extension, it would not retain access to the file on disk; it would be just a snapshot at the moment of an upload.

An app, however, can. With chrome.filesystem API, you can request read or read/write access to a file, and retain the resulting entry to query it again later without dialogs to the user.

Of course, it's up to your JS code to actually read the database. There is no API for that, you need to use a library.

Upvotes: 2

Related Questions