Postico App Icon Postico 2

Changelog

Build 9123
Download
Fixed crash when importing Postico 1.5 favorites on macOS 12
Build 9113
Download
Remove offline help
Build 9112
Download
Add preference for update channel
Fix crash when dragging second library on Postico window
Build 9106
Download
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
Build 9088
Download
Add button to reveal / export SSH keys and SSL certs
Build 9085
Download
Replace deprecated method setNeedsDisplay with needsDisplay=YES
Replace deprecated method graphicsPort with new API
Build 9069
Download
Remove dead code
Support for filenames containing slashes
Build 9067
Download
Removed "Import Servers From Postico 1.x" menu item since Postico 2 does that automatically
Build 9066
Download
Connection URL improvements
Fix compiler warnings
Updated Xcode version to 13
Fixed a crash when removing server connections on computers without trash directory
Build 9022
Download
Fixed occasional crash when deleting unsaved queries
Change effective display name for local library
Build 9013
Download
Fixes and UX improvements for import of Favorites/Servers
Build 9005
Download
Allow hiding table columns via context menu
Fixed restoration of column order & sort options
Build 8993
Download
Add hidden setting for default action when double clicking servers
Build 8975
Download
Remove TableInfoMetadata
Build 8974
Download
SQL Formatter uses ~/.pg_format configuration
Build 8957
Download
Fixed a crash when dragging files of unknown type on a Postico window
Build 8955
Download
Toggle line comment without selection works again
Build 8951
Download
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
Build 8941
Download
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
Build 8917
Download
Add tabs at the end
Automatically scroll to current query file in sidebar
Support for EXCLUDE constraints in DDL view
Build 8893
Download
Improve performance of syntax highlighting
Fixed a crash when retrieving catalog information
Fixed CSV importer crash
Build 8866
Download
SQLKeywordList: reduce allocations
Sidebar remembers splitter position
Autocomplete: don’t cancel autocomplete if parser is not ready yet
Build 8836
Download
Function structure editor support for BEGIN ATOMIC
Build 8831
Download
Improve statement grouping logic and add support for BEGIN ATOMIC
Build 8818
Download
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
Build 8779
Download
Reduced trace logging performance overhead
Build 8728
Download
Connection URL fixes
Fixed crash when sending feedback
SQLParser: Remove string provider
Build 8716
Download
SQLToken: Remove SQLParser dependency
Build 8696
Download
Query editor performance improvements
Performance improvements for table/function source lists
Build 8693
Download
Restore only existing queries, only tables/functions of main database
Build 8690
Download
Restore Navigation View type
PGELicenseManager: use dispatch_once for safety
TraceLog: added missing enum cases
Build 8670
Download
Add a button to show saved passwords
Build 8666
Download
Don't save temporary queries for Server/Favorite-level restoration
Use Table View font for JSON Viewer
Fix occasional Sparkle hangs
TextBasedTableExporter test improvements
Build 8645
Download
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
Build 8635
Download
Make Postico store the first launch date of each build
Build 8619
Download
Fixed a regression in Redshift when fetching view column information
Build 8614
Download
JSON Viewer Improvements
Fixed a bug where CMD+Backspace did not delete line in Query Editor
Build 8602
Download
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
Build 8591
Download
Fixed crash when expanding/collapsing items in the sidebar
Fixed crash when double clicking outside of rows in query result table
Build 8573
Download
Add support for generated columns
Build 8549
Download
Show error message instead of crashing when column info can not be loaded
Build 8547
Download
Fixed second crash when connecting to server
Fixed crash when connecting to server
Limit length of error messages
Build 8529
Download
Add Popover for viewing JSON and JSONB values
Build 8528
Download
Fixed: Tables with FLOAT4 columns could not be updated without primary key
Sidebar navigation state persistence
Fixed: Saving untitled queries did leak duplicates
Build 8523
Download
Improved diagnostics for occasional catalog cache crash
Build 8517
Download
Fixed an issue where radio buttons of the Vacuum dialog appeared invisible
Greenplum v6 support
Fixed data race crash in PGEColumn.isGeometry
Build 8514
Download
Unit Test runtime improvements
Build 8470
Download
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
Build 8414
Download
Don't prevent closing window when deleting temp query fails
Fix nullability
Relative file browser item
Build 8390
Download
Restore sidebar expansion state when restoring windows
Remove unused serialNumber property
Build 8384
Download
SQLFormatter: explicitly use system Perl
Build 8375
Download
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
Build 8325
Download
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
Build 8304
Download
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"
Build 8315
Download
Fixed SQL formatting in case of CREATE prefix or DROP suffix
Build 8282
Download
Update buy link
Build 8280
Download
Autocomplete: Use full width outline view style
Change App Icon to a Squircle
Fix type so it builds on Xcode 13
Build 8272
Download
Add command to resize window for screenshot
Build 8269
Download
Fixed crash when using autocomplete with array function default arguments
Catalog: Throw exception instead of crash when parsing function arg defaults
Build 8263
Download
Fixed sorting of negative MONEY numbers
Build 8259
Download
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
Build 8194
Download
Fix tests broken due to missing JSON support of PG8.2
Build 8183
Download
Fixed UUID filter type for right click column filtering
Fix sorting columns of type "money" in query results
Build 8127
Download
JSON export uses the new parser/printer
Pretty print JSONB in the right sidebar
Build 8062
Download
Use pretty print for func arg defaults
Reversed order of tab names
Build 8060
Download
Workaround for "bogus varno" bug
Build 8052
Download
Fixed Xcode 12.5 warnings
Build 8038
Download
Improved export: More CSV settings and JSON
Build 8031
Download
NumericNumber Improvements
Remove unused localisations
Build 7994
Download
Query editor performance improvements part 1
Build 7975
Download
Library Changes part1
Build 7973
Download
Query history search
Build 7952
Download
Fix NumericNumber formatting bug
Build 7901
Download
Sidebar context menu now offers opening items in new tab and new window
FileSystemMonitor: fixed crash in callback after stopping
Build 7887
Download
Licensing
Build 7884
Download
Fixed: Precision loss with large numeric values
Build 7866
Download
Tooltips for toolbar and buttons
Escape no longer discards changes in SQL text fields
Build 7825
Download
Table DDL now displays INSTEAD OF triggers correctly
Build 7823
Download
Updated copyright range for 2021
Bugfix for autocomplete with Redshift external tables
Replace os_log Obj-C Logging with TraceLog
Build 7800
Download
Redshift: Add support for late binding views
Fixed: "New Schema" command was disabled in function browser sidebar
Build 7721
Download
Preference Icons
Build 7681
Download
Fixed crash when opening files when sidebar is closed
Fix error message for notNilOrDie
Build 7659
Download
File system monitor improvements
Avoid exception annoying during debugging
Build 7625
Download
Fixed: Redshift MATERIALIZED VIEWs not be opened in structure view
Build 7612
Download
Fixed restoration of query documents within external root
Build 7607
Download
Adopt macOS 11 system sounds for drag and drop / move to trash
Fix table view & outline view styles on Big Sur
Build 7594
Download
Query history datasource lifetime now coupled to popover
Fixed crash in GenericPasswordKeychainItem
Disable crash/hang reporter when launched from Xcode
Build 7578
Download
Fixed: Query history item titles display file names instead of formatted time
Build 7577
Download
Query history performance improvement
Build 7573
Download
Upgrade pgFormatter
Added table filter comparison operator "is not empty string" for text columns
Build 7568
Download
Fixed query error when using table filters with boolean column
Build 7556
Download
Removed accidentally commited code
DDL support for triggers
Fixed crash when navigating to sidebar filter without left sidebar
Build 7543
Download
Allow horizontal scrolling in table structure view
Fix test case
Fixed file system path checks for ancestor/descendent
Build 7512
Download
CSV Import: support scientific exponential notation
Fixed crash caused by StatusDisplay drawing code
Build 7503
Download
Fixed: DDL could not be displayed for a table with constraint triggers
Fixed a bug where the incorrect foreign key column was shown
Build 7496
Download
Check for disconnects while attempting connection
Build 7494
Download
Fixed a bug where external references could not be added in case of another broken reference
Error message improvements when opening invalid URLs
Build 7487
Download
Fix crash when trying to open a non-existing file
Build 7484
Download
Improved Crash Reporter
Build 7466
Download
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
Build 7442
Download
Query result sorting fixes
Build 7425
Download
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
Build 7360
Download
Fix duplicate query create bug
SQL Text Editor fixes for files exceeding limit
Build 7343
Download
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
Build 7320
Download
Status Display Fixes
Fix additional file descriptor leaks
Build 7311
Download
Fix a file descriptor leak
Build 7310
Download
Fix graphical glitches in the sidebar
Remove SQL Query from Breadcrumb button
SSH Host Key Verification Dialog
Build 7302
Download
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
Build 7256
Download
Show dialog for missing / incorrect password
Build 7234
Download
Fixed a bug where Postico did not include schema name when editing functions
CatalogCache partial invalidation
Build 7213
Download
Add support for libraries with encrypted passwords
Build 7206
Download
Fix Redshift external tables
Switch to Xcode 12
Build 7185
Download
Edit and create functions / procedures
Build 7183
Download
Fixed Xcode 12 warnings
Fix reload and reload current view commands
Build 7173
Download
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
Build 7161
Download
Fix truncate width for UUIDs in Query View
Table Views: Fixed autosizing for enum/bool types
Build 7148
Download
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
Build 6982
Download
Fixed restoration of servers with same UUID in different stores
Build 6980
Download
Fixed: Structure edits cause reinsertion into wrong sidebar section
Fixed: Sidebar item is not reselected after structural edit
Build 6969
Download
Fixed: Update checking caused endless spinning wheel
Build 6918
Download
Allow top level object to have type "library"
Fixed test cases
Improve file name scheme for duplicates
Build 6911
Download
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
Build 6892
Download
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
Build 6838
Download
Convenience method for abbreviated path
Query File Size Limit
Build 6824
Download
Cherrypicked bugfixes from Postico 1.5.14
Query history item text normalization
Fixed Query history order
Build 6785
Download
Big Sur Design Fixes
Bookmark error handling
Build 6784
Download
CSV import via drop
Faster loading of favorites that contain many files
Build 6756
Download
Open SQL files without connecting to a server
PR #1191 Fix build on Xcode 12
Build 6694
Download
Drop query files on window to open
Build 6674
Download
Crash reporter improvements
Fixed Retain Cycle
Build 6665
Download
Hang detection
Build 6624
Download
File browser plays drop sound
Add --function-case 1 argument to pg_format
Build 6611
Download
Bugfix: Saving Table Filters did not work
Bugfix: Custom SQL Filter crashed
Build 6607
Download
Fix Tests and warnings
File format forward compatibility
Show dialog when adding SQL files
Play user interface sounds on the system sounds device
Build 6573
Download
PR: File browser drag and drop
Fixed an issue where opening external queries in place did not work
Build 6566
Download
Cockroach support for SAVEPOINTs
Build 6529
Download
Fix delete query for procedures https://github.com/jakob/Postico/issues/707
Build 6528
Download
File Browser: Network move to trash fix
Build 6506
Download
Fixed crash when indexColumnExpressions contains NULL
Update OpenSSL to 1.1.1g
Build 6492
Download
Fixed crash when editing enum cells while previous update query was still running
Build 6472
Download
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
Build 6457
Download
Fix race condition in file browser
Build 6450
Download
Add support for startup query
Increase timeout for CSV import tests
Refactor FavoriteViewController
Build 6441
Download
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
Build 6401
Download
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
Build 6358
Download
Restored shortcut CMD+SHIFT+T to go to queries
Bugfix: Crash when attempting to format empty SQL statement
Fixed typo: 'DropBox' -> 'Dropbox'
Build 6355
Download
Added shortcut: CMD+F shows table filter
Build 6354
Download
Time display in Query View
Build 6342
Download
Bugfix: Import Favorite did not refresh favorites list
Duplicated favorites now have suffix ‚ copy‘
Build 6339
Download
More convenient runtime assertions
Restored CMD-ENTER use case
Build 6324
Download
Main menu validation fixes
Redesign Sidebar Tabs
Build 6313
Download
SQL File Browser: Import/Open query files
Bugfix: „New Folder“ did not work if „Untitled Folder“ was already present
Build 6282
Download
Query history
Build 6260
Download
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
Build 6194
Download
Build 6168
Download
Refactored file system code
Fixed crash when test connection command fails
Bugfix: Fixed crash related to custom SQL filters
Build 6145
Download
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
Build 6126
Download
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
Build 6105
Download
Keyboard Navigation in Favorites List
Build 6076
Download
Bugfix: crash in SQLTextView.selectedTextAttributes
Build 6064
Download
Improved SQL Parser and added Query Formatting
Build 6038
Download
Bugfix: keyword-like identifiers were not quoted in DDL
Build 5998
Download
Require Activation
Syntax highlighting fixes & performance improvements
QuickLook for images in right sidebar
Build 5955
Download
Feedback: Disable screenshot by default
OpenSSL 1.1.1d, libpq 10.11, newer version of libssh2
Build 5927
Download
Build 5920
Download
Build 5835
Download
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
Build 5820
Download
User Preferences for Syntax Highlighting Themes
Build 5779
Download
Fix test failures caused by too small timeout
New tabs clone state
Fixed preferences window restoration when using mutliple versions of Postico
Build 5754
Download
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
Build 5705
Download
Improved File System Monitoring (Query Sidebar)
Table filter can be extracted as view
Build 5696
Download
Fixed a bug with file path normalisation
Refresh query sidebar when favorite is moved to a different folder
Build 5678
Download
Build 5666
Download
Build 5657
Download
Postico no longer changes file names when moving favorites (and handles file name collisions better)
Build 5632
Download
Don't overwrite query files after an error
Build 5631
Download
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)
Build 5618
Download
We now distribute a DMG instead of a ZIP to avoid issues with automatic updates
Build 5601
Download
Small design tweaks in the "Update" preference pane
Build 5596
Download
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
Build 5540
Download
Fixed: Postico now autosaves queries when you press ⌘Q
Build 5529
Download