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

Announce and Discuss the Latest Theme and Extension Releases.
Post Reply
CharlieCL
Posts: 3
Joined: December 10th, 2007, 4:47 pm

How to call a C++ dll function in SQLite Manager?

Post by CharlieCL »

Is there any way to call a function in a dll library?
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

version 0.3.0

Post by mrinal.kant »

It is safe to say that Firefox 3 is around the corner. It embeds the version 3.5.4.1 of sqlite library. Also, there are improvements in XUL. I intend to begin working on using these features in sqlite manager now. In fact, I have been eagerly waiting to do so since the last 3 months. Why? Some reasons are enumerated below:

- the following pragma statements would not work in Firefox 2 but they do in Firefox 3 (Gecko 1.9; sqlite 3.5.4): schema_version, user_version, locking_mode, max_page_count
- Trees can now be scrolled horizontally, which means that you can now see all the columns of a table with appropriate width instead of trying to fit them in the tree's width. This is important if you have too many columns in the table.
- we have numeric textboxes, which means no need to write additional code to ensure that only number is allowed in a textbox. This will be of use in some preferences and db settings.

Other major change I plan to introduce:

- allow the user to store some extension related info in a table within the sqlite db. E.g., query history: a record of all successfully executed sqls from the execute sql tab which can then be accessed using back and forward buttons/images.
CharlieCL
Posts: 3
Joined: December 10th, 2007, 4:47 pm

Use SQLite Manager with a Web Server Like PHPMyAdmin

Post by CharlieCL »

How can I use SQLite Manager along with an Apache server like PHPMyAdmin? So I can use SQLite Manager by launch a SQLite database in URL http://www.mydb.com/sqlitemanger/mydb.sqlite.
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: Use SQLite Manager with a Web Server Like PHPMyAdmin

Post by mrinal.kant »

CharlieCL wrote:How can I use SQLite Manager along with an Apache server like PHPMyAdmin? So I can use SQLite Manager by launch a SQLite database in URL http://www.mydb.com/sqlitemanger/mydb.sqlite.


Sorry, this extension does not do what you want. You must first download the db file to client computer and then use the extension for it.

However, the better thing would be to use a different software which are available on internet for doing exactly what you want.
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: version 0.3.0

Post by mrinal.kant »

mrinal.kant wrote:It is safe to say that Firefox 3 is around the corner. It embeds the version 3.5.4.1 of sqlite library. Also, there are improvements in XUL. I intend to begin working on using these features in sqlite manager now. In fact, I have been eagerly waiting to do so since the last 3 months. Why? Some reasons are enumerated below:

- the following pragma statements would not work in Firefox 2 but they do in Firefox 3 (Gecko 1.9; sqlite 3.5.4): schema_version, user_version, locking_mode, max_page_count
- Trees can now be scrolled horizontally, which means that you can now see all the columns of a table with appropriate width instead of trying to fit them in the tree's width. This is important if you have too many columns in the table.
- we have numeric textboxes, which means no need to write additional code to ensure that only number is allowed in a textbox. This will be of use in some preferences and db settings.

Other major change I plan to introduce:

- allow the user to store some extension related info in a table within the sqlite db. E.g., query history: a record of all successfully executed sqls from the execute sql tab which can then be accessed using back and forward buttons/images.


For Firefox 3 users only:
version 0.3.0b1 is a beta version which can be downloaded from http://code.google.com/p/sqlite-manager/downloads/list

It incorporates some of the changes proposed in the quote above as well as better localization (more strings in locale/en-US).
P-Y Delens
Posts: 10
Joined: December 10th, 2004, 7:53 am
Location: Bruxelles
Contact:

Connect to preexisting Sqlite database file

Post by P-Y Delens »

Bonjour,

this is my first test of SqLite LManager in Firefox (2.0.06)

Seems wonderful,
but why do I fail to connect to my existing LTF-Mngt.db file (SqLite 2.8)?
Even if renaming to *.sqlite?
As there is a SqLite version option, I guess both generations 2 and 3 for db files are supported .. ?

What can I do?
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: Connect to preexisting Sqlite database file

Post by mrinal.kant »

P-Y Delens wrote:Bonjour,

this is my first test of SqLite LManager in Firefox (2.0.06)

Seems wonderful,
but why do I fail to connect to my existing LTF-Mngt.db file (SqLite 2.8)?
Even if renaming to *.sqlite?
As there is a SqLite version option, I guess both generations 2 and 3 for db files are supported .. ?

What can I do?


No, only sqlite 3 is supported because firefox 2 embeds sqlite 3. This extension merely provides the gui for the embedded sqlite library. In order to use 2.8 db, you must first convert it to sqlite3 format. Instructions to do so can be found at http://www.wpdev.org/wiki/index.php/Con ... te3_format

sqlite version option is given so that you can get to know the version of the embedded sqlite.
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: version 0.3.0

Post by mrinal.kant »

mrinal.kant wrote:It is safe to say that Firefox 3 is around the corner. It embeds the version 3.5.4.1 of sqlite library. Also, there are improvements in XUL. I intend to begin working on using these features in sqlite manager now. In fact, I have been eagerly waiting to do so since the last 3 months. Why? Some reasons are enumerated below:

- the following pragma statements would not work in Firefox 2 but they do in Firefox 3 (Gecko 1.9; sqlite 3.5.4): schema_version, user_version, locking_mode, max_page_count
- Trees can now be scrolled horizontally, which means that you can now see all the columns of a table with appropriate width instead of trying to fit them in the tree's width. This is important if you have too many columns in the table.
- we have numeric textboxes, which means no need to write additional code to ensure that only number is allowed in a textbox. This will be of use in some preferences and db settings.

Other major change I plan to introduce:

- allow the user to store some extension related info in a table within the sqlite db. E.g., query history: a record of all successfully executed sqls from the execute sql tab which can then be accessed using back and forward buttons/images.


I tried creating a separate version for firefox 3 (gecko 1.9) to incorporate the above, but got a very poor response. The idea was to reduce my work and avoid testing the extension on multiple platform versions. However, poor response = poor direction.

So, I am back on the original track and have uploaded version 0.2.27 at AMO.
You can download the latest version from:
songbirdnest.com: http://addons.songbirdnest.com/extensions/detail/89
AMO: https://addons.mozilla.org/en-US/firefox/addon/5817
code.google.com: http://code.google.com/p/sqlite-manager/downloads/list

In this version:
Changes:
- General menu: added a menuitem called "Enable Table for Extension Data" which creates a table in the database to remember the query history of successful queries in Execute SQL tab. There are back and forward buttons in that tab to retrieve the stored queries. Also, the extra table created in the db can be removed using the disable menuitem under general menu. The name of the table is changeable using options.

- Database menu: added menuitem to check integrity using "PRAGMA integrity_check"
- DB Settings tab: added controls for schema version, user version if underlying platform of the application is > gecko 1.9b3
-DB Settings tab: added controls for locked mode, max page count.
- Execute tab: the PRAGMA menu does not show commands which can be queried/set through DB Settings tab.
- more strings now come from locale.

Thus, the extension enables features based on newer version of Gecko after detecting the version in the application.

Complete changelog: https://addons.mozilla.org/en-US/firefo ... sions/5817
Homepage: http://sqlitemanager.mozdev.org/
FAQs: http://sqlitemanager.mozdev.org/faq.html
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: version 0.3.0

Post by mrinal.kant »

version 0.2.28 has been released.

You can download the latest version from:
songbirdnest.com: http://addons.songbirdnest.com/extensions/detail/89
AMO: https://addons.mozilla.org/en-US/firefox/addon/5817
code.google.com: http://code.google.com/p/sqlite-manager/downloads/list

In this version:
Changes:
- Options/Preferences:
- new preference for setting the number of maximum columns in create table dialog
- new preference for setting the rows of the multiline textbox for entering sql in execute sql tab
- options dialog: a little reorganization; "toolbar" tab renamed as "user interface" tab which allows to set toolbar settings as well as the two mentioned above
- options dialog: control for setting the number of records to display moved from "main" tab to "user interface" tab
- bug fixed: if table for extension data was enabled, the UI in execute sql tab failed to show the previous/next/clear images on reopening the db. Fixed.
- localization: many more strings out of .js into .properties file. This will help localizers.
- execute sql tab:
- more space for results by removing the line which showed the number of rows returned. This information is now displayed in the status bar.
- merged create and alter table menus to create space for "run" button alongside the menu so that one more line can be removed which currently has run button and last error. I plan to keep last error hidden except when there is a real error in which case it can be shown with the message in red color, etc.

Complete changelog: https://addons.mozilla.org/en-US/firefo ... sions/5817
Homepage: http://sqlitemanager.mozdev.org/
FAQs: http://sqlitemanager.mozdev.org/faq.html
20after4
Posts: 1
Joined: February 27th, 2008, 10:16 pm
Contact:

Re: version 0.3.0

Post by 20after4 »

For Firefox 3 users only:
version 0.3.0b1 is a beta version which can be downloaded from http://code.google.com/p/sqlite-manager/downloads/list

It incorporates some of the changes proposed in the quote above as well as better localization (more strings in locale/en-US).[/quote]

I'm interested in testing your 0.3.0 beta and I may be able to help with development in some way.. I can't find it on your google project page anymore, have you given up on the new functionality or has that been rolled into the 0.2.x series?
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: version 0.3.0

Post by mrinal.kant »

20after4 wrote:For Firefox 3 users only:
version 0.3.0b1 is a beta version which can be downloaded from http://code.google.com/p/sqlite-manager/downloads/list

It incorporates some of the changes proposed in the quote above as well as better localization (more strings in locale/en-US).

I'm interested in testing your 0.3.0 beta and I may be able to help with development in some way.. I can't find it on your google project page anymore, have you given up on the new functionality or has that been rolled into the 0.2.x series?


Sorry for the confusion. The functionality has been merged into 0.2.x series.
The extension checks for the underlying version of gecko platform and incorporates the new features if the version of gecko is >= 1.9b3.
Thanks.
westbluz
Posts: 1
Joined: February 28th, 2008, 8:45 am

Post by westbluz »

I tried to make the extension compatible with a custom xulrunner app. I added the followin code in install.rdf, but it doesnt do the trick. What else do i have to do to make it compatible?

<!-- my app -->
<em:targetApplication>
<Description>
<em:id>myappid</em:id>
<em:minVersion>1.9a1</em:minVersion>
<em:maxVersion>1.9b4pre</em:maxVersion>
</Description>
</em:targetApplication>

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

Post by mrinal.kant »

westbluz wrote:I tried to make the extension compatible with a custom xulrunner app. I added the followin code in install.rdf, but it doesnt do the trick. What else do i have to do to make it compatible?

<my>
<em>
<Description>
<em>myappid</em>
<em>1.9a1</em>
<em>1.9b4pre</em>
</Description>
</em>

Thanks!


create an overlay file (e.g. smoverlay-tb.xul for thunderbird) in chrome/content directory and make the corresponding entry in chrome.manifest file. That, I guess, should suffice.
grikdog
Posts: 2
Joined: February 29th, 2008, 10:18 am

Add/Edit in Views not enabled?

Post by grikdog »

Actually, this is the only thing I miss, and there's an obvious workaround. Bravo, and thanks for a completely unexpected bit of functionality!
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: Add/Edit in Views not enabled?

Post by mrinal.kant »

grikdog wrote:Actually, this is the only thing I miss, and there's an obvious workaround. Bravo, and thanks for a completely unexpected bit of functionality!


sorry, i couldn't follow. I am curious to know what is it that you miss, and what is the workaround, and what is the unexpected bit of functionality.
Post Reply