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, figuring 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.
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.
Session data Data from the Session object 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 .ToString() value.
Param scrubbing Sensitive parameter 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 Rollbar.
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.