Base versions

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

NOTES:

Base 2.2.1 is a free update for all 2.x owners
This is a paid upgrade for all 1.x owners

Base 2.2 build 963

NOTES:

Base 2.2 is a free update for all 2.x owners
This is a paid upgrade for all 1.x owners

CHANGES:

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)

Base 2.1.1 build 923

NOTES:

Base 2.1.1 is a free update for all 2.x owners
This is a paid upgrade for all 1.x owners

CHANGES:

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

Base 2.1 build 895

NOTES:

Base 2.1 is a free update for all 2.x owners
This is a paid upgrade for all 1.x owners

CHANGES:

Added an option for graphic placeholder for NULL values. Check out the app preferences for details.
Filtering of NULL values in the data browser now behaves correctly
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
Multi-word column types break 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
Users who allow system information to be submitted will now also report if the app is in trial or registered mode
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 build 850

NOTES:

Base 2.0.2 is a free update for all 2.x owners
This is a paid upgrade for all 1.x owners

CHANGES:

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 build 835

NOTES:

Base 2.0.1 is a free update for all 2.x owners
This is a paid upgrade for all 1.x owners

CHANGES:

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

Base 2.0 build 821

IMPORTANT NOTES:

Base 2 is a paid upgrade. However if you purchased Base 1 on or after January 6, 2011 you can upgrade for free.
Base 2 requires an Intel Mac running Mac OS 10.6 or newer

NEW FEATURES:

New table schema view — now supports all column and table constraints
New table creation and editing system — now supports all column and table constraints
Autocompletion is now available in SQL text fields
Store commonly used SQL as snippets
New data/BLOB viewer – includes support for viewing BLOBs as images and generic files as well as text
New row inserter for the data browsing views
New find & filter system for data browsing
New source list filter
New application icon!
You can now export the results of custom queries
Can now drag data out of data browser as CSV

IMPROVEMENTS:

Base 2 is Intel & Snow Leopard (10.6) only (dropping support for 10.5 and PowerPC–based Macs)
Enabled support for running as a 64–bit process
Improved support for virtual tables
Improved support for special values (eg CURRENT_DATE) throughout the app
Improved support for viewing/creating/editing indexes
Improved syntax highlighting performance
Syntax highlighting can now differentiate between strings ('') and quoted identifiers ("")
Syntax highlighting now displays hexadecimal data values in a shortened form
Improved importing performance
Improved exporting performance
Improved SQL logging system
Improved first–launch window to show recently opened files
Added right–click menu on source list items
Allow selection of custom SQL results
Updated SQLite to version 3.7.5
Enabled FTS3 (with enhanced query syntax) and FTS4
The application help book is now much easier to read

BUG FIXES:

Fixed a bug causing open/save dialogs to forget their last position
Fixed exporting so that it no longer causes the app to become non–responsive
Fixed a bug where some exported files would not be closed after being created (making them hard to delete)
Fixed a bug causing the SQL log to forget it's last scrolled position
Fixed syntax highlighting bug, causing invisible text when the chosen log font is disabled
Fixed a bug that could cause a crash when creating a new document
Fixed a bug causing changes to not be committed
Fixed a crash which could occur when importing only certain columns from a CSV file
Fixed a display bug which occurred when dropping a virtual table

Base 1.4.2 build 461

v1.4.2:
– Fix compatibility with systems running OS 10.5
– There are no other changes beyond v1.4.1

v1.4.1:
– Fix bug which occurs when attempting to import files with CR-only line endings
– Fix bug causing column names to be unmappable when importing non-comma delimited text
– Fix crash/hang when selecting a CSV file to import
– Fix crash occurring when attempting to import only some CSV columns

Base 1.4.1 build 460

– Fix bug which occurs when attempting to import files with CR-only line endings
– Fix bug causing column names to be unmappable when importing non-comma delimited text
– Fix crash/hang when selecting a CSV file to import
– Fix crash occurring when attempting to import only some CSV columns

Base 1.4 build 456

– 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)

Base 1.3.4 build 376

Changes
Bug Fixes: – Fixed a bug where Base would crash on exit

Base 1.3.3 build 321

Changes

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.

Base 1.3.2 build 293

Changes
Bug Fixes: – 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.

Base 1.3.1 build 284

Changes

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

Base 1.2 build 213

Changes

New Features:
– Syntax highlighting for SQL
– Support for viewing views and triggers
– Column widths are now saved on a per-table basis

Bug Fixes:
– 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

Base 1.1 build 175

Changes

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.

License File fix
Fixed a common problem which was preventing license files from being registered properly.

Base Initial Release
Initial Release.

Base 2.2.1 build 976

CHANGES:

NOTES:

Base 2.2 build 963

NOTES:

CHANGES:

Base 2.1.1 build 923

NOTES:

CHANGES:

Base 2.1 build 895

NOTES:

CHANGES:

Base 2.0.2 build 850

NOTES:

CHANGES:

Base 2.0.1 build 835

NOTES:

CHANGES:

Base 2.0 build 821

IMPORTANT NOTES:

NEW FEATURES:

IMPROVEMENTS:

BUG FIXES:

Base 1.4.2 build 461

Base 1.4.1 build 460

Base 1.4 build 456

Base 1.3.4 build 376

Changes

Base 1.3.3 build 321

Changes

Base 1.3.2 build 293

Changes

Base 1.3.1 build 284

Changes

Base 1.2 build 213

Changes

Base 1.1 build 175

Changes

Base 1.0.2 build 143

Bug Fixes

Base 1.0.1 build 139

License File fix

Base 1.0 build 137

Base Initial Release