VistaDB 3.0 CTP update posted

Nov. 13th, 2006

VistaDB 3.0 update has been posted for all 3.0 customers. Download VistaDB 3.0 here.:

VistaDB 3.0 CTP Update List

• ALTER command is now implemented. This means you can change a schema via code using SQL and DDA and also alter a database using Data Builder.
• Some optimization for SQL has been implemented resulting in big performance gains for Views and various SELECT commands. Some SQL statements run 10x faster.
• Data Builder has a new SQL Editor form that generates the SQL for a database (ie. reverse engineer a database). This form/module is still Beta so double check the output carefully before using the generated code. Future builds will allow options such as selecting what objects to generate the SQL for and what data to include if any (e.g. Schema, Data, Schema and Data options). The form generates SQL for both Schema and Data in this build
• Support for EntitySpaces is close to complete. (See here for the original announcement). We are communicating with Mike Griffin at EntitySpaces regularly and expect that by this week, EntitySpaces support for VistaDB 3.0 will be implemented. EntitySpaces is waiting for us to expose Transaction Processing in 3.0 to provide full support.
• The various informal bug reports on 3.0 posted on our support forums have been addressed, including:
  • Added support for STDDEV
  • Constraints issues have been fixed
  • VistaDBParamater.Add now returns a standard type