Build 101 - Improved SQL Editor.

Download


Release date: 20 Apr 2018.

  • Auto add quote when table/column has space or case sensitive in auto-completion.
  • 100x faster syntax parsing.
  • [SQLite] Supported rtree index.
  • [SQLite, SQL Server] Supported edit data directly in SQL Query.
  • [SQL Server] Fixed bug beautify SQL.
  • Supported show table creation/comment.
  • Fixed a bug missing options when creating a foreign key.
  • Changed comment code color.

Build 100 - The 100th build.

Download


Release date: 13 Apr 2018.

  • Redis official support.
  • Enabled “run current” and “split result into tabs” by default.
  • Supported save filter states.
  • [MySQL] Support procedure.
  • [PostgreSQL] Improved parsing function.
  • [SQLite] Added encrypted key into connection form.
  • [SQL Server] Faster canceling a query.
  • [CockroachDB] Improved array serializer.
  • Supported export as HTML.
  • Fixed a bug when running custom query.
  • Fixed a syntax bug when sorting column.
  • Refactored title bar.

Build 99 - New features


Release date: 6 Apr 2018.

  • The official support for CockroachDB.
  • [PostgreSQL] Supported column comment and index comment.
  • [MySQL] Supported column comment.
  • [MySQL] Supported auto increment.
  • Improved shortcut keys.
  • [SQL Server] Fixed a bug executing a custom query but do not get the result.
  • Fixed many other bugs.

Build 98 - Improved performance and stability


Release date: 2 Apr 2018.

  • Improved performance and stability.
  • [PostgreSQL] Supported full SSL mode.
  • [MySQL] Supported full SSL mode.
  • Supported change the CSV encoding.
  • [SQL Server] Support streaming rows.
  • Support change indent type: tabs or spaces.
  • Fixed bug case sensitive in MySQL.
  • Fixed a bug render counter.
  • Fixed a bug when editing TablePlus scrolls to top after commit.
  • Fixed a bug row counter.

Build 96 - Streaming data rows


Release date: 28 Mar 2018.

  • Supported streaming data rows, TablePlus loads data much faster.
  • Added ability to cancel a long run query.
  • Improved Export GUI.
  • Improved Import CSV: custom delimiter, quotes and it’s faster.
  • TablePlus shows empty schemas.
  • Fixed a random crash.
  • Added ability to change tab width spaces.
  • Supported keys: home, end in the editor.
  • [SQLite] Support read the encrypted database.
  • Fixed a crash bug when comment code in SQL Query.
  • Added ability to show advanced filter query.
  • [SQL Server] Fixed export bug.
  • Support auto converts empty JSON, Array to null in preferences.
  • Fixed bug that can prevent show welcome screen after close workspace.

Build 95 - Updated UI


Release date: 23 Mar 2018.

  • Added import CSV Wizard.
  • Improved general UI.
  • When opening multiple databases, the databases in the same connection will be grouped by a separator.
  • Increased timeout for SQL Server, PostgreSQL.

Build 94 - New licensing system


Release date: 16 Mar 2018.

  • New activation system using license key.
  • [PostgreSQL] Supported raise notice.
  • [SQL Server] Fixed a bug rename table/column.
  • Allowed Command P/N to move up/down auto-suggestion result.
  • Fixed a minor bug in SQLite.
  • [MySQL] Show primary index.

Build 93 - Remake history and favorites


Release date: 9 Mar 2018

  • History is separated by the connection.
  • The last saved SQL Query is separated by the connection.
  • Added ability to group favorites.
  • Searchable Favorites.
  • Added ability to mark table as favorites.
  • Improved performance when viewing JSON.
  • Fixed a bug connect to SQL Server Express edition 2008.
  • Update PostgreSQL Driver to 10.3.
  • Many other improvements and bug fixes.

Build 92 - Upgraded security


Release date: 4 Mar 2018

  • Fixed login bug.
  • Fixed a bug Raw SQL filter: wrong escape character.
  • Fixed a bug that suggested duplicated columns when using autocomplete.
  • Fixed a crash that happened when pressing a number key.
  • Linked help in the main menu to the feedback form.

Build 90 - Updated TablePlus UI colors


Release date: 23 Feb 2018

  • Updated theme colors.
  • Updated advanced filter UI.
  • Improved auto-suggestion: TablePlus now can suggest a column without table name.
  • Changed default advanced filter to Raw SQL.
  • Added hotkeys for the advanced filter.
  • Added brackets for SQL Server queries to prevent the reserved keywords conflict.
  • Support load/edit/create SQL Server functions.
  • Added column drop down in filter columns pop up in the data view.
  • Improved support import/export connection as URL.
  • Fixed a bug sort numeric in SQL Query result.
  • Fixed a bug update cell via quick menu.

Build 89 - The awesome advanced filter


Release date: 19 Feb 2018

  • Added the advanced filter.
  • [MS SQL] Fixed syntax for MS SQL version 2000, 2005, 2008, 2011.
  • Fixed a bug import connection from URL.
  • Fixed a bug when import/export table without primary key.
  • Fixed a bug order rows while loading table data.
  • Fixed a bug: scrollers are not shown in some cases.
  • Fixed all foreign key issues related to the column with uppercase.
  • Improved performance.

Build 88 - Happy Lunar New Year


Release date: 15 Feb 2018

  • [PostgreSQL] Fixed an issue: functions are not shown.
  • [PostgreSQL] Updated Driver to 10.2.
  • [MySQL] Fixed SSL issue.
  • [SQLite] Added tinyint data type.
  • [MS SQL] Fixed a bug: Database tables are not listed on Microsoft Azure.
  • [Redis] Fixed a bug connect to the server.
  • Improved the tutorial that helps user figured out how to commit the change.
  • Fixed a bug prevents TablePlus close window appeared in build 87.
  • Show number of rows affected after running an update statement in SQL Query.
  • Enabled Enter key for Execute Query, Open Anything, AutoComplete.
  • Fixed a typo in the dropdown in the right panel.
  • Updated all tooltips with an associated shortcut key.
  • Added shortcut show columns filter: command + shift + F.
  • Improved shortcut switch between table data and table structure: command + shift + [ and command + shift + ].
  • Fixed a bug that prevents TablePlus show uncommit confirmation popup.
  • Updated design of TablePlus About window.
  • Changed window title in the main menu or in the right click menu on the dock icon.
  • Fixed bug that prevents TablePlus restore window after minimizing.
  • Improved minimized behavior, now click on dock icon TablePlus will restore the lasted minimized window instead of show main window.

Build 87 - Improved SSH support


Release date: 09 Feb 2018

  • Added ability to change default execution: run all or run the current statement in SQL Query.
  • TablePlus respects ssh/config, when you create a new connect, no need to enter username, password, port and ssh keys anymore.
  • Added ability to set null/default/empty/now in the right panel.
  • Fixed a bug animation in textview in the right panel.
  • Improved tutorial create a new connection.

Build 86 - New features


Release date: 04 Feb 2018

  • Supported mass update rows, you can select multiple rows and edit all rows in the right panel.
  • Added ability to turn off auto reconnect.
  • Upgrade PostgreSQL backup/restore binaries to 10.1.
  • Fixed a bug in backup/restore windows.
  • Supported filter columns in the right panel with regex: keyword1 keyword2
  • Updated icon set for blind color users.
  • Support open connection by Unix command: open an_url_string.
  • Added feature: import connection as URL.
  • Added feature: copy connection as URL.
  • Make popup report error bigger.
  • Corrected placeholder string in the left panel.
  • Support fuzzy search in the right panel.
  • Fixed a bug filter columns in the right panel.
  • [MySQL] Fixed a bug can’t execute a query in SQL Query.
  • [MySQL] Fixed a bug reload tab name in tabbed windows after switch database.
  • Many minor bugs were fixed.

Build 85 - EL Capitan supported


Release date: 27 Jan 2018

  • Fixed bug can’t open connection on EL Capitan.
  • Fixed bug showing the wrong shortcut key in left panel placeholder.
  • [MySQL] Fixed no database selected when running a query in SQL Query.

Build 84 - Workspace tab

Release date: 26 Jan 2018

  • Added workspaces tab.
  • Added open new connection button, shortcut: Command + Shift + K.
  • Added a search field in Database Window.
  • Search item + database + open anything with pattern prefix: ^ and suffix: $.
  • Apply fuzzy search for items on the left-sider bar.
  • [MySQL] Added ability to change SSL Mode when creating a new connection.
  • Fixed a bug beautify SQL.
  • Fixed a bug “Show Main Menu” is not working in some cases.

Build 83 - Big Update

Release date: 21 Jan 2018

  • Added ability to change group icon on the welcome screen.
  • [SQLite] Supported load resource file: .sqliterc.
  • [MySQL] Updated driver to version 5.7.21.
  • [MySQL] Corrected error report while testing a new connection.
  • [MS SQL] Fixed rare case: result convert overflow.
  • Updated UI in-app notification.
  • Enabled Plugin Manager: command + L.
  • Added auto-uppercase for auto-complete keywords.
  • Added auto-covert empty to null for numeric and uuid.
  • Added behaviors tab in preferences.
  • Updated status bar font size.

Build 82 - UI updated, bugs fixes

Release date: 14 Jan 2018

  • Added an option keeps connections alive in preferences.
  • New preferences UI.
  • New account UI.
  • Press tab to auto-complete.
  • [PostgreSQL] fixed a bug: export table rows.
  • Removed the limitation group for the free version.
  • TablePlus now remembers item section states.
  • Show hidden folder while adding ssh key.
  • A lot of minor bugs were fixed.

Build 81 - Supported Function

Release date: 7 Jan 2018

  • TablePlus remembers all pane divider.
  • Supported create/update views.
  • Supported highlight syntax for PostgreSQL function.
  • Double click on Driver to create a new connection.
  • Fixed double render count rows in table data.
  • Improved Stability.

Build 80 - Remove limitations

Release date: 30 Dec 2017

  • Click on the status of the workspace to change status color.
  • Optimized performance while loading a table with billions of rows.
  • Fixed a bug: can’t create a unique index.
  • Fixed a bug: missing some foreign keys.
  • Fixed a bug: ordered wrong compound primary keys.
  • Fixed a bug show wrong table index in the right panel.
  • Fixed a bug crash while creating an index.
  • Potential crash fixes.

Build 79 - Remove limitations

Release date: 26 Dec 2017

  • Removed limitations on free version: connection, favorite.
  • Increased limitations on free version: 2 windows, 3 plugins.
  • Replace text in control commit/preview/discard by icons.
  • Added shortcut key for add new row/column, index: command + option + I.
  • Left alignment for float number.
  • Double click on title bar should maximum window size.
  • Supported edit cell data in quick look popup.
  • Added delete cascade in the menu. Hold shift/option when delete to trigger delete cascade and restart identify.
  • Fixed potential crash.

Build 78 - TLS Update

Release date: 21 Dec 2017

  • [PostgreSQL] Supported custom TLS.
  • [MySQL] Supported connect using custom SSL key file.
  • Supported add an empty row when double click on the tablespace.
  • [MySQL] Supported edit data in SQL Query result.
  • Fixed a crash bug when rendering plugin’s menu.
  • TablePlus now remembers lasted opened schema unique by database name.
  • [MySQL] Fixed a bug export rows.
  • Allow sorting rows in memory (sort SQL Query result, table structure, table index).
  • Fixed a bug workspace changed to default database after clicking on the dock icon.
  • Fixed a bug can’t edit data in a cell in some cases.
  • And many perfect pixels were fixed.

Build 77 - New features

Release date: 17 Dec 2017

  • [PostgreSQL] Supported partial index.
  • Supported rename tab (right click on the tab and rename it).
  • Added notification system, TablePlus will notify you when your query was completed (in case you have a long run query).
  • Added button show all workspaces. Now you can switch between opened workspaces easier.
  • Supported change status color, you can change the status color in new/update connection popup.
  • TablePlus can self-move to Applications folder.
  • Fixed bug TablePlus doesn’t update detail pane when changing table selection by arrow keys.
  • Fixed bug Apple layout (some segment control was cut off the edges).
  • Right alignment for number and split moment data type into 2 lines.
  • Corrected SQL Query status when executing long run queries in multiple tabs.

Build 76 - Bug fixes

Release date: 12 Dec 2017

  • Fixed Apple auto layout bugs.
  • Fixed bug recently opened not was updated.

Build 75 - Improved support foreign keys

Release date: 11 Dec 2017

  • Support navigate to a referenced table by multiple foreign keys
  • Improved detect statement under the cursor.
  • Allow selecting multiple items on the left panel.
  • Changed default table content column width.
  • Perfect pixels fixes.
  • Supported uglify SQL Query.
  • Auto-suggestion for schema name.
  • TablePlus now will confirm you before exit if there are uncommitted changes.
  • Supported add/delete foreign key in the table structure.
  • Fixed bug auto-suggestion in MS SQL.
  • Fixed crash bug renders in the background.
  • Fixed bug indent SQL by right click menu.
  • Fixed bug show wrong error location.
  • Performance improved.

Build 74 - Improvements

Release date: 3 Dec 2017

Changelogs:

  • Supported edit row in SQL Query Result: issue 120.
  • Added auto-suggestion in database filter: issue 122.
  • Fixed theme issues: issue 121.
  • Supported plugin feature, you can write a plugin with pure Javascript: Example OpenURL plugin.
  • The number of rows returned now unique per connection.
  • Tab name now has two fonts: italic (tab can be replaced when open new item) and normal font. This behaviour is similar to Sublime Text.
  • Added a yellow popup when close braces/brackets/parentheses in SQL Query.
  • Added support auto indent a new line in SQL Query: issue 123.
  • Added Redis driver, but still under development.
  • Fixed a crash bug when moving word boundary by a dot (hold option).
  • Fixed a bug SQL Query execute button was not enabled after execute statement contains only tabs.
  • General performance improved.

Build 73 - An awesome SQL Editor

Release date: 27 Nov 2017

Changelogs:

  • Supported detect identifiers in SQL Statement.
  • Supported suggest tables in the schema.
  • Supported suggest columns of table define by alias.
  • Press Esc to toggle auto-completion.
  • Unique recently opened items by connection+database pair 119.
  • Boundary word by dot when: option + move left/right, option + delete and double mouse click 118.
  • Tuning dark theme colors.
  • Show change logs in update popup.
  • No more crash since build 72 😎

Build 72 - Dark mode.

Release date: 22 Nov 2017

Changelogs:

  • Supported Full-dark mode
  • Added empty state for all screens
  • Show tab title at the end of the status bar
  • Support emoji in MySQL
  • Fixed all undo issues in SQL Query
  • Improved support bytea
  • Improved stability and performance

Build 71 - bug fixes.

Release date: 16 Nov 2017

Changelogs:

  • Fixed bug data do not show correctly when result contains fields with the same name.
  • Fixed crash bug on OSX 10.11.
  • Fixed bug does not show database listing when clicking on database button.

Build 70 - New features, bug fixes.

Release date: 15 Nov 2017

Changelogs:

  • Added split pane in SQL Query feature.
  • Added auto highlight query under the cursor.
  • Changed hotkey: Switch database cmd+shift+d.
  • Added hotkey: split pane cmd+d.
  • [MySQL] Fixed escape characters bug.
  • [PostgreSQL] Fixed bug can’t set now() as default value.
  • Improved general menu.
  • Fixed a lot of other bugs and stability improved.

Build 69 - New features, bug fixes.

Release date: 08 Nov 2017

Changelogs:

  • Added support materialized view.
  • Added support byte data type.
  • Fixed random crash when rendering data cell <- important update.
  • Improved performance and stability.

Build 68 - Improvements, bug fixes.

Release date: 04 Nov 2017

Changelogs:

  • Search part of the word (Fuzzy matching + recently matching): SQL Query, Open Anything.
  • Fixed bug lost all connections. <- very important
  • Fixed bug ordering in history tab (if the ordering is still wrong, please clear the history).
  • Fixed layout issue on OS X 10.13.
  • Performance and Stability Improvement. <- very important

Build 67 - New features, bug fixes.

Release date: 28 Oct 2017

Changelogs:

Features:

  • Group history by date
  • Added new loading background and new workspace background
  • Updated PostgreSQL 10 driver, MySQL 5.7.20 and SQLite 3.21.0
  • Added autosuggestion table field name in SQL Query
  • Not allowed opening table when it’s being created.

Bugfixes:

  • Fixed bug export result
  • Fixed bug can not re-order connection group
  • Fixed bug random crash when app becomes active
  • Fixed bug re-connect twice while switching database
  • Fixed bug edit colors are not affected in alternating view mode
  • Fixed bug insert rows by CSV with JSON field
  • Fixed bug undo not work correctly in SQL Query

Build 66 - New features, bug fixes.

Release date: 18 Oct 2017

Note: please re-login in this update.

Changelogs:

  • Added table history.
  • Added warning level in safe mode.
  • Added export table progress indicator.
  • Allow switch tab by command + number while editing SQL Query.
  • [PostgreSQL] Fixed memory leak when export table.
  • Fixed bug delete key stop working in SQL Query.
  • Fixed bug conflict keychain with Pocket App.
  • Fixed bug require 2 clicks in the right sidebar.
  • Fixed bug not reset sidebar after delete row.

Build 65 - Bugs fixes

Release date: 08 Oct 2017

Changelogs:

  • Fixed bug welcome screen/workspace screen does not always remember size.
  • Fixed bug crash when close workspace.
  • Fixed bug memory leak when close SQL Editor/SQL Viewer.
  • Autofocus TextView when open SQL Query.
  • Fixed bug case sensitive in auto-completion popup.

Build 64 - Auto completion

Release date: 04 Oct 2017

Changelogs:

  • Added autocomplete feature.
  • Support delete row by delete button on full layout keyboard.
  • [PostgreSQL] Fixed bug report wrong error position in SQL Query.
  • Fixed bug does not reload row detail after commit data.
  • General performance improvements.

Build 63 - Favorite and History

Release date: 26 Sep 2017

Changelogs:

  • Added status bar for SQL Editor: line, column, position.
  • Added History and Favorite.
  • Added shortcut key for resizing text size in SQL Query: command - and command +.
  • Added feature return on error when executing multiple queries.
  • Limit 100 result tabs to prevent crash when using split results feature.
  • Split queries now faster 1000 times.
  • Bold font for table header view.
  • Increase height of tab size.
  • Many bugs were fixed and general performance improvements.

Build 62 - Improvements

Release date: 17 Sep 2017

Changelogs:

  • Added Outline View on Welcome Screen: group connection.
  • Added support import CSV.
  • TablePlus will show progress when executing queries in SQL Query.
  • SQL Query now can load large queries (up to 50 millions characters due to Apple limit).
  • Temporary disable highlight syntax when SQL Query has more than 20000 characters. (The limit will be removed in the future).
  • Temporary disable autosuggestion. (will be replaced with a better popup).
  • Added SQLite document type: now you can double click on SQLite file to open.
  • Changed font of Ruler in SQL Query to Mono Space font.
  • Correct parsing syntax for characters: # and \.
  • Fixed bug wrong format when import/export data.
  • Fixed bug can’t drop the current database.
  • Fixed crash application when executing query with big text.
  • Fixed crash application when beautifying a query.

Build 61

Release date: 7 Sep 2017

Changelogs:

  • Press Space to toggle selected Row Detail.
  • Supported open SQL Query in Open Anything window.
  • Added shortcut key: command + ecommand + return to open SQL Query.
  • Added feature: middle mouse click on SQL Query icon to open new SQL Query tab.
  • Update layout: move table view setting to preferences, new icon set.
  • [SQL Server] Support query with Binary type.
  • [SQL Server] Handle update/delete row of a table without primary key.
  • Redesign status bar: Mono Space Font + Cancel query.
  • Added feature open Quick Look by middle mouse.
  • Auto-reconnect when the connection failed.
  • [PostgreSQL] Added support connect without a password.
  • [MySQL] Added support connect via socket.
  • Added SQLite Driver.
  • Fixed layout bug in feedback box.
  • Fixed MySQL performance issues.
  • Bug fixes and performance improvements

Build 60

Release date: 29 Aug 2017

Changelogs:

  • Added link to tables by foreign keys.
  • Added feature switch tabs with command + numbers.
  • Added new shortcut key execute statements command + return
  • Added new shortcut key execute selected statements command + shift + return
  • Added menu copy/paste rows in table data. Copy/paste rows to create a new row.
  • Added menu copy cell.
  • Support main menu: copy, paste, cut, delete rows.
  • Changed shortcut key switch tab command + arrows => command + [ or ]
  • Increased default size of column date time.
  • Fixed bug crash when query return error.
  • Fixed bug cannot save server port.
  • Fixed bug cannot set the value of new column/index. And many other bugs were fixed.

Build 59

Release date: 24 Aug 2017

Changelogs:

  • Added recovery password function.
  • Added Query Progress Bar.
  • Added menu copy/paste in SQL Query Editor.
  • Added menu copy row as CSV/JSON in SQL Query result.
  • Auto disable buttons next/previous on paging section.
  • Added “local” environment in connection tag.
  • Added result suggestion in Open Anything Popup.
  • Supports switch database in Open Anything Popup.
  • Supports copy multi rows in table/query result.
  • Redesign export data UI.
  • Fixed glitch when open SQL Query.
  • Fixed crash when close SQL Query.
  • Fixed syntax error when truncating MySQL tables.
  • Fixed bug query filter.

And many other bugs were fixed.

Build 58 - Improvements

Release date: 12 Aug 2017

Changelogs:

  • Fixed bug crash when generate alter table statements.
  • Fixed bug can’t select public schema in an empty database.
  • Fixed bug case sensitive when search table and column name in left and right sider bars.
  • Fixed bug can’t connect to a database over ssh in some case.
  • Added error popup in create connection screen.
  • Added support Microsoft SQL Server.
  • Added feature close tab by middle mouse on tab view.
  • Added feature open tab by middle mouse on the left-sider bar.
  • Added support run selected statement in SQL Query: command + shift + E.

Build 57 [HotFix]

Release date: 1 Aug 2017

Changelogs:

  • Fixed: value not set when inserting new row data.
  • Improved: UI in SQL Query.
  • Official release MySQL.

Build 56 [Big update]

Release date: 31 Jul 2017

Changelogs:

New Features:

  • Plugin: TablePlus now supports plugins, you can write your plugin with JavaScript.
  • Added: query execution time.
  • Added: close tab by middle mouse button.
  • Added: gesture close left/right sidebar by moving the mouse.
  • Redesign: structure/index tab.
  • Redesign: database listing dropdown.
  • Added: sound when locking database.
  • Added: sort database listing by alphabet.
  • Added: setting to show scrollbar in SQL Query.
  • Remove reload/log buttons.

Bug fixes:

  • Fixed: crash when getting database listing.
  • Fixed: empty statement in preview SQL.
  • Fixed: crash when indent very large input text.
  • Show warning when trying to drop the current database.
  • Improved performance and stability.

Build 55

Release date: 19 Jul 2017

Changelogs:

  • Add support export JSON, copy as JSON
  • Add support document type, now you can open tableplus from a file with SQL extension
  • Using default browser instead of Safari when opening a web link
  • Improved open anything: add placeholder
  • Many other bugs fixed, improved performance and stability

This is the latest release before big update, stay tuned 😁

Build 54

Release date: 14 Jul 2017

Changelogs:

  • Fixed bug memory leak in SSH Framework
  • Fixed crash when getting list of databases
  • Fixed bug create table
  • Improved create type statement Format
  • Improved open anything: cmd + p
  • Many other bugs fixed, improved performance and stability

Build 53

Release date: 12 Jul 2017

Changelogs:

  • Supported switch schema
  • Supported open anything: cmd + p
  • Many bugs fixed, improved performance and stability

Build 51

Release date: 10 Jul 2017

Changelogs:

  • Fixed bug undo/redo when closing tab
  • Improved performance and stability

Build 50

Release date: 8 Jul 2017

Changelogs:

  • Support undo/redo when rename/change primary key
  • Fixed bugs crash on OS X El Capitan
  • Fixed bug order column
  • [MySQL] Fixed bug does not show the error message
  • Improved performance and stability

Build 49

Release date: 5 Jul 2017

Changelogs:

  • Fully support undo/redo when editing database, structure, indexes
  • Many bugs fixed, improved performance and stability

Build 48

Release date: 3 Jul 2017

Changelogs:

  • [MySQL] Supported change ordinal position
  • [MySQL] Supported ENUM data type
  • Add Quick Look feature on right-click menu on Row Data
  • TablePlus is following Apple Sandbox
  • Bugs fixed, improved performance and stability

Build 47

Release date: 1 Jul 2017

Changelogs:

  • Supported TLS
  • Supported open views in the database
  • Bugs fixed, improved performance and stability

Build 46

Release date: 28 Jun 2017

Changelogs:

  • Changed database icons
  • Added support config multi lines and change the font size
  • Supported self-update
  • Improved performance and stability

Build 45

Release date: 24 Jun 2017

Changelogs: