Just some thoughts about the tools and services I am using for my project.<\/p>\n
Up until the middle of the batting stats table, I had been running MySQL locally on my late 2012 MacBook Pro 15inch Retina,<\/a>\u00a0maxed out with the 2.6 i7 and 16GB of RAM.\u00a0 It’s still a great machine.<\/p>\n For a while, I had been using MySQL Workbench<\/a> as my interface.\u00a0 It’s not bad at all and, for a free tool, it’s great.\u00a0 It does have some shortcomings in terms of ease of use and importing data.\u00a0 For example, when using it to connect to a remote database, it insists on treating it like a localhost.\u00a0 Honestly, after a few hours of live chats with tech support trying to make it work, I gave up on it.<\/p>\n I switched to Querious<\/a> and I couldn’t be happier.\u00a0 Not cheap, but it’s a joy to work with.\u00a0 My favorite feature?\u00a0 That would have to be the ability to easily import from csv.\u00a0 Being able to do it at all is pretty fantastic, but being able to clean and manipulate the data easily before import is amazing.\u00a0 On top of that, the import speeds are blazing fast.<\/p>\n Querious has 4 main views: Content, Structure, Query, and Server.<\/p>\n Content allows you to view the content of tables and views just by clicking on an object in the sidebar.\u00a0 From within that view, you can filter the results shown by clicking on the “show all’ button.\u00a0 This pulls down a list of all the columns in the table and allows you to write a quick WHERE clause to filter the data.\u00a0 A real time saver when you need to do a quick sanity check.<\/p>\n Clicking on the database itself rather than a table gives you a view of every table and view along with data size, index size, auto_increment count, and row count.\u00a0 My only quibble with this is that the row count does not update automatically.\u00a0 You have to refresh for each table to see a value.<\/p>\n Structure shows you the structure of the database and the tables.\u00a0 Clicking on the database will show you a diagram of all the tables, with lines showing foreign keys and relationships between tables.\u00a0 Clicking on a\u00a0 table will show you all of the columns, their types, any constraints.\u00a0 You can switch tabs to see primary keys, indexes, and foreign keys.\u00a0 You can also add, change, or delete these from this view.\u00a0 Other tabs show you what triggers exist for tables and allow you to create or change them.\u00a0 Finally, you can see table info and options – along with an exportable CREATE statement.<\/p>\n The Query view gives you a SQL editor with all the usual bells and whistles: context sensitive highlighting, an intelligent (much more so than Workbench) auto complete feature.\u00a0 There’s also a context sensitive table reference panel that senses which table you’re referring to and lists all of the columns.\u00a0 Double clicking on a column will insert the name at the cursor.\u00a0 You can also switch to a different table if you’re thinking quicker than the AI.<\/p>\n You can also open or create SQL files in a separate window that has all of the same features except for the table reference panel.\u00a0 \u00a0 The look and feel of both the editors are great, but for reasons mentioned below, I am still doing most of my editing in a different program.<\/p>\n My only complaint at all about Querious is that it seems to be frightened of large sql files.\u00a0 My 10MB Test Data Load script has never failed to hang the program (beachball) necessitating a force-quit.\u00a0 Even loading a 1000 line script hangs the program for at least a minute.\u00a0 That’s loading, not executing.\u00a0 The way around the test data load is to import the data via csv.\u00a0 It handles that like a pro.<\/p>\n Still, as mentioned above, I do most of my editing in a separate program.\u00a0 I use Brackets <\/a>because the editing environment is almost as good as Querious and the file management is far better.\u00a0 Perhaps because it was made with web design in mind, it makes it much easier to manage a collection of files, keeping them straight, organized, and easily accessible.\u00a0 Querious allows you to save sql files and even allows you to put them in folders and favorites, but I can’t seem to get comfortable with the function.\u00a0 With Brackets, I know where my files are and can flip back and forth with ease.<\/p>\n My remote database is hosted by DreamHost<\/a>.\u00a0 I have a number of domains hosted with them and really like them.\u00a0 Their pricing is fair and have a number of goodies that make setting up portfolios and blogs, as well as provisioning databases, simple.\u00a0 Their customer service is great.\u00a0 If you’re interested in setting up hosting with them, ask me for a referral!<\/p>\n","protected":false},"excerpt":{"rendered":" Just some thoughts about the tools and services I am using for my project. Up until the middle of the batting stats table, I had been running MySQL locally on my late 2012 MacBook Pro 15inch Retina,\u00a0maxed out with the 2.6 i7 and 16GB of RAM.\u00a0 It’s still a great machine. For a while, I… Continue reading The Tools I’m Using<\/span>