Postico 1 5 103

Return to site

Postico 1 5 103

August 5, 2016
Postico 1 5 103 =
Postico 1 5 103 Resz
V103 102.7 FM Today's R&B and Throwbacks. Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike. App will look familiar to anyone who has used a Mac before. Just connect to a database and begin working with tables and views. Start with the basics and learn about advanced features of PostgreSQL as you go along. Postico is a native OS X app which is available through Mac App Store. The UI is fast, responsive and integrates seamlessly with the OS. Created by an experienced developer in the field. Postico is the successor of PG Commander, an older Mac Posgres GUI tool which is also widely used. They are both maintained by the same person. Windows PC에서 Postico 를 다운로드하여 설치하고 즐기십시오. 이 게시물에서 무료로 컴퓨터에 Postico 를 다운로드하고 설치할 수 있습니다. PC에서 Postico 를 사용하는이 방법은 Windows 7/8 / 8.1 / 10 및 모든 Mac OS에서 작동합니다.
Postico v1.0.9 Postico now automatically restores text in the SQL query editor #152
 Added 'Open Quickly…' command. Press ⌘P and type a part of a table name to show a list of matching tables, then press enter to navigate to the the matching table. #228
 Postico now supports tabs on macOS Sierra. Press ⌘T to open a new tab. #44
 You can now select PEM files for TLS client certificates #237
 Fixed an issue where Postico did not update the total number of rows after changing filter settings. #230
 Postico now uses a heuristic to decide whether to restore the filter in foreign key popovers #232
 Errors during loading of the structure view are now reported in more detail. 
 Fixed a problem where connection errors where displayed only partially. 
June 1, 2016
Postico v1.0.8 Fixed an issue that prevented Postico from updating Boolean columns. #227
May 31, 2016
Postico v1.0.7 Postico now supports using client certificates for authentication #218
 Postico now has basic support for CockroachDB #224
 Numbers with type NUMERIC(x,y) are now displayed with trailing zeros. #205
 Support for copy/pasting tables with cells that contain newlines #59
 Fixed a problem where Postico could hang when quickly clicking the next page button #220
 Fixed a problem with NULL values in the sidebar #219
 Clicking the column header now cancels the previous query, so you no longer have to wait until Postico has finished loading a table before you can change the sort order. If you accidentally clicked the header, you can now just click it again to deactivate sorting again. #221
 Postico now asks for confirmation before deleting favorites #210
 Error messages for loading tables are no longer modal #198
 Numbers in generated SQL are no longer quoted. 
 Bundled libpq updated to 9.5.3, OpenSSL updated to 1.0.2h 
April 12, 2016
Postico v1.0.6 Performance of column autosizing has been vastly improved, especially for tables with many columns. 
 Add support for the standard Find & Replace panel in the Query View. You can activate it by ⌘F. Unfortunately this means I've had to change the shortcut for filter rows to ⌥⌘F #53#165
 A small button in the status bar now shows whether the connection is encrypted or not. Clicking the button lets you validate details such as the SSH host key or TLS certificates sent by the server. 
 You can now delete rows by pressing backspace (as an alternative to Cmd-Backspace) 
 Added a 'Reload Current View Only' command ⌥⌘R 
 Added a list of keyboard shortcuts to the documentation 
 Fixed an issue where Postico would try to sort by inaccessible columns (eg. ctid) 
March 4, 2016
Postico v1.0.5 Postico now treats UUID columns as numeric when filtering #184
 Updated OpenSSL to version 1.0.2g. 
 Fixed a bug where text was sometimes truncated when changing row height to a single line. 
 Fixed problem when displaying error message. 
 psql commands are now highlighted in red (they are not supported) #145
Feb 25, 2016
Postico v1.0.4Table view: Added preferences for font size, number of lines per row, alternating row background color #26#38
 Postico now adjusts column widths intelligently #87
 The number of selected rows is now displayed in the status bar #170
 Improved display of floating point numbers #166
 Postico now remembers whether you last used the contents or structure view #40
 Postico no longer attempts to load columns that you don't have permission to view. #179
Server view: Added a search field to filter databases. 
 Added a 'Create Database' button #112
SQL Query View: Press Ctrl-H to look up the current word in Dash #176
 You can now change the tab width (default 4 spaces) and use spaces instead of tabs #103
 Additional keyboard shortcuts: Shift Left ⌘[ and Shift Right ⌘] #103
 Postico now uses Notification Center to show update notifications. #135
 Postico now remembers the last used window size #14#98#136
 Fixed a bug where Postico rejected certificates signed by intermediate Certificate Authorities #158
 Fixed a bug where Postico gets confused when you replace a view/table with an object of a different type. #146#163
 Fixed a bug where navigating between foreign keys didn't work #177
 Update bundled OpenSSL to 1.0.2f 
 Update bundled libpq to 9.3.11 
 Update bundled libssh2 to version 1.7.0. This version adds support for diffie-hellman-group-exchange-sha256, and it fixes CVE-2016-0787
Jan 12, 2016
Postico v1.0.3 PostGIS geometry and geography columns are now detected even if they use annotations like geography(Point,4326)#140
 Fixed a bug where loading SQL files with Windows linebreaks was slow and led to odd behavior. 
 Additional filters for text columns (>, >=, <, <=) #147
 Allow sorting JSON columns #60
 Automatically disconnect when idle is now off by default, because it can cause unexpected behavior. You can enable it in the preferences. #142#153
Nov 30, 2015

Postico v1.0.2 Fixed an issue when pasting values into columns of type NUMERIC 
 Tabs in the SQL query view are now exactly 4 spaces wide #103
 Fixed two regressions from version 1.0.1:  Inserting tabs into the SQL query view works as expected again 
 Postico now again shows proper error messages when saving changes fails 
Nov 23, 2015
Postico v1.0.1 Added an option in preferences to change the font size of the SQL Query text view #38
 The interface now refreshes correctly after deleting the last index. 
 The SQL Query View now recognises statements containing semicolons #109
 Fixed a bug where the execute button was enabled even though there was no query on the line. 
 Postico now correctly handles special characters in filenames (like /) when exporting. 
 When saving changes to a table, you now have the option to commit changes even when the number of affected rows does not match what Postico expected #130 You can now also disable the check altogether with a hidden preference: 
defaults write at.eggerapps.Postico IgnoreAffectedRows 1
 Postico now automatically replaces non-standard space and newline characters in the SQL query view, and it strips byte order marks. #75#84
 You can disable this behaviour with a hidden preference: 
defaults write at.eggerapps.Postico SanitizeWhitespace 0
 Added a 'Copy with Header' command #65#125
 Added a preference to disable Magic Mouse and trackpad gestures #129
 Type select in the grid view: You can now just start typing to select tables in the grid view #119
 Filter tables & schemas in the grid view #119
Nov 4, 2015
Postico v1.0Indexes: Postico now displays table indexes in the table structure view right below the columns. This feature is currently mainly useful for informative purposes: it's convenient to get a quick overview. You can also rename indexes, add comments, or delete indexes. However, there is no graphical user interface yet for creating indexes (I will add that in a future version) #19
Avoid lost connections: Postico now automatically disconnects from the server before your Mac goes to sleep, or when the connection was idle for 5 minutes. Postico reconnects automatically the next time you try to execute a query. This should hopefully fix the problem of lost connections when servers are configured with a timeout. You can disable the idle timeout in preferences. #66
Typography: Postico now uses Apple's new system font San Francisco everywhere (except for SQL which is shown in Menlo). I also switched back to fixed width digits for better legibility of tabular data. Additionally, numeric columns are now right-aligned. I've also tweaked all the margins since the different x-height of the new font requires slightly different alignment occasionally. 
 PostGIS geometry and geography columns are now displayed as EWKT, which is slightly more readable than the default binary gibberish #92
 Deleting a table that hasn't been saved yet no longer shows an error message and works as expected. 
 I added a context menu for table column headers in the SQL Query view #97
 Fixed a deadlock (beachball) in the syntax highlighter #108
 When using the 'Copy As Insert' command, Postico now separates rows with newlines #104
 Redesigned foreign key fields in the sidebar for a more consistent look and feel. 
 The sidebar now displays column types. 
 The tables in the popup menu for foreign keys are now sorted again #85
 The query history popover lets you now insert queries by double clicking or pressing enter #101
October 9, 2015
Postico v0.28 You can now execute all queries with the keyboard command ⌥⌘↩︎ (behavior similar to Postico before version 0.27) 
 Fixed an issue where the Execute button became disabled (eg. after hitting ⌘A) 
 Fixed an issue where typing ⌘/ to uncomment lines didn't work 
October 8, 2015
Postico v0.27System requirements raised to OS X 10.9. Postico wasn't as stable on 10.8 as I wanted it to be. Working around bugs in Mountain Lion and additional QA efforts for the legacy system would have required too much time that I'd rather spend on new features, considering the very low number of users. 
Improved error handling during connection establishment. Postico was unreliable when restoring previously open windows in certain conditions. Problems occurred when the server did not support SSL, or when the SSH server required keyboard-interactive authentication. Connection establishment should now be much more reliable. Also, certificate warnings are now shown only once. #81
'Execute' (Cmd-Return) now executes only the current query#11
Improved query historyFilter the history to search for specific queries #74
Detail view shows the full query.
Clicking back/forward now replaces only the current query, or the selection.
Delete multiple queries from the history at once using the context menu.
 SQL Preview popover is now bigger and scrolls. 
 Added support for displaying foreign tables. 
 Fixed a bug where a query displays no results when it is executed while a previous one is still running. 
 Improved button styling in SQL Query view in Yosemite (eg. cancel button is now visibly disabled). 
 Fixed display issues on El Capitan. 
 Postico now ignores unsupported SSH host key types in known_hosts #78
 Fixed a crash when clicking the foreign key table button when multiple rows were selected. 
 Fixed a problem where strings were quoted incorrectly on Amazon Redshift #73
 Fixed a problem where inserting rows failed on Amazon Redshift 
 Comments are now saved when adding a column to a table #79
 Added new filters: 'begins with', 'ends with', and 'like' #56
 The breadcrumb control now also includes the schema of a table #32
 Fixed display issues in the favorite window on OS X 10.9 
August 14, 2015
Postico v0.26More responsive user interfaceWhen designing new tables, they appear in the sidebar in italic until they are saved
 Deleting objects now removes them from the sidebar and the main window without needing to refresh #3
 Truncating a table refreshes it and no longer shows a modal dialog #4#20
Table view automatically refreshes after making changes to table structure
Postico now remembers settings like column order when renaming tables
Improved data entry for enums, booleans, and foreign keys You can now select values for enum and boolean columns from a popup menu #33
Foreign Keys now have a little icon that lets you pick rows from the related table
 Added a button to view the related table #22
 Tweaked the design of the table view. The header is now light gray and single-line, and I've added vertical grid lines. #26
Views now load constraints from their source tables, allowing foreign key selection in editable views.
Fixed layout issues on El Capitan
 Fixed a crash when editing table structure with a check constraint that is not related to any columns. #30
 Improve performance for tables containing very long text by truncating tooltips. 
Fixed an issue where toggling the right sidebar didn't work.
Skip count query when number of rows can be inferred.
 Added an option in preferences to disable forced sorting (improves performance for large tables without indices) #16
Check constraints are now syntax-highlighted.
Server Nickname is now displayed correctly in breadcrumb navigation
Added reload button to the default toolbar #45
 Fixed a problem where changing the 'Rows per page' preference did not take effect. #35
 Filters are now displayed at the top #27
Changed default column type on Redshift from SERIAL (unsupported) to INTEGER
The status display now shows 'Transaction active' when a transaction is in progress.
Postico now reloads the full row after making changes.
July 9, 2015
Postico v0.25 Open new windows from the dock menu. #5
 Open connections now have a 'New Window' button in the favorites window #9
 Quickly comment (and uncomment) code in the SQL Query View. Hit Cmd-/ to comment selected lines. Or use Cmd-Alt-/ to comment a block of text. #10
 Added a 'Copy Column Name' menu item to the table view header context menu #13
 Previously open windows are now restored when app is restarted. (related to #14) 
 Add support for deleting databases #23
 Update to PostgreSQL 9.3.9 
 Update to libssh2 1.6.0 
 Update to OpenSSL 1.0.2d – Fixes CVE-2015-1793
 Fixed button styling in SQL Query View on OS X El Capitan 
 You can now select and copy error messages in the Favorites window 
 Added a workaround for a bug in NSTableView where only the first 32000 characters are selected when starting to edit a cell with more that 32000 characters. 
June 26, 2015
Postico v0.24Filter Tables in the sidebar
 Another feature that many people have requested. With convenient keyboard shortcuts: Press Cmd-Shift-F and type a few characters to filter tables. Then select a table using up and down arrow keys. 
 Syntax highlighting is now enabled for the view definition text field, for SQL expression filters, and for the SQL preview popover. 
 Fixed back tab behavior when full keyboard access is turned on. #1
 Hitting escape in text fields now discards changes and aborts editing instead of invoking auto-complete. #2
 Toast schemas and temporary schemas from other connections are now hidden in the sidebar. Additionally, there are now two separate settings for expanding the public schema and hiding system tables. Confusingly, these two settings used to be combined. #12
 Fixed a crash when the server sends an error message containing invalid characters. 
 Return now commits changes in the sidebar. To insert a newline, type alt-return instead. 
 Fixed a problem were license files failed to validate (caused by a bug in Aquatic Prime). 
 Fixed a crash when opening a table with an exclusion constraint on a function. 
 Fixed a drawing bug on OS X 10.11. 
June 12, 2015
Postico v0.23Fixed a bug where DELETE TABLE, TRUNCATE TABLE did not work on OS X 10.9 10.8.
Updated OpenSSL to version 1.0.2b
Updated libpq to version 9.3.8
May 22, 2015
Postico v0.22Fixed a crash when typing three consecutive single quotes into the query text field.
Fixed a crash when typing 'u' into an empty query text field.
Added support for syntax highlighting on Redshift and older versions of PostgreSQL.
Fixed a problem where characters that can't be displayed using Menlo were hidden in the query text view (eg. Chinese characters, Emojis)
It is now possible to provide a nickname parameter when using postgres:// URLs.
Allow deleting schemas from the sidebar context menu.
Customize CSV export format.
May 19, 2015
Postico v0.21Syntax Highlighting
 Postico now includes a custom made syntax highlighter that was designed from the ground up for PostgreSQL. It supports all language features (including peculiarities like nested C-style comments or dollar quoted string constants). The high efficiency parser automatically runs in the background as you type and can handle even very large queries. 
Smart Text Selection
 Double-click quotes to select the entire quoted string. Also works for comments – just double click the start or end markers. 
Line Numbers
Improved Connection HandlingYou can now forcefully disconnect if the connection was lost without closing the window by pressing ⌘⌥.
Canceling the current query no longer freezes the UI if the connection was lost
Connections are disconnected more reliably when windows are closed, any still running queries are cancelled
Separate windows now use separate connections
It is now possible to cancel commands when using SSH tunnels
SSH tunnels now use a random unused local port
More reliable caching of table structure
Fixed a bug where Postico would hang when typing Shift-Tab (to reduce indentation) when the cursor was at the end of SQL text view.
Improved performance when executing thousands of queries at once
Fixed a problem where large integers were converted to double when entering data
Added command to context menu in table view for inserting special values (NULL, DEFAULT, empty strings)
Improved responsiveness when connecting to a database with 50000 tables
March 30, 2015
Postico v0.20Sidebar automatically expands schema/database to show current table
Small performance improvements for SSH tunnels
Fixed compatibility issue with OS X 10.8 and 10.9 (eg. TRUNCATE command did not work)
Fixed a compatibility issue with PostgreSQL 8.0 and Amazon Redshift
Updated to OpenSSL 1.0.2a
The favorites window now displays the app version again
March 12, 2015
Postico v0.19Display table owner in the list view
Escape key now works as expected when a table cell in the query view is selected
Connection status messages in the favorites window no longer overflow
New connections now open with your most recently used view mode (icon view or list view)
Fixed a problem where view structure was incorrectly marked as having changes
Improved autosizing behavior when double clicking separator between column headers.
Display prettier SQL for default expressions and check constraints.
Started to write documentation.
Updated to libssh2 version 1.5.0
March 06, 2015
Postico v0.18Improved Reconnection Behavior
Navigation Popup in window titlebar replaced with breadcrumb buttons
Status display now full width
Allow moving window when starting drag on status display
Restored ‘Copy Name' command in context menu
Query View no longer cleared when reloading
Shift-Tab now un-indents even when no text is selected
Fixed ‘Copy Cell' command in context menu
Fixed database view on PostgreSQL 8.3 and earlier
Upgrade libpq to 9.3.6; OpenSSL to 1.0.1l
February 2015
Postico 1 5 103 =Postico – changes from PG CommanderPostico 1 5 103 ReszAll new design — optimized for Yosemite
 I have simplified and completely redesigned PG Commander to take full advantage of Yosemite's new design language. The new design degrades gracefully and also looks great on older versions of OS X. 
Table Structure Editor
 The most requested feature in PG Commander is finally here! Rename tables, change schema, change tablespace
Rename columns, add columns, remove columns
Change column type and default value
Add & remove column constraints (Primary Key, Unique, Check, Not Null, Foreign Key)
Add comments to tables, columns, and individual constraints
Table Contents View
Inline Editor: double click cell to edit
Batch editing: insert, update, delete multiple rows in a single transaction
Update views
Sanity check: PG Commander checks the number of affected rows before committing
Row detail view now in the sidebar
Update many rows at once with the sidebar
Vastly improved scrolling performance
SQL Query View
 I have completely replaced the SQL Terminal with the all new SQL Query View inspired by Sequel Pro. I thought that the SQL terminal was a good idea, but it had a lot of usability issues. For example, a common complaint from customers was that controls moved around. Also, the terminal had unfixable performance issues. All new design & improved performance
Support for large results (more than a million rows)
Support for long SQL queries (100.000 lines or more)
Query history popup: browse recent queries, clear individual queries from history
Status Display
 There is now a status display in the title bar. It shows what query is currently executing. When idle, it shows which database you are connected to, and the server version. 
Cancel command
 The keyboard shortcut ⌘. now aborts the current query. 
Improved Reload behavior
 Cached data is now purged more reliably when reloading. The terminal is no longer cleared when you reload. 
Improved change tracking
 PG Commander is now more reliable when you navigate away from a view with unsaved changes, eg. when using the back button. 
New Sidebar Icons
 Updated to a flatter look. Schemas now have a folder icon. 
 Table column titles now span multiple lines when there isn't enough space to show them in a single line 
 Added a preference to require confirmation before connecting to SSL servers with valid, but unknown certificates 
 Added a command to truncate tables. 