Changelog

Fix a bug when creating temp tables on CockroachDB (currently an experimental feature)

Update bundled library versions: libpq to 14.4, OpenSSL to 1.1.1q This adds support for SNI which improves compatibility with cloud services like Neon.

SSH tunnels now support rsa-sha2-256 and rsa-sha2-512 authentication. This fixes the error message "The SSH server rejected the private key"

Fix a bug where the red strike-through line was not shown when deleting a NOT NULL or PRIMARY constraint

Fixed a potential crash in the SQL parser

Add an additional method for automatic license deployment Postico now checks the paths ~/.postico-license and /Library/Application Support/Postico/license-key.txt for a license key

Fixed a problem where Postico could not save passwords in the keychain

Add support for automatic license deployment (see documentation for license activation)

Fix blurry toolbar icons on Retina Displays

Fixed a hang when loading tables with large amounts of jsonb data

Fix bug in Function Editor on PostgreSQL 14 or newer

Update recommended warnings

Fix Xcode 13.3 build error

Fix Xcode 13.3 warning

Fixed a bug where Postico showed an error message after truncating multiple tables

Fixed a regression in build 9376 where Postico crashed when dragging files on the sidebar

Fixed a regression in build 9332 where Postico crashed after creating a new database, refreshing a materialized view, reindexing, truncating or vaccuuming a table.

Fix regression: Update sidebar after changing database

Copy as Markdown support

Middle click opens item in new tab

Customizable tab layout in left sidebar

Fix an issue where the feedback button transmitted an outdated configuration

Add support for importing encrypted Postico 1.x favorites

Fixed crash in library preferences

Fix a rare crash when resizing the window

Fixed loading table filter files

Fixed a bug where saving a temp table can lead to a broken UI state

Fixed crash when creating new tab in readonly libraries

Fixed crash when reloading connection

Fixed a regression where table structure reload did not work

Fixed a regression where sidebar items appeared blurred

Use Python 3 instead of Python 2 in build script

Updated copyright range for 2022

Fixed crash when opening new tab from new table/function screen

Fixed a bug where the table filter button did not hide the filter view

Adress an issue where Postico failed to open previously open queries and showed a permission error instead

Autocomplete now also searches in "pg_temp" alias

Remove dead code

CSV Importer: Fixed rare crash

Fixed a bug where clicking the reload button in the sidebar did not work

Fix rare crash when source table of view was changed

Automatically Expand Query Search Results in the Sidebar

SQL preview popup supports find via CMD+F

JSON popup supports find via CMD+F

Fixed: Table Filter generated SQL contained extranous % symbol

Font Preferences for Left Sidebar

Add button "New Server from URL…"

Add support for connection parameter 'options'

Fix Preferences layout issue

Cockroach v21.2 support

Configure deployed archive type DMG (Postico 2 Devel)

TableMetadataPromise: more helpful assertions

Font Preferences

Remove dead code

Fix Line Numbers on macOS 12

Reduce padding in left sidebar

Fix layout glitches with RTL text

Call `scrollRangeToVisible` only after explicit user action

Auto-Uppercase SQL keywords

Add design files to repo

Fixed crash when importing Postico 1.5 favorites on macOS 12

Remove offline help

Add preference for update channel

Fix crash when dragging second library on Postico window

Workaround for macOS Monterey bug where Help > Report a Bug captures broken screenshots

Remove deprecated pasteboard type NSPasteboard.PasteboardType.filePromise

Add "Jump To Line" command

Add button to reveal / export SSH keys and SSL certs

Replace deprecated method setNeedsDisplay with needsDisplay=YES

Replace deprecated method graphicsPort with new API

Remove dead code

Support for filenames containing slashes

Removed "Import Servers From Postico 1.x" menu item since Postico 2 does that automatically

Connection URL improvements

Fix compiler warnings

Updated Xcode version to 13

Fixed a crash when removing server connections on computers without trash directory

Fixed occasional crash when deleting unsaved queries

Change effective display name for local library

Fixes and UX improvements for import of Favorites/Servers

Allow hiding table columns via context menu

Fixed restoration of column order & sort options

Add hidden setting for default action when double clicking servers

Remove TableInfoMetadata

SQL Formatter uses ~/.pg_format configuration

Fixed a crash when dragging files of unknown type on a Postico window

Toggle line comment without selection works again

Fix crash when double clicking rows without columns

Catalog: lock during cache update, but not result preparation

Fixed a crash when opening connection URLs while connected window has pending changes

Fix test cases on Redshift

Table View: Don’t start text field editor for popup cells

Check if data cell is of correct type when reusing table columns

Add tabs at the end

Automatically scroll to current query file in sidebar

Support for EXCLUDE constraints in DDL view

Improve performance of syntax highlighting

Fixed a crash when retrieving catalog information

Fixed CSV importer crash

SQLKeywordList: reduce allocations

Sidebar remembers splitter position

Autocomplete: don’t cancel autocomplete if parser is not ready yet

Function structure editor support for BEGIN ATOMIC

Improve statement grouping logic and add support for BEGIN ATOMIC

Disable hang detector

Add default Query to Servers created via Connection URL

Syntax highlighting and autocomplete for dollar quoted strings

SQLKeywordList: updated keywords for PG13 and PG14

Reduced trace logging performance overhead

Connection URL fixes

Fixed crash when sending feedback

SQLParser: Remove string provider

SQLToken: Remove SQLParser dependency

Query editor performance improvements

Performance improvements for table/function source lists

Restore only existing queries, only tables/functions of main database

Restore Navigation View type

PGELicenseManager: use dispatch_once for safety

TraceLog: added missing enum cases

Add a button to show saved passwords

Don't save temporary queries for Server/Favorite-level restoration

Use Table View font for JSON Viewer

Fix occasional Sparkle hangs

TextBasedTableExporter test improvements

Fixed a crash when literal strings contain null bytes

Fixed a crash when quickly re-triggering autocomplete

Fixed race condition when parsing SQL

Fixes for clipped toolbar items

JSON Viewer: treat whitespace as empty

Make Postico store the first launch date of each build

Fixed a regression in Redshift when fetching view column information

JSON Viewer Improvements

Fixed a bug where CMD+Backspace did not delete line in Query Editor

Query Table Results: Fixed a regression where double clicking non-JSON cells no longer selected text

Fixed: Crash when renaming a color theme and deleting it

Generated columns: report an error when attempting to alter virtual stored columns

Fixed crash when expanding/collapsing items in the sidebar

Fixed crash when double clicking outside of rows in query result table

Add support for generated columns

Show error message instead of crashing when column info can not be loaded

Fixed second crash when connecting to server

Fixed crash when connecting to server

Limit length of error messages

Add Popover for viewing JSON and JSONB values

Fixed: Tables with FLOAT4 columns could not be updated without primary key

Sidebar navigation state persistence

Fixed: Saving untitled queries did leak duplicates

Improved diagnostics for occasional catalog cache crash

Fixed an issue where radio buttons of the Vacuum dialog appeared invisible

Greenplum v6 support

Fixed data race crash in PGEColumn.isGeometry

Unit Test runtime improvements

TestConnectionPool: Allow plain text connection also in other initializer

Fixed Crash in WindowController.unregisterAllFileSystemMonitorObservers

Ignore UTF-8 BOM during CSV import

Greenplum 6.8 support

Fixed an issue where files disappeared from the sidbar after saving

Accept non-SSL database connections while testing

PGEConnection: Stricter error checking

Fixed crash due to explicit cast to NSSavePanel

Don't prevent closing window when deleting temp query fails

Fix nullability

Relative file browser item

Restore sidebar expansion state when restoring windows

Remove unused serialNumber property

SQLFormatter: explicitly use system Perl

Remember size of query result area

Fixed: Theme Preference buttons were invisible on Big Sur

Separate buttons for reloading sidebar

Fixed: Query sidebar reload occasionally lost root elements

Discard changes in text fields by pressing Escape key

Fixed a bug where changes to connection settings were discarded when switching to another app

Only show connection status display badge when properly connected

Fixed potential race condition in Status Display

Test case fixes for Cockroach

Add libraries by drag and drop

Fix right sidebar layout bug

Library Preferences: Fixed layout constraint for default button

Remove dark gray border from 16px app icon

Rename "Execute Query" menu item to "Execute Statement"

Fixed SQL formatting in case of CREATE prefix or DROP suffix

Update buy link

Autocomplete: Use full width outline view style

Change App Icon to a Squircle

Fix type so it builds on Xcode 13

Add command to resize window for screenshot

Fixed crash when using autocomplete with array function default arguments

Catalog: Throw exception instead of crash when parsing function arg defaults

Fixed sorting of negative MONEY numbers

Fixed a crash when editing NUMERIC values in the sidebar

Do not quote function default arguments

CSV quoting fix

Shorter debug description of PGError

Double click on left sidebar toggles expansion state

Fixed JSON test cases

Add Button to Show Error Details

JSON Values: Fixes for Copy Special as SQL insert statements

Fix tests broken due to missing JSON support of PG8.2

Fixed UUID filter type for right click column filtering

Fix sorting columns of type "money" in query results

JSON export uses the new parser/printer

Pretty print JSONB in the right sidebar

Use pretty print for func arg defaults

Reversed order of tab names

Workaround for "bogus varno" bug

Fixed Xcode 12.5 warnings

Improved export: More CSV settings and JSON

NumericNumber Improvements

Remove unused localisations

Query editor performance improvements part 1

Library Changes part1

Query history search

Fix NumericNumber formatting bug

Sidebar context menu now offers opening items in new tab and new window

FileSystemMonitor: fixed crash in callback after stopping

Licensing

Fixed: Precision loss with large numeric values

Tooltips for toolbar and buttons

Escape no longer discards changes in SQL text fields

Table DDL now displays INSTEAD OF triggers correctly

Updated copyright range for 2021

Bugfix for autocomplete with Redshift external tables

Replace os_log Obj-C Logging with TraceLog

Redshift: Add support for late binding views

Fixed: "New Schema" command was disabled in function browser sidebar

Preference Icons

Fixed crash when opening files when sidebar is closed

Fix error message for notNilOrDie

File system monitor improvements

Avoid exception annoying during debugging

Fixed: Redshift MATERIALIZED VIEWs not be opened in structure view

Fixed restoration of query documents within external root

Adopt macOS 11 system sounds for drag and drop / move to trash

Fix table view & outline view styles on Big Sur

Query history datasource lifetime now coupled to popover

Fixed crash in GenericPasswordKeychainItem

Disable crash/hang reporter when launched from Xcode

Fixed: Query history item titles display file names instead of formatted time

Query history performance improvement

Upgrade pgFormatter

Added table filter comparison operator "is not empty string" for text columns

Fixed query error when using table filters with boolean column

Removed accidentally commited code

DDL support for triggers

Fixed crash when navigating to sidebar filter without left sidebar

Allow horizontal scrolling in table structure view

Fix test case

Fixed file system path checks for ancestor/descendent

CSV Import: support scientific exponential notation

Fixed crash caused by StatusDisplay drawing code

Fixed: DDL could not be displayed for a table with constraint triggers

Fixed a bug where the incorrect foreign key column was shown

Check for disconnects while attempting connection

Fixed a bug where external references could not be added in case of another broken reference

Error message improvements when opening invalid URLs

Fix crash when trying to open a non-existing file

Improved Crash Reporter

Fixed crash when attempting to connect while connection should disconnect

Fixed look of push buttons and segmented controls for Big SurFixed look of push buttons and segmented controls for Big Sur (Postico 2)

Fixed test cases

Fix drawing bug on macOS 10.15

Function Structure Editor: return type handling fixes

Query result sorting fixes

Fixed crash when trying to remove erroneous external references

Breadcrumb Background Color Fix on Big Sur

Disable Hang Reporter when Postico is in the background

Fixed testcase to reflect Big Sur file system monitoring behaviour

Fixed a crash in Function Structure Editor in case of unsupported attributes

Fixed a crash when trying to create servers/folder in a library which is not yet loaded

Foreign key table popover fixes

Fixed crash when ejecting connection while renaming query

SQL Text Editor fixes for opening descendents of items already present in the sidebar

Universal build

P #1339 from eggerapps/big-sur-fix-breadcrumb Fixed breadcrumb toolbar button content size for Big Sur

Fixed table column constraint button layout for Big Sur

Fix duplicate query create bug

SQL Text Editor fixes for files exceeding limit

Workaround for Big Sur certificate bug

Fix Horizontal Scroller in Table Structure View

Fixed a bug where Postico does not create default "SQL Query.sql" file

SQLTextField theme color support

Fixed sort order of timestamp columns in query results

Status Display Fixes

Fix additional file descriptor leaks

Fix a file descriptor leak

Fix graphical glitches in the sidebar

Remove SQL Query from Breadcrumb button

SSH Host Key Verification Dialog

Disable auto-hiding scrollbars when scrollbars are set to "Always Visible" in System Preferences to avoid a beachball

Add support for syncing private keys in libraries with master password

Show dialog for missing / incorrect password

Fixed a bug where Postico did not include schema name when editing functions

CatalogCache partial invalidation

Add support for libraries with encrypted passwords

Fix Redshift external tables

Switch to Xcode 12

Edit and create functions / procedures

Fixed Xcode 12 warnings

Fix reload and reload current view commands

Added menu items to create new schema

Fixed crash when clicking query completion notification for ejected connections

Fixed crash when restoring text selection after file reload

Fix truncate width for UUIDs in Query View

Table Views: Fixed autosizing for enum/bool types

Make "New Folder" more discoverable

Show error message when Trash directory is not available

Fixed crash when reordering libraries in the Preferences via drag-and-drop

Fixed crash when dragging with left sidebar hidden

Rename "Remove Server" menu item to "Move Server to Trash"

Renamed 'Filter Favorites' to 'Filter Servers'

Remove "Reload" button from error message

SQL Text Fields tab width initialization

PGEQuery: Block based initializer for Swift

Fixed restoration of servers with same UUID in different stores

Fixed: Structure edits cause reinsertion into wrong sidebar section

Fixed: Sidebar item is not reselected after structural edit

Fixed: Update checking caused endless spinning wheel

Allow top level object to have type "library"

Fixed test cases

Improve file name scheme for duplicates

Server list menu validation fixes

Fixed crash when disconnecting while loading table in SSH connection

Make debugging with Swift error breakpoints less annoying

Error message is truncated if window height too small

Fixed crash when creating new windows without current server

Automatically create new file when opening tab

SQL Text Editor Window restores previous size

Connection favorites are now called servers

Nullability assertions for PGEWindowController

Fix memory leak after closing query files

Refactor SQLDocument.withWindowController

Fix sorting broken favorites

Convenience method for abbreviated path

Query File Size Limit

Cherrypicked bugfixes from Postico 1.5.14

Query history item text normalization

Fixed Query history order

Big Sur Design Fixes

Bookmark error handling

CSV import via drop

Faster loading of favorites that contain many files

Open SQL files without connecting to a server

PR #1191 Fix build on Xcode 12

Drop query files on window to open

Crash reporter improvements

Fixed Retain Cycle

Hang detection

File browser plays drop sound

Add --function-case 1 argument to pg_format

Bugfix: Saving Table Filters did not work

Bugfix: Custom SQL Filter crashed

Fix Tests and warnings

File format forward compatibility

Show dialog when adding SQL files

Play user interface sounds on the system sounds device

PR: File browser drag and drop

Fixed an issue where opening external queries in place did not work

Cockroach support for SAVEPOINTs

Fix delete query for procedures https://github.com/jakob/Postico/issues/707

File Browser: Network move to trash fix

Fixed crash when indexColumnExpressions contains NULL

Update OpenSSL to 1.1.1g

Fixed crash when editing enum cells while previous update query was still running

Fixed crash due to CSV import menu validation not called

Fixed crash when quickly duplicating and inserting rows

Improved assert on source list child index

Fix crash when favorites list is empy

Improve test timeout error message

Fix race condition in file browser

Add support for startup query

Increase timeout for CSV import tests

Refactor FavoriteViewController

Additional keyboard shortcuts

Copyright and website URL updated

Duplicate now ignores Query History, Queries, but copies DisplayOptions

Default keywords for syntax highlighting

Use weak instead on unowned NSTextView

Warn before sending anonymous feedback

Fixed a bug in file browser when files were deleted

More Keyboard shortcuts

Fixed restoration of Custom SQL table filters

Bugfix: DisplayOptions were not skipped on export

Right sidebar does not stay hidden

Bugfix: "Go to queries" did not work when left sidebar was never shown

Fixed a bug where the left sidebar reappeared unexpectedly

Add favorite + database name to window title

Restored shortcut CMD+SHIFT+T to go to queries

Bugfix: Crash when attempting to format empty SQL statement

Fixed typo: 'DropBox' -> 'Dropbox'

Added shortcut: CMD+F shows table filter

Time display in Query View

Bugfix: Import Favorite did not refresh favorites list

Duplicated favorites now have suffix ‚ copy‘

More convenient runtime assertions

Restored CMD-ENTER use case

Main menu validation fixes

Redesign Sidebar Tabs

SQL File Browser: Import/Open query files

Bugfix: „New Folder“ did not work if „Untitled Folder“ was already present

Query history

Upgrade libpq to 10.12, libssh2

Buttons no longer overlap SQL text

Fix a crash when quitting with unsaved changes

Ignore errors when autosaving

Fixed frequent hangs when working with large SQL files

Refactored file system code

Fixed crash when test connection command fails

Bugfix: Fixed crash related to custom SQL filters

Bugfix: Crash when clicking error icon

Bugfix: Crash in Table Structure View

Fix performance when you have many functions on the server

Bugfix: Incorrect invalidation of invalid parenthesis

Create View From Filter: Don’t add OFFSET or LIMIT clauses

SQL preview background color fix

Merge pull request #1033 from eggerapps/sidebar-filter-shortcut Re-enable "Filter ... in Sidebar" command

Keyboard Navigation in Favorites List

Bugfix: crash in SQLTextView.selectedTextAttributes

Improved SQL Parser and added Query Formatting

Bugfix: keyword-like identifiers were not quoted in DDL

Require Activation

Syntax highlighting fixes & performance improvements

QuickLook for images in right sidebar

Feedback: Disable screenshot by default

OpenSSL 1.1.1d, libpq 10.11, newer version of libssh2

Make left sidebar visible by default

Move favorites by default instead of copy when dragging between stores

Add feedback button to preferences window

Fixed crash due to Swift Optimizer ARC over-release

Fixed "Group By Extension" preference setting

User Preferences for Syntax Highlighting Themes

Fix test failures caused by too small timeout

New tabs clone state

Fixed preferences window restoration when using mutliple versions of Postico

Use FileSystemDatasource to monitor changes to SQL Files

Autosave changes before renaming file

Update database placeholder when username changes

Don't play user interface sounds when user disabled them

Table filter restoration

Highlight Matching Parenthesis in SQL Editor

Improved File System Monitoring (Query Sidebar)

Table filter can be extracted as view

Fixed a bug with file path normalisation

Refresh query sidebar when favorite is moved to a different folder

Postico no longer changes file names when moving favorites (and handles file name collisions better)

Don't overwrite query files after an error

Better handling of save query errors

Show a dialog when an update is available and the user disabled automatic updates (instead of a notification in notification center)

We now distribute a DMG instead of a ZIP to avoid issues with automatic updates

Small design tweaks in the "Update" preference pane

Fixed an issue were Postico did not detect changed query files when multiple files were moved in quick succession

Postico now restores opened query files again

Fixed a crash when a query completes while the window is in the background

Fixed an issue where Postico replaced query file contents with placeholder text

Improved changelog displayed in update dialog

Fixed: Postico now autosaves queries when you press ⌘Q