The main focus of this release is table schema editing. As SQLite does not natively have the ability to alter table schemas, it is a multi-step process (create new table, copy old data across, delete the old table) and I’m very pleased to finally have such an important feature in the app.
Update 2009-05-31
PayPal have now restored access to payment processing. All should hopefully be normal now.
As anyone who has tried to buy Base since Friday (28 May 2009) has noticed, I'm currently unable to accept payments and hence process any sales. This is because PayPal has noticed that I had not fully verified my details with their system to prove I'm not some sort of international fraudster. Which I'm not.
It’s good that they do check people out. Their system as a whole would collapse without a decent level of scrutiny. However in my case, I don’t feel they’ve applied much common sense to the matter. Example:
I’m very happy to announce that our first foray into iPhone development has been released. Jezz is a game for the iPhone and iPod Touch, closely based on the old game of Jezzball. To complete each level, you must claim 70% of the playing field by building walls. If a wall in progress is hit by a ball, the wall is destroyed and you lose a life. Each level becomes more difficult through adding more and destructive balls.
Well, Base 1.2 has been out for just over a week now, so I figured it’s time for an update.
So far, the app seems to have had a pretty good reception. Thank you to everyone who has taken the time to contact me with feedback (especially those who have sent detailed bug reports). For the most part, complaints and requests have centered around one area: the editing of existing tables.
Now that the Christmas / new year festivities are out of the way it’s time for an update on how Base development is coming along. The next release - version 1.2 - will have some useful changes being made, though there isn’t a predicted release date yet. The three things I’d like to pick up on are:
There have been some pretty heavy changes to this site in the last couple of days. Hopefully they shouldn’t actually be very visible. The biggest change has been installing Wordpress to power this blog.
The original blog was self-made using Ruby on Rails and was a very simple affair that started accumulating huge amounts of comment spam and was lacking some features I wanted (namely file uploading and easy archive browsing). Integrating Wordpress (a php-based system) with my Rails site was not actually that difficult. For those who are considering doing this, you will just need a mod_rewrite rule to redirect /blog/ to the Wordpress index.php file. The tricky part was realising that Dreamhost disable mod_rewrite when you use Passenger to power Rails as poorly crafted rewrite rules can break Passenger. However they are very helpful and will enable it for you after explaining what not to do.
I’m pleased to announce that the first public application from Menial has been released. Base is an SQLite 3 database reader/editor for Mac OS X and more details can be found at it’s product page.
17th November, 2008:
Unfortunately there was a problem that slipped through testing before release. When a license file was opened, the app would not register that license. To fix this, just re-download the app from this page and double-click your license file again.
Got a couple of pieces of AppleScript for starting and stopping Apache and MySQL which are too small to be worth posting as downloads. I don’t use these any more, but they were handy for custom installs of Apache/MySQL.
Starting:do shell script “/sw/sbin/apachectl start” password “MY_PASSWORD” with administrator privileges do shell script “/usr/local/mysql/bin/mysqld_safe > /dev/null 2>&1 &” password “MY_PASSWORD” with administrator privileges