• Fixed a bug where exported SQL files would be empty • Fixed a bug causing CHECK constraints to not be editable

• Fixed a bug where Base would crash part-way through exporting some files

• Modernised UI to fit in with current macOS versions better • Fixed a bug in the jump to row sheet causing it to jump to the wrong row • Fixed a number of minor UI inconsistencies and dark mode colors

Changes from 2.4.16: • Adds syntax highlighting themes for light and dark mode • Fixes a bug where the add index feature had invisible text Changes from 2.4.15: • Base now only runs on macOS 10.14 (Mojave) or higher • Added support for Dark Mode • Row numbers in the data browser now stick to the left edge correctly • Fixed a bug which caused logged SQL to not show the correct font or syntax colouring

• Base now only runs on macOS 10.14 (Mojave) or higher • Added support for Dark Mode • Row numbers in the data browser now stick to the left edge correctly • Fixed a bug which caused logged SQL to not show the correct font or syntax colouring • Enabled macOS sandboxing

• Update SQLite to 3.17.0 • Fix a crash on launch bug

• Update SQLite to 3.17.0 • Fix a crash on launch bug

Base 2.4.10 is a bug fix release. Changes include: • 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

Base 2.4.9 is a bug fix release. Changes include: • 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 rare crash in the table editor • SQLite updated to 3.8.6

Base 2.4.8 is a bug-fix release. Changes include: • 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 the recent documents window no longer outputs vast numbers of messages to the system console • SQLite updated to 3.8.1

This is primarily a bug-fix release. Changes include: • 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

This is primarily a bug-fix release. Changes include: • 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.

This is primarily a bug-fix release. Changes include: • 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

This is a bug-fix release. Changes include: • Base now requires Mac OS 10.8 (Mountain Lion) or newer • Sandboxing has been re-enabled • 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

⚠ This is an important update! Read on for details. There was a bug in the previous version of Base which prevented users running Mac OS 10.7 from making changes to their databases. This update fixes that problem by temporarily removing sandboxing from Base. If you are running 10.7, you really should update to this version. The next update will require Mac OS 10.8 or higher as Base will re-enable sandboxing. This update will come within the next two months, so please do download this version soon. If you have any queries, please email info@menial.co.uk Other 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.

Base 2.4.2 is a bugfix release. • Fixed a crash-on-launch bug for users on Mac OS 10.7 (Lion) Changes from Base 2.4: • New SQL logging system - includes fast log filtering • Execution time can now be shown for custom SQL statements • Source list filtering now uses unanchored searching (it doesn't only match the start of entity names) • Enabled sandboxing (Mac App Store version only) • Updated to latest version of SQLite (3.7.15) • 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 an internal framework - Base is slightly smaller and faster • Plugged two memory leaks

Users on Mac OS 10.7 (Lion) should *not* update to 2.4 as it contains a crash-on-launch bug. Please wait for 2.4.1 which fixes this problem. Users on 10.8 (Mountain Lion) are not affected by this problem. Base 2.4 contains new features and bug fixes: • New SQL logging system - includes fast log filtering • Execution time can now be shown for custom SQL statements • Source list filtering now uses unanchored searching (it doesn't only match the start of entity names) • Enabled sandboxing (Mac App Store version only) • Updated to latest version of SQLite (3.7.15) • 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 an internal framework - Base is slightly smaller and faster • Plugged two memory leaks

Base 2.3.1 is a bugfix release. • 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 the speed of operations which load table schema Please note that this will be the last update to support 10.6. Future updates will require 10.7 or higher.

• 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 • Updated to the latest version of SQLite at release (v3.7.11)

Base 2.2.1 is a bugfix release. 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

• 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 (⌘ +), delete row (←), previous page (⌘ ⤎), next page (⌘ ⤏) • 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)

Base 2.1.1 is primarily a bugfix release: • 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

• 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

Base 2.0.2 is primarily a bugfix release: • 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

Base 2.0.1 is primarily a bug fix release: • Included more auto-complete options for SQLite pragmas • Disabled blob placeholder insertion except in the log screen • Identifiers quoted with square brackets are now parsed correctly • Fixed parsing of table constraints starting with lower-case words • Fixed parsing of table schemas with comments inside • Explicitly allowing NULL in column definitions no longer breaks the schema view • Column types with precision & scale values now display in full • Sorting table data by columns other than rowid no longer breaks row inserting • Plugged two memory leaks in the logging system • Exported XML now correctly closes tags