Tuesday, September 29, 2009

REALSQLDatabase/SQLite Update

We had originally planned to update the REALSQLDatabase class to use the latest version of SQLite in REALbasic 2009 R4 (released today). The work was done but we also took the time to substantially overhaul the internals of the REALSQLDatabase class. We reduced the amount of code by quite a bit making it easier for us to maintain and made it faster as well. Unfortunately, the side effect of such a big change is that it requires more testing time and it was ready too late in the beta cycle for us to feel comfortable releasing it for R4.

The good news is that we are planning to have another release this year primarily to ship the updated REALSQLDatabase class.

9 comments:

Anonymous said...

SQLite is moving target and I know you have to freeze the version you are working with at some point.

So when you say current version what do you mean?

The most recent version of Sqlite is 3.6.18 and was released on September 11. That version added support for recursive triggers.

Will it be that version or 3.6.17 that was released August 10th, or a new one that may come out before the RB update is released or an earlier one?

Geoff Perlman said...

It will likely be 3.6.17. However, since we will have some time before the R5 release, we will be looking at 3.6.18 to determine if it makes sense to update to that now.

Steve Garman said...

@Geoff, according to my calculations, the 90 day cycle requires another release this year anyway.
When you say "The good news is that we are planning to have another release this year", are you referring to an extra release?

Aaron said...

Please add math functions along with this update.

Geoff Perlman said...

Hi Steve,

No, I'm just pointing out that there will be another release most likely in early December.

Ed M said...

What about the issues with RealServer? I still have a customer that can't use it on a Windows 2003 server without it locking up... Real tech's say they've got a fix but it's not available yet....

Simon Larkin said...

Version 3.6.1.9 - Please!!! Foreign Key support would be a great benefit. And as Aaron says - math functions - nice!

Geoff Perlman said...

That is the version of SQLIte we have updated to for REALbasic 2009 R5.

Fred Roller said...

SQLite 3.6.20 was released on November 4th and more updates may come between now and R5. We would prefer to see the latest version of SQLite in R5 when it's released but understand that time is needed for testing each new release of SQLite. Since new SQLite versions are released even more rapidly than REALbasic and REALServer, please make every effort to get the latest possible version of SQLite into your products when they're released. We accept that it may be the latest version but the later the better. Thank you.