It's a big step for Foxhound when a new version of SQL Anywhere is released.
First, Foxhound has compile on Version 12, then it has to run properly against target databases created with versions 5.5 through 11.
What is Foxhound? It's a database monitor and schema display utility for SQL Anywhere databases, currently in development with its own beta planned for 2010.Foxhound also has to recognize target databases created with version 12, and then it has to work properly with those target databases... it's one thing to get Foxhound to stop rejecting "12" as a database version number, quite another matter to get Foxhound to handle version 12's enhancements and behavior changes.
But, first things first: Foxhound compiles cleanly on the SQL Anywhere version 12 beta with no code changes, and it passes a simple smoke test.
Woohoo! That's no mean feat... virtually all of Foxhound is written in SQL...
- 80,000 lines of rather funky Watcom SQL, up from 60,000 lines a year ago,
- 200 web services, procedures, events and triggers,
- 340 tables and views with 2600 columns, plus
- 1,300 lines of C in 9 external procedures.