Разрядность: 32bit, 64bit Язык интерфейса: Английский Таблэтка: Присутствует Системные требования: Windows 2000, XP, Vista, 7 Описание: SQLite Expert — встраиваемый движок баз данных. В 2005 году проект был награждён наградой Google-O’Reilly Open Source Awards. Слово «встраиваемый» означает, что SQLite не использует парадигму клиент-сервер, то есть движок SQLite не является отдельно работающим процессом, с которым взаимодействует программа, а предоставляет библиотеку, с которой программа компонуется и движок становится составной частью программы. Таким образом, в качестве протокола обмена используются вызовы функций (API) библиотеки SQLite. Несколько процессов или потоков могут одновременно без каких-либо проблем читать данные из одной базы. Запись в базу можно осуществить только в том случае, если никаких других запросов в данный момент не обслуживается, в противном случае попытка записи оканчивается неудачей, и в программу возвращается код ошибки (другим вариантом развития событий является автоматическое повторение попыток записи в течение заданного интервала времени).
March 20, 2013: Version 3.4.53. build 2281
SQLite library version 3.7.16 is now included. Fixed bug in refreshing database properties.
March 17, 2013: Version 3.4.52. build 2280
Fixed word wraping bug causing the program to hang at startup.
February 24, 2013: Version 3.4.51. build 2279
Fixed incorrect word wrapping in SQL editor when max line width exceeds 255 characters.
February 10, 2013: Version 3.4.50. build 2278
Fixed a bug handling default values.
January 30, 2013: Version 3.4.49. build 2277
Fixed a bug in parsing primary key.
January 16, 2013: Version 3.4.48. build 2275
Fixed bug in applying SQL editor font color when using themes. Updated SQLite library to 3.7.15.2.
December 7, 2012: Version 3.4.47. build 2269
Minor user interface improvements.
December 4, 2012: Version 3.4.46. build 2268
SQLite library is now compiled with SQLITE_ENABLE_FTS4_UNICODE61.
November 30, 2012: Version 3.4.45. build 2267
Pragma ''default_cache_size'' is no longer used.
November 30, 2012: Version 3.4.44. build 2266
Fixed ''database is locked'' error when refreshing database properties while using exclusive locking.
November 28, 2012: Version 3.4.43. build 2265
Updated pragma list on database tab.
November 26, 2012: Version 3.4.42. build 2264
Fixed error parsing primary key conflict clause.
November 25, 2012: Version 3.4.41. build 2263
Fixed encoding issue when importing data from text files.
November 23, 2012: Version 3.4.40. build 2262
Fixed another bug in handling null values when importing data from CSV files. Fixed scrolling issue on schema compare form.
November 19, 2012: Version 3.4.39. build 2261
Fixed bug in handling null values when importing data from CSV files.
November 19, 2012: Version 3.4.38. build 2260
Fixed bug in handling null datetime values when pasting data from clipboard.
November 13, 2012: Version 3.4.37. build 2259
Query Builder layout is no longer cleared when an error occurs during SQL generation.
November 5, 2012: Version 3.4.36. build 2258
Fixed encoding issue when copying data to clipboard.
October 30, 2012: Version 3.4.35. build 2257
Fixed bug in character encoding detection when pasting data from Excel.
October 15, 2012: Version 3.4.34. build 2256
Fixed startup error on Windows 2000.
October 7, 2012: Version 3.4.33. build 2255
SQLite library 3.7.14.1 included.
September 26, 2012: Version 3.4.32. build 2254
Fixed encoding issue when copying data to clipboard.
September 19, 2012: Version 3.4.31. build 2253
Fixed bug in importing text files when the destination table name needs quoting.
September 18, 2012: Version 3.4.30. build 2252
Fixed bug in character encoding detection when loading text files.
September 17, 2012: Version 3.4.29. build 2251
Fixed an error in internal SQL parser.
September 16, 2012: Version 3.4.28. build 2250
Improved character encoding detection when loading text files with missing BOM.
September 12, 2012: Version 3.4.27. build 2249
A warning is now displayed if the maximum cell length has been exceeded when exporting to Excel.
September 8, 2012: Version 3.4.26. build 2248
Data transfer operations now handle circular foreign key references correctly. SQLite library 3.7.14 included.
August 26, 2012: Version 3.4.25. build 2247
Fixed bug in ordering objects by dependencies when exporting to SQL script.
August 19, 2012: Version 3.4.24. build 2246
Improved the timing of queries having unbound parameters.
August 14, 2012: Version 3.4.23. build 2245
Fixed a bug in foreign key parsing.
August 9, 2012: Version 3.4.22. build 2244
Minor DATE/DATETIME fixes.
July 26, 2012: Version 3.4.21. build 2243
Fixed bug in filtering DATE/DATETIME fields.
July 14, 2012: Version 3.4.20. build 2242
Fixed bug preventing the editing of long lines in SQL editor.
June 30, 2012: Version 3.4.19. build 2241
Fixed skin support on the main toolbar.
June 29, 2012: Version 3.4.18. build 2240
Added Ctrl+Enter shortcut for record editor.
June 15, 2012: Version 3.4.17. build 2229
Added ''Show characters'' option to encryption key dialog. Confirmation is no longer required when entering default encryption key.
June 15, 2012: Version 3.4.16. build 2228
SQLite library 3.7.13 included. Fixed a bug filtering on a field matching a SQL keyword.
June 3, 2012: Version 3.4.15. build 2225
Fixed a bug in processing error messages.
May 28, 2012: Version 3.4.14. build 2224
Fixed an error in time display introduced in 3.4.13.
May 26, 2012: Version 3.4.13. build 2223
SQLite library 3.7.12.1 included. Enhanced data grids to handle ISO-8601 date and time formats.
May 14, 2012: Version 3.4.12. build 2221
SQLite library 3.7.12 included.
May 8, 2012: Version 3.4.11. build 2220
Fixed bug in generating SQL statements to clipboard.
May 5, 2012: Version 3.4.10. build 2219
Fixed bug in Query Builder causing the generation of invalid queries when using attached databases.
April 11, 2012: Version 3.4.9. build 2218
Improved performance when opening tables with large text values when ''Cell auto height'' option is selected.
April 5, 2012: Version 3.4.8. build 2217
Fixed data conversion error when importing from ADO data source.
April 3, 2012: Version 3.4.7. build 2216
Fixed integer overflow when importing from ADO data source.
March 30, 2012: Version 3.4.6. build 2215
Improved error messages returned by SQLite Expert.
March 29, 2012: Version 3.4.5. build 2214
For performance reasons, blobs are no longer loaded in memory if the ''Show images'' option is not selected.
March 20, 2012: Version 3.4.4. build 2213
Updated SQLite library to 3.7.11.
March 10, 2012: Version 3.4.3. build 2212
Fixed a startup error when running on Linux with the Wine compatibility layer.
February 29, 2012: Version 3.4.2. build 2211
Fixed a bug in updating the tab visibility.
February 23, 2012: Version 3.4.1. build 2210
Fixed a bug in refreshing Query Builder.
February 17, 2012: Version 3.4.0. build 2208
Updated some third party components.
January 14, 2012: Version 3.3.55. build 2206
Fixed an issue in restructuring tables having default values.
January 4, 2012: Version 3.3.54. build 2205
Fixed issue with F3 shortcut key in search/replace dialog.
January 3, 2012: Version 3.3.53. build 2204
Fixed case sensitivity issue in search/replace dialog.
November 3, 2011: Version 3.3.52. build 2203
Modified error reporting options to include only basic debug information.
November 2, 2011: Version 3.3.51. build 2202
Fixed bug causing the locking of the database file after an unsuccessful attempt to open an encrypted database.
November 1, 2011: Version 3.3.50. build 2201
Fixed text clipping issues in data transfer wizard when using large fonts. Fixed bug in grid filter on GUID fields. SQLite library 3.7.9 included.
October 26, 2011: Version 3.3.49. build 2200
Minor user experience improvements. License upgrade tool no longer included.
October 25, 2011: Version 3.3.48. build 2199
Fixed a bug in retrieving the SQLite error message.
October 19, 2011: Version 3.3.47. build 2198
Fixed bug in exporting GUID values to CSV.
October 15, 2011: Version 3.3.46. build 2196
Checking for updates now allows downloading and installing new version from within the program.
October 14, 2011: Version 3.3.45. build 2195
Fixed incorrect ordering on Database tab.
October 9, 2011: Version 3.3.44. build 2194
Fixed bug on extensions tab - functions and collations displayed for the wrong extension.
September 24, 2011: Version 3.3.43. build 2193
SQLite library 3.7.8 included.
September 22, 2011: Version 3.3.42. build 2192
DOCID is now preserved when restructuring virtual table.
September 21, 2011: Version 3.3.41. build 2190
Fixed flickering issue when hovering the mouse over buttons.
September 11, 2011: Version 3.3.40. build 2189
Fixed a bug in parsing CREATE TRIGGER statements.
September 8, 2011: Version 3.3.39. build 2188
Further optimizations when copying data to clipboard.
September 7, 2011: Version 3.3.38. build 2186
Fixed performance issues when copying and pasting data via the clipboard. When exporting to SQL script, triggers are now created after all the tables and views have been created. Fixed resizing issues on some forms.
September 5, 2011: Version 3.3.37. build 2185
File associations are now saved in the current user settings so they no longer require admin privileges.
August 26, 2011: Version 3.3.36. build 2179
Fixed error in getting SQLite driver capabilities in the Options dialog.
August 22, 2011: Version 3.3.35. build 2178
Minor UI fixes.
August 14, 2011: Version 3.3.34. build 2175
Fixed bug in field type auto-detection when importing from CSV files.
August 7, 2011: Version 3.3.33. build 2174
Minor internal fixes.
August 2, 2011: Version 3.3.32. build 2173
Minor bug fixes.
July 28, 2011: Version 3.3.31. build 2169
Fixed a performance issue when refreshing schema.
July 13, 2011: Version 3.3.30. build 2166
Updated help file.
June 28, 2011: Version 3.3.29. build 2159
SQLite library 3.7.7.1 included. SQLite library is now compiled with SQLITE_SOUNDEX enabled. Last open file is now remembered in open/save dialogs.
June 5, 2011: Version 3.3.28. build 2158
Minor bug fixes.
May 20, 2011: Version 3.3.27. build 2157
SQLite library 3.7.6.3 is now included.
May 10, 2011: Version 3.3.26. build 2156
Fixed bug causing incorrect order of fields in an index.
May 10, 2011: Version 3.3.25. build 2155
Fixed startup error message when using external library. Fixed "table not found" error when creating an index on a new table.
May 8, 2011: Version 3.3.24. build 2154
The ''move up'' and ''move down'' buttons now work with multiple selected records on the field designer.
May 7, 2011: Version 3.3.23. build 2153
Fixed bug in index editor.
April 29, 2011: Version 3.3.22. build 2152
Improved JPEG image format detection.
April 24, 2011: Version 3.3.21. build 2151
The record counts are now calculated using separate connections to the database.
April 21, 2011: Version 3.3.20. build 2150
The record count feature is now optional.
April 21, 2011: Version 3.3.19. build 2149
The record count feature is now disabled to prevent performance issues on large databases. It will be made optional in the next version.
April 18, 2011: Version 3.3.18. build 2148
Removed redundant record count calculations to improve performance. Added error message when attempting to perform a database backup if the selected SQLite library does not support the online backup API.
April 18, 2011: Version 3.3.18. build 2148
Fixed incorrect dependency order when exporting database to script. Fixed error in parsing triggers containing CASE statements.
April 17, 2011: Version 3.3.17. build 2147
SQLite library 3.7.6.2 is now included.
April 17, 2011: Version 3.3.16. build 2146
Fixed field not found error when primary key field contains blank characters.
April 16, 2011: Version 3.3.15. build 2145
Record count is now always displayed for all tables and views. SQLite library 3.7.6.1 is now included.
April 15, 2011: Version 3.3.14. build 2144
Fixed AV after opening and canceling the Options window.
April 13, 2011: Version 3.3.13. build 2143
Fixed error in refreshing schema after deleting an object.
April 13, 2011: Version 3.3.12. build 2142
Fixed error in sorting objects by dependencies when exporting data. Fixed error in generating SQL for tables having foreign keys.
April 12, 2011: Version 3.3.11. build 2141
SQLite library 3.7.6 is now included.
April 11, 2011: Version 3.3.10. build 2140
Fixed program startup error when using auto-extensions.
April 10, 2011: Version 3.3.9. build 2139
Added support for the ICU extension.
April 7, 2011: Version 3.3.8. build 2138
Fixed bug in refreshing data when being displayed in text mode.
April 5, 2011: Version 3.3.7. build 2137
Fixed bug in importing null values from CSV files.
April 4, 2011: Version 3.3.6. build 2136
Added database online backup option.
April 1, 2011: Version 3.3.5. build 2135
Minor bug fixes.
March 30, 2011: Version 3.3.4. build 2134
Minor bug fixes.
March 27, 2011: Version 3.3.3. build 2133
Added database DDL compare tool.
March 20, 2011: Version 3.3.2. build 2132
Added options "Auto cell height" and "Show cell hints" to main menu.
March 18, 2011: Version 3.3.1. build 2131
Added support for RTREE virtual tables.
March 17, 2011: Version 3.3.0. build 2130
Added support for virtual tables including FTS3 and FTS4. Added progress bar, cancel button and improved performance when generating random data.
Modified internal handling of blob fields for accurate display in the Hex editor regardless of the storage class.
February 14, 2011: Version 3.2.17. build 2117
Fixed bug introduced in previous version preventing the usage of external SQLite libraries.
February 13, 2011: Version 3.2.16. build 2116
Added support for changing the field sort order in the index editor.
February 6, 2011: Version 3.2.15. build 2115
Fixed datetime display error occurring for date values above year 2100.
February 5, 2011: Version 3.2.14. build 2114
SQLite library version 3.7.5 included. Fixed a few UI annoyances.
February 1, 2011: Version 3.2.13. build 2113
Fixed a registry error when reading file associations.
January 20, 2011: Version 3.2.12. build 2112
Fixed error in copy/paste records on systems with decimal separator different than ".".
January 18, 2011: Version 3.2.11. build 2111
Fixed incorrect application title in Professional Edition.
January 7, 2011: Version 3.2.10. build 2110
Upgraded external SQLite library to 3.7.4.
January 7, 2011: Version 3.2.9. build 2109
Minor UI fixes.
January 4, 2011: Version 3.2.8. build 2108
Added associated extensions to the list of file extensions in the open database dialogs.
December 16, 2010: Version 3.2.7. build 2107
Performance improvements for datasets with a large number of columns.
December 16, 2010: Version 3.2.6. build 2106
SQLite library version 3.7.4 is now included. Added option to set a default encryption key. Minor internal fixes.
November 15, 2010: Version 3.2.5. build 2105
Improved image format detection for images displayed in the grid.
November 14, 2010: Version 3.2.4. build 2104
Grid selection is now cleared after sorting by a column.
November 13, 2010: Version 3.2.3. build 2103
Fixed cell auto height not using the current setting on a new SQL tab.
November 11, 2010: Version 3.2.2. build 2102
Minor corrections to the Pascal script engine.
November 5, 2010: Version 3.2.1. build 2101
Added "Close other SQL tabs" menu item. Updated sample scripts to work with version 3. Fixed an error in Lua script output. Fixed a database locking error.
October 28, 2010: Version 3.2.0. build 2100
Added database repair function. Added pragmas automatic_index and wal_autocheckpoint. Fixed error updating data after modifying in Hex editor.
October 18, 2010: Version 3.1.23. build 2099
Fixed error in local time calculation when using the internal SQLite library.
October 10, 2010: Version 3.1.22. build 2098
Added rowid to the parent key drop-down list in the foreign key editor.
October 8, 2010: Version 3.1.21. build 2097
SQLite library version 3.7.3 included.
October 7, 2010: Version 3.1.20. build 2096
Fixed bug in import from a text file with encoding set to "Default ANSI code page" on multi byte character sets.
October 6, 2010: Version 3.1.19. build 2095
Fixed error in refreshing non-integer primary key for tables having unique constraints".
October 5, 2010: Version 3.1.18. build 2094
Fixed bug in import from a text file with encoding set to "Default ANSI code page".
October 1, 2010: Version 3.1.17. build 2093
Fixed error in local time calculation when using the internal SQLite library.
September 30, 2010: Version 3.1.16. build 2092
Fixed SQLite library not restored at application startup.
September 28, 2010: Version 3.1.15. build 2091
Fixed bug in restoring SQL history at application startup.
September 25, 2010: Version 3.1.14. build 2090
Implemented some schema refresh optimizations.
September 24, 2010: Version 3.1.13. build 2089
Fixed error in local time calculation when using the internal SQLite library.
September 17, 2010: Version 3.1.12. build 2088
Added tab width option. Added keyboard shortcut (CTRL+/) for commenting/uncommenting selected text in SQL and script editors.
September 11, 2010: Version 3.1.11. build 2087
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.
September 9, 2010: Version 3.1.10. build 2086
Fixed incorrect restoring of SQL queries containing double quotes at program startup.
September 1, 2010: Version 3.1.9. build 2085
Added word-wrap option for SQL editors.
September 1, 2010: Version 3.1.8. build 2084
Fixed child fields not being renamed when renaming field in tables with multiple foreign keys.
August 31, 2010: Version 3.1.7. build 2083
Fixed tab character not expanded in the grid and in the tooltip windows.
August 28, 2010: Version 3.1.6. build 2082
Fixed current record number not being displayed except the first SQL tab. Fixed conversion error when applying a filter on a field containing null records.
August 23, 2010: Version 3.1.5. build 2081
SQLite library 3.7.2 included.
August 23, 2010: Version 3.1.4. build 2080
Fixed navigator buttons not working on the SQL tabs.
August 23, 2010: Version 3.1.3. build 2079
Fixed record number not showing on the SQL grids.
August 22, 2010: Version 3.1.2. build 2078
SQLite library 3.7.1 included.
August 22, 2010: Version 3.1.1. build 2077
SQL Builder now generates queries in a new SQL tab to preserve existing queries.
Внимание! AdBlock блокирует показ скриншотов, все вопросы к разработчикам )))