archive-com.com » COM » S » SEQUELPRO.COM

Total: 92

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Project News | Sequel Pro Blog
    on Lion machines Enjoy If to encounter any bugs check the issue tracker first and report anything new you find Any questions can be posted to Google Groups If you happen to encounter any bugs check the issue tracker first and report anything new you find Any questions can be posted to Google Groups If you use Sequel Pro on a regular basis please consider donating 10 or 20 to the project Download Now Release Notes Donate 22 Comments Sequel Pro 0 9 9 July 1st 2011 It s been a long year for us and we hope you haven t missed us too much We have been working hard the whole time creating the most feature rich Sequel Pro we have ever released Seriously you don t want to miss this update Start Downloading User Interface Features We now have tabs in the main connection window allowing multiple connections in one window A new bundle plugin system makes it easy to add new features to sequel pro in almost any scripting language You can share your bundles at http www sequelpro com bundles share Improved keyboard navigation throughout the app Better Mac OS X integration with a QuickLook plugin for viewing files sequel pro can open including SQL dumps Improved auto completion and syntax colors in the SQL editor Literally hundreds more usability improvements Perform a Find F while browsing a table now presents an interface to quickly create and apply a WHERE filter Translation Support Added German and Russian translation and support for translation for many other languages Many other languages are already in progress Please help us finish your language by visiting http translate sequelpro com Database Features Can now add rename browse databases Improved compatibility with many servers where we previously had issues connecting or maintaining a reliable connection Built in support for additional data types index types table structures Better performance when browsing large tables All new Import Export system much more powerful faster with large data sets and easier to use If you use Sequel Pro on a regular basis please consider donating 10 or 20 to the project Donate Download Sequel Pro 0 9 9 Now Full list of changes and fixes 39 Comments Sequel Pro 0 9 9 Release Candidate June 13th 2011 It s been quite a long time since our last release but we haven t been idle we re happy to present you with a release candidate of the next version of Sequel Pro 0 9 9 Please download a copy of the application test and report any bugs you find Highlights of the new features in this version are translation support plugin support tabbed window support QuickLook new index creation interface overhauled and unified export interface improved import interface with much better CSV field mapping a server navigator improved data type support including spatial data support improved table views and much improved stability There are however many many more features to discover some of the changes in this

    Original URL path: http://www.sequelpro.com/blog/category/news/ (2016-02-10)
    Open archived version from archive


  • Release Candidates | Sequel Pro Blog
    Any questions can be posted to Google Groups Download 0 9 9 Release Candidate more 16 Comments Sequel Pro 0 9 8 Release Candidate Updated April 4th 2010 Today we are offering a new release candidate of our next version of Sequel Pro 0 9 8 Download a copy of the app test and report any bugs you find Please focus your testing on the following new features User management Table triggers support Custom query placeholder support including lists custom query text macros and tab triggers Improved custom query autocomplete including table and field names Overhauled CSV mapping interface including defaults and updates Improved printing support Greatly improved stability New crash reporter Sequel Pro is now a full 64 bit build Check the issue tracker and report any new bugs you find in this release Any questions can be posted to Google Groups Update We ve fixed over 20 issues thanks to your testing Release Candidate 2 is now available and is linked below Download 0 9 8 Release Candidate 2 Full Release Notes 21 Comments Sequel Pro 0 9 7 Release Candidate December 10th 2009 The release candidate of Sequel Pro 0 9 7 is ready for your testing pleasure Highlights of the new features in this version are New application icon New server processes panel Query favourites editor Filter editor Improved tooltips including image previews Pagination interface for the content view Much faster and more stable import and export Early support for document based connections Ability to stop custom query and content loads Introduction of threading for some tasks Check the issue tracker and report any new bugs you find in this release Any questions can be posted to Google Groups Download 0 9 7 Release Candidate Full Release Notes Note to testers We have made changes to the way Query Favourites are stored If you use Query Favourites and anticipate that you will revert to 0 9 6 or run both 0 9 6 and this release candidate side by side please read this article on Backing up your Preferences file 11 Comments Sequel Pro 0 9 6 Release Candidate Updated August 3rd 2009 The team has been working on some great features over the last two months We are really excited about this new release Here s the quick rundown an overhauled connection window including SSH tunnel support updated interface filterable tables list foreign key support sortable and editable custom query results native MySQL help support and significant speed and memory usage improvements This is a release candidate folks so the usual applies Please try out the new features above and help us make sure that we have a release that is ready for the masses Report any bugs to the issue tracker Any questions can be posted to Google Groups Update We ve fixed a few issues thanks to your testing Release Candidate 2 is linked below Download 0 9 6 Release Candidate 2 Release Notes 16 Comments Sequel Pro 0 9 5 now available

    Original URL path: http://www.sequelpro.com/blog/category/release-candidates/ (2016-02-10)
    Open archived version from archive

  • Security Update 1.1.0.1 - Sequel Pro Blog
    Version 1 1 0 1 fixes a security flaw reported by Radoslaw Karpowicz that allows remote code execution by any user on your LAN Please use the built in check for updates system to install the fix Download Now Release Notes Donate Posted in Project News Leave a Comment Name required Mail will not be published required Website Sequel Pro Donate Get Involved CocoaMySQL Blog Download Nightly Builds Release Notes

    Original URL path: http://www.sequelpro.com/blog/2016.01/security-update-1-1-0-1/ (2016-02-10)
    Open archived version from archive

  • Release Notes | Sequel Pro
    Foreign Key tweaks for localised languages Localisation Duplicate DB Sheet Fix layout issues of main window including issue with connect screen Bug Fixes Fix startup encoding detection when connection to servers with an init connection option set fixing errors viewing tables and display of NULLs for data Various New Index Sheet fixes Fix an issue when cancelling the User Manager Fix exceptions editing non unique keyed views or custom query results containing some types of binary data Correctly use the user specified NULL string in the CSV exporter Use the CLIENT INTERACTIVE mode for MySQL connections to improve timeout behaviour Fix an issue when removing the only content filter Crashes when using Use monospaced fonts or Display vertical grid lines preferences after closing at least one window Fix crashes on cancelling the CSV import field mapper Fix issues with autocomplete behaviour Fix exceptions in the bundle controller when using tab switching keys Regression Re add default new table s id field to AUTO INCREMENT Misc Add Sparkle to credits Various code base tidy ups and fixes Attempt to fix SSH master use Release 0 9 9 July 1 2011 Build 3348 Highlights of the new features in this version are translation support plugin support tabbed window support QuickLook new index creation interface overhauled and unified export interface improved import interface with much better CSV field mapping a server navigator improved data type support including spatial data support improved table views and much improved stability There are however many many more features to discover some of the changes in this version are Interface Support the up and down arrow keys to navigate between cells in Content and Query views The enter key now ends editing for the current cell and saves the row Allow tab and shift tab to select all cells including BLOB content opening the editor sheet on first edit Made deletion actions more consistent by renaming many occurrences of Remove to Delete Filesystem sizes are now reported in base 2 KiB MiB rather than base 10 KB MB to clarify what 1GB represents Implement database renaming Implement database duplication including content if requested Improve the layout of several menus and rename a number of menu items for clarity Update Add Table and Add Database dialogs to use lists of supported encodings provided by the server Add a server Navigator view for viewing databases and tables Display a filterable list of all databases their tables and their columns Support selecting columns to view overview information about each Support double clicking databases and tables to switch the active window to the selection Support synching the navigator selection to the current view Support dragging and dropping tables and columns into custom query editors Support dragging tables onto the table list to copy that table and its content Add a Sequel Pro Quicklook plugin for SQL and connection session files Support as a keyboard shortcut to restore font sizes to their default setting in edit fields Allow Show Copy Create Syntax use when multiple items are selected showing all create syntaxes When using Show Copy Create Syntax on Procedures wrap the output with DELIMITER for convenience Reduce the minimum window size by making the connection view layout scrollable Display the field type and NULL details in the editor sheet Don t allow input in the editor textfield or sheet if the field length would be exceeded Improve support of the Escape key to cancel or abort row editing Improve the interface to more closely reflect the capbilities of different server versions Support three finger swiping gestures for navigating backwards and forwards in history Add the ability to move the selected line up or down in many text views and Add the ability to Jump to Selection J Move the performance schema database to the system databases group Improve the field editor sheet to be document modal and improve standard OS interaction within it for example Find and undo behaviour Right align numeric columns in table content and custom query views Add the ability to double click in empty areas of main tableviews to add new rows Translation Add translation support to the application including easy interface translation and a translation ecosystem Add German translation Add Russian translation Add a Provide Translation Feedback menu item in the Help menu Made many more strings and interface components localisable Tabs Implement tabs for multiple connections within the same window Improve custom PSMTabBar implementation for improved appearance and dragging behaviour Allow keyboard navigation between tabs with multiple keyboard shortcuts and Support duplication of the current tab T and moving it to a new window If text is dragged onto a tab switch to that tab and the query view within it Support double clicking on a tab to duplicate it Support double clicking on an empty part of the tab bar to create a new tab Bundles Add initial support for user plugins saved as spBundle files and a bundle editor to allow editing and creation Allow spBundle bundles to contain any support files and allow upgrading spBundle versions by UUID Support scripts in any OS supported scripting language BASH Ruby Python Perl Applescript etc Support general scope plugins Support table data scope plugins with support for selected row data or table data with BLOB control Support text editing scope plugins with support for the selected text or the full content of the editor Support execution of custom commands via a sequelpro URL scheme Allow organisation of bundles within a Bundles menu by menu category Support bundle triggers which execute the bundle database changed table changed or row selection changed Support a long list of shell variables for Sequel Pro state use within plugins Allow all plugins to display results in an HTML window foreground or background or tooltips Allow text plugins to amend or replace the selection or wider text editor contents Add appropriate bundles to contextual menus Allow custom keyboard shortcuts to be assigned to Bundles More complete Bundle documentation can be found at http www sequelpro com docs Bundle Editor Add default bundles included with Sequel Pro Add a bundle to enable copying selected table data as JSON Add a bundle to copy a line from a text field quoted for use in other scripts Add a bundle to display a report with all databases tables and their formats and sizes Add a bundle to format SQL using an online service Add a bundle to open the selected table in Numbers or Excel Add a bundle to display JSON format cleanly and to convert it back to valid JSON Add a bundle to demonstrate wrapping selected text within a DELIMITER statement Connection Fix favourite sorting persistence Add support for SSL connections Perform the initial MySQL connection on a background thread increasing UI responsiveness and allowing the connection to be cancelled Support saving entire connection sessions all open windows including tabs as a Sequel Pro Session file spfs Replace built in MySQL reconnection with custom connection handling code Attempt a single reconnect automatically without displaying the disconnection UI If no network is available delay reconnects to allow the network to come back up Improve SSH reconnections and stability Consolidate Reconnect and Retry buttons in the connection lost dialog Improve stability when disconnecting for both single and multiple concurrent connections Improve connection keepalive Improve stability when dealing with poor network conditions especially with multiple connections Add support for SSH identity files public keys in custom locations Improve compatibility with systems which support MySQL interfaces including Sphinx Allow SSH connections to use custom ports specified in SSH configuration files Alter SSH connections to use ControlMaster auto settings instead of master mode Improve SSH tunnel behaviour for connections with non Latin characters in their name Add a fallback to ask the user for their SSH password if automatic lookups fail Fix the use of extended character sets in passwords or connection details Allow keyboard navigation through favourites even if they have blank passwords If a favourite is selected and the tab key is used move the selection to an empty password field if one exists Tables List Fix a crash after truncating tables in certain table states Support exporting currently selected tables from the table list context menu Add a menu item for refreshing the table list to the database menu R Keep the tables list a fixed width when resizing the window Correctly preserve the width of the tables list across sessions Fix display of the table name if deleting a table from a filtered list Preserve active content table filter settings when the tables list is refreshed Structure Tab Add support for additional field information comments encoding and collation Allow key encoding collation and comment columns to be hidden using an options menu below the table Display field types as uppercase to match convention Add an optional placeholder to the new index name field to clarify that it isn t required Improve row saving particularly when editing combo boxes or popup buttons with the mouse Improve DEFAULT syntax generation to avoid unnecessary error messages for unsupported types Add support for SERIAL and BOOL EAN types Update the interface based on selected field type to disable invalid options Improve field type autocompletion and processing user entered strings Improve error messages when saving rows by displaying the generated SQL statement Save column widths across sessions Add a contextual menu item to show optimised field type Add a new Index creation sheet Allow multiple columns to be indexed easily Allow the index storage type to be specified as an advanced setting Allow the length prefix to be specified on columns as an advanced setting Allow definition of the index s key block size as an advanced setting Improve display of binary types Set columns to unsigned if they are set as a primary key Improve handling of date and time field types Only allow selection of auto increment for fields if there isn t an auto increment already present Ensure the structure view is activated after creating a new table Content Tab Fix an error when the row is deleted or duplicated while editing a cell Automatically resize table column widths to match their contents Update the table view with new results as they are retrieved Support editing view contents on a per cell basis if fields can be uniquely identified Allow numeric formatters such as commas to be entered in the pagination limit field Fix an possible exception if loading a content page with no result rows Fix restoration of table pagination when navigating from a table with no rows Update the table row count when deleting rows via the interface Fix exceptions when using filters or pagination while editing a row Add support for a keyboard driven quick query builder for power users activated by Find F Allow filter values to be specified for all fields in a table Allow multiple values to be specified for each field Support negation Support a live SQL preview Support a query shorthand for different operator types and default operators Allow DISTINCT searches via the options menu Allow quick search of all fields Support live filtering while typing Only include edited fields in the UPDATE query when saving rows Save numeric fields as NULL if a cell is blanked and the field support NULLs Preserve the filter comparison type if possible when the filter column is changed Query Tab Allow stored procedures to be run Currently only the first actual result set will be displayed Support in cell editing of non TEXT BLOB custom query result fields instead of editing all fields in sheets Further improve autocompletion Support autocompletion for database or table aliases Display the text cursor at the correct position when autocompleting to clarify text entry Show autocompleted text at partial opacity to indicate it s temporary until selected Update the autocomplete placeholder when the autocomplete dropdown selection changes Improve autocompletion adjacent to a number of special characters including mathematical operators Detect whether the caret is within quotes to improve autocompletion suggestions Move the rows affected and timing stats to a new button bar Don t display the error message area unless there is a message to display Add a contextual menu and menu item to export the custom query results Normalise linebreaks in whitespace to prevent syntax errors Automatically resize custom query result column widths to match their contents Update the results view with new results as they are retrieved Reset the custom sort order display when running a new query Add a contextual menu item for the table allowing copying of the result set Improve Shift Left Shift Right including adding support for configurable space based indentation Improve Select Line to include the entirety of wrapped lines Disable AutoHelp when the help window is closed Improve highlighting of custom query errors by scrolling to any errors that occur Fix syntax highlighting for r and n comment styles Improve speed of processing very long text in the query editor Triggers Tab Support double clicking on triggers to edit them drop and re create Load triggers only when the triggers tab is loaded Improve trigger column widths Fix trigger deletion and improve deletion error handling Information Tab Improve display of auto increment value Preferences Add the ability to set the selection colour in the Preferences Query Editor tab Support definition and display of alpha transparency in custom colours in editor themes Support switching between import and export of query editor colour themes spTheme Support previews of Tables and Query Editor fonts Import Export Redesign the export interface into a unified interface exposing new functionality Integrate CSV SQL XML and dot export types mapping as appropriate to available data Rework interface for selecting tables and information to export Support saving custom filenames including placeholder tokens for host database table and date formats Improve filename extension construction Display and remember the export location to reduce number of steps for most exports Support specifying custom CSV and XML NULL values Support configuration of whether the UTF 8 BOM should be used in SQL dumps Support export of BLOB values in SQL as plain text rather than hex Support configuration of maximum INSERT size when generating SQL to export content Improve handling of files which already exist when exporting multiple files Display a warning if new tables have been created between an export being set up and initiated Display a small warning if the selected export format cannot be imported by Sequel Pro Support the MySQL schema format for XML export Support gzip compression for import and export Support bzip2 compression for import and export Allow import file encoding to be autodetected or specified via a menu instead of using the connection encoding Normalise linebreaks in whitespace when importing files to avoid syntax errors Addition of an Import from Clipboard File menu item I as an alternate to the new Import menu This shows a small preview of the clipboard and the standard import options Improve the speed of writing exports to file resulting in faster exports Improve handling of connection loss during import Update the field mapping table after refreshing the table list in the CSV import field mapper Add the ability to import a CSV into a new table allowing naming and smart field setup Support custom SQL functions when importing data from CSVs via the field mapping sheet via Add value or expression including placeholder support for CSV values Add the ability to add columns to the target table A or via the contextual menu and remove them Improve support for DELIMITER syntax in import files Automatically switch between commas and tabs as the field delineator based on csv or tsv selection for imports Improve handling of CSV files containing partial or empty rows When importing SQL views ask how to deal with import errors ask how to proceed or ignore all errors Change the default SQL import behaviour to ask how to proceed on error Improve case sensitivity support in dot exports add a new checkbox controlling case sensitivity when generating dot graphs prepopulated according to the server s case sensitivity setting When importing CSVs set numeric fields to NULL instead of 0 if empty strings are encountered Improve CSV automatic field mapping under Align field names by to use Levenshtein and improved logic Server Processes Panel Add the ability to auto refresh the process list can be toggled with a button or R Add the ability to configure the auto refresh interval Update the process list on a background thread for increased interface responsiveness Improve handling of connection loss Assign the Refresh button a keyboard shortcut R and fix the tooltip Enable alternating rows for improved display Allow sorting of the server processes Preserve server process list column widths across sessions User Manager Fix permissions saving for users with underscores in their names Improve User Manager compatibility with MySQL 3 x and 4 x servers Fix issues when adding new hosts to existing users Improve support for blank passwords Fix issues with applying all privileges not including GRANT OPTION Support double clicking on schema privileges to move them between available and granted Improve editing of user hosts Improve error reporting when saving users Printing Support Allow the AppleScript print command to print the current view Update structure headings to reflect the table type Only print the indexes table if indexes are present Query Console Log Improve thread safety when logging from multiple threads Other Add support for spatial data Display spatial data as editable AsText function strings including multi polygon and geometry collections Add spatial field types to structure autocompletion lists Display spatial representations of data in the tooltip in Content and Query views Support addition of spatial indexes on MyISAM tables Support SRID edits of spatial fields via WKT strings and conversion to GeomFromText Improve handling of BIT fields including editing with new interface display and import and export Improve handling of VAR BINARY fields Fix handling of strings containing null characters 0 Improve encoding handling to support extended characters in database table and column names Improve UTF8 over Latin1 handling in custom queries and edits Retrieve supported database encodings from MySQL 4 1 servers Increase speed by cacheing server version for use by various actions Improve handling of table names containing backslashes Improve multithreading and query locking to prevent hangs Fix connection loss crashes when attempting to save data caused by unsafe content escape routines Fix a crash if AppleScript is used to open without any parameters Update RegexKitLite to 4 0 Enable more optimisations within the MySQL libraries Fix history navigation when using Trigger views Upgrade to MySQL 5 1 57 client libraries was 5 1 44 Significant code cleanup stability and architecture changes Release 0 9 8 1 August 9 2010 Build 2492 The 0 9 8 1 build is a bug fix release Changes in this version include Behavioural Fix favourites sorting User manager fixes Fix table row count display of filtered tables Fix copying binary data as tab delimited strings Improved handling of corrupted tables disabled storage engines and similar errors Fix structure editing errors Improve structure behaviour editing to commit when the return key is pressed Respect Reload after editing preferences when editing custom query results Prevent custom query uppercasing of reserved keywords if they are quoted Fix reordering of timestamp fields Improve default socket search paths Fix custom query intercepting up down arrow keys when autocomplete finds no matches Speed and compatibility Improve background database structure querying including support for MySQL 3 4 Table trigger loading improvements and fixes from MySQL Fix 10 5 not appending correct file extension to exports Fix custom query custom query autocomplete tab snippets in 10 5 Import from clipboard improvements Hangs and crashes Replace Core Animation calls with manual drawing code this fixes hangs certain users were seeing very regularly and prevents newer MacBook Pros from triggering their discrete graphics chips Fix intermittent crashes when cancelling or stopping queries on MySQL 3 4 Fixed a range of thread safety issues causing exceptions and crashes Fix intermittent crashes when opening files Fix intermittent crashes in the CSV import mapping interface Fixes to running certain custom queries Fix errors in table saving on right clicking in the table list Improve robustness when closing windows quickly Fix exceptions printing extended table information in certain circumstances Other Memory usage improvements Improve Xcode 3 2 3 project compatibility Fix resizing of table information pane if it started in a collapsed state Improve data storage exceptions Release 0 9 8 May 4 2010 Build 2210 Highlights of the new features in this version are user management table triggers support custom query placeholder support including lists custom query text macros and tab triggers much improved custom query autocomplete including table and field names an overhauled CSV mapping interface including defaults and updates improved printing support a 64 bit build and much improved stability including the addition of a crash reporter Some of the changes in this version include Interface MySQL system databases i e mysql and information schema are now visually separated from user databases at the top of the list Fix for occasional overlapping alert sheets Addition of inline table view procedure and function renaming Further reduction in the number of sheets that are run in an application modal fashion that would subsequently prevent access to other connections Addition of a preference to set the font and size of all result set tables that display MySQL content Fix an issue where the background colour of the table list search field would appear different to that of the rest of the list Ability to display or hide the MySQL server version in connection window titles via a hidden preference Addition of a Filter Content menu item to the Table menu which places focus on the table content filter field Addition of a Filter Tables menu item to the Table menu which places focus on the table list filter field if visible or the first table if not visible Addition of a Keyboard Shortcuts menu item in the Help menu that links to the online documentation wiki Addition of a new table triggers toolbar icon Addition of a help button on the query favorites editor that links to the online documentation wiki Fix keyboard tab behaviour when selecting connection detail fields standard socket and SSH on the connection view Addition of a contextual menu in the connection favorites table view allowing the deletion and duplication of the selected favorite Addition of a gear menu in the connection favorites table view allowing the sorting of favorites by name host and type as well as in reverse order Addition of a contextual menu in the connection view allowing the user to edit the selected favorite Addition of a new preference to control whether or not anonymous system information is provided when checking for updates Add a Show create syntax menu item to the table list gear and contextual menus Display CREATE syntax s for tables and views with a trailing semi colon for easier copying and pasting No longer append semi colons to console error messages Connection Improved handling of server variable requests from certain versions of MySQL specifically 4 Fix the hanging of secondary SSH tunnels when running in 64 bit mode Fix for failed connections caused by whitespace and newline characters in the host and SSH host fields Significantly improved connection loss and reconnection behaviour Improved connection timeout behaviour Allow arbitrary questions from SSH in order to support keyboard interactive authentication methods such as those used by RSA SecurID Improved SSH tunnel proxy behaviour Improved SSH tunnel behaviour of connections that don t have a password in the user s keychain Improved stability of disconnections when switching tables Improved CPU usage of SSH tunnel question password dialogs Improved connection failure handling Structure Tab Improved error handling when adding removing and editing table fields Ability to reset the AUTO INCREMENT value of primary key fields by right clicking the primary key index Fix an issue caused by duplicating table fields that are yet to be saved to the database Adding and removing table indexes as well as removing table fields is now performed on a separate thread allowing the user to cancel the operation Fix an issue that prevented the addition of multi column table indexes because of leading and trailing whitespace Content Tab Improve large InnoDB table loading by replacing the Fetch correct row count preference with the option of specifying a new table row count query level in relation to whether additional queries should be used Options are never only for small tables 5MB and always Fix an issue caused by selecting Copy as SQL INSERT after a table content filter has been applied Fix for incorrectly escaping MySQL special characters when applying table content filters Improved speed and lower memory usage when loading very large data sets Fix for incorrectly encoding BLOB and binary TEXT fields when copying Table sorting filter criteria scroll position and row selection are now preserved when switching between tables Addition of the ability to reset the AUTO INCREMENT value when deleting all records from a table Fix an issue that caused the progress indicator and bezel not to disappear once a table sort operation was complete Fix an issue that caused the following of table relation links when the initial mouse click was not on the link arrow Duplicating table content rows now correctly loads deferred BLOBs and sets auto increment fields to NULL Fix errors when deleting content rows which are currently being edited Fix errors deleting multiple content rows on certain servers Query Tab Improved handling and stability of line selection for MySQL errors ending in numbers Improved behaviour of editing query results Ability to save the custom query history to disk as well as copy to the pasteboard Ability to select filtered query history and favorite items using arrow keys Significantly improved auto completion for all database objects including information about all tables and fields in any selected database Ability to insert query favorites via user definable tab triggers Ability to define nested snippets within query favorites text macros Ability to select predefined dynamic variables within nested snippets that are expanded upon use Speed improvements when working with large amounts of text Fix for partial syntax highlighting for very long lines Fix for the synchronisation of query history lists if more than one instance of the same connection document spf file is open Ability to run any shell commands and scripts Perl Ruby AppleScript etc within query favorite text snippet macros Scroll position and selection are now preserved when editing custom query results Option to enable auto completion after a pause while typing in Query Editor preferences and custom query gear menu Option to specify the time delay of auto completion For untitled connections non SPF based documents saving query favorites now defaults to saving them globally Significantly improved thread safety when running queries Fix an issue where selecting the Clear Global History menu item would fail to do so in some circumstances When switching to the custom query view always set the focus to the custom query editor Relations Tab Fix an issue when creating foreign key relationships with names that included reserved characters and names Fix an issue that prevented the addition of foreign key relationships immediately after changing a table s storage engine to InnoDB Fix field relation referential actions not showing in certain circumstances Triggers Tab New triggers tab Ability to add and remove triggers Information Tab Ability to reset or set to a specific value the primary AUTO INCREMENT field of a table Improve permissions error checking and handling when gathering various types of table information Import Export Table triggers and functions are now included in MySQL dumps Fix for save panel export options disappearing when exporting a custom query result SQL import and export now correctly support the use of DELIMITERs Procedures and functions are now included as an option when performing SQL dumps Completely redesigned CSV field import mapper allowing the choice of whether specific fields should be imported as well as the import method used INSERT REPLACE or UPDATE Ability to set global variables in new CSV import field mapper Fix for incorrectly displaying the read file size of CSV and SQL imports greater than 4GB in size Server Processes Panel Panel is now a separate window rather than a sheet on the current connection to enable active process monitoring Ability to hide the process ID column Ability to enable the use of SHOW FULL PROCESSLIST instead of SHOW PROCESSLIST User Manager New database user accounts manager Ability to add and remove users and hosts Ability to manage usernames and passwords Ability to manage global and schema privileges Ability to manage resource limits Printing Support Significantly improved printing support including The inclusion of table names on print outs If present the inclusion of table indexes when printing a table s structure The use of monospaced fonts in print outs to be consistent with user preferences The inclusion of vertical grid lines in printed tables to be consistent with user preferences Ability to print the table relations view Ability to print the table triggers view Ability to print the extended table information view The inclusion of NULL values represented as the user s NULL value placeholder when printing a table s structure and indexes Dynamic calculation of the size of page margins based on the paper size of the selected printer The generation of print outs on a separate thread giving the user a chance to cancel the operation for large data sets Present a warning to the user when attempting to print a large number of table rows Current threshold is set to 1000 rows and can be changed via a hidden preference Lots of print out style enhancements Other Sequel Pro is now fully 64 bit compatible on Intel systems running Mac OS X 10 6 Snow Leopard Restore default OS X behaviour of bringing the most recent window to the front when clicking the dock icon Fix an issue where the renaming of a table failed when only the case changed Bound three finger multi touch right left swipe event to trigger back forward in table selection history Restore the default standard shortcut of H to hide all other applications CHECK OPTIMIZE REPAIR FLUSH CHECKSUM and ANALYZE TABLE can now all be applied to multiple tables at once Addition of in app crash and exception reporting to a new online repository viewable at http log sequelpro com to improve the stability of Sequel Pro Updated MySQL client libraries to version 5 1 44 Updated Sparkle auto update framework to address a number of issues Fix a stability issue caused when gathering table information and the user chooses to close the connection when the reconnect sheet appears Fix an issue that prevented the addition of new tables with a CSV storage engine because of an initial nullable field Lots of memory leak fixes Lots of stability improvements and exception fixes Ask for confirmation before deleting connection favourites Allow spfs to be saved with empty passwords or sockets Fixed display of Growl notifications for long running tasks Release 0 9 7 December 21 2009 Build 1630 Highlights of the new features in this version are a new server processes panel a query favourites editor a filter editor improved tooltips including image previews a pagination interface for the content view much faster and more stable import and export early support for document based connections the ability to stop custom query and content loads and the introduction of threading for some tasks Once again this version contains too many changes to mention in depth a selection of the changes includes Interface Improve Growl interaction only Growling if in the background or for long tasks Addition of a new about panel The default view can be set in Preferences by default the last used view will automatically be selected Addition of new tooltip methods including multiline previews and image previews Save the status of Check spelling while typing in field editor sheets NULL and not loaded placeholders are displayed in grey The preferences interface has been tweaked Allow insertion of the NULL value via the Edit menu The monospaced font preference will now apply to more views and use Monaco as the default font Addition of a new server processes panel available via the Database menu Ability to kill queries and connections from the server processes panel Ability to filter and save server processes Addition of a number of menu items to the Dock menu Follow the OS X user interface guidelines and make the Cancel button the default on destructive tasks Addition of keyboard shortcuts for the non default confirmation button on destructive tasks D for Delete R for Remove T for Truncate Make a number of warning and information dialogs clearer Make a large number of sheets and dialogs non modal allowing use of other windows eg Add New Index Add New Database Create Table syntax Server Variables Add Relation Table editing sheets Thread initial database loads Thread view switch loads Sequel Pro is now an editor for sql files opening them in the Custom Query view or offering to import depending on size Addition of basic procedure and function information in the Table Info pane Addition of a Provide Feedback menu item in the Help menu Allow copying server variables from the server variables sheet Addition of Copy and Save buttons to the Create Table Syntax sheet The view History can now be navigated using entries in the View menu including keyboard shortcuts Clicking and holding the history buttons will now show a list of history states to select Improve window cascading especially for large windows Allow use of the Return or Enter key to edit some lists and tables including the table list Display the name of the field being edited at the top of the field editor sheet for context Add Return as a shortcut to save and close the field editor in addition to Enter FnReturn Connection Allow the OS or users preferred SSH agent to handle public and private keys Add ControlMaster compatibility to SSH tunnels Offer to reconnect directly to the old SSH tunnel if another tunnel is already bound to the remote port Preserve the host field when switching to and from Socket connections Addition of support for saving connections as spf connection files Save window state within spf connection files including history Add Open and Open Recent support for spf connection files Improve connection stability on connections with high packet loss or a tendency to drop Structure Tab Allow the deletion of fields which are parts of foreign keys and indexes by deleting dependencies automatically after prompting the user for confirmation Allow default values in BIT notation when creating BIT fields eg b 1 Addition of support for adding BINARY and VARBINARY fields Preserve any comments and column details unsupported by the interface when editing or moving columns Fix checkbox display on Mac OS X 10 6 Content Tab Addition of a new pagination interface replacing the old LIMIT text box Allow easy jump to deep pages and control of pagination preferences by clicking on the pagination text Content loads content filters and content sorts can be stopped during loading Content loads content filters and content sorts are threaded and show progress where data is available All content loads are faster and use less memory A content filter editor is available via the Filter comparsion dropdown allowing the creation of custom filters which can be saved either globally or per document in spfs Placeholder support in the custom filter editor including up to two arguments Addition of a BETWEEN filter operator and fixes to other filter types Correctly display content within BINARY VARBINARY fields Improve the display of the row count and update row counts as table contents change Vastly improve deletion of large numbers of

    Original URL path: http://www.sequelpro.com/release-notes (2016-02-10)
    Open archived version from archive

  • Donate to the Sequel Pro Project | Sequel Pro
    Florent Vaucelle Kaliware LLC Dimitrios Makropoulos Scott Brisko dotplex e K Kazukiyo UEDA Jacek Karpinski Alexandre Gauthier Padraig Kennedy Justin Morris Brendan Young Jon Gilbraith WebCamp One LLC Ryan Cooley Klaus Thuesen Adam Ellingford Thanks To Gravity Robert Kuo Rowland Carson Pixlock e K Jan Rademaker Andrew MacKinlay Balint Orosz Balgair Enterprises Chris Iufer Namue srl Aaron Glemann Surojit Niyogi Jens Wollersheim Francesc Esplugas Marti Gustave Stresen Reuter Steve Roy Software Design Steve Kump Anthony Duva Douglas Carter Derek Jones Erik Johansson Tomi Joki Korpela Juanma Cabello Rattle Records Ltd Nathan Beadle Joseph Bartlett Marian Dörk Jonathan Marshall Sven Andersson 12house com VGKids Scott Shupe Patrick Collins Iwao Abe Jochen Rau Brian Dunagan Vietnam Art Gallery David Cruz Ivor Humphreys Magnus von Bromsen Daniel Ackerson TQ White II Brian Seymour Randy Kruzan Claudio Januario Nicholas Lo Truecast Design Studio Truecast Design Studio Mike Oldham Ken Dunnington Nathan Hadfield Jeremy Lecour Thomas Baustert OIWebhost com Matvey Kalachev Kirill Dergachev Matthew Weber Matthew Weber Brian Kusler Zachariah Teitler Mark Ainge Bart Bons Jonathan Baer Hugh Flynn Mario Witte Patrick Fitzgerald Chad Mohler James Rothschild Hardesty Ingraham Sebastian Galonska Vladimir Jirasek Ronald van Eede Guillaume Pancak Art Schumer Philipp Kleinschmit Sergio Mora Hernández Flying Man Productions Inc Glare Technologies Limited Mark Taylor Media Atelier Phillip Sasser Automatique Greg Eden Mike Chan Amro Mousa Scott Rankin backsite de Markus Demmelbauer Phelipe de Sterlich Shane Davis Kuba Dębski Crossroad Solutions iconfinder net Adam Patterson Karl Mikkelsen Cesar Gomez VMD Health Care Training Ben Hall Ransom Weaver Mateus Armando Filipp Lepalaan Remi Gabillet Mark Rinella Ann Patrice Hickey Théo Reichel Thilo Schmidt Anders AM FÖRVALTNING AB Tiger of the Stripe Russell F Imrie Matthew Ratzloff christopher dickes Michael George Brad Stewart Leigh Daniels WOW Design Solutions TST Media LLC Francesco Levorato Lee Neo Fishlight Ltd Christophe

    Original URL path: http://www.sequelpro.com/donate (2016-02-10)
    Open archived version from archive

  • Sequel Pro 1.1 – A touch of colour for your Databases - Sequel Pro Blog
    all Great job But after this update I cannot export a custom query to csv format it freezes Kraddle October 1st 2015 Thanks for update Great Job Bruce October 1st 2015 Awesome I wait for a long time for this news Thanks all Renato Gama October 1st 2015 Thank you very much guys Have been waiting a long time for some of these improvements Yacker October 2nd 2015 Great update After 2 years Love the color coded tabs Jason Kelsey October 2nd 2015 Awesome I can t wait to download it Thank you so much for the hard work Niklas October 4th 2015 Thank you for the release and the improvements However the color feature really feels like a complete fail I had hoped I could finally instantly see if I am connected to a critical production server by marking those connections in a warning color to prevent me from accidentally destroying data or overloading the server But the way colors are implemented doesn t help a bit here Here s why a The color is shown in the tab background only If I have only one connection open there is no tab and therefore no color visible b Even if I have multiple tabs open or I finally find the option to have Tabs always on the colors feature doesn t help still because the tabs are ALWAYS colored a tiny bit darker though So if I have 4 colored Tabs open I can fairly easily overlook which of the Tabs i m currently on There should be some sort of big red banner line on top of the open Tab which changes its color or disappears if none depending on the Tab I have open Something which actually clearly visibly changes when I change from one tab to

    Original URL path: http://www.sequelpro.com/blog/2015.09/sequel-pro-1-1-a-touch-of-colour-for-your-databases/ (2016-02-10)
    Open archived version from archive

  • Sequel Pro 1.1 RC2 - Sequel Pro Blog
    menu fixes 2161 Fix a rare exception when opening a session via Open Recent Fix an exception when trying to sort favorites by host or type while groups are present fixes 2151 Fix a crash when the database popup was removed from the toolbar fixes 2147 Fix an exception when no database was selected and the user tried to export a query result with the database file name token fixes 2145 Fix a crash when displaying the server process list fixes 2114 Fix a popular exception when a user tried to edit a field with a lost connection and then chose disconnect when Sequel Pro asks to reconnect fixes 2137 Fixed a rare crash when SSH connections failed caused by a race condition fixes 2132 Field Editor now uses the newer find bar instead of the find panel on supported OS X versions 2148 Download Sequel Pro 1 1 RC2 Posted in Project News 4 Comments Jay August 22nd 2015 Does this including favorites syncing over iCloud or Dropbox Tony Ja August 26th 2015 It s crazy that the last release is from 2013 So far it s running smoothly on OSX 10 11 DP6 Iain Kay September 6th 2015

    Original URL path: http://www.sequelpro.com/blog/2015.08/sequel-pro-1-1-rc2/ (2016-02-10)
    Open archived version from archive

  • Sequel Pro 1.1 RC1 - Sequel Pro Blog
    us get to 100 translated Posted in Release Candidates 12 Comments Remi June 8th 2015 Hi I read that you are looking for translators in French How can i help you yubo June 9th 2015 Thank very mach very good OSX 10 11 You can use ykk June 11th 2015 OMG Finally Can t wait to try this out Phil June 24th 2015 Hi Great news on v1 1 I was wondering do you plan on implementing the new JSON field type that is appearing in MySQL v5 7 which has just made it to RC1 It would be great if it could as we ve been juggling switching to Postgres because of its availability of this field but what s holding us back to MySQL is the great features of the SequelPro tool Thanks Phil Kimbley June 25th 2015 As of today how is the beta testing coming along for Sequel Pro 1 1 RC1 John July 6th 2015 Can t wait Beta runs fairly reliably so far Got it into a funky state once where any scrolling in the Table lest panel would trigger a crash Let crash reporter do it s thing and sent the details Thanks for all the work you guys do on this excellent client One day I know you re going to use it to bring us the PostgreSQL client we so desperately need too Cheers David July 26th 2015 Absolutely fantastic program Can finally ditch phpmyadmin Tony G August 8th 2015 Hi I have downloaded your new version but was wondering if you have added the multiple filters feature If not when do you expect to have that feature ready Luke August 10th 2015 Oh looks good Can t wait Alex Mac August 11th 2015 Tried v1 1 for a few weeks

    Original URL path: http://www.sequelpro.com/blog/2015.06/sequel-pro-1-1-rc1/ (2016-02-10)
    Open archived version from archive



  •