Say what you will about Microsoft SQL Server Management studio, but the query interface was actually pretty good. Now that I’m using PostgreSQL and MySQL I’m finding myself looking for desktop tools for querying. Nothing more than that, just simple CRUD operations for one-off data imports, querying, figuing stuff out.
It’s been staggeringly difficult to find a desktop client that can do this well. If I were to create one, which I may if my struggle continues, this would be my wishlist. Some of these seem obvious but I’ve found clients lacking one or more of these.
- Keyboard shortcut to running SQL
- Run only the selected query text
- Block commenting and un-commenting
- Sortable results grid
- Copying and saving results
- Indicate trailing whitespace on string columns
- Make null and empty string values obvious
- Clearly indicate errors and recordcounts after query execution
- Shortcut to get schema, keys, and indexes on a table in your query
The 2.0 beta version of My Flight Map is currently open for beta testing at kaya.mroach.com. This is a full rewrite using Rails 4.1. With the new platform it will be easier to maintain and add features. The UI is the last bit needing some attention.
Version 2.0 is open source and hosted on GitHub at https://github.com/mroach/myflightmap. All are welcome to submit issues for feature requests and bug reports.
More to come when we’re live.
The new release adds two bits of missing functionality.
Data from the
Sessionobject is now added to reports. Data is described/stringified as best we can, with non-value types being reported with their type name, hash code, and
Sensitive paramter values are now scrubbed. Each character is replaced with an asterisk. By default, any parameter in the following list will be scrubbed:
password password_confirmation confirm_password secret secret_token creditcard credit_card credit_card_number card_number ccnum cc_number
You can override this list by setting the
Faced with having to script out schema and objects from a SQL Server database, the only option was using SMO. That’s a Windows-only solution that has some known bugs and performance problems. Using the management views in SQL Server you can script everything out yourself. So I created mossy to do that in Ruby. It can script out a whole database in under 15 queries and depending on the size of modules, should only takes a few seconds.