lazierthanthou / sqlite-manager Goto Github PK

when can display other Encoded?

Good morning, I am using your useful extension but I have a problem in duplicating rows.
I have an autoincrement column and need to duplicate records but, when I click on 'Duplicate' and modify the fields, the manager return an error because try to add a new value also into the autoincrement field.
It can be very useful if you give the opportunity to edit the sql into the preview before execution.

Thank you.
Stefano.

Since today's update (February 28th), I cannot open nor create any sqlite database using sqlite-manager. Every time I get this error message: Connect to 'Users/Spitfire/.../mydb.sqlite' failed: TypeError: $$(...) is null

Using sqlite-manager 0.8.1.1-signed with Firefox 43.0.3 on Windows 8.1, and starting from an empty SQLite file:

CREATE TABLE test (field1 STRING, field2 TEXT);
INSERT INTO test VALUES ('15E2621', '15E2621');

('15E2621' is a serial number that mixes digits and chars)

The value shown in field2 is correct.
The value shown in field1 is 'Infinity', which is not correct

My interpretation:
1 - STRING is not a valid SQLite type, so the 5th rule to chose type affinity applies, and gives NUMERIC.
2 - 15E2621 is parsed successfully as a float... but far too large (infinity).

I have no problem with point 1 (I fixed the issue for myself by changing the column type to TEXT).

/But I have a problem with the behavior of sqlite-manager regarding point 2/: the required reversibility checking (https://www.sqlite.org/datatype3.html, chapter 2) should have invalidate this conversion, leaving the text string, despite the NUMERIC affinity.

I usually use this addon only to search email addresses. So I regularly click on search to open the search function, the search window opens up, I need to change the field "value" from "=" to "contains" and enter "@". Then I need to confirm. This wastes time when I search for many different terms.

I'd like to have a field under the search tab in which I enter the search term "@ OR .com" and then the last used search will be executed using the term I entered. Ideally it results all email addresses and all terms which include .com.

SQLite Manager is a superb piece of work, however since I run Firefox Developer Edition v43.0a2 I can't find the tool anywhere. Any thoughts?

Mozilla plan to deprecate XUL extensions : XUL extensions won't work anymore in few month or probably next year in Firefox.

This extension is very useful for me (and many other users I guess). It mustn't died. I see there is an application.ini. So It may work with firefox --app. But I didn't find a package dedicated for firefox --app.

To no loose user, I think you should:

• propose a package that it is easy to use with firefox --app (probably create a bash/batch file to launch SQlite Manager)
• add this information on your addons.mozilla.org page

SQLiteManager: ALTER TABLE "main"."testtable" ADD COLUMN "testcolumn" VARCHAR DEFAULT foo bar [ near "bar": syntax error ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

I think it must identify these kind of situation and surround with double quotes.

On the left, there has always been a list of the tables that are in the currently opened database.

I must have closed something, because it's not there anymore... and I can't figure out how to reopen it.

Any help?

Thanks - Brian

Hi support team,

I tried to import an CSV file into an existing Tables but failed.
Error Information:
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

The same csv can create a new tables.

I have no idea anything I miss,
my firefox version is 34.0

Thanks,

aogogmei

Hey lazierthanthou (no you are not 😛 ),

It's not really an issue but since there is no better way to communicate with you, I'm creating one here.

What I wanted to ask is: Is the master branch of this repo sent to Mozilla's Repos? In other words - is this the repo which is updated most?
The reason I ask is that I am planning to make a firefox extension myself and since this is one of those I admire and use the most, I would like to study the source code of your extension.

PS [EDIT]: I can see that the last update was 2 days ago but do you update the code to Mozilla as well?

In the spanish version on the "Base de Datos" menu there's an option that says "Esportar Base de Datos" when it should be "Exportar Base de Datos" just like in the option above this one.

Just a tiny detail (:

I have not found a way to open a password protected using SQLite Manager. Please add options to open password protected database files.

Thanks,
Reas

Does this plug in provide SQLite support for web applications?
HTML which works in Chrome results in "openDatabase is not defined" in Firefox with this plug-in installed.
Please advise. Thank you

It does not always work in the database search add-on for FF43.0.4 (possibly earlier, for 42 there is no problem). For example, in plaсes.sglite ->url -> contains.

I am using Firefox in Traditional Chinese (zh-TW). Somehow I can't get the UI in corresponding locale. Not knowing if the same issue happens on other languages. Do I need to set-up something first? By the way, are there any instructions on translating this handy add-on?

SQLiteManager: Likely SQL syntax error: SELECT rowid, * FROM "main"."E6EAN" LIMIT 100 OFFSET 0 [ no such column: rowid ]

This is SQLiteManager 0.8.3.1 and sqlite3 3.11

See also https://sqlite.org/withoutrowid.html

When the left sidebar is very small (<30px or so), clicking on an item makes it go crazy. Crazy being defined as rapidly trying to resize itself, bigger and smaller, and bigger and smaller. The only way to fix the issue is to grab ahold of the sidebar and resize it to be larger.

Does not occur all every time. But very possible to reproduce. I got it to happen 3 times in ~5 min.

If you run a query in the "Execute SQL" tab and get a result containing NULL values, these cells are displayed with a pink background (so far everything is fine). If you then change the order of rows by clicking one of the column headers, the data is reordered properly, but the pink highlights stay in the rows they were at the start, regardless of whether the value in this cell is now NULL or not.

This is happening Firefox with extension version 0.8.3.1

sqlite-manager does not work with SQLite tables created with the WITHOUT ROWID option. Here is the error message:

SQLiteManager: Likely SQL syntax error: SELECT  `rowid`,  * FROM "main"."listings"  LIMIT 100 OFFSET 0 [ no such column: rowid ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

This is on 0.8.3.1-signed using Firefox 38.

Looks like its not possible to access hidden folders within the "Connect with database" dialogue.
Using 0.8.3.1 of sqlite-manager within FF 43.0.1 on a linux system.

The Analyze Database menu item does not seem to work (no output).

Connection/Disconnection is pretty fast on sqlite databases. It would be nice to disconnect after any action so the file is freed.

When working on shared database (I know, sqlite is not the best choice for shared databases), one can often forget to close the module. As a result all synchronization processes cannot work (on windows) because "File is being used by another person or process"

I downloaded the Chrome extension and unzipped the file. I went to Chrome Extensions, checked Developer Mode and then I click "Load unpacked extensions". I navigate to the SQLite Manager extension folder and click Ok. Chrome throws an error “Failed to load extension Manifest file is missing or unreadable.” I tried saving the chrome.manifest file to UTF8 encoding, same issue. I am using Chrome 64-bit.

Thank you for your assistance!

From a lazy user...
While viewing, changing or duplicating (for further mod, or to graft it onto another table) a trigger is actually an UPDATE/INSERT on sqlite_master, and therefore can be performed as regular SQL execution, having such commands on the left hand tree control as extra options to context menu there would be handy. Specifically the following two items are desirable:
Edit trigger
Displays an UPDATE query on the master table, with a clause SET listing the trigger text for straightforward change upon executing the query.
Copy trigger
Displays an INSERT query with field values identical to those of the right-clicked trigger. Changing the table or text will create a copy or variant of the trigger upon executing the query. Require that submitted tbl_name or sql be different from initial values.
Many thanks for the useful add-on!
Chris

I tried to execute the query below, but got no result message or error and the destination table received no data. Your software should at least return something.
Both tables are previously created and Table1 has data and Table2 is empty.

INSERT INTO Table2 SELECT * FROM Table1;

Tables:

CREATE TABLE Table1 (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,
"column1" INTEGER NOT NULL,
"column2" INTEGER NOT NULL,
"column3" DATETIME NOT NULL,
"column4" DATETIME
);

CREATE TABLE TicketHistory (
"id" INTEGER PRIMARY KEY NOT NULL ,
"column1" INTEGER NOT NULL,
"column2" INTEGER NOT NULL,
"column3" DATETIME NOT NULL,
"column4" DATETIME NOT NULL,
);

I have the latest ff37 and sqlitemngr0.8.3 and cannot get sqlite-manger plugin to open any firefox database. i choose a ff sqlite db from dropdown but list of tables do not populate on left. help
config: win7 x64 latest upds, ff37, sync on.
the only way to see data is to export table to csv.

While viewing a table, SQLite Manager currently provides a way to create, update and drop an index via a query. However, in some cases when viewing a database an index can have long names, which makes executing queries on these index difficult as they become a lot easier to mistype.

I'd like to suggest adding a way to view all the indexes for a table (let's say in a new tab) and then be able to create or alter the index there.

In case of a primary key distributed over several columns
when i choose to drop a column (not concerned by the primary key) the SQL order proposed, by sqlite manager, to rebuild the table miss the multi-columns primary key.
The proposed SQL order give the attribute PRIMARY KEY only to the first column

Extension lacks any hint of how to actually use it. No toolbar button, no using Ctrl+O from Firefox to open a DB, no tutorial on the home page.

I would be great if the value field of type TEXT could add some support for (stringified) JSON. Maybe converting the textbox in the edit record dialog and the tooltips to a treeview.

I'm asking because I'm storing a lot of stringified JSON data in records and reading them isn't easy.

This is not an issue, couldn't find any other place to post this question. I have searched many sites and read a lot of posts but couldn't find the way to create a Encrypted database of using SQLCipher. I do have a database contains thousands of words and I wanted to add this into my Android application. It is stated that Using https://www.zetetic.net/sqlcipher/sqlcipher-for-android/ I can decrypt the encrypted one. Is there any option in this Add on to create/update a database as a Encrypted one.

Is it possible to use SQLITE_ENABLE_UPDATE_DELETE_LIMIT ?

Thank you.

When importing a 329MB csv file receive this error:

[JavaScript Application]
CSV Worker error!
InternalError: allocation size overflow
File name: chrome://sqlitemanager/content/workerCsv.js
Line number: 21

It seems, there is a bug in the sqlite-manager exporting more than one table. I have a sqlite database, which contains a lot of tables. I tried to export it with the different options, but i don't get a complete file with all create table and insert statements.

1. Export all tables: Returns a file, with the CREATE and INSERT statements only for the first table.
2. Export database: Same result than topic 1.
3. Export database structure: Seems to be ok. But the INSERTs for the data are missing. So not usable for me.

I have a table set up with an AFTER UPDATE trigger to set a column's value to the current timestamp when that row is updated. It works for handwritten SQL instructions. However, if I edit a row using the edit menu on the Browse and Search screen, the update timestamp column is changed for every row in the table regardless of whether that row was changed or not.

Is there anyway to avoid this behavior and only fire trigger on the specific record being updated when using the GUI?

First of all, thanks a lot for this very useful extension.

I found a workaround to load predefined queries in for generated database. I first saved (exported) the __sm_ext_mgmt table in SQL, modified it to insert NamedQuery lines, and saved this SLQ file, so I can load (import) this file each time I open a database to retreive my queries.

1/ I would find very useful to be able to use these named queries when creating Views;
2/ is there any documentation about the other kind of lines in the __sm_ext_mgmt table?

When I export a database with FKs with the Export feature, the tables are not written to file in the right order. This becomes apparent when the exported database is re-imported with the Import feature, when a table B requires a table A because it references it - and table B is created before table A.
The error message upon importing looks like this:

SQLiteManager: 
INSERT INTO "B" VALUES(x,y); [ no such table: main.A ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

Hello,
i would to know how or have possiblity to connect to Firefox SQLite manager from other SQL client.

I suppose that is possible export DB file and import it into proper non Firefox SQLite engine, but i would like to connect locally or remotly into SQL lite running in browser engine without any export or db engine installation.

At work we use .db and .db3, would be nice to recognize them instead of having to select *.*

Query results can be exported to a CSV file via the "Actions/Save result (CSV) to file" button/dropdown menu. However, there is no option to include a header row containing the names of the columns, so when it is needed, it has to be added to the exported file manually.

Sqlite-manager 0.8.3.1, Sqlite 3.8.10.1, Firefox 41.0.1, Windows 7. Import Wizard only has CSV and SQL tabs.
Am I missing a library?

When I enter a value like 72057594037927935 to an INTEGER column, SQLite manager shows a wrong value (72057594037927940) instead. A different tool shows the correct value in the DB.

Table is created as: "CREATE TABLE "TEST" ("test" INTEGER PRIMARY KEY NOT NULL DEFAULT 0)"

Even if I enter 72057594037927935 and 72057594037927936 to the same table, SQLite Manger is showing the value 72057594037927940 twice.

Used versions are SQLite Manager 0.8.3, Firefox 31.6, Win7 64-bit.

When you define a custom rowid, such as "rowid INTEGER PRIMARY KEY ASC", then SQLite Manager displays two times rowid.
It looks like SQLite Manager automatically adds "rowid" to all "select *" requests, even when there is already a rowid column.

Generally speaking, it looks like there is no management for custom rowid (or no rowid), like reported in issue #25 .

Hey there,

Tried to install this awesome extension into Komodo IDE 9.1 but it says it's not supported; I would hazard a guess it's merely the version string that is incorrect :)

Cheers,
Josh

Hi. I installed sqlite-manager but can't find the toolbar icon to run it. (Normally looks like a shiny blue cylinder). I can't find any relevant settings in Options. When I try to customise the icons by right-click in the toolbar area, the icon for sqlite-manager is not there.

The only way to run sqlite-manager is to display the old fashioned FF menu at the top and it's available under Tools. What am I doing wrong?

I seem to remember this issue has been around forever. I've certainly had a problem on various different PCs. I'm using FF 47.0 on Windows 7.

1. I am on sqlite version 3.8.8.3 and sqlite manager version 0.8.3.
2. I have defined a table XREF with two fields ftype and bu each of which is defined as a Foreign Key (FK) in XREF and is a primary key in two tables FILETYPE and BUSINESSUNIT. The relevant part of the XREF schema reads as "BU varchar(2) NOT NULL,ftype varchar(5) NOT NULL, FOREIGN KEY(BU) REFERENCES BUSINESSUNIT(BU), FOREIGN KEY(ftype) REFERENCES FILETYPE(FTYPE)".
3. On sqlite-manager I changed an existing data record in XREF to have an invalid value in the BU field (i.e. it does not exist in the BUSINESSUNIT table). The record was changed successfully and displays with invalid field value in sqlite-manager.
4. Querying the database with the PRAGMA foreign_key_list(XREF) displays a violation with on_update = NO ACTION and on match as NO ACTION NONE.
   Why is sqlite-manager allowing an update that violates the FK constraint.

I often create and populate a DB in other code and then use this to confirm it. A quicker way to close current DB and then re-open (after I've run my create-and-populate code) would be handy. Seems 2 new buttons after "Connect Database" would suffice (yes, I know it's right there in the "Database" menu but ...).

Firefox 38.0.5
SQLite Manager 0.8.3.1-signed

I create a table x:
CREATE TABLE x (Nbr INTEGER PRIMARY KEY, FullName TEXT)

Use GUI to add a record. Use GUI to duplicate the record
In duplicate record I deleted the value in Nbr
Click on "OK"
Result:

INSERT INTO "main"."x" ("Nbr","FullName") VALUES (,?1)
Parameters:
param 1 (text): Test

Click on "OK"
Result:
SQLiteManager: Create statement failed (executeWithParams): INSERT INTO "main"."x" ("Nbr","FullName") VALUES (,?1) [ near ",": syntax error ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]