Softpedia >Windows >Internet >Servers >Database Utils >SQLite Expert Personal >  Changelog

SQLite Expert Personal Changelog

What's new in SQLite Expert Personal 5.3.3 Build 389

Feb 25, 2019
  • Added support for UPSERT clause.

New in SQLite Expert Personal 5.2.0.178 (Sep 19, 2017)

  • Due to user feedback, we have decided to bring back the DevExpress components used in version 3.x. This fixes some issues related to displaying and editing data in the grid, and improves the overall look and feel of the application by replacing the VCL Styles with the DevExpress Skin Library.
  • Added data export to JSON.

New in SQLite Expert Personal 4.0.0.453 (Apr 22, 2016)

  • Both Win32 and Win64 versions.
  • Redesigned table/view/virtual table editors, using a new recursive-descent SQL parser based on COCO/R.
  • Separate editors for table and column constraints.
  • The change script is available before applying changes to a database object.
  • Experimental SQL formatter on the SQL and DDL tabs.
  • Database schema compare.
  • Settings are now stored in a JSON file.

New in SQLite Expert Personal 3.5.89.2509 (Dec 7, 2015)

  • Improved license registration process.

New in SQLite Expert Personal 3.5.49.2469 (Jun 2, 2014)

  • Added support for partial indexes.
  • Added support for tables without rowid.

New in SQLite Expert Personal 3.5.6.2425 (Dec 10, 2013)

  • Improved license registration process.

New in SQLite Expert Personal 3.4.98.2328 (Nov 4, 2013)

  • Upgraded ICU library to version 52

New in SQLite Expert Personal 3.4.97.2327 (Oct 30, 2013)

  • Removed "rowid" from the list of available parent columns on the foreign key editor.

New in SQLite Expert Personal 3.4.96.2326 (Oct 29, 2013)

  • Fixed error when creating a new table with indexes.

New in SQLite Expert Personal 3.4.95.2325 (Oct 28, 2013)

  • Fixed error when creating foreign keys.

New in SQLite Expert Personal 3.4.94.2324 (Oct 26, 2013)

  • Fixed when applying changes after deleting an index.

New in SQLite Expert Personal 3.4.93.2323 (Oct 26, 2013)

  • Fixed AV when creating table in an empty database.

New in SQLite Expert Personal 3.4.92.2322 (Oct 26, 2013)

  • Fixed error when creating foreign keys.

New in SQLite Expert Personal 3.4.91.2321 (Oct 25, 2013)

  • Fixed a few issues in trigger editing using the visual editor.

New in SQLite Expert Personal 3.4.90.2320 (Oct 24, 2013)

  • Fixed keyword capitalization in queries generated with the Query Builder.
  • Fixed error when renaming a table.
  • Fixed error when copying a table using drag and drop.

New in SQLite Expert Personal 3.4.89.2319 (Oct 23, 2013)

  • Fixed a bug in query builder generating incorrect queries for tables in attached databases

New in SQLite Expert Personal 3.4.88.2318 (Oct 23, 2013)

  • Fixed a bug preventing queries using table aliases from being editable

New in SQLite Expert Personal 3.4.87.2317 (Oct 22, 2013)

  • SQLite library 3.8.1 included.
  • Table names are now always qualified.
  • Fixed a few issues related to temporary triggers.

New in SQLite Expert Personal 3.4.86.2316 (Oct 18, 2013)

  • Modified database creation dialog to allow providing the encryption key, for compatibility with SQLCipher

New in SQLite Expert Personal 3.4.84.2314 (Oct 15, 2013)

  • Fixed errors in handling in memory and attached databases

New in SQLite Expert Personal 3.4.83.2313 (Oct 12, 2013)

  • Fixed an error in restructuring tables in temporary or attached databases.

New in SQLite Expert Personal 3.4.82.2312 (Oct 10, 2013)

  • Fixed an error in generating filter expression

New in SQLite Expert Personal 3.4.81.2311 (Oct 7, 2013)

  • Fixed an error in generating DDL for columns having declared sizes.

New in SQLite Expert Personal 3.4.80.2310 (Oct 2, 2013)

  • Fixed order of records when pasting data from Excel.

New in SQLite Expert Personal 3.4.79.2309 (Oct 1, 2013)

  • Fixed detection of delimiter when pasting data from Excel

New in SQLite Expert Personal 3.4.78.2308 (Sep 23, 2013)

  • SQLite library 3.8.0.2 included.

New in SQLite Expert Personal 3.4.77.2307 (Sep 7, 2013)

  • Enhanced the Pascal Script query object by adding a Fields function to allow iteration of the query fields by index

New in SQLite Expert Personal 3.4.76.2306 (Sep 7, 2013)

  • SQLite library 3.8 included.

New in SQLite Expert Personal 3.4.75.2305 (Aug 24, 2013)

  • Fixed alternate row color not persisted between sessions.

New in SQLite Expert Personal 3.4.74.2304 (Jul 28, 2013)

  • Fixed tree refresh issue after renaming a table

New in SQLite Expert Personal 3.4.73.2303 (Jul 22, 2013)

  • Fixed incorrect copy/paste of numeric values on systems having the decimal separator different than '.'

New in SQLite Expert Personal 3.4.72.2302 (Jul 22, 2013)

  • Fixed incorrect handling of boolean data types

New in SQLite Expert Personal 3.4.71.2301 (Jul 18, 2013)

  • Fixed error preventing the usage of null values in parameterized queries.
  • Fixed error preventing the usage of empty table names or field names which are valid in SQLite.

New in SQLite Expert Personal 3.4.70.2300 (Jun 8, 2013)

  • Fixed a few more skin color issues.

New in SQLite Expert Personal 3.4.69.2299 (Jun 4, 2013)

  • Fixed a few skin color issues.

New in SQLite Expert Personal 3.4.68.2298 (Jun 4, 2013)

  • Fixed a few skin color issues.

New in SQLite Expert Personal 3.4.67.2297 (May 31, 2013)

  • Rolled back changes in the previous version.

New in SQLite Expert Personal 3.4.66.2296 (May 31, 2013)

  • Fixed an error executing SQL queries containing sub-queries.

New in SQLite Expert Personal 3.4.65.2295 (May 30, 2013)

  • Fixed error in importing large UTF-8 encoded CSV files

New in SQLite Expert Personal 3.4.64.2294 (May 27, 2013)

  • Removed wal_checkpoint added by mistake to the list of pragma properties.

New in SQLite Expert Personal 3.4.63.2293 (May 23, 2013)

  • SQLite library version 3.7.16.2 is now included.
  • Added support for pragma application_id, busy_timeout, mmap_size, vdbe_addoptrace, wal_checkpoint.
  • The first five lines of the SQL statement that caused an error are now included in the error message.

New in SQLite Expert Personal 3.4.62.2292 (May 20, 2013)

  • Fixed issue in generating table creation SQL when declared type is not a valid identifier.

New in SQLite Expert Personal 3.4.61.2291 (Apr 30, 2013)

  • Fixed character encoding issue in Lua scripting engine.

New in SQLite Expert Personal 3.4.60.2287 (Apr 25, 2013)

  • Fixed bug in restoring windows position when using multiple monitors.

New in SQLite Expert Personal 3.4.59.2289 (Apr 18, 2013)

  • SQLite library version 3.7.16.2 is now included.
  • Modified random data generation to take into account the declared types, e.g. for type BYTE the range will be 0 to 255.
  • Fixed index out of range error when inserting a large number of records using the clipboard.

New in SQLite Expert Personal 3.4.58.2286 (Apr 12, 2013)

  • Added tab indent option for all editors.

New in SQLite Expert Personal 3.4.57.2285 (Apr 5, 2013)

  • Fixed a bug in the SQL parser.

New in SQLite Expert Personal 3.4.56.2284 (Apr 1, 2013)

  • SQLite library version 3.7.16.1 is now included.

New in SQLite Expert Personal 3.4.55.2283 (Mar 28, 2013)

  • Fixed another query builder refresh issue.

New in SQLite Expert Personal 3.4.54.2282 (Mar 27, 2013)

  • Fixed query builder refresh issue.

New in SQLite Expert Personal 3.4.53.2281 (Mar 21, 2013)

  • SQLite library version 3.7.16 is now included.
  • Fixed bug in refreshing database properties.

New in SQLite Expert Personal 3.4.52.2280 (Mar 18, 2013)

  • Fixed word wraping bug causing the program to hang at startup.

New in SQLite Expert Personal 3.4.51.2279 (Feb 25, 2013)

  • Fixed incorrect word wrapping in SQL editor when max line width exceeds 255 characters.

New in SQLite Expert Personal 3.4.50.2278 (Feb 11, 2013)

  • Fixed a bug handling default values

New in SQLite Expert Personal 3.4.49.2277 (Jan 31, 2013)

  • Fixed a bug in parsing primary key.

New in SQLite Expert Personal 3.4.48.2275 (Jan 17, 2013)

  • Fixed bug in applying SQL editor font color when using themes.
  • Updated SQLite library to 3.7.15.2.

New in SQLite Expert Personal 3.4.47.2269 (Dec 8, 2012)

  • Minor user interface improvements.

New in SQLite Expert Personal 3.4.46.2268 (Dec 5, 2012)

  • SQLite library is now compiled with SQLITE_ENABLE_FTS4_UNICODE61.

New in SQLite Expert Personal 3.4.45.2267 (Dec 3, 2012)

  • Pragma 'default_cache_size' is no longer used.

New in SQLite Expert Personal 3.4.44.2266 (Dec 3, 2012)

  • Fixed 'database is locked' error when refreshing database properties while using exclusive locking.

New in SQLite Expert Personal 3.4.43.2265 (Nov 29, 2012)

  • Updated pragma list on database tab.

New in SQLite Expert Personal 3.4.42.2264 (Nov 27, 2012)

  • Fixed error parsing primary key conflict clause.

New in SQLite Expert Personal 3.4.41.2263 (Nov 26, 2012)

  • Fixed encoding issue when importing data from text files

New in SQLite Expert Personal 3.4.39.2261 (Nov 20, 2012)

  • Fixed bug in handling null values when importing data from CSV files

New in SQLite Expert Personal 3.4.38.2260 (Nov 20, 2012)

  • Fixed bug in handling null datetime values when pasting data from clipboard

New in SQLite Expert Personal 3.4.37.2259 (Nov 14, 2012)

  • Query Builder layout is no longer cleared when an error occurs during SQL generation.

New in SQLite Expert Personal 3.4.36.2258 (Nov 6, 2012)

  • Fixed encoding issue when copying data to clipboard.

New in SQLite Expert Personal 3.4.35.2257 (Oct 31, 2012)

  • Fixed bug in character encoding detection when pasting data from Excel

New in SQLite Expert Personal 3.4.34.2256 (Oct 16, 2012)

  • Fixed startup error on Windows 2000.

New in SQLite Expert Personal 3.4.33.2255 (Oct 8, 2012)

  • SQLite library 3.7.14.1 included.

New in SQLite Expert Personal 3.4.32.2254 (Sep 27, 2012)

  • Fixed encoding issue when copying data to clipboard.

New in SQLite Expert Personal 3.4.31.2253 (Sep 19, 2012)

  • Fixed bug in importing text files when the destination table name needs quoting.

New in SQLite Expert Personal 3.4.30.2252 (Sep 19, 2012)

  • Fixed bug in character encoding detection when loading text files

New in SQLite Expert Personal 3.4.29.2251 (Sep 18, 2012)

  • Fixed an error in internal SQL parser

New in SQLite Expert Personal 3.4.28.2250 (Sep 17, 2012)

  • Improved character encoding detection when loading text files with missing BOM.

New in SQLite Expert Personal 3.4.26.2248 (Sep 10, 2012)

  • Data transfer operations now handle circular foreign key references correctly.
  • SQLite library 3.7.14 included.

New in SQLite Expert Personal 3.4.25.2247 (Aug 27, 2012)

  • Fixed bug in ordering objects by dependencies when exporting to SQL script.

New in SQLite Expert Personal 3.4.24.2246 (Aug 20, 2012)

  • Improved the timing of queries having unbound parameters.

New in SQLite Expert Personal 3.4.23.2245 (Aug 16, 2012)

  • Fixed a bug in foreign key parsing

New in SQLite Expert Personal 3.4.22.2244 (Aug 12, 2012)

  • Minor DATE/DATETIME fixes.

New in SQLite Expert Personal 3.4.21.2243 (Jul 27, 2012)

  • Fixed bug in filtering DATE/DATETIME fields.

New in SQLite Expert Personal 3.4.20.2242 (Jul 16, 2012)

  • Fixed bug preventing the editing of long lines in SQL editor.

New in SQLite Expert Personal 3.4.19.2241 (Jul 2, 2012)

  • Fixed skin support on the main toolbar.

New in SQLite Expert Personal 3.4.18.2240 (Jun 30, 2012)

  • Added Ctrl+Enter shortcut for record editor.

New in SQLite Expert Personal 3.4 (Jun 16, 2012)

  • Updated some third party components.

New in SQLite Expert Personal 3.3 (Jun 16, 2012)

  • Added support for virtual tables including RTREE, FTS3 and FTS4.
  • Added database DDL compare tool.
  • Added database online backup option.
  • Added support for the ICU extension.

New in SQLite Expert Personal 3.2 (Jun 16, 2012)

  • Added database repair function.

New in SQLite Expert Personal 3.1 (Jun 16, 2012)

  • Added option to open multiple SQL tabs.
  • Added tab width option.
  • Added keyboard shortcut (CTRL+/) for commenting/uncommenting selected text in SQL and script editors.
  • Replaced System.Data.SQLite with a custom built SQLite library with compatible encryption that does not require .NET.
  • Statically linked SQLite library now supports encryption.

New in SQLite Expert Personal 3.0 (Jun 16, 2012)

  • Added skin library.
  • Added printing library.
  • Added support for custom delimiters when exporting/importing to/from text files.
  • Added option to allow only one instance of the application.
  • Grid rows now resize height with the size of the text.

New in SQLite Expert Personal 2.4 (Jun 16, 2012)

  • Added option to hide tabs and menu items to prevent bloating the user interface.
  • Added code completion.
  • Added record editor.

New in SQLite Expert Personal 2.3 (Jun 16, 2012)

  • Added Find/Replace option in SQL/Lua/Pascal script editors.
  • Added option to associate custom file extensions with SQLite Expert.
  • Added ability to generate SELECT, INSERT, UPDATE and DELETE statements based on the visible fields on the current table.
  • Added option to limit the amount of memory used when displaying results as text. Default is 10 MB.
  • Added option to display the "rowid" on the Data tab.
  • Added Extensions tab.
  • Redesigned the Database tab to display or set pragma properties for all attached databases.

New in SQLite Expert Personal 2.2 (Jun 16, 2012)

  • Added "Reindex Table" and "Reindex All Tables" options.
  • Added support for auto extensions.
  • Added foreign key support.