Changelog
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