| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
| |
to allow filtering for NULLs.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
result sets - when iterating through a mysql result set, all the data up to each row was seeked through again. With this fixed SP can work with very large result sets at much, much higher speeds.
- Fixed incorrect query splitting in splitQueries - improves custom queries and imports.
- CSV export now exports NULLs as an empty cell (eg "1,,3"). This resolved Issue #67. Correspondingly, CSV import now also accepts this syntax.
- CSV and SQL exports no longer quote numeric values for file size and neatness improvements.
- Multi-table exports now show progress through the tables in the text description, and use the progress bar for export of each table, for improved feedback.
- The old "Export Table Content" menu has been split into two - "Current Browse View" which matches the old behaviour, and a new "Current Table" entry. This addresses Issue #97.
- Exports now write data to a file stream as data is processed for export, and also parse data from the database as a stream where possible. This leads to lower memory usage, speed improvements, and much more accurate and constant feedback.
- The export processes have been restructured and rewritten for further speed and memory improvements.
- SQL exports now correctly export BLOB and TEXT contents ready for re-import into all systems.
- SQL exports now group multiple VALUES for each INSERT INTO command for much, much faster imports of exported data.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
---
Field mapping when importing CSV file now makes more sense.
You can import data into multiple columns in the table.
Known Issue: changing table while field mapping doesn't work. Select the table first before importing
TableContent
---
Partially solves issue where label at bottom "x of y rows selected" wasn't being updated
TablesList
---
Moved table delegate methods under correct pragma mark
|
|
|
|
| |
strings, fixing the data corruption problems in all TEXT/BLOB types
|
| |
|
|
|
|
| |
not showing any applied limit on initial table load
|
|
|
|
|
|
|
|
|
|
| |
- Refreshing or reloading a table view will now attempt to preserve sorting and filters.
Other changes:
- Initial cleanup of TableContent loadTable:
- Replacing project-distributed column sort arrows with the OS-provided images
|
|
|
|
|
|
|
| |
then restore it afterwards - ie suggestion (2) in http://groups.google.com/group/sequel-pro/browse_frm/thread/71541c6267fc08c1/2f4aeeaa7f15b268 .
I was initially in two minds as to whether this would be a good thing, but with r195/r196 removing the need to refresh for structural changes, this change does actually feel right to me - in fact, I now wish it didn't clear any filters/limit, and I'd like to preserve them as well. Any objections?
|
| |
|
|
|
|
|
|
| |
Note that this fix may not be the best solution.
However it solves the issue in the meantime.
|
|
|
|
| |
table information (commented out until bug resolved)
|
| |
|
|
|
|
|
| |
changed search to 'live'
|
| |
|
|
|
|
|
|
|
| |
refactor menu validation
move database action buttons into a new "Database" menu
pretty up the table select view and it's action buttons
|
| |
|
|
|