Announcing SQLVue 4.0

SQLVue 4.0 is now available.

SQLVue is a new, elegant IDE for SQLite developers. You can purchase it through the Mac App Store at a special introductory price of $9.99 through April 15th.

2011 ARBP Real Studio Summit Recap

This past weekend (March 19th and 20th) in Atlanta, about 50 or so people attended the 2011 Real Studio Summit. If you weren’t there, you missed out on a great event for Real Studio Developers.

(more…)

Real Studio 2011 Release 1 Now Available

Today Real Software shipped Real Studio 2011 Release 1. The first thing you might notice is that Real Software is no longer spelled in all caps as REAL Software. And Real Studio is no longer REAL Studio. Minor changes to be sure, but I think this new branding looks more professional.

More importantly, Real Studio 2011 Release 1 has a large number of fixes for both Cocoa and Web Edition. Cocoa still has the beta tag associated with it, but I’ve found that it works much, much better than before. I now have three projects that seems to work perfectly fine when built for Cocoa (up from 0 in prior releases).

This release also includes the CGI deployment option for web applications. This is intended to replace the FastCGI deployment option, which was pretty tricky to configure on many hosts. The CGI deploying purports to be easier and in my testing it so far has been. There are other web fixes as well.

Be warned that web projects saved in Real Studio 2011 cannot be opened in Real Studio 2010 Release 5.1, not that you would want to given all the web edition changes.

REAL Studio Developer Magazine 9.3

The latest issue (9.3 – March/April 2011) of REAL Studio Developer Magazine is now available. In my Databases column, I talk about various ways to use SQLite as a server.

Also debuting in this issue is my new column on web development with REAL Studio Web Edition.

Check it out!

REAL Studio Developer Magazine

Detecting 64-bit Windows

While testing, we discovered a REAL Studio app for a client was acting odd when running on Windows 7 64-bit.  The HTMLViewer control was causing odd exceptions and crashing the app.

After a bit of research I figured out that if I instead updated the HTMLViewer from a timer, rather than directly when the window was opening, the crashes went away.

But the timer introduced a slight delay before the HTML appeared so I didn’t want to have all versions of the app work this way.  Of course, I could easily restrict it to Windows by using a compile constant:

#If TargetWin32 Then
...
#Endif

But this catches all versions of Windows, 32-bit and 64-bit. This is because all REAL Studio applications are 32-bit applications regardless of which version of Windows they are running on.
(more…)

RBDevZone gets a new server

As part of my researching of virtual private servers (VPS) for use with REAL Studio web edition, I have now settled on one: HostRail.com

Their prices are fabulous, their support is great and their servers run well. I’ll have more to say about their server and how I set it all up to host REAL Studio web apps, multiple web sites, Subversion and REAL Server (SQLabsServer).

As a first test, I have moved RBDevZone from BlueHost to my VPS at HostRail. Already, the web site seems faster. And of course, I can now host REAL Studio web applications on this VPS. Check out my WebAppTest application.

If you notice anything missing from the site, please let me know!

DreamHost with REAL Studio Web Edition

Sample REAL Studio web app running on DreamHost: http://www.pharmacaidonline.com/WebAppTest.fcgi

Also refer to my earlier post, Deploying Web Apps with REAL Studio Web Edition.

DreamHost offers a free one week trial of their VPS offering, so I decided to give it a try. Their setup is a bit unique. First, you have to create an account and then add the regular hosting plan ($9/month) to it. This is a “shared hosting” account so don’t expect REAL Studio WE to work with it. Next you have to add a VPS to your account (clicked Enable VPS Service) in the VPS section of the control panel. It can take up to a day for your VPS to get added to your account. Once your VPS is set up, you need to move your domain to it, which you can do by clicking Manage Domains in the Domains section. This can take up to 6 hours for the DNS to propogate (it took almost exactly 6 hours for me). DreamHost gives you 1 week free to test out the VPS. Hopefully with these instructions you can get up and running quickly. Their VPS plans start at an addition $15/month depending on RAM that you require. It would be wise to do some serious load testing of your web app during the free week to see what you might need for RAM.
(more…)

Deploying Web Apps with REAL Studio Web Edition

Yesterday, REAL Software released REAL Studio 2010 Release 5. The big new feature for this release is that it now includes Web Edition, at least for those that own an Enterprise Edition license. If you don’t have Enterprise, then you can purchase WE for $600, but it probably makes the most sense to just upgrade to Enterprise.

Web Edition is pretty impressive for a 1.0 product. You can quickly build web apps using your existing REAL Studio skills. However, I’ve seen a lot of questions about how to run your web apps outside the IDE. There are three ways to do that: Standalone, Dynamic FastCGI and Static FastCGI. You can choose which to build in the Web tab of the Build Settings window. Static FastCGI is such a pain to configure that I’m not sure why it’s even there, so I won’t be discussing it.
(more…)