Friday, January 20, 2006

SQLGrinder 2 Beta 9 Now Available

The 9th beta version of SQLGrinder 2, the completely-rewritten version of our database development tool, was posted today.

Please see the release notes page for the full list of changes.

This release resolves a couple of recently found issues.

SQLGrinder is quickly approaching release candidate status. Please make sure that you report any remaining issues, problems, crashes, etc. so that they can be fixed. The documentation is also nearing completion as well, so the next release should have at least the first edit of it. Finally, the samples and instructions for the SQLGrinder AppleScript Dev Kit are pretty much done, so expect that soon as well.

Also, just a reminder that beta builds are full debug builds and aren't optimized for speed, size, etc. yet, and carry the usual "use at your own risk" warnings.

SQLGrinder Beta 9 can be downloaded here.

Finally, you can subscribe to the release notes page, which now has an RSS feed, to stay up-to-date on what's changed and what known issues there might be.
Pricing and availability for SQLGrinder 2

Pricing for the new version has been set at $59. During the beta period however, SQLGrinder 2 can be purchased for the current price of $49.95 with purchasers receiving a free upgrade to the final version once available. Owners of the current version can purchase an upgrade for only $19 by sending their current registration information to upgrades@sqlgrinder.com. Beta coupons will be sent out to users near the end of the beta.

SQLGrinder 2 for Mac OS X is currently available for a limited time as an unlimited beta version.

The beta of SQLGrinder 2 can be downloaded from the Advenio web site at: http://www.advenio.com/sqlgrinder/download.

Wednesday, January 11, 2006

Using SQLite with SQLGrinder 2

I've been using SQLGrinder 2 with SQLite databases for a while now. There is a very good SQLite driver made available by Tim Anderson here. The driver doesn't support every JDBC feature, and you'll need to set the compatibility mode for your SQLGrinder connections to JDBC 1, but overall it's really useful.



To use it, go to the web page above and click the "Mac OS X 10.4 JNI wrapper" link. Take the two files in the downloaded archive, named sqlite.jar and libsqlite_jni.jnilib and put them in the Library/Java/Extensions ( you may have to create these folders) folder in your home folder and restart SQLGrinder. SQLGrinder will automatically discover the driver and "SQLite" will appear in the drivers list in the login sheet.

A couple of caveats:

  1. Your database file cannot have spaces in the name, this is a JDBC thing, not a Mac or SQLite thing.

  2. The URL field in the sheet when SQLite is selected should look something like "jdbc:sqlite://Users/username/pathtodatabasefile, the URL checkbox should be checked, and no username or password are required.


Tuesday, January 10, 2006

SQLGrinder 2 Beta 8 now available

The 8th beta version of SQLGrinder 2, the completely-rewritten version of our database development tool, was posted today.

Please see the release notes page for the full list of changes.

This release resolves a bunch of issues, and adds support for triggers and sequences and Oracle's ROWID.

SQLGrinder is quickly approaching release candidate status. Please make sure that you report any remaining issues, problems, crashes, etc. so that they can be fixed.

Also, just a reminder that beta builds are full debug builds and aren't optimized for speed, size, etc. yet, and carry the usual "use at your own risk" warnings.

SQLGrinder Beta 8 can be downloaded here.

Finally, you can subscribe to the release notes page, which now has an RSS feed, to stay up-to-date on what's changed and what known issues there might be.
Pricing and availability for SQLGrinder 2

Pricing for the new version has been set at $59. During the beta period however, SQLGrinder 2 can be purchased for the current price of $49.95 with purchasers receiving a free upgrade to the final version once available. Owners of the current version can purchase an upgrade for only $19 by sending their current registration information to upgrades@sqlgrinder.com. Beta coupons will be sent out to users near the end of the beta.

SQLGrinder 2 for Mac OS X is currently available for a limited time as an unlimited beta version.

The beta of SQLGrinder 2 can be downloaded from the Advenio web site at: http://www.advenio.com/sqlgrinder/download.

Friday, January 06, 2006

Dan Wood's Story on Getting to Live "The Life"

Another interesting read, this time from Karelia's Dan Wood:

Small and Nimble- The Long Story behind Karelia's New logo

Is it just me or does Dan's conversation with Jobs sound very familiar to Panic's Cabel Sasser's own conversation in their story on the history of Audion:

Jobs to Panic: "It's like you guys are a little push-cart going down the railroad tracks, and we're a giant steam engine about to run you down."

Jobs to Wood (paraphrased): "You know those handcars, the little machines that people stand on and pump to move along on the train tracks? That's Karelia. Apple is the steam train that owns the tracks."

Tuesday, January 03, 2006

Developing Mac Applications for a Living: My Own Take on Getting to Live "The Life"

On Software DesignGus Mueller's and Brent Simmons' own stories on how they achieved indie Mac software development as a day job finally inspired me to write down my own path to getting to live "The Life," as John Gruber of Daring Fireball calls it.

First, let me start off by saying that I didn't give up my day job at first. Not for quite some time actually. When I started my first Mac application, SQLGrinder, Mac OS X had JUST reached developer preview 4. I was working for a startup at the time, a company called Abuzz (which was purchased by the New York Times about a year before this time period), but things were starting to wind down. The Dot.com bubble had burst, and the Times had decided that they had spent enough money and were going to shut us down. So, with shutdown severance in hand, I spent the next 8 months learning Cocoa and OS X, and building SQLGrinder, which was released in August of 2001. SQLGrinder did OK. Not super-great, but well enough to encourage me to put more work into it, which I think is all you can hope for with a brand new version 1.0 product. Because it didn't do well enough to give up having a day job, back to work I went. For about a year I toiled working for someone else, improving SQLGrinder at night and during weekends, and putting money aside. I still knew that I'd do the full-time Mac thing at some point, so I went about banking as much money as was possible.

At the end of this next year, the company I was working at was having financial difficulties, so they cut 15% of their staff, a portion which included me. Again I had an opportunity to switch to doing my own Mac development full time, but the timing still wasn't right. I knew that one product was not going to be enough to support me, and SQLGrinder, which is kind of a niche app to begin with, was a long way from replacing my day job. Back to working for someone else I went, again.

I love to cook, and at some point in 2004 I decided I needed to organize my recipes in a way that was better than the system I was using at the time. I was pretty much just building a collection of text files, web pages etc. and knew that there had to be a better way to do this kind of thing. I looked at the available applications back then. There was, I think, one that was written in Cocoa (if it was even Cocoa, I'm not sure) and the rest were FileMaker applications. None fit my needs. Like any good software engineer, I decided to write my own application. I had already started rewriting SQLGrinder in Objective-C (as an aside, the first version, because I knew Java extremely well and Cocoa/Objective-C not at all, was written in Java Cocoa), so I knew it pretty well, and knew Cocoa very well. The application came together quickly, despite some temporary health issues that Summer, and in August of 2004, MacGourmet 1.0 was released. Development time had taken away from SQLGrinder, but MacGourmet was immediately a better seller, so that seemed like a good tradeoff, especially because SQLGrinder is a lot more expensive to develop (in time and resources).

With two applications now, I was starting to take the idea of doing my Mac development full time. I had essentially been working 2 full-time jobs for a long time, and it was starting to take its toll. Something had to give. Some contract work came along, and lasted longer than I expected. The job and money were good though, but by the end, I had pretty much decided that with one application selling well, and another that was heading towards an all-new version 2, that this was the time to take the plunge. It was time to live "The Life."

I didn't need a company. My friend Stephan (who does MacXword, among other things) and I had already set up Advenio as an LLC. But taking the next step did more or less require me to change my current living situation. I was living just outside of Boston, which is easily one of the most expensive places to live, and this had to change. To cut my burn rate, and make my revenue stream have more "oomph", I moved back to the city where I grew up, and where most of my family still lives, Lewiston, Maine, which is not too far from Portland. Big change, but I essentially cut my expenses in half, which was great.

So here I am. I'm now trying to finish up SQLGrinder 2, and am also doing work on MacGourmet 2. Additionally, I have some other ideas I'm chomping at the bit to start on, so I'd say things are good, at least for now. How long will I be able to live like this, and do this for a living? I have no idea. Right now though, it's a pretty fun ride, and even though I took a sizable pay cut, working for myself can't be beat, so it's all definitely been worth it.