What's new in Base 2.4.12 Build 2113
Mar 26, 2017
- Fix a bug causing Base to sometimes crash on launch
- SQLite updated to 3.17.0
New in Base 2.4.11 Build 2107 (Mar 22, 2017)
- Update SQLite to 3.17.0
- Fix a crash on launch bug
New in Base 2.4.10 Build 1678 (Jun 10, 2015)
- Fixed a bug where dropping a table via right-click could drop the wrong table
- The description for pragma auto_vacuum now lists options in the right order
- Disabled sorting of columns in the table editor. This prevents altered tables from having the column orders swapped without notice.
- Fixed some speling and gramer mistakes
- Updated SQLite to 3.8.10.2
New in Base 2.4.9 Build 1547 (Sep 29, 2014)
- The row editor sheet now correctly shows column names
- Disabled smart quotes, dashes and links the data browser and SQL tab
- Corrected the description for the secure_delete pragma
- Fixed a crash that would occur on OS X Yosemite
- SQLite updated to 3.8.6
New in Base 2.4.8 Build 1445 (Nov 4, 2013)
- Smart quotes, dashes, spelling and data detectors are now disabled in the SQL editor
- The add index sheet is no longer missing column names
- Showing recent documents no longer outputs vast numbers of messages to the system console
- SQLite updated to 3.8.1
New in Base 2.4.7 Build 1409 (Oct 21, 2013)
- Quotes from imported CSV files are now un-escaped correctly
- iOS 7 Core Data files can now be opened correctly
- Base no longer crashes when renaming certain tables
- Full-screen mode now has a menu item and keyboard shortcut
- Row numbers in the data browser no longer jump around on Mavericks
New in Base 2.4.6 Build 1301 (Jul 22, 2013)
- Changes made in the data browser no longer show the old value before being committed
- Exported SLK files now include column names
- Custom queries now show the number of rows returned
- Filtering large tables no longer shows empty pages
- When creating the first table in a database, the source list auto-expands to show it
- The SQL log now shows setting values to NULL correctly (they were already set correctly, but the log was wrong)
- CSV import no longer fails when the last line of a file is empty
- Exporting custom SQL queries to CSV now includes column names
- Changes made to constraints in the table editor could sometimes not be saved. They are now.
New in Base 2.4.5 Build 1224 (Jun 8, 2013)
- Failed CSV imports now report where and why failure occurred
- Tabbing between fields in the data browser now wraps from line to line
- Tables where a column name is an unquoted SQL keyword now display correctly
- Table list filtering no longer loses focus after each keystroke
- Table list filtering is now case insensitive
- The custom SQL split view now remembers its last position
- The application_id pragma can now be viewed and set in the database options
- Updated SQLite to 3.7.17
New in Base 2.4.4 Build 1201 (May 17, 2013)
- CHANGES:
- Base now requires Mac OS 10.8 (Mountain Lion) or newer
- A potential crash-on-launch bug has been fixed
- An interface glitch preventing an error message from being dismissed has been fixed
- The menu bar items for switching views have moved from the Window menu to the View menu
- NOTES:
- This is a free update for all 2.x owners
- This is a paid upgrade for all 1.x owners
New in Base 2.4.3 Build 1176 (Mar 29, 2013)
- CHANGES:
- Trying to open a file that is not a database now shows an error instead of crashing
- Fixed a bug causing the string 'NULL' to be displayed as a null icon
- Fixed a bug where entering 'NULL' into a field would result in a string being saved instead of a true null
- Fixed a bug where constraints containing an empty string would stop the table schema being fully displayed
- Custom SQL query results now have alternating background colours like other tables
- NOTES:
- This will be the last update to support 10.7. Future updates will require 10.8 or higher.
- This is a free update for all 2.x owners
- This is a paid upgrade for all 1.x owners
New in Base 2.4.2 Build 1161 (Jan 3, 2013)
- CHANGES:
- Fix a crash-on-launch bug for users running Mac OS 10.7 (Lion)
- This update replaces v2.4 and v2.4.1
- PREVIOUS CHANGES:
- New SQL logging system - includes fast log filtering
- Execution time can now be displayed for custom SQL statements
- Plugged two memory leaks
- Source list filtering now uses unanchored searching (it doesn't only match the start of entity names)
- Enabled sandboxing (Mac App Store version only)
- Removed third-party libraries in favour of system-provided interface elements
- Schema display no longer breaks when a negative number is set as a default value
- Custom SQL execution no longer reports only two statements completed
- Removed internal frameworks - Base is slightly smaller and faster
- Updated to latest version of SQLite (3.7.15)
- NOTES:
- This update requires Mac OS 10.7 or newer.
- Base 2.4 is a free update for all 2.x owners
- This is a paid upgrade for all 1.x owners
New in Base 2.4 Build 1147 (Dec 29, 2012)
- CHANGES:
- New SQL logging system - includes fast log filtering
- Execution time can now be displayed for custom SQL statements
- Plugged two memory leaks
- Source list filtering now uses unanchored searching (it doesn't only match the start of entity names)
- Enabled sandboxing (Mac App Store version only)
- Removed third-party libraries in favour of system-provided interface elements
- Schema display no longer breaks when a negative number is set as a default value
- Custom SQL execution no longer reports only two statements completed
- Removed internal frameworks - Base is slightly smaller and faster
- Updated to latest version of SQLite (3.7.15)
- NOTES:
- This update requires Mac OS 10.7 or newer.
- Base 2.4 is a free update for all 2.x owners
- This is a paid upgrade for all 1.x owners.
New in Base 2.3.1 Build 1054 (Aug 21, 2012)
- Added retina-quality icons
- Fixed a crash when toggling the snippets view
- Corrected a graphical glitch when toggling the snippets view
- Fixed a bug causing the last parenthesis of an SQL statement to not be displayed
- Fixed a crash when using undo in the custom SQL view
- Constraint popovers will now be in the right place on MacBook Pro with Retina Display
- Improved speed of operations which load table schema
New in Base 2.3 Build 1018 (Mar 24, 2012)
- CHANGES:
- You can now view and edit pragmas for the main database without manually typing SQL
- Data tables now show line numbers
- Improved support for importing and exporting UTF-16 data
- Enabled more SQLite options (FTS4, Soundex and STAT3)
- The data editing sheet now has the editing area selected when it first appears
- Fixed a bug causing the first non-header row of CSV files to not be imported
- The app is now signed ready for Gatekeeper
- Updated to the latest version of SQLite at release (v3.7.11)
- NOTES:
- Base 2.3 is a free update for all 2.x owners
- This is a paid upgrade for all 1.x owners
New in Base 2.2.1 Build 976 (Dec 10, 2011)
- CHANGES:
- Fixed LIKE filters in data browser when looking for numeric values
- CSV import no longer inserts column names as a first row
- Fixed a crash which occurred when importing some CSV files with blank rows
- CSV exporting now behaves correctly when the first column is not selected
- CSV exporting no longer fails on tables with spaces in their names
- The table editor now commits open changes before creating a table
- The table editor Save button now enables/disables itself correctly
- The split view in the SQL tab now remembers its position
- The add/remove row control in the data browser is now disabled when inspecting SQLite-internal tables
New in Base 2.2 Build 963 (Oct 25, 2011)
- Massively improved table schema parsing reliability and speed. This fixes several schema display bugs.
- Data viewers now auto-detect data types and show the appropriate preview type
- BLOB data type is now auto-detected where possible and the proper file extension/icon shown ready for dragging
- BLOB data in the data browser is now shown as a placeholder icon. Double-click to reveal it in full
- When exporting to SQL, indexes and triggers can now be included with their parent table
- Sorting in the data tab is now case-insensitive
- Added keyboard shortcuts to the data browser: Add row (command-plus), delete row (backspace), previous page (command-left), next page (command-right)
- Add tooltips to more buttons
- Fixed a hang/crash when autocompleting column names in the SQL editor
- Made the snippet editor use the font selected for SQL editing
- Fixed a visual glitch occurring when the snippet editor was resized
- Updated to the latest version of SQLite at release (v3.8.0)
New in Base 2.1.1 Build 923 (Aug 24, 2011)
- Base now supports Lion full-screen display
- Fixed a display problem for schemas with comments
- Table columns now truncate their displayed data instead of clipping it
- The create index button now enables itself correctly when columns are selected
- Fixed a bug where small CSV files would not import
- Fixed a crash when importing tab delimited files
- Fixed a crash when importing delimited text with a byte order mark
- Constraints on the first column of new table can now be edited correctly
- Added support for the .sqlite file extension
New in Base 2.1 Build 895 (Jun 21, 2011)
- Filtering of NULL values in the data browser now behaves correctly
- Improved display of NULL values. Check out the app preferences for details.
- Multi-word column types no longer break schema display
- Columns with leading underscores no longer break schema display
- The number of custom SQL queries executed can now count above 2
- Fixed a bug preventing the selection of custom delimiters in CSV export
- Fixed a bug preventing the exporting of SYLK data
- The sheet-based row editor is no longer confused by active filters in the data browser
- Fixed a bug where the database file might not be closed when the app is closed
- Improved the reliability of CSV importing
- Imported CSV columns now attempt to auto-match to existing column names
- Import panel now remembers the last selected import type & delimiter
- Entities in column/table constraints are now escaped correctly
- The create index button no longer remains disabled
- Exported XML now escapes entities correctly
- Updated SQLite to version 3.7.6.3
New in Base 2.0.2 Build 850 (Apr 1, 2011)
- Enabled support for the SQLite R*Tree module
- Fixed a hang which occurred when selecting certain tables
- Larger font sizes no longer cause clipped text in the autocomplete box
- Editing and dropping of shadow tables is now not possible through the interface (note that if you want to, you can still shoot yourself in the foot by running the SQL yourself)
- Editing the default value for a column no longer nests quotes repeatedly
- Schemas with identifiers in backticks are now parsed correctly
New in Base 1.4.2 Build 461 (Sep 3, 2010)
- Fix compatibility with systems running OS 10.5
New in Base 1.4.1 Build 460 (Aug 16, 2010)
- Fix bug where importing only some CSV columns would cause a crash
- Fix bug causing hang/crash when importing CSV files with CR-only line endings
- Fix bug causing columns to be unmappable when importing non-comma delimited text
New in Base 1.4 Build 456 (Mar 8, 2010)
- Added CSV importing
- Improved SQL importing
- Updated to SQLite version 3.6.22
- Added a new preference pane for browsing–related settings
- You can now choose how many rows to view per page in the data browser
- Opening an empty database now auto–selects the SQL tab
- Errors in custom SQL are now correctly displayed
- Added a keyboard shortcut (cmd–R) for reloading the current database file
- Added the ability to vacuum database files from the UI
- You can now drag and drop entities from the source list into the SQL tab
- Improved how numeric data is handled when edited
- Re–added alternating row colours in the data browser
- Fixed a UI bug that occurs when deleting newly inserted rows
- Fixed a UI bug in the export sheet
- Changing the log font now longer needs a restart to take effect
- Fixed a crash that occurred when importing large SQL files
- Enabled Sparkle anonymous system profiling (opt–out in app preferences)
New in Base 1.3.3 Build 317 (Oct 4, 2009)
- Enhancements:
- Better handling of quotes in the table editor
- Better handling of sqlite_* internal tables
- Changed default logging font to one that supports international characters
- Can now add unique indexes via the GUI
- Enabled FTS3
- Bug Fixes:
- Fixed a problem where changes made in the data browser may not be applied
- Fixed a bug where you could not tab between field in the table creator
- Fixed a validation error on the create index sheet
- Fixed string escaping in exported SQL
- Fixed a memory leak when manually reloading a file
- Note: Although FTS3 has been enabled, it's integration with Base is slightly less than ideal as it is seemingly impossible to reliably identify tables that are part of an FTS index. To this end I have disabled the modification of virtual tables and the user is responsible for not renaming or deleting the *_content, *_segdir and *_segments tables generated by the FTS module. I do hope to improve this in the future.
New in Base 1.3.2 Build 293 (Jun 17, 2009)
- Fixed escaping of identifiers in the ALTER TABLE sheet.
- Fixed display of edited data in the data browser.
- Better notification of broken triggers after altering tables.
- Slightly better handling of SQLite internal tables. More improvements to come on this.
New in Base 1.3.1 Build 284 (Jun 7, 2009)
- New Features:
- Full support for altering tables.
- Can now rename tables, views and triggers.
- Added a toolbar button for manually reloading changes made by external processes.
- Document windows now autosave their position.
- You can now select multiple rows in the data browser.
- Bug Fixes:
- Much better support for entities needing escaping.
- Improved state saving between tab (schema, data, sql, log) switches.
- Minor internal tweaks which probably shouldn't be noticed.
- Fixed a bug where editing a sorted row would cause it to move and edit the next cell wrongly.
- Licensing window will now accept any file extension for dropped files.
- The open dialog will now browse inside packages/bundles.
- The data browser properly responds to the delete key.
New in Base 1.2 Build 213 (Jan 26, 2009)
- Syntax highlighting for SQL.
- Support for viewing views and triggers.
- Column widths are saved on a per-table basis.
- Editing a value to NULL no longer inserts the string 'NULL'.
- Fixed a bug where BLOB data would be reported as NULL.
- Minor internal tweaks which probably shouldn't be noticed.
New in Base 1.1 Build 175 (Dec 15, 2008)
- You can now sort data by clicking on column headers.
- Added tooltips for buttons in bottom bar.
- Custom SQL can now be executed by pressing cmd-return or enter.
- Fixed display error when resizing create table sheet.
- Fixed tabbing between edited cells in data browser.
- Disabled rearranging of columns temporarily to prevent data editing weirdness.
- Fixed a bug where some users could not add columns.
- Toolbar layout is now automatically saved.
New in Base 1.0 Build 137 (Nov 17, 2008)