Does not Support CTEs Rated 3 out of 5 stars

Good tool but it need to be updated to support Common Table Expressions

FireFox 29 compatibility Rated 5 out of 5 stars

How to launch this addon in FireFox 29?

Rated 5 out of 5 stars

My son is very grateful for this addon

Very good Sqlite database. Rated 5 out of 5 stars

I think that sqlite database is very good database.

Rated 5 out of 5 stars

Exactly what I needed.

Rated 5 out of 5 stars

Fantastic! Extremely simple to use, does everything I need.

Rated 5 out of 5 stars

Great tool for developer

Rated 5 out of 5 stars

Very nice addon. Thanks.

Rated 4 out of 5 stars

Nice little add-on. Perfect for my simple query needs and fits nicely tucked inside Firefox! Great job!

Settings functionality could be a little better.

Rated 5 out of 5 stars

Great addons
no hang no bang

Thanks guys

This review is for a previous version of the add-on (0.8.0). 

Rated 2 out of 5 stars

This is one big joke of an add-on. It is sluggish and its UI rendering speed is just sad. After installation of this add-on Firefox would start up no more and would just clog one CPU core to 100% without showing the window. 2* for the effort.

This review is for a previous version of the add-on (0.8.0). 

Rated 5 out of 5 stars

Very good. Why list is white in my new FF 23, on my old FF 3.6 was colored, like fileds in editor? Preview of images stored in blobs will be nice.

This review is for a previous version of the add-on (0.8.0). 

Rated 5 out of 5 stars

Actually registered here just to rate this addon and say 'Thanks' and 'Great Job'! :)

Better than all 6 of the other 'managers' I've downloaded and tried!

This review is for a previous version of the add-on (0.8.0). 

Rated 1 out of 5 stars

There's a SEVERE error in SQLite. It's actually returning incorrect queries. It happens any time an OR is used in a LEFT JOIN statement. This is a very serious and critical error. If you like you can see my fiddle which demonstrates this issue.
Here's my original issue from the SQLite mailing list:
I'm getting unexpected and differing results between WebSQL(SQLite) and SQLite. The query produces the correct results in WebSQL.

This is the script that I'm running. It's designed to allow us to filter out, over several tables, data that we decide is not interesting and therefore whitelisting it.

First here's the link to the fiddles I've created demonstrating this issue. The correct result is one row; SQLite returns all rows.
http://sqlfiddle.com/#!7/74e01/1 WebSQL(SQLite)
http://sqlfiddle.com/#!5/74e01/1 SQLite(SQL.js) (Click "Cancel" if prompted.)


CREATE TABLE scans (
scan_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL);


CREATE TABLE hosts(
host_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
scan_id INTEGER NULL);

CREATE TABLE programs(
program_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
host_id INTEGER NULL,
name varchar NULL,
publisher varchar NULL);

CREATE TABLE whitelist(
whitelist_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
scan_id INTEGER NULL,
value1 varchar NULL,
value2 varchar NULL
);

insert into hosts(host_id) VALUES (1);

insert into programs(program_id,host_id,name,publisher) VALUES (1,1,"foo", "foo");
insert into programs(program_id,host_id,name,publisher) VALUES (2,1,"bar", "bar");
insert into programs(program_id,host_id,name,publisher) VALUES (3,1,"abc", "def");
insert into programs(program_id,host_id,name,publisher) VALUES (4,1,"ghi", "jkl");
insert into programs(program_id,host_id,name,publisher) VALUES (5,1,"mno", "jkl");
insert into programs(program_id,host_id,name,publisher) VALUES (6,1,"pqr", "stu");

insert into whitelist(whitelist_id,value1,value2) VALUES (1,"foo","foo");
insert into whitelist(whitelist_id,value1,value2) VALUES (2,"bar","bar");
insert into whitelist(whitelist_id,value1,value2) VALUES (3,"abc","");

---The Query---

SELECT *
FROM programs p
LEFT JOIN hosts h
ON p.host_id = h.host_id
LEFT JOIN whitelist w
ON (w.value1 = p.name
AND p.publisher = w.value2)
OR ( w.value1 = ''
AND p.publisher = w.value2 )
OR ( w.value2 = ''
AND p.name = w.value1 )
WHERE w.whitelist_id IS NULL



And here's the correct answer:

The bug was fixed for 3.7.17. It's this one:

http://www.sqlite.org/src/info/f2369304e47167e3e


Please fix!!!

This review is for a previous version of the add-on (0.8.0). 

Rated 5 out of 5 stars

Very Useful Tool For Me.
Thanks

This review is for a previous version of the add-on (0.8.0). 

import function work. OK!! Rated 5 out of 5 stars

Thank you!!

This review is for a previous version of the add-on (0.8.0).  This user has a previous review of this add-on.

Rated 5 out of 5 stars

Excellent tool, great feature for importing data

This review is for a previous version of the add-on (0.7.7). 

Rated 2 out of 5 stars

As saturngod mentioned below, there are new bugs with the latest release. Export seems to be broken as well. I can't select the database and table on the drop down menus, and there are two OK buttons. Worked great until now. Using FF 20.0.1 and SQLM 0.7.7.

This review is for a previous version of the add-on (0.7.7). 

Rated 5 out of 5 stars

the only one tool I'm using for sqlite

This review is for a previous version of the add-on (0.7.7). 

import is not working Rated 2 out of 5 stars

after updating , I can't import from file.

I am using mac OSX 10.8.3 and firefox 20

This review is for a previous version of the add-on (0.7.7).