What's new? | Help | Directory | Sign in
Google
Project Home
  
Downloads
  
Wiki
  
Issues
    
Search
for
Updated Today (14 hours ago) by mrinal.kant
VersionHistory  
Issues fixed in given version.

Changes in Version 0.3.13

  •  Issue #153 : Copy Row(s): Provide a choice to copy as an Insert statement. Thus you can now copy rows in two formats: csv and sql. Wherever "Copy Row(s)" menuitem was available, now two menuitems are available namely "Copy Row(s) as CSV" and "Copy Row(s) as SQL". The second option copies the data in the form of an Insert statement e.g., INSERT INTO "someTable" VALUES ("3","2007-10-24","Linux","2","Linux");
  •  Issue #181 : Make hardcoded strings in sqlitemanager.xul localizable. For details, see the issue.
  •  Issue #182 : support Firefox 3.1b2pre. Done.

Changes in Version 0.3.12

  •  Issue #178 : Enhance new database to allow creation of in-memory database. Done. To open an in-memory db, go to Database menu -> New In-Memory Database. If the db opens successfully the title displays "in-memory database", in the left sidebar "in-memory" is displayed instead of db name and the statusbar displays "Memory" instead of Shared/Exclusive.
  •  Issue #180 : alert the user if a file from MRU could not be opened and remove the failed entry from MRU. Fixed.

Changes in Version 0.3.11

  •  Issue #151 : "Copy Row" command should not include rowid if it is not a column in the table. Fixed.
  •  Issue #156 : Add Record, Edit Record, Search dialogs: Allow to paste constants instead of typing them. As of now, you can paste constants in input fields in dialogs for Add Record, Edit Record, Duplicate Record, Search by using the following shortcut keys: CTRL + 1: CURRENT_DATE, CTRL + 2: CURRENT_TIME, CTRL + 3: CURRENT_TIMESTAMP
  •  Issue #169 : Add New Record: Option to retain the previous values in the textboxes or to clear all textboxes and show default values where available. This can be done by setting the value of preference "extensions.sqlitemanager.whenInsertingShow" to either "previous" or "default". The default value is "previous". The preference can be set from the Options dialog. However, when the Add Record dialog is first opened, default values will be shown whatever the preference is set to.
  •  Issue #171 : support SeaMonkey 2.0a2. Done.
  •  Issue #174 : Export the Database Structure. This can be done through a menuitem "Export Database Structure" under the "Database" menu.
  •  Issue #175 : Default values for columns should not be converted to strings in all cases. The problem occurs in create table dialog and add column action under structure tab. Even if numbers like 12, 12.21, 12.1e-2, etc. are specified and while adding column even if the default value is left blank, the extension converts them to strings and adds the default clause in the column definition. This has now been fixed. If the default value field contains the string NULL (case-insensitive) or is blank, the default clause is omitted. If the value can be converted to a number it is considered as a number otherwise it is regarded as a string. The special strings CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP are treated as constants.
  •  Issue #176 : Add Record, Edit Record, Search dialogs: accesskey related errors. Fixed.

Changes in Version 0.3.10

Changes in Version 0.3.9

  •  Issue #144 : Incorrect rendering of the UI on Vista. Fixed.
  •  Issue #155 : Automatic database backup is now available. The backup is created before a database is opened. By default, this feature is off. The feature can be enabled through a preference called "extensions.sqlitemanager.autoBackup". It can take one of the 3 values: "off" (means no auto backup; default value), "on" (means auto backup) and "prompt" (means prompt for backup whenever a db is opened). The preference can be set in the Options dialog. As an example, a db file abc.sqlite will be backed up as abc_timestamp.sqlite
  •  Issue #159 : Window Sizing Issue. Fixed.
  •  Issue #160 : When opening a database if openDatabase (uses shared pager cahe) fails, openUnsharedDatabase is used. Earlier the user had to choose one of these by toggling the "Shared Pager Cache" menuitem under the Tools menu. However, if you unselect this menuitem it is assumed you want an exclusive connection only and only openUnsharedDatabase is used. The status bar shows whether the db is open in "Shared" or "Exclusive" mode.
  •  Issue #161 : Link to homepage in About SQLite Manager dialog did not work. Fixed.
  •  Issue #163 : Autoincrement checkbox would not get enabled while using keyboard. Fixed.

Changes in Version 0.3.8

  •  Issue #14 : When importing, it should be possible to modify the tables created by import. As of now, it is possible to import csv, sql and xml. It is assumed that importing sql should not require this feature. While importing csv/xml, the user can choose to modify the table which the extension will create. Since multiple tables can be imported at the same time using xml, the user will be prompted for modifying each new table. When importing from xml, the user cannot edit the column names.
  •  Issue #46 : Too small (Incorrect width) text-fields in record-editing dialog on ubuntu
  •  Issue #128 : Improvement of "Add new record": now you can add multiple records without leaving the add record window. To exit the add record dialog, press cancel.
  •  Issue #145 : Support for modifying view, renaming view, renaming trigger
  •  Issue #147 : Export all tables as sql and Export database (includes all tables and create statements for views/triggers/indexes). These features are available through two menuitems under Database menu. These are (1) Export All Tables: concatenation of the output as produced by the export for individual tables; and includes create table statements (2) Export Database: this produces the previous menuitems output followed by create statements for all views, triggers and indexes (in that order)
  •  Issue #152 : provide a Duplicate Record button to open a new record dialog with the defaults of the currently selected record
  •  Issue #157 : autoincrement option in create table dialog didn't work

Changes in Version 0.3.7

Summary of all the changes made for handling attached database:
  1. Database menu has menuitems: "Attach Database" and "Detach Database"
  2. Attached db are shown in a menulist on the left (above the db objects tree) where there used to be the name of the opened database
  3. Right clicking on the menu also provides "Detach Database" in a context menu
  4. Attaching a db adds the dbname and the file leafname to the menu; detaching removes the corresponding item after confirmation from the user. The full path of the attached db can be seen as a tooltip by hovering the mouse over the menuitem
  5. On selecting an attached db, the corresponding db objects are shown in the tree.
  6. temp db objects are now available by selecting "temp" in the menu. No separate tab for temp objects anymore
  7. removed the master tab; instead, added the master as a node in the structure tree. This node contains the master table sqlite_master (for the main and all attached db) and sqlite_temp_master (for temp)
  8. Handled pragma queries using "pragma dbname.table_info()" syntax. But there is an issue when temp db has a table of the same name as the main db. This will be fixed in sqlite 3.6.2 only (see http://www.sqlite.org/cvstrac/tktview?tn=3320)
  9. fixed rename table, add column and drop column to work for attached db too.
  10. Export dialog: lists the master table alongwith all the tables of the selected main, temp or attached db. Thus you can export a table in attached db too.
  11. Dialogs for create table, create index, create view and create trigger: Now there is a dropdown box for the db list (main, temp and attached db), and wherever relevant the table list gets populated according to the selected db. However, if temporary checkbox is selected, the object is always created in temp db.
  12. Copy Table: major improvements here: (a) no more acrobatics by renaming tables, creating unnecessary tables, etc. Now, we have a simple create table statement to create the new table. (b) It is now possible to copy table from any of the available db (main, temp or attached db) to the same or another db.
  13. Fixed add record, edit record, delete records and search facilty for attached databases.

Changes in Version 0.3.6

  •  Issue #130 : autoincrement option should be available in the create table UI
  •  Issue #133 : minVersion for Songbird should be 0.6
  •  Issue #134 : Import CSV with double quotes error
  •  Issue #135 : facility to start with a user-selected default directory to show all db in that directory
  •  Issue #136 : Column textbox width in "Structure" Tab too short; double it
  •  Issue #137 : sqlite-manager should support attached databases

Changes in Version 0.3.5

  •  Issue #110 : Import from CSV where some fields can span across multiple lines
  •  Issue #116 : Create Table dialog: If "Primary key" is selected for a field, allow-null checkbox should automatically be set "NO"
  •  Issue #117 : Structure: Add Column : combobox for Type should be provided
  •  Issue #118 : In Browse tab, provide a Show All button to clear search results and show the complete table/view
  •  Issue #123 : Fix for SeaMonkey overlay problems in 0.3.4
  •  Issue #131 : Feature request: Add a MRU list - MRU list added. It will be displayed under the Database menu. The size of the MRU list is controlled by the preference "extensions.sqlitemanager.mruSize" whose default value is set to 10.
  •  Issue #132 : Add support for thunderbird 3.0b1pre and songbird 0.8.0pre

Changes in Version 0.3.4

  •  Issue #103 : Feature request: Support tab character as field separator for CSV import and export. - Fixed by waltergr.
  •  Issue #107 : Support multiple default file extensions in options (e.g. .db3, .sqlite etc.)
  •  Issue #108 : provide a facility to reconnect to a database.

Changes in Version 0.3.3

  •  Issue #104 : Export View Broken: in the dropdown list, the tables are listed instead of views

Changes in Version 0.3.2

  •  Issue #101 : Option to display the system tables should be available - A new tab for the master tables in the left sidebar (structure tree) has been added to show the master tables.
  •  Issue #84 : Failure in opening sqlite database that has virtual table - So far, we connected to db with "shared pager cache" enabled - which meant that db with virtual table could not be opened. Now we have a menuitem (it toggles) called "shared pager cache" under Tools menu. Disable/uncheck this item and then open the db containing virtual table(s). The db will successfully open. This feature is available on Gecko 1.9 platform only. That means that you can use Firefox 3 for this feature but not Firefox 2.
  •  Issue #96 : Open profile database not available on Mac OS X - On OS X the "menus" are not part of the application window, but rather part of the system and appear on the top of the screen. To fix this, the dropdown listbox has been moved from the menubar to the toolbar.

Changes in Version 0.3.1

Changes in Version 0.3.0

  •  Issue #90 : on closing a db the tabs ( structure tab, db info tab, etc.) continue to show the info of closed database.
  •  Issue #92 : Temporary objects are not visible in tree structure - Now, the left tree structure (in the sidebar) has two tabs: one for normal db objects (as in all the versions so far) and another for the temp objects.
  •  Issue #93 : Multiple query error if last line contains a single line comment (beginning with --)
  •  Issue #94 : Failure in using some files as a blob value

Changes in Version 0.2.46

  •  Issue #63 : There should be a way to copy selected rows to the clipboard - In the context menu in tree you have a menuitem called "Copy Row(s)" which copies the selected rows' content to the clipboard.
  •  Issue #78 : sidebar (database tree structure) jumps away from selected table after certain operations - Actually, this is a kind of duplicate of  Issue #89 . The problem occurs whenever the sidebar (tree structure) is internally refreshed. Fixed.
  •  Issue #89 : "Refresh" jumps to first table

Changes in Version 0.2.45

  •  Issue #74 : Run SQL, produces no results when running a query not terminated by semicolon
  •  Issue #79 : Repeat "Connect Database" twice to open a .sqlite file
  •  Issue #82 : Exporting to SQL more flexible - The user can decide whether the exported SQL statements are enclosed within BEGIN TRANSACTION and COMMIT statements or not.
  •  Issue #83 : Import data using SQL statements - There is an option which, if checked, it is assumed that, in the selected file, the first and last statements are BEGIN TRANSACTION and COMMIT respectively. The extension will exclude these and execute all the remaining statements in a single transaction. If there are transaction related statements in between too these should be manually removed from the file before importing.

Changes in Version 0.2.44.1

  •  Issue #70 : 2.44 upgrade killed the extension. Use of for each not allowed in Gecko 1.8

Changes in Version 0.2.44

  •  Issue #34 : Support multiple query statements in the 'Execute SQL' tab
  •  Issue #60 : Make the extension and the xulrunner app for SQLite Manager as close as possible for easy maintenance - Done (see the issue for details on how)
  •  Issue #64 : In the DB structure tree, the tables should have the columns/fields as children
  •  Issue #65 : Support Flock 1.2.1 and Firefox 3.1a1pre
  •  Issue #69 : store the state of the structure tree in the extension management table - We store the list of tree nodes which are expanded so that when the db is opened again later the same nodes can be shown expanded.

Changes in Version 0.2.43

  •  Issue #58 : minVersion for Songbird should be 0.5
  •  Issue #59 : Failure to identify rowid if the primary column has multiple columns one of which has the type INTEGER

Changes in Version 0.2.42

  •  Issue #19 : provide option for hiding sqlite manager as menuitem in Firefox
  •  Issue #55 : Add support for songbird upto version 0.7pre
  •  Issue #56 : Support Thunderbird 3.0a2pre
  •  Issue #9 : Table import fails if table exists - Data can now be imported into an existing table.

Changes in Version 0.2.41

  •  Issue #51 : Interface suggestion: resizable query field - SQL query field in Execute SQL tab can be resized using a splitter
  •  Issue #53 : error in searching when the operator is "=" and the argument is a string
  •  Issue #54 : save frequently-used sql queries - The user can save any queries written in the Execute SQL tab. This feature requires the enabling of table for extension data under the Tools menu.

Changes in Version 0.2.40

  •  Issue #40 : SQL export + Blob - SQL export + Blob handling for exporting blob data as hex string (thanks to Bigane)
  •  Issue #41 : make the extension compatible with Firefox maxversion 3.0.
  •  Issue #42 : Incorrect number of arguments in getXxxPref methods of nsIPrefBranch
  •  Issue #43 : Problems with clicking OK on Edit Record/Add Record dialog
  •  Issue #44 : search criteria should not get stored in a preference
  •  Issue #45 : menuitem for SQLite Manager does not get added under the Tools menu in Sunbird version 0.9pre (Calendar)

Changes in Version 0.2.39

Changes in Version 0.2.38

  •  Issue #23 : simplify the entry of data; implicitlyQuote preference does not look like a right way of doing things - simplified the entry of data: implicitlyQuote preference does not look like a right way of doing things.
  •  Issue #32 : When doing a search clicking on OK the search screen should go away.
  •  Issue #33 : Localization problem

Changes in Version 0.2.37

  •  Issue #11 : favicon for the extension - When the extension opens in a new tab a 16x16 favicon is displayed on tab and address bar.
  •  Issue #20 : When deleting a large number of rows, the confirmation dialog becomes very large, to the point where OK and Cancel buttons are not visible - Bug: When deleting a large number of rows, the confirmation dialog becomes very large, to the point where OK and Cancel buttons are not visible. Fixed: the sql is not shown anymore. Instead the confirm dialog displays the no. of records to be deleted as "Delete n records from table xxx".
  •  Issue #24 : It should be possible to add blobs while adding new record through "Add New Record" dialog - It is now possible to add blobs while adding new record through "Add New Record" dialog.
  •  Issue #30 : when updating records, a separate sql is executed for each blob field and one for the rest. - when updating records, a separate sql was executed for each blob field and one for the rest. Fixed: A single update statement is used with parameter binding for blob data.

Changes in Version 0.2.36

  •  Issue #27 : error on creating index if the indexed column name is a keyword - error on creating index if the indexed column name is a keyword. Fixed
  •  Issue #28 : It should be possible to change the following preferences using Options dialog: textForNull, textForBlob, showBlobSize - It should be possible to change the following preferences using Options dialog: textForNull, textForBlob, showBlobSize. Done
  •  Issue #29 : the 32x32 icon shown in addons dialog should be similar to 16x16 icon for the extension - It should be possible to change the following preferences using Options dialog: textForNull, textForBlob, showBlobSize. Done

Changes in Version 0.2.35

  •  Issue #12 : On row change, blank string reinterpreted as NULL - on row change, blank string is interpreted as null. Now only dirty fields are updated.
  •  Issue #21 : Exclude BLOB fields from the listing of data - showing blob data makes display slow. Fixed.
  •  Issue #22 : Allow to save existing blob data and change a field's value to blob data - Allow to save existing blob data and change a field's value to blob data
  •  Issue #25 : double-clicking on a record of a view in the browse tab opens a dialog titled "edit record" - double-clicking on a record of a view in the browse tab opens a dialog titled "edit record" and the dialog shows no record at all. Fixed.

Changes in Version 0.2.34

  •  Issue #15 : Support Firefox 3.0b5, 3.0pre and Gecko 1.9b5, 1.9pre

Changes in Version 0.2.33

Changes in Version 0.2.32

Changes in Version 0.2.31

Older Versions

Version 0.2.28 — February 27, 2008 — 75 KB

Version 0.2.27 — February 23, 2008 — 74 KB

Version 0.2.23 — January 29, 2008 — 68 KB

Version 0.2.22 — January 28, 2008 — 68 KB

Version 0.2.15 — January 2, 2008 — 66 KB

Version 0.2.9.6 — December 6, 2007 — 63 KB

Version 0.2.9.5 — December 4, 2007 — 62 KB

Version 0.2.9.1 — November 26, 2007 — 63 KB

Version 0.2.9.0 — November 25, 2007 — 62 KB

Version 0.2.8.6 — November 21, 2007 — 59 KB

Version 0.2.8.4 — November 19, 2007 — 58 KB


Sign in to add a comment