SQLite Manager - Extension for Firefox, Sunbird, Flock, etc.

Announce and Discuss the Latest Theme and Extension Releases.
Post Reply
nibl
Posts: 5
Joined: January 14th, 2005, 3:25 pm

Post by nibl »

Using 0.2.8.5 on Ubuntu Edgy, Firefox 2.0.0.8, I have two serious problems:

1) The create table dialog does not react when clicking "OK". No table is created, you must press cancel to close the dialog.


2) Import: An error tells me the sqlite DB is not valid. But this is a valid sample DB for Kbarcode which works in sqlite and kbarcode. It is a sample DB provided by the author and unchanged.

Can I get a notification when the extension is updated, it looks like a very useful program.
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Post by mrinal.kant »

nibl wrote:Using 0.2.8.5 on Ubuntu Edgy, Firefox 2.0.0.8, I have two serious problems:

1) The create table dialog does not react when clicking "OK". No table is created, you must press cancel to close the dialog.


2) Import: An error tells me the sqlite DB is not valid. But this is a valid sample DB for Kbarcode which works in sqlite and kbarcode. It is a sample DB provided by the author and unchanged.

Can I get a notification when the extension is updated, it looks like a very useful program.


version 0.2.8.6 is available here: http://addons.songbirdnest.com/extensions/detail/89
It is yet to be reviewed by an AMO editor. I have already submitted it there nearly 6 hours back. It fixes the following bugs:
Bugs fixed:
- create Table/Index/etc. boxes had stopped working. this problem got introduced in version 0.2.8.5. Fixed now.
- on choosing "export table" the table name did not show up. Fixed.
- opening in a tab, only General and Database menus were visible. Fixed.

thanks to shantanu oak again for pointing out the bugs

Could you also point me to the sqlite db that you are referring to?
Last edited by mrinal.kant on November 22nd, 2007, 1:42 am, edited 1 time in total.
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: Add Record window

Post by mrinal.kant »

shantanuo wrote:
drexton wrote:It nearly invisible, all that shows up is about a 2 pixel wide drop down shadow in the main window. Occasionally if I click in just the right spot I can get the drop down window to expand, but usually this proves impossible.

Same with Ubuntu.


Thanks for that feedback. I should be able to fix this problem in a couple of hours if it is a problem with Ubuntu too. Meanwhile version 0.2.8.7 is still under review at AMO.
Until then, version 0.2.8.7 is available here: http://addons.songbirdnest.com/extensions/detail/89
It fixes the following bugs that u pointed out:
Bugs fixed:
- create Table/Index/etc. boxes had stopped working. this problem got introduced in version 0.2.8.5. Fixed now.
- on choosing "export table" the table name did not show up. Fixed.
- opening in a tab, only General and Database menus were visible. Fixed.
Last edited by mrinal.kant on November 22nd, 2007, 1:16 am, edited 1 time in total.
User avatar
Philip Chee
Posts: 6475
Joined: March 1st, 2005, 3:03 pm
Contact:

Re: Ubuntu?

Post by Philip Chee »

shantanuo wrote:On Ubuntu OS:
The add/ Edit record opens a pop-up window with correct width. But the height of the window is anywhere between 0-5 px. I have to resize it and then update the record.
Adding window.sizeToContent(); to the end of StructureManager.loadDialog() seems to fix this issue.

Phil
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: Horizontal scroll bars

Post by mrinal.kant »

tiliqua wrote:Great extension!

Could you possibly add a horizontal scroll bar to the Browse & Search tab? (or am i just missing something and need to figure out how to turn it on... ;) One of my tables has ~30+ columns and they disappear off the right side of the screen.

Edit:WinXP, Firefox 2.0.0.9, SQLite Manager 0.2.8.5


I will sure try that. In fact I have tried that once already. The problem I faced then was that I was unable to resize the last column. And, when the resize worked there were some other problems.
Firefox 3 will automatically include a horizontal scroll bar in such cases. So, I had given up trying to fix this. Since you need this, I will try once again.
Last edited by mrinal.kant on March 14th, 2008, 11:08 pm, edited 1 time in total.
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: Ubuntu?

Post by mrinal.kant »

Philip Chee wrote:
shantanuo wrote:On Ubuntu OS:
The add/ Edit record opens a pop-up window with correct width. But the height of the window is anywhere between 0-5 px. I have to resize it and then update the record.
Adding window.sizeToContent(); to the end of StructureManager.loadDialog() seems to fix this issue.

Phil


Thanks Phil. I have incorporated that change in version 0.2.8.6. But I cannot test it until the next few hours. That is when I can access the Ubuntu machine.
nibl
Posts: 5
Joined: January 14th, 2005, 3:25 pm

0.2.8.6 download

Post by nibl »

mrinal.kant wrote: Until then, version 0.2.8.6 is available here:
http://sqlitemanager.mozdev.org/SQLiteManager-0286.xpi



- The address gives me a file not found error.

- I can send you the sample DB by PM if poss.?, or do you prefer email?
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: 0.2.8.6 download

Post by mrinal.kant »

nibl wrote:
mrinal.kant wrote: Until then, version 0.2.8.6 is available here:
http://sqlitemanager.mozdev.org/SQLiteManager-0286.xpi



- The address gives me a file not found error.

- I can send you the sample DB by PM if poss.?, or do you prefer email?


Strange. I could find the file there when I downloaded but not anymore. Anyway, pl download the extension from http://addons.songbirdnest.com/extensions/detail/89
User avatar
Philip Chee
Posts: 6475
Joined: March 1st, 2005, 3:03 pm
Contact:

Post by Philip Chee »

I don't think mozdev allows you to serve XPI files out of your www directories. Anyway I see that http://downloads.mozdev.org/sqlitemanager/SQLiteManager_0.2.8.7.xpi is now available from the download mirrors.

Phil
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Post by mrinal.kant »

Philip Chee wrote:I don't think mozdev allows you to serve XPI files out of your www directories. Anyway I see that http://downloads.mozdev.org/sqlitemanager/SQLiteManager_0.2.8.7.xpi is now available from the download mirrors.

Phil

Yes, I realized that later. In fact, after committing to www directory, the xpi file was available at least for a few seconds because I tested it.

Also, thanks for that sizeToContent idea. It fixed the problem on Kubuntu. Perhaps, on Mac too.

This is the first time that I introduced some serious bugs in a new version 0.2.8.5. So the version 0.2.8.6 should have been made public by AMO editors very fast. But some problem there. Normally, they make my extension's new version public in a matter of 3-6 hrs. But this time, when such speed was most needed, it is over 24 hrs now and no comments from any editor yet. Thankfully, mozdev.org and songbirdnest.com are available. These are where I have put the latest version as of now. Hopefully, it fixes some of the serious bugs.
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: 0.2.8.6 download

Post by mrinal.kant »

nibl wrote:
mrinal.kant wrote: Until then, version 0.2.8.6 is available here:
http://sqlitemanager.mozdev.org/SQLiteManager-0286.xpi



- The address gives me a file not found error.

- I can send you the sample DB by PM if poss.?, or do you prefer email?


1. I am sure you must have found the new version at http://downloads.mozdev.org/sqlitemanag ... .2.8.7.xpi or http://addons.songbirdnest.com/extensions/detail/89

2. the kbarcode_sqlite.db is a sqlite 2.1 database. Firefox, etc. use the sqlite 3 library that is why that file cannot be opened. However, I have converted it to sqlite3 db with the name kbarcode_sqlite3.db and mailed it to you. In case you need to convert more of your older version sqlite db files to sqlite 3, you can easily do so yourself by following the instructions at http://www.wpdev.org/wiki/index.php/Con ... te3_format
User avatar
Philip Chee
Posts: 6475
Joined: March 1st, 2005, 3:03 pm
Contact:

Post by Philip Chee »

mrinal.kant wrote:This is the first time that I introduced some serious bugs in a new version 0.2.8.5. So the version 0.2.8.6 should have been made public by AMO editors very fast. But some problem there. Normally, they make my extension's new version public in a matter of 3-6 hrs. But this time, when such speed was most needed, it is over 24 hrs now and no comments from any editor yet. Thankfully, mozdev.org and songbirdnest.com are available. These are where I have put the latest version as of now. Hopefully, it fixes some of the serious bugs.
There are two things you can do:

1. send email to amo-editors@mozilla.org .
2. go to irc://moznet and join the "addons" channel and ping one of the editors (whoever is on line at the moment) to alert them of the urgency.

Phil
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Version 0.2.9.0 released

Post by mrinal.kant »

I have published version 0.2.9.0 of SQLite Manager. You can download it from http://addons.songbirdnest.com/extensions/detail/89

It is pending for review at addons.mozilla.org. Should be available there too shortly.

New in version 0.2.9.0:
- Database tab which shows the database settings; also, allows you to change the settings right there without having to execute pragma statements separately
- Under Database menu, we have option to Compact (using Vacuum statement) and Analyze (using Analyze statement) the database
- A menu item under General menu to see the version of SQLite library

Bugs fixed in this version:
- display of data in Browse tab is faster. This is because the script for displaying the data was being executed twice when you clicked on the browse tab. This has been fixed.
darshanmarathe
Posts: 2
Joined: November 26th, 2007, 2:21 am
Location: India
Contact:

Re: Version 0.2.9.0 released

Post by darshanmarathe »

Hi
Ones you open the about window why it shows download window

mrinal.kant wrote:I have published version 0.2.9.0 of SQLite Manager. You can download it from http://addons.songbirdnest.com/extensions/detail/89

It is pending for review at addons.mozilla.org. Should be available there too shortly.

New in version 0.2.9.0:
- Database tab which shows the database settings; also, allows you to change the settings right there without having to execute pragma statements separately
- Under Database menu, we have option to Compact (using Vacuum statement) and Analyze (using Analyze statement) the database
- A menu item under General menu to see the version of SQLite library

Bugs fixed in this version:
- display of data in Browse tab is faster. This is because the script for displaying the data was being executed twice when you clicked on the browse tab. This has been fixed.
Regards
Darshan Marathe
www.ajaxguy.i.am
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: Version 0.2.9.0 released

Post by mrinal.kant »

darshanmarathe wrote:Hi
Ones you open the about window why it shows download window



It just opens a dialog. May I know what version you are using and
what is the target application (firefox/thunderbird/etc.)?

The changelog is at

https://addons.mozilla.org/en-US/firefo ... sions/5817
Post Reply