Archive for February, 2008
How To Add a System Tray Icon For TortoiseSVN
Posted on February 27, 2008, under Development, How To, Software, Tools and Services.
TortoiseSVN is arguably the best SVN client for Windows, my favorite for sure. The only negative aspect he program comes with is that TSVNCache.exe becomes very large in memory over time. This process keeps a cached state of your folders under source code control.
There is a way of putting an icon in the system tray which allows you to gracefully exit this app from time to time, not allowing it to get that large. This trick is documented in the hidden registry features of TortoiseSVN.
Fairly simple if you know your way around the registry. All you have to do is create a DWORD value under "HKCU\Software\TortoiseSVN\CacheTrayIcon" and set it to 1.
Presto! A System tray icon.
No Comments
Easy MySQL Backups on a Windows Server
Posted on February 27, 2008, under Code Snippets, How To, IIS, Software, Windows.
During the re-launch of BlueCrestStudios we moved to a Windows server. It was part of our initiative to take things back to our roots, and make things simpler. Because we run a fair amount of PHP applications we went with MySQL as our database. MySQL comes with a great little application called "mysqldump" which simply enough dumps your data to a SQL file. This little tool, combined with the free and great 7Zip makes for simple and great database backups. It’s best to dump your database onto a separate drive then where the data is stored, offers a little redundancy.
Now before we get started, I know some of you are thinking there is no need for this if you hosting company does backups. True, yes any good hosting company should do regular backups of all your data. However, I find it good to have a dump of our databases for that oops situation, and not involve the hosting company if we need to recover a database or table or row. In addition, you can schedule dump every other hour, or more regularly then your hosting company does backups.
So here is our script, let’s see what we are doing here:
1: set ARCHIVE=E:\Backups\MySQL\%DATE%.zip
2: set FILE=E:\Backups\MySQL\Backup.sql
3: DEL %ARCHIVE% /f /q
4: "C:\Program Files\MySQL\bin\mysqldump.exe" –all-databases –user=YOURMYSQLUSER –password=YOURMYSQLPASS > %FILE%
5: "C:\Program Files\7-Zip\7z.exe" a -tzip %ARCHIVE% %FILE%
6: DEL %FILE% /f /q
Basically we are dumping the database daily here, to an archive that holds the day of the week. The variable "ARCHIVE" holds to archive for today that will be created. The "FILE" variable holds the temporary dump file before we compress it, it is deleted after the compression just to clean up after ourselves.
- Line 3, we are deleting the current backup archive just incase.
- Line 4, we are doing the actual dump. You need to set your mysql user and password , a note do not use root!
- Line 5, we are doing the actual creating of the archive. SQL dump files compress very well, so this is a space saver step.
- Line 6, we are deleting the temporary backup file as mentioned above.
The tactics above can be enhanced greatly, as you can do dumps based on database, time, and get very elaborate on this. As an extra step I am using my Windows Home Server to download the dump nightly via FTP. Simple, elegant, fairly robust, and useful.
No Comments
Adobe’s AIR: The Good Comes With Bad
Posted on February 25, 2008, under Adobe AIR, Development, Software, Tools and Services.
One my favorite morning reads, ReadWriteWeb has a great article about Adobe’s AIR technology. For those not familiar, AIR stands for Adobe Integrated Runtime, and is a cross platform, code once run everywhere, light weight platform for applications. It holds a lot of advantages over other similar platforms. It’s two strong points in my eyes are: 1) it’s sexy looking, which is always a plus for end users. 2) It is easy to program in, especially for those who have worked with other Adobe products and technologies.
However my first experience with AIR was similar to some of my frustrations with .NET desktop applications. I was on the beta program for Pownce, which is written completely in AIR on the desktop side. I went and downloaded AIR, and naturally got the latest version from Adobe. Went to install the Pownce application and it said I needed an older version of AIR, immediately I was derailed. This happens more often than not with these "platforms", developers compile to a certain version of the platform and managing more than one version is a nightmare. Additionally, the last thing you want for a potential customer or user of your product is one more step before they can use your application; especially if that step is going to download another version of .NET or AIR. It’s the main reason I do not code in .NET for BlueCrestStudios.
I understand that with AIR it is just getting it’s official start out of Adobe labs, so it may not hold much weight here, we will see in the future. I hope that Adobe learns from others mistakes and makes the platform backwards compatible, easily distributable within AIR applications, and able to have more than one version installed if developers are going to be compiling against a certain version.
All in all, I think it has great potential, and will definitely be working it into future projects.
No Comments
Is There No "Try" in "Free Trial"?
Posted on February 19, 2008, under Software, Tools and Services.
With the revamp and release of BlueCrestStudios product line right around the corner, I am paying extra detail to user experience as we polish off the corners and get things ready to go. When you are in development mode, user experience can slide a little as you are mainly concerned about just getting the software working. I would rather be late to the market and get it correct, then early or on time and wrong.
Free trials and demos are a key part to new customers, something that I will admit I have taken the wrong approach on over the years. It’s natural to release a trial application that is locked down, doesn’t have all of the features, and only gives you a glimpse of how the application will behave if and when the user becomes a customer.
I recently had this experience with Stamps.com. I have be eyeing up stamps.com for about three months now. Lately I have been backlogged on items I need to mail out. Free welcome package to get me started, free digital scale, and 30 day money back. What could be better? Well then I get the welcome email. My welcome package has been sent, and I should get it in as soon as one business day. The digital scale, however; well I have to wait 30 days for my voucher and then pay shipping and handling. I understand that this is to prevent customers from canceling the service and making off with the scale, but I also find out that even if I wanted to stay a customer and keep using the service happily for years to come; I would still have to wait 30 days to apply for the scale.
Why is this a big deal? Well because I have packages to mail… now… not in 30 days. And in 30 days if I get the scale, and find out it’s a huge pain to mail packages, and the scale doesn’t work, and it killed my dog, and my girlfriend left me; and this whole Stamps.com thing just isn’t working out; I can’t get my money back.
Solution? Send the scale out, get the customer that still has an easy out using and loving the software. Get them thinking that it’s the best thing since slice bread. Then if within 30 days on the off chance that they do not like the service, let them know they have to return the scale or they will be charged for it.
It saves me from having to go to Amazon.com and use my Prime account to get a certified scale sent overnight to me. The only reason I did this was because it was a certified USPS scale vs. the one that Stamps.com gives you, and it had a higher weight tolerance. Still, not something you want customers to have to do.
No Comments
Back Up and Running
Posted on February 16, 2008, under Site News.
We are in the final week(s) of relaunching BlueCrestStudios, and I have had some time lately to overhaul Code and Coffee. New theme, and new content to come soon. Looking forward to it.
No Comments
Server Change
Posted on February 8, 2008, under Site News.
In the process of relaunching BlueCrestStudios and Code and Coffee there will be a server and DNS change happening in the next week. Thanks.
No Comments
