| Commit message (Collapse) | Author | Age | Files | Lines |
|---|
| |
|
|
|
|
|
| |
conversion to strings to avoid memory trampling, addressing Issue #1708
- Update localizable strings
|
| |
|
|
|
|
|
|
| |
- r4090: Issue #1536: Add the option to force delete a table, which will disable then re-enable foreign checks. Also, provide a more helpful error message when a table cannot be deleted because of foreign key constraints
- r4091: Update localisation comment
- r4092: Include Spanish translators in Credits
- r4093: Fix truncation of table content BINARY values which are being edited in-place, addressing Issue #1702; Ensure that truncation of data values includes an ellipsis to make it clear when performance-based truncation is occurring
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
potentially comprising the last of 1.0.2:
- r4066: Fix query status and error message title to not always suggest an error has occurred, addressing Issue #1670
- r4067: Fix validation of the "Add to Favorites" File menu item when editing past favorites; Fix the action of the "Add to Favorites" File menu item to correctly create the new favorite; These address Issue #1666
- r4068: Move the SPBeginWaitingAlertSheet function to a beginWaitingAlertSheetWithTitle:... class method on a new SPAlertSheets class, allowing us to use invocation forwarding to ensure the entire function is executing on the main thread. This allows runloop processing to happen on the main thread, addressing Issue #1676
- r4069: Fix newline warnings
- r4070: Issue #1601: Fix menu items not being validated properly once a connection is established
- r4071: Split the process list controller's table view data source and delegate methods into their own category
- r4072: Fix process list kill query/connection actions not using the correct ID if the list was filtered
- r4074: Correctly link the SSH name field, fixing issues editing and automatically filling in connection names on the SSH tab, addressing Issue #1686
- r4075: Specify the NULL status of fields when creating view placeholders on export, fixing problems with invalid timestamp NULL defaults, addressing Issue #1688
- r4076: Add a spotlight comment to allow easy location of Sequel Pro with other search terms than the name
- r4077: Fix string type detection, addressing errors when converting string types to blob or binary fields (addressing Issue #1453)
- r4078: Composite Foreign Keys will now show all columns in Relation view (workaround)
- r4079: Changed a query (addressing issue #1687); Make some strings localizable
- r4087: Fix another issue causing ALTER statements to error for binary column types being edited, further addressing Issue #1265
- r4088: Update version number to 1.0.2
|
| |
|
|
|
|
|
|
| |
- r4062: Fix build warning
- r4064: Combine the "Run All" and "Run Current/Previous/Selection" buttons into a single button with dropdown menu with ability to change the default action: Create a new SPComboPopupButton class; this subclasses NSPopupButton to retain the ability to show the popup menu, but only when the right-hand side of the button is pressed, allowing the rest of the button to perform the click action; Combine the previous two "Run" buttons on the Custom Query view into a new SPComboPopupButton; Move the Run menu items from the gear menu into the Run button popup menu so they can be discovered more easily (and the shortcuts seen more easily) ; Add a menu item to switch the button's default action, which also swaps all associated shortcuts; Clean up associated logic. This implements Issue #1569
- r4065: Alter the SPComboPopupButton to ignore clicks started in the left-hand part of the button but ended in the right-hand part of the button; Change the button to use "Run All" instead of "Run All Queries" to avoid localisation issues
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- r4034: End editing for deleting content filter or query favourites, addressing exceptions and Issue #1648
- r4035: Apply schlabberdog's fix for log #3969, addressing Issue #1647
- r4036: Fix an error parsing SQL inside an unterminated delimiter statement causing an off-by-one error in positioning, addressing Issue #1643
- r4037: If date-type fields are cleared, and allow NULLs, save the cell value as NULL; this implements Issue #1638
- r4038: Alter the content filter manager and the query favourite manager to import items from a file into the Global group if the document is untitled, improving import UX and addressing Issue #1616 and Issue #1645. Also select and scroll to the newly imported items for clarity.
- r4039: Fix crashes in the User Manager when fields don't validate but a save/cancel/tab switch is still triggered, addressing Issue #1627
- r4041: Tweak and improve the User Manager: Rework how data to populate the user manager is retrieved from the server, speeding up display of lots of users by a large factor; Fix support for schema permissions for the Anonymous user, and add support for '%' and '' hostnames (only showing if already set once), fixing Issue #1620; Highlight databases in the user manager that have permissions set for the selected user; Switch to using the centrally provided database list to reduce queries and remove the information_schema and performance_schema "databases"; Speed up a number of operations by tweaking the logic and queries used
- r4042: Fix release builds after r4041; Update localizable strings
- r4043: Set Sequel Pro to always run on Integrated Graphics on machines with both integrated and discrete, improving power consumption if nothing else is triggering the discrete GPU. This addresses Issue #1609
- r4044: Make the theme background apply to the query favourites editor
- r4045: If the Custom Query editor view is active on window open, correctly set the focus in it, addressing Issue #1590
- r4046: Add support for querying the server default charset and collation; Move a bit of redundant code into a method
- r4047: Restore tab bar label when cancelling a connection
- r4048: Fix format string error in QueryKit
- r4049: Alter the preferences favourite minimum version to avoid issues with previous runs of nightlies, which may partially address Issue #1588; Remove the old favourites key from the preferences now imports have succeeded
- r4050: Allow Favorites import to read favorites from an old preferences .plist file, further addressing Issue #1588
- r4051: Change the string '=' and '!=' to be case- and collation-insensitive by default, using the Shift key (as documented in the tooltip) to trigger a BINARY exact match. This addresses Issue #1578
- r4052: When adding a database the servers default charset is now shown
- r4053: Adjust keywords list to fix auto capitalisation of "ON"
- r4054: Add a new SPMySQLEmptyResult class to SPMySQLFramework, returning it instead of nil if a query produces no result set. This allows per-result-set properties to be preserved, fixing issues where information like query execution time was lost - addressing Issue #1577
- r4056: Improve startup when loading from file, preventing overwrite of details read from a spf/spfs during startup. This addresses Issue #1619
- r4057: Correctly reset document state for setting it from file/when duplicating tab, further addressing Issue #1619
- r4058: Add a stub override to fix exceptions when code receiving a SPMySQLEmptyResult expects a SPMySQLStreamingResult/SPMySQLFastStreamingResult (Exception #3988)
- r4060: Make some small tweaks to string BINARY handling: Correctly send the binary state/collation when reordering fields, addressing Issue #1265; Allow unticking of the binary box to save correctly, allowing conversion of fields to non-binary collations again
- r4061: Fix errors when editing or moving columns on server vesions which do not support character sets/collations, addressing Issue #1629; Fix needless collation queries on those servers; Disable field enums and table encoding dropdown on those servers
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- r4021: Add a check for SPNotLoaded values when automatically generating new tables when importing CSVs, fixing Issue #1621 (SPNotLoaded values are generated when rows shorter than the header row are seen)
- r4022: Fix crashes when importing favorites on the connection view, addressing Issue #1556; Select and scroll to newly created favorites after import
- r4023: Default to disabling SSH multiplexing to avoid connection issues as per Issue #1457; leave multiplexing code present, but behind a preference. Run `defaults write com.sequelpro.SequelPro SSHMultiplexingEnabled -boolean YES` to re-enable
- r4024: Fix handling of double-dash style comments within field names, addressing Issue #1554
- r4025: When favorites in the connection view gave no password, no longer set the focus to the password field as soon as they're selected; instead, make the password field the next responder for tab keys. This addresses Issue #1555
- r4028: Fix escaping of backlsashes in non-LIKE clauses, addressing string matching with the = and RegExp operators - addresses Issue #1563
- r4029: Fix handling of primary keys listing multiple fields of which an early field has a specified length, addressing Issue #1641
- r4030: Alter the database creation sheet to correctly use the selected new database encoding; Clean up the database creation logic and remove redundant selection logic; Correctly reset and detect the database encoding when creating and switching databases
- r4031: Fix blurry text in a number of text views in 1.0.x (Possibly caused by IB mangling; recreated new text views with the same settings to address). This fixes Issue #1560
- r4032: Detect deleted or non-writable folders for export targets and give appropriate errors (particularly for saved paths), addressing Issue #1566
- r4033: Add support for export path tokens containing non-alphanumeric characters, automatically grouping and tokenising as required for both dragged and typed tokens. This addresses Issue #1567
|
| |
|
|
|
|
|
| |
edge cases, addressing Issue #1547
- Bump the version number to 1.0.1
|
| |
|
|
| |
title changes ourselves, fixing the last part of Issue #1521
|
| | |
|
| |
|
|
|
|
|
| |
previous debug builds
- Update localizable strings
|
| |
|
|
|
|
|
|
|
| |
fields:
- Rename all "IS" entries to "=", to make the intended purpose clearer, and switch the underlying command to use "= BINARY" instead of "LIKE", producing an exact match instead of replicating LIKE functionality. Move LIKE p to just below the = options. This addresses Issue #1441.
- Add entries for "matches RegExp" and "does not match RegExp", implementing Issue #1508.
- When adding custom filters, add them by default to the Global group if the favourite isn't an on-disk document, addressing filter loss between sessions; this addresses Issue #1381
|
| |
|
|
| |
preparation for upcoming release
|
| |
|
|
|
| |
- Add a copy phase to the distribution build process to copy in languages downloaded from dev.sequelpro.com/languages before signing
|
| |
|
|
|
|
|
| |
- Recompress all pngs losslessly to reduce disk use slightly
- Remove old unused images
- Switch some code over to imageNamed: to allow easier Retina additions in future
|
| | |
|
| | |
|
| |
|
|
|
|
|
|
|
| |
thanks to Panic, Inc), recompressed for smaller file size and 10.5 compatibility
- Add document icons to match
- Amend the Info.plist to fix Sequel Pro being able to edit old .spf files etc
- Add .mysql file support (Issue #1366)
|
| | |
|
| |
|
|
| |
1x and 2x displays.
|
| | |
|
| |
|
|
|
|
|
|
| |
Current/Previous/Selection" shortcuts and positions (Issue #1094)
- Tweak the designated requirement to correctly sign the tunnel assistant (Issue #1503)
- Add support for important release notes in the version upgrade routines to highlight important issues, and add notes for the button swap and signing change to alert users
|
| |
|
|
|
|
|
|
|
|
| |
passwords *
- Change the bundle identifier from com.google.code.sequel-pro to com.sequelpro.SequelPro
- Change the code signing process to use a new identity and requirement, to add Developer ID support on 10.7+ but to also maintain functionality on 10.5+
- Add a preference migration routine to copy the old application defaults to the new bundle identifier's defaults
- Re-order the default keys to alphabetical to more easily locate values
|
| |
|
|
| |
(not added to Xcode project yet)
|
| |
|
|
| |
Update README to give hint about compiling with 10.5 and 10.6 SDK.
|
| |
|
|
|
|
|
| |
case-insensitive for a more Mac-like feel, groups are sorted alphabetically among favourite nodes when name sorting is being used, and above (or below when reversed) other favourites in type/host mode
- Update localisable strings and fix a warning
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
editing on the connection screen (Issue #1339, Issue #1440):
- No longer save changes made to connection favourites as soon as the interface is updated
- Alter the interfaace if favourites are editing, offering to save the changes either to the old connection favourite or to a new favourite
- Add a "Test connection" button to verify changes before saving
- Add a "Quick Connect" entry to the top of the connection view's favourites list so a blank form is always available
- Use a custom highlight when editing favourites to show the favourite has changed but is still linked
- Reduce the margin on the left-hand side of the connection favourites list to increase the available space
- Alter favourite name generation, making it less aggressive when generating names from partial details (eg creating names of just "@") and removing the user
- Alter key icon usage to correctly update the button appearance if an SSL or SSH key is selected
|
| | |
|
| | |
|
| | |
|
| |
|
|
|
|
|
|
|
|
|
| |
address Issue #877:
- On servers with very short timeouts set the wait_timeout for the session as well as the interactive_timeout to prevent the connection from dropping frequently
- Improve recovery from connection errors, correctly restoring the connection if appropriate and possible
- Allow reconnections to occur recursively by altering the internal tracking mechanism
- Fix some edge cases where the connection would remain locked incorrectly
- Improve error messaging for the "MySQL Server has gone away" network case
|
| |
|
|
| |
schlabberdog!)
|
| |
|
|
| |
dependencies now that all BW custom elements have been removed; remove last references and build steps.
|
| |
|
|
| |
DatabaseServerVariables, Navigator, and IndexesView nibs, replacing with SPSplitView and standard equivalents
|
| |
|
|
|
|
|
| |
with SPSplitView and equivalents
- Update localisable strings
|
| |
|
|
|
|
|
|
|
| |
standard equivalents and SPSplitView
- Replace the "Add" action menu on the connection view with two buttons for easier use and to avoid having to set up more popup buttons
- Improve SPSplitView's handling of delegates set through code
- Update localisable strings
|
| |
|
|
|
|
|
|
| |
configured from code
- Replace the other NSSplitView on the Query pane with an equivalent SPSplitView to allow easier constraint management
- Fix SPSplitView collapsible subview resizing to only amend the collapsible subview's autoresizing mask along the axis of the split view, leaving the other axis untouched to avoid problems with subviews not correctly picking up window resize changes when they were collapsed
|
| | |
|
| |
|
|
|
|
|
|
|
|
| |
replacing the anchored button bar and buttons with normal equivalents.
- Make the main split view collapsbile to avoid resize issues with the filter box
- Fix problems with additional drag handles in SPSplitView when one of the views was using flipped coordinates
- Fix problems with manually dragged uncollapses in SPSplitView
- Fix problems instantiating SPSplitView instances on 10.5 (with thanks to schlabberdog)
|
| |
|
|
|
|
|
|
| |
allow us to remove BWToolKit. Supports constraints and animated collapsible subviews configured in code, fixes crashes and exceptions if a window is closed while animations are taking place or scheduled to take place.
- Replace the two vertical splitters in the table list (the filter splitter, and the table info splitter) with SPSplitView implementations as a test
- Add a helper method in the new SPDateAdditions
|
| | |
|
| |
|
|
| |
* In Help viewer [HELP\nTOPIC] would not be recognized as link
|
| | |
|
| |
|
|
|
|
|
|
| |
results found and showing the table of contents if the field is cleared
- Permit help searches for the operator "%" as a standalone string
- Update localisable strings
|
| |
|
|
|
|
|
|
|
|
| |
- Prevent groups from being dragged into themselves (or child nodes) to prevent data loss
- Improve selection handling when manually reordering nodes
- Don't allow drags of the "Favorites" title at the top of the view to prevent exceptions
- Prevent the "Favorites" title from being collapsed to prevent confusion on 10.7+
- Improve group tooltips to reflect contained favourites and groups
- Improve menu validation checks
|
| |
|
|
|
|
|
|
|
|
|
|
| |
background loss of connections:
- Attempt to fix a condition causing a reconnection loop by fixing the order of connection state check and a query variable
- If a connection is lost in the background, only attempt a single reconnect instead of requiring user intervention at once
- Add a new connection state to handle background disconnects
- If the connection has been lost in the background but is about to be used, reconnect it automatically (informing the user of loss if appropriate)
- Don't attempt background reconnections if the connection has not been used for some time
(Also update localisable strings, and tweak navigator controller connection usage)
|
| |
|
|
| |
be translated causing translation faults; this addresses Issue #1322.
|
| | |
|
| | |
|
| |
|
|
|
|
|
| |
fix nightly builds
- Fix warnings
|
| |\
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| | |
the functionality required from MCPKit and is based around its interface for relatively easy integration.
Externally visible changes as a result of this merge:
- Speed improvements, particularly when loading large data sets
- Stability improvements, particularly related to connection state after the connection is dropped (eg Issue #1256)
- Improved support for new MySQL data types, which should address Issue #1052.
- Database structure retrieval and query cancellation now use a single persistent helper connection instead of lots of connections on-demand. This should help Issue #1097.
- More internal commands now use queries instead of MySQL functions; for example USE queries are now used to trigger database selection, improving transcripts. This addresses Issue #1247.
- Improved internal encoding work; while this needs support within the UI, it lays the foundation for issues like Issue #1280.
Code improvements:
- Much improved class layouts including extensive category usage
- Improved documentation across framework methods
- Support for fast enumeration across result objects
- Rewrite fixes use of a number of deprecate functions
- Much less code duplication across result set types
- Improved encapsultation within the framework, limiting the number of methods exposed, and also not exposing all the MySQL headers
From the Readme file:
The SPMySQL Framework is intended to provide a stable MySQL connection framework, with the ability to run text-based queries and rapidly retrieve result sets with conversion from MySQL data types to Cocoa objects.
SPMySQL.framework has an interface loosely based around that provided by MCPKit by Serge Cohen and Bertrand Mansion (http://mysql-cocoa.sourceforge.net/), and in particular the heavily modified Sequel Pro version (http://www.sequelpro.com/). It is a full rewrite of the original framework, although it includes code from patches implementing the following Sequel Pro functionality, largely contributed by Hans-Jörg Bibiko, Stuart Connolly, Jakob Egger, and Rowan Beentje:
- Connection locking (Jakob et al)
- Ping & keepalive (Rowan et al)
- Query cancellation (Rowan et al)
- Delegate setup (Stuart et al)
- SSL support (Rowan et al)
- Connection checking (Rowan et al)
- Version state (Stuart et al)
- Maximum packet size control (Hans et al)
- Result multithreading and streaming (Rowan et al)
- Improved encoding support & switching (Rowan et al)
- Database structure; moved to inside the app (Hans et al)
- Query reattempts and error-handling approach (Rowan et al)
- Geometry result class (Hans et al)
- Connection proxy (Stuart et al)
|
