Kexi/Releases/Kexi 2.4: Difference between revisions

From KDE Community Wiki
< Kexi‎ | Releases
Line 5: Line 5:


General
General
*Rename icons so they do not use '-' character in names to avoid problems with 'report' prefix
*Updated translated messages retrieving, translations splitted for plugins
*Avoid overlapping current plugin declarations by old-style plugin declarations
**Without this new report items were not visible if uk.co.piggz.report class was used before
*Fix loading recent entries for server databases
*Fixes in date, time and date/time validating code, little refactoring, simplifing API
*Fixes in date, time and date/time validating code, little refactoring, simplifing API
*Do not load and show objects with invalid metadata in project navigator. Such invalid objects include: objects with id <= 0, objects with name reserved for internal use, objects with name not being valid identifier.
*Do not load and show objects with invalid metadata in project navigator. Such invalid objects include: objects with id <= 0, objects with name reserved for internal use, objects with name not being valid identifier.
Line 22: Line 27:


Main window
Main window
*Fixed crash on startup because of conflicts with Qt completion APIs
**Renamed symbols from Q to Kexi prefix
**{{bug|285583}}
*Make global search "full text"
*Clear contents on activation, update on pressing Delete
*Make Escape, Tab, Backtab keys set focus back to previously focused widget in Global Search
*On activating global search box, select all previous text
*Clear highlighting for objects in global search when needed
*Matching substrings are highlighted in completion list of global search
*Make behaviour of global search box more intuitive
**go back to completing when popup is closed and F4/Down pressed
**hide popup if F4 pressed
**single item on the completion list => select it automatically
**more than one item on completion list=>find exact match, if ok, accept
**there is no matching text => go back to completing
*Added minimal global search implementation with completion list, now just searches within Project objects
**after pressing Enter - select object name in Project Navigator
**on highlighting in completion list, highlights the object name
*Simplified background below menu to make it flicker less
*Select first item in Project Navigator when focused if there's no selection
*Simple support for global search box in Kexi
*Global search box accessible using Ctrl+K
*Fixed setup of global shortcuts
*Added "Import, Export or Send" menu item and assistant
*Rearranged Kexi menu items for usability
*Settings menu item disabled for now
*"Open Recent" page becomes more generic "Welcome" page
*Hide Project Navigator pane completely when closing project
*Hide Project Navigator pane completely when closing project
*Update availability of "Import Tables" action when closing project
*Update availability of "Import Tables" action when closing project
Line 50: Line 82:


Startup
Startup
*Improve info for recent entries
**text now skips filename if there is caption for file-based entries
**tooltips show server type or full filename path
*Assistant Framework added for the Modern Menu
*Assistant Framework added for the Modern Menu
*"New blank database" assistant implemented; reused previous code
*"New blank database" assistant implemented; reused previous code
Line 71: Line 106:


Forms
Forms
*Context Menu for container widgets appears misplaced
**{{bug|283568}}
*Changed Form Design Toolbar icons order and set to have text under icon
*Move icons from global directory to web/map plugins so these can be part of plugin packages
*Revert disabling "Save Record" action for editing cancelling
*Revert disabling "Save Record" action for editing cancelling
*Display widget's data source after selecting source
*Display widget's data source after selecting source
Line 86: Line 125:


Reports
Reports
*Move icons from global kexi or report lib directories to map/web/shape/barcode plugins so these can be part of plugin packages
*Install icons for reporting plugins into calligra/ icons directory to make the plugins independent of Kexi
*Web Report Element by Shreya Pandit
**fixed all issues noted in review, cleaned up code using astyle


Import & Export
Import & Export
*CSV Import: Fixed crash for larger CSV data
**{{bug|282936}}
*CSV Export: When copying CSV data to clipboard use native line endings, force \r\n only in files
*Fix saving recently visited directories for source and destination database in the migration wizard
*Fix saving recently visited directories for source and destination database in the migration wizard


Database support
Database support
*Make DriverInfo.name lowercse to avoid mistakes when comparing strings
*Fix memory leak in multiargument expressions of any type
*Fix memory leak in multiargument expressions of any type
*Fix memory leak in query schema
*Fix memory leak in query schema
Line 100: Line 147:
*MySQL driver: mark "information_schema" as system database
*MySQL driver: mark "information_schema" as system database


Documentation
*Official Kexi handbook is now at http://userbase.kde.org/Kexi/Handbook


Examples
Examples
Line 105: Line 154:
*Make forms andreport in "Simple Database" example look a bit more modern
*Make forms andreport in "Simple Database" example look a bit more modern
*Remove auto tabs to avoid focus
*Remove auto tabs to avoid focus
New Developers
*Shreya Pandit
*Dimitrios Tanis
*Radosław Wicik


</div>
</div>

Revision as of 23:17, 10 April 2012

List of changes

General

  • Rename icons so they do not use '-' character in names to avoid problems with 'report' prefix
  • Updated translated messages retrieving, translations splitted for plugins
  • Avoid overlapping current plugin declarations by old-style plugin declarations
    • Without this new report items were not visible if uk.co.piggz.report class was used before
  • Fix loading recent entries for server databases
  • Fixes in date, time and date/time validating code, little refactoring, simplifing API
  • Do not load and show objects with invalid metadata in project navigator. Such invalid objects include: objects with id <= 0, objects with name reserved for internal use, objects with name not being valid identifier.
  • Cleanups in API of the data-aware view
  • Disable "Save Record Changes" action when user cancels editing or reverts edited text to the original value. "Cancel Record Changes" action is not disabled though, so user is still able to exit from record editing mode.
  • Ask for confirmation when going to Design View and have pending record changes in Data View of table or form
  • Replaced term "row" with "record" in visible places
  • Delayed loading of plugins, improves startup times
  • Fix regression added with the delayed loading of plugins: "Create" toolbar works now
  • Disable "Save Record Changes" action when user cancels editing or reverts edited text to the original value. "Cancel Record Changes" action is not disabled though, so user is still able to exit from record editing mode.
  • Ask for confirmation when going to Design View and have pending record changes in Data View of table or form
  • Replaced term "row" with "record" in visible places

Main window

  • Fixed crash on startup because of conflicts with Qt completion APIs
  • Make global search "full text"
  • Clear contents on activation, update on pressing Delete
  • Make Escape, Tab, Backtab keys set focus back to previously focused widget in Global Search
  • On activating global search box, select all previous text
  • Clear highlighting for objects in global search when needed
  • Matching substrings are highlighted in completion list of global search
  • Make behaviour of global search box more intuitive
    • go back to completing when popup is closed and F4/Down pressed
    • hide popup if F4 pressed
    • single item on the completion list => select it automatically
    • more than one item on completion list=>find exact match, if ok, accept
    • there is no matching text => go back to completing
  • Added minimal global search implementation with completion list, now just searches within Project objects
    • after pressing Enter - select object name in Project Navigator
    • on highlighting in completion list, highlights the object name
  • Simplified background below menu to make it flicker less
  • Select first item in Project Navigator when focused if there's no selection
  • Simple support for global search box in Kexi
  • Global search box accessible using Ctrl+K
  • Fixed setup of global shortcuts
  • Added "Import, Export or Send" menu item and assistant
  • Rearranged Kexi menu items for usability
  • Settings menu item disabled for now
  • "Open Recent" page becomes more generic "Welcome" page
  • Hide Project Navigator pane completely when closing project
  • Update availability of "Import Tables" action when closing project
  • Fixed regression: Prevent renaming objects to invalid identifiers in Project Navigator
  • Set sane default size for the first run, for <=1024 maximize the window
  • Disable moving of the columns in property editor
  • Modern Menu
    • Display lighter gradient, make clicking on persistent items possible only once per item
    • Improve gradient, make empty menu mostly transparent
    • Make shortcuts work - menu is displayed and contents appear
    • Added fades when switching between contents
    • Proper selecting/deselecting persistent items
    • All actions in main menu have at least a placeholder
    • Only hide menu if clicked outside
    • Escape key closes the contents area, then second press closes the main menu
    • enable Alt+F as accelerator for the main menu
    • menu is focused after opening and first menu item is highlighted
    • set contents area Window brush to Base and WindowText brush to Text
      • this web-like style harmonizes the with some white pages like 'open recent' [1]
  • Tabbed toolbar
    • focusing removed to fix usability with the main menu (arrows)
  • Help menu added to drop-down button
  • "Search" entry added
  • Fix opening projects in new process: start the process in detached mode
  • Use delayed deletion of Kexi menu to avoid crashes
  • Main window starts smoother

Startup

  • Improve info for recent entries
    • text now skips filename if there is caption for file-based entries
    • tooltips show server type or full filename path
  • Assistant Framework added for the Modern Menu
  • "New blank database" assistant implemented; reused previous code
  • Project selector and connection selector ported to Qt4
  • "New Project" assistant
  • Message Widget
  • "Open Project" assistant added
  • "Recent Projects" assistant
  • Shortcut files
    • bumped version to v3: "name" for shortcuts to file-based databases is a full file path now. If the file is within the user's home directory, the dir is replaced with $HOME, e.g. name=$HOME/mydb.kexi. Not compatible with earlier versions but in these versions only filename was stored so the file was generally inaccessible anyway. "lastOpened" field added of type date/time (ISO format).
    • saving and loading code moved to KexiProjectData
  • Information about recent projects now saved, loaded and displayed properly
  • Show "Recent files" screen as welcome screen, disable old welcome dialog
  • Items in "Recent Projects" sort by date descending

Tables

  • Fixed input mask for date, time and date/time data fields in table views
  • Fix regression in displaying record editing indicators
  • Fix posible crashes because of running 'process events' in table view data's destructor

Forms

  • Context Menu for container widgets appears misplaced
  • Changed Form Design Toolbar icons order and set to have text under icon
  • Move icons from global directory to web/map plugins so these can be part of plugin packages
  • Revert disabling "Save Record" action for editing cancelling
  • Display widget's data source after selecting source
  • Add some missing translations to property names
  • Hide the pixmapId property of the picture box
  • "Show Form UI Code" dialog is now not cached, what fixes issues with memory ownership
  • Re-add foreground and background color properties for widgets; undo/redo works too
  • added --hide-menu command line option: Hides the main menu (the tabbed toolbar) completely. A number of commands from the main menu is always visible. This option is useful in User Mode.
  • Fixed possible crash in the "assign action" feature
  • Fixed possible crash in tab ordering code
  • Fixed possible crash in context menus

Reports

  • Move icons from global kexi or report lib directories to map/web/shape/barcode plugins so these can be part of plugin packages
  • Install icons for reporting plugins into calligra/ icons directory to make the plugins independent of Kexi
  • Web Report Element by Shreya Pandit
    • fixed all issues noted in review, cleaned up code using astyle

Import & Export

  • CSV Import: Fixed crash for larger CSV data
  • CSV Export: When copying CSV data to clipboard use native line endings, force \r\n only in files
  • Fix saving recently visited directories for source and destination database in the migration wizard

Database support

  • Make DriverInfo.name lowercse to avoid mistakes when comparing strings
  • Fix memory leak in multiargument expressions of any type
  • Fix memory leak in query schema
  • Fix memory leak (lexer was not released)
  • Fix possible crash when handling queries with lookup columns

Database drivers

  • MySQL driver: add /var/run/mysql/mysql.sock to list of possible local socket paths
  • MySQL driver: mark "information_schema" as system database

Documentation

Examples

  • Updated examples generation scripts to use system sqlite3 instead of old ksqlite command
  • Make forms andreport in "Simple Database" example look a bit more modern
  • Remove auto tabs to avoid focus

New Developers

  • Shreya Pandit
  • Dimitrios Tanis
  • Radosław Wicik

Missing or discontinued features in 2.4

None identified compared to 2.3.

Retrieved from "https://community.kde.org/index.php?title=Kexi/Releases/Kexi_2.4&oldid=19901"