sql-js / sql-js/sql.js

Load a database from the server Failed Error: file is encrypted or is not a database

Open
#185 9 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
JavaScript
Stars
13.7k
Forks
1.1k
PR merge metrics
No merged PRs in 30d

Description

Load a database from the server Failed Error: file is encrypted or is not a database
Here are my codes. test.db is in the root directory of my website
var xhr = new XMLHttpRequest();
xhr.open('GET', 'test.db', true);
xhr.responseType = 'arraybuffer';

xhr.onload = function(e) {
var uInt8Array = new Uint8Array(this.response);
var db = new SQL.Database(uInt8Array);
var contents = db.exec("SELECT * FROM testtable");
};
xhr.send();

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the XMLHttpRequest and SQL.Database construction shown in the issue, and reproduce the failure while inspecting the downloaded test.db response. Check the project’s browser-loading entry points and existing database-loading tests, if available. Done means identifying the cause of the reported error and defining a verified loading path or a documented limitation.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, sqlite
Domain
databases, web-dev
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.