| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
|
|
| |
- FULLTEXT index type should only be available for MyISAM tables
- Index prefix lengths are ignored when specified for FULLTEXT indexes so don't require one (fixes issue #1306)
|
|
|
|
|
|
|
| |
- Use menu item tag to insert the snippet, instread of using part of the tooltip; this is safer when localising values
- When inserting query placeholders, automatically wrap all the values if not already within a placeholder. This addresses Issue #1313.
- When inserting query placeholders, automatically use the lowest unused completion index instead of a fixed value
|
| |
|
|\
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| | |
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)
|
| |
| |
| |
| |
| |
| | |
- Return User Manager details as strings as some result types are marked as binary; fixes opening of user manager
- User manager schema list is now a list of databases instead of a list of database dictionaries with one key; simplify model to match
|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| | |
exceptions as database structure retrieval is currently missing!
Further work on SPMySQLFramework integration:
- Improve SPMySQL framework build settings including correct ppc builds and a Distribution configuration for the build distributions to match
- Add new convenience querying and result methods to the framework
- Amend Sequel Pro source to use the new SPMySQL.framework methods everywhere, replacing MCPKit methods where they differ and improving some functions
- Remove MCPKit from the source
- Fix a number of warnings on Release-style builds
|
| | |
|
| | |
|
|/ |
|
| |
|
|
|
|
| |
both backslash and double-character escaping. This will mean the vast majroty of CSVs selected for import will be read correctly by default, fixing issues such as Issue #1252
|
|
|
|
|
|
| |
from origin {0,0}; now it's synchronized
• minor speed ups for custom query editor
|
| |
|
| |
|
| |
|
|
|
|
| |
.strings files)
|
|
|
|
| |
this addresses Issue #1176
|
|
|
|
| |
currently used relation names in a backgroud thread. In the event that the user opens the add new relation sheet during this process, the ability to enter a relation name and confirm the addition is disabled until the retrieval process is complete. There is also a new progress indicator on the add sheet to indicate this.
|
| |
|
|
|
|
| |
auto_increment value to use Default instead of Custom style, possibly addressing Issue #1135 (auto_increment display issues in 10.5)
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
the main window only; hide SSH/SSL status when entering fullscreen mode, to prevent drawing issues
- Lion compatibility improvement: update tab colours under 10.7 to match system styles
- Lion compatibility improvement: fix issues dragging tabs out of windows and into other tab bars
- Lion compatibility improvement: fix QuickLook issues under 10.7, including windows which couldn't be closed, fullscreened, or crashes
- Fix exceptions in the bundle controller when using tab switching keys
- Lion compatibility improvement: use overlay scrollers where possible
|
|
|
|
| |
option is not enabled.
|
|
|
|
| |
AUTO_INCREMENT value on a table's structure is included. Defaults to not included. Implements issue #1064.
|
|
|
|
|
| |
* Fixes a case were for string == NULL was checked instead of [string length] == 0 (fixes #1103)
* Fixes a logic error while copying databases and adds ability to copy InnoDB tables with foreign key checks (fixes #1111)
|
| |
|
|
|
|
|
|
| |
translated (fixes #1105)
* Adds support for naming relations (fixes #948, #1085)
|
|
|
|
|
|
| |
- Fix logic for enabling/disabling the index storage type popup button when changing the index type.
- Add a number formatter to the index length field.
|
| |
|
|
|
|
|
|
|
|
| |
• added to default bundles SHA1 und MD5 the key:
<key>isDefaultBundle</key>
<true/>
- for both bundles description and author are missing
• removed bundle file 'echo n' from SHA1 package
|
|
|
|
|
|
|
| |
- Rearrange the bundle editor interface further, building on Stuart's work in r3330; particularly focussing on logically grouping fields together.
- Move the "Disable" checkbox to the bottom of the window, rename it to "Disable bundle" to make the intent clear, and update the interface when it is in NSOnState
|
|
|
|
| |
compilation warnings
|
| |
|
|
|
|
| |
localizations (esp. for German and Russian)
|
| |
|
| |
|
|
|
|
| |
greater visibility to novice users
|
|
|
|
|
|
|
| |
keyboard shortcuts
- Update localizable strings
|
| |
|
|
|
|
| |
* Update strings files
|
|
|
|
|
|
|
| |
from a #ifndef SP_REFACTOR/#else/#endif to just a #ifdef SP_REFACTOR/<protocol declaration>/#endif, and remarking a few items as IBOutlets
- Update localisable strings
|
|
|
|
| |
panel. Fixes issue #1036.
|
|
|
|
| |
the implementation of issue #939.
|
| |
|
|
|
|
| |
TablesList's context and gear menu to avoid having two separators one after another
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
functionality, including an overhaul of filename NSTokenField functionality:
- Improve the NSTokenField used for export filenames: only tokenise reserved tokens, don't tokenise reserved words which are parts of other words, allow the comma to be used, update tokenisation during typing, and prevent whitespace triming.
- Save the last selected export path, and make the path selection button open a dialog to the selected directory
- Save the export filename and restore on future uses of the export dialog (only if the name contains placeholder tokens, so one-off export names aren't saved)
- If the advanced options are collapsed, display a summary of the selected options next to the disclosure triangle
- Display a small warning in the corner of the window if the export file cannot be imported into Sequel Pro, to warn those people attempting to back up their databases in XML
- Clarify and improve the export warning dialog if files already exist or could not be created; make the simpler file-exists cases reflect OS-style dialogs, alter wording based on the number of files that failed and how they failed, and only show the "replace" or "skip" type buttons if it makes sense to do so.
- Fix a mutation-during-enumeration error when skipping files
- If "Cancel" is chosen in the export file creation replace/error dialog, redisplay the export sheet with the previous selection still active
- Add support for year, month and day tokens in the filename token list
- Don't allow blank custom filenames, before or after tokenisation, as this can cause problems - instead fall back to default filenames in those cases
- Only append the extension if one hasn't been set - on all export formats, extending r3284
- If exporting to multiple files option is enabled but only one table is selected, supply that table name for filename table tokens
- Update the progress bar to reflect update progress when exporting CSV data
- Fix a bug causing exports to hang if the low-memory advanced option was set and content was selected to export and any empty tables were encountered
- Save memory use and compression advanced export settings across sessions
- Update localisable strings
|
|
|
|
| |
their controller instead of SPPreferencesController; this fixes issues such as the favourite name not being generated correctly, or the password being lost when a username or database field is changed.
|
|
|
|
|
|
|
| |
- This may be due to an Apple bug. I tracked it down to purely SPDatabaseDocument having a reference outlet to the activity scroll view.
- Removing the reference worked as a fix; removing all code that used that reference did not.
- Renaming the reference, and removing SPTableInfo's use of a reference, appears to act as a workaround. If the reference is not renamed, the bug still mainfests (!!!)
|
| |
|
| |
|