Elevate Software BlogProduct Status Updates for April 2018
Posted by Tim Young on Tue, Apr 10 2018
Things have been very quiet around here lately, so I thought I would update everyone on the status of Elevate Web Builder, ElevateDB, and DBISAM, as well as give more information on some general changes occuring here at Elevate Software.
Elevate Web Builder 3
Elevate Web Builder 2.07 (more information here: Progress Update on Elevate Web Builder 2.07 has now become Elevate Web Builder 3, due to the sheer number of features being added. However, once Elevate Web Builder 3 is released, it will not be a major release upgrade and only require that you have an active Elevate Web Builder subscription (I will be blogging about the upcoming changes to our support policy in conjunction with subscriptions soon). Since switching to a subscription model several years ago, we have been avoiding doing any major releases due to the fact that our internal systems need some changes to accomodate major version upgrades being included with subscriptions. But, we have now fixed those issues and will be doing more major upgrades going forward.
Work is progressing nicely on Elevate Web Builder 3 and is starting to hit the "downhill" phase of the project where things are rapidly coming together. Hopefully, it won't be much longer than the end of April or beginning of May when we can release a public beta. At this point, the quality of the beta looks like it may be more alpha than beta, but most of the rough edges will be missing features in the run-time for the server-side applications, and those features will be filled in pretty quickly during the beta. I apologize for all of the delays so far, but there have been several unforeseen issues that have extended the development time quite a bit. In particular, the IDE re-write took a few months and was not originally planned at all, but was necessary in order to get the IDE in a position to be able to support multi-mode (client and server) development.
ElevateDB 2.28
ElevateDB 2.28 is now in public beta and should be released in the next week. ElevateDB 2.28 includes the following breaking changes and features:
2.28 Breaking Changes
The following are breaking changes in 2.28:
The following are the new features in 2.28:
The new buffered file I/O and SQL statement/function/procedure caching are pretty significant improvements to the engine and can increase performance by up to 50% or more, depending upon the workload and how the client applications use the ElevateDB Server. These are attributes that will determine how well these improvements work for you:
DBISAM
DBISAM hasn't been getting much attention lately, and we will be rectifying this after Elevate Web Builder 3 is released. Later on in the year, we will be doing a thorough facelift on DBISAM to bring it up-to-date in terms of its UI, help management, and more. In terms of core improvements, our main goal is to get Unicode field support into the product and improve some core functionality, such as the socket handling, in order to bring it more in line with ElevateDB and Elevate Web Builder 3.
ElevateDB 2.27 Released
Posted by Tim Young on Thu, Jan 11 2018
ElevateDB 2.27 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.
The complete list of breaking changes and new features is below.
2.27 Breaking Changes
The following are breaking changes in 2.27:
The following are the new features in 2.27:
Elevate Web Builder 2.06 Build 11 Released
Posted by Tim Young on Tue, Nov 28 2017
Elevate Web Builder 2.06 Build 11 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions. This build contains several bug fixes, which are detailed here.
Progress Update on Elevate Web Builder 2.07
Posted by Tim Young on Mon, Nov 27 2017
I just wanted to take some time to update everyone on the (now) very-late 2.07 update to Elevate Web Builder and solicit some comments on potential areas of improvement in the IDE. I also figured that I would do this in a proper blog post, primarily because I don't blog enough about what's going on here at Elevate Software and this is an effort to change that.
To recap, Elevate Web Builder 2.07 will be quite a big update for a minor release. In fact, it's essentialy a major release crammed into a minor release. The list of improvements include:
Thanks very much for your feedback.
ElevateDB 2.26 Build 7 Released
Posted by Tim Young on Fri, Nov 24 2017
ElevateDB 2.26 Build 7 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions. This build contains several important bug fixes, which are detailed here.
ElevateDB 2.26 Build 6 Released
Posted by Tim Young on Mon, Oct 30 2017
ElevateDB 2.26 Build 6 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.
This build contains one important bug fix:
# 4590 Querying an Updateable View with Sub-Query SELECT Expressions Can Cause AV
Previous Entries: 1-6 7-12 13-18 19-24 25-30 31-36 37-42 43-48 49-54 55-60 61-66 67-72 73-78 79-84 85-90 91-96 97-102 103-108 109-114 115-120 121-126 127-132 133-138 139-144 145-150 151-156 157-162 163-168 169-174 175-180 181-186 187-192 193-198 199-204 205-210 211-216 217-222 223-228 229-234 235-240 241-246 247-252 253-258 259-264 265-270 271-276 277-282 283-288 289-294 295-300 301-306 307-312 313-318 319-324
Posted by Tim Young on Tue, Apr 10 2018
Things have been very quiet around here lately, so I thought I would update everyone on the status of Elevate Web Builder, ElevateDB, and DBISAM, as well as give more information on some general changes occuring here at Elevate Software.
Elevate Web Builder 3
Elevate Web Builder 2.07 (more information here: Progress Update on Elevate Web Builder 2.07 has now become Elevate Web Builder 3, due to the sheer number of features being added. However, once Elevate Web Builder 3 is released, it will not be a major release upgrade and only require that you have an active Elevate Web Builder subscription (I will be blogging about the upcoming changes to our support policy in conjunction with subscriptions soon). Since switching to a subscription model several years ago, we have been avoiding doing any major releases due to the fact that our internal systems need some changes to accomodate major version upgrades being included with subscriptions. But, we have now fixed those issues and will be doing more major upgrades going forward.
Work is progressing nicely on Elevate Web Builder 3 and is starting to hit the "downhill" phase of the project where things are rapidly coming together. Hopefully, it won't be much longer than the end of April or beginning of May when we can release a public beta. At this point, the quality of the beta looks like it may be more alpha than beta, but most of the rough edges will be missing features in the run-time for the server-side applications, and those features will be filled in pretty quickly during the beta. I apologize for all of the delays so far, but there have been several unforeseen issues that have extended the development time quite a bit. In particular, the IDE re-write took a few months and was not originally planned at all, but was necessary in order to get the IDE in a position to be able to support multi-mode (client and server) development.
ElevateDB 2.28
ElevateDB 2.28 is now in public beta and should be released in the next week. ElevateDB 2.28 includes the following breaking changes and features:
2.28 Breaking Changes
The following are breaking changes in 2.28:
- Large file support is now enabled by default in ElevateDB. Along with this change, the TEDBEngine LargeFileSupport and TEDBSession LocalLargeFileSupport properties have been removed.
These are published properties, so please be sure to open, ignore any warnings about these properties being absent, and re-save any forms or data modules that use the TEDBEngine or TEDBSession components to ensure that you do not see any runtime component persistence errors in your application(s). - The TEDBEngine ExclusiveFileAccess property has been removed and replaced with the TEDBEngine BufferedFileIO property. Please see the new features in 2.28 section below for more information on the new buffered file I/O functionality in ElevateDB.
The following are the new features in 2.28:
- ElevateDB now includes new global buffered file I/O functionality. There are new TEDBEngine BufferedFileIO, BufferedFileIOSettings, and BufferedFileIOFlushInterval properties for configuring the buffered file I/O in the engine. Please see the Buffering and Caching topic in the SQL manual for more information.
- ElevateDB now includes new SQL statement and function/procedure caching functionality. There are new TEDBSession SQLStmtCacheSize and FuncProcCacheSize properties for configuring the caching, as well as the TEDBSession FreeCachedSQLStmts and FreeCachedFuncProcs methods for freeing cached SQL statements and functions/procedures. Please see the Buffering and Caching topic in the SQL manual for more information.
- There are two new system information tables, the FileIOStatistics table, and the SessionStatistics Table table.
The new buffered file I/O and SQL statement/function/procedure caching are pretty significant improvements to the engine and can increase performance by up to 50% or more, depending upon the workload and how the client applications use the ElevateDB Server. These are attributes that will determine how well these improvements work for you:
- If your databases are particularly large and routinely contain table files that are in excess of 25-30GB of data, then the new buffered file I/O can improve performance by up to 10-20% over the existing model by allowing you to more accurately fine-tune the way that I/O is performed by ElevateDB and, consequently, the way that ElevateDB interacts with the operating system and disk hardware.
- If your application uses a lot of triggers and/or executes a lot of duplicate SQL statements, then the new SQL statement and function/procedure caching can improve performance by up to 30-40% by eliminating a lot of the overhead from SQL statement/function/procedure preparation. This is especially true with client applications that use session/statement pooling where SQL statements/functions/procedures cannot be manually prepared and cached by the client application for multiple executions.
DBISAM
DBISAM hasn't been getting much attention lately, and we will be rectifying this after Elevate Web Builder 3 is released. Later on in the year, we will be doing a thorough facelift on DBISAM to bring it up-to-date in terms of its UI, help management, and more. In terms of core improvements, our main goal is to get Unicode field support into the product and improve some core functionality, such as the socket handling, in order to bring it more in line with ElevateDB and Elevate Web Builder 3.
| Tags: Elevate Web Builder, ElevateDB, DBISAM, Status Update | Permanent Link • 8 Comments |
ElevateDB 2.27 Released
Posted by Tim Young on Thu, Jan 11 2018
ElevateDB 2.27 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.
The complete list of breaking changes and new features is below.
2.27 Breaking Changes
The following are breaking changes in 2.27:
- The XML output from the EXPORT TABLE SQL statement now includes a top-level "table" element in order to properly adhere to the XML specifications and allow exported XML files to be properly validated.
The IMPORT TABLE SQL statement can still import XML files formatted with or without the top-level "table" element. - Comparisons between timestamp values and date values now ignore the time portion of the timestamp value and only compare the date portion of the timestamp value with the date value. This means that you can now execute queries like the following:
SELECT * FROM MyTable WHERE TimeStampColumn = DATE '2017-10-17'
and the query will return all rows where the TimeStampColumn column contains a timestamp value whose date portion matches the specified date constant value. - As indicated in incident report #4609:
# 4609 Default Expressions for DECLARE SQL/PSM Statements Not Being Properly Type-Checked
default expressions for DECLARE SQL/PSM statements were previously not being type-checked properly, so you may see new type errors during compilation of routines that do not specify correct default expressions for a given variable type.
The following are the new features in 2.27:
- New VCL TEDBDataSet Import and Export methods have been added to allow for the import/export of files to/from TEDBTable, TEDBQuery, TEDBScript, and TEDBStoredProc components.
- A new LOG EVENT SQL/PSM statement has been added in order to allow SQL/PSM routines (scripts, procedures/functions, triggers, and jobs) to log information, warning, and error events directly to the logged events for the current ElevateDB configuration.
- There are new VCL TEDBEngine AddDayTimeToDateTime, AddDayTimeToTime, AddYearMonthToDate, AddYearMonthToDateTime, SubtractDateFromDateAsDayTime, SubtractDateFromDateAsYearMonth, SubtractDateTimeFromDateTimeAsDayTime, SubtractDayTimeFromDateTime, SubtractDayTimeFromTime, SubtractTimeFromTimeAsDayTime, SubtractYearMonthFromDate, and SubtractYearMonthFromDateTime methods that allow for basic interval math directly from native code, in addition to SQL.
- As noted above in the breaking changes section, you can now directly compare the date portion of timestamp values with date values.
- ElevateDB now logs warning events to the logged events for the current ElevateDB configuration when a database is opened and the database path does not exist, or if the database catalog does not exist.
- The ALTER INDEX and ALTER TEXT INDEX SQL statements no longer alter the entire index when only the description is changed.
| Tags: ElevateDB, New Releases | Permanent Link • 0 Comments |
Elevate Web Builder 2.06 Build 11 Released
Posted by Tim Young on Tue, Nov 28 2017
Elevate Web Builder 2.06 Build 11 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions. This build contains several bug fixes, which are detailed here.
| Tags: Elevate Web Builder, New Builds | Permanent Link • 0 Comments |
Progress Update on Elevate Web Builder 2.07
Posted by Tim Young on Mon, Nov 27 2017
I just wanted to take some time to update everyone on the (now) very-late 2.07 update to Elevate Web Builder and solicit some comments on potential areas of improvement in the IDE. I also figured that I would do this in a proper blog post, primarily because I don't blog enough about what's going on here at Elevate Software and this is an effort to change that.
To recap, Elevate Web Builder 2.07 will be quite a big update for a minor release. In fact, it's essentialy a major release crammed into a minor release. The list of improvements include:
- The IDE has been given a facelift and looks quite a bit different in several ways. Part of this is due to the need of starting the process of making the IDE high-DPI aware, and the other part is the need to improve the look and feel of the IDE, especially in terms of negative space and ease-of-use. The new IDE tries very hard to make sure that what one needs is only a single click or keystroke away, whether it be recent projects or saving debug messages to a text file.
- The web server has also been given a facelift, in addition to several other major improvements listed below. There isn't a user interface for the web server anymore, and instead all administration is performed through the IDE or via a web interface. You can still run the web server as an interactive console process for development purposes, but it is primarily designed now to run exclusively as a service without a user interface.
- The web server now includes built-in SSL support. The first platform supported will be Windows, of course, so I have implemented the SSL support using the Windows crypto API. This will make things easier to deal with in terms of Windows security updates and improvements, and allow administrators to control how the web server works in terms of which crypto cipher suites are used, as well as which base versions of SSL/TLS are used. And all of this can occur without the developer needing to configure anything in the web server itself, making deployments much easier. Other future platform targets will use the OpenSSL libraries.
- The web server now includes built-in GZip support. This will greatly improve the Elevate Web Builder client application loading performance over slow connections (mobile), especially when updates to the client applications are deployed.
- The web server now includes support for loading and executing server-side applications that use the Elevate Web Builder runtime. The runtime is an interpreted Object Pascal execution environment that has been present in the IDE since Elevate Web Builder 2.00, but has only been used for design-time execution of code. It has been updated to include functionality for working with web server requests, files, HTML, and more. What this means is that 2.07 will allow you to create and deploy server-side applications in much the same way that you do now for client applications that run in a browser.
- The IDE now includes support for creating server-side applications that use the Elevate Web Builder runtime available in the web server. The server-side applications are monolitic and self-contained, so there are no dependency issues. The server-side applications are also compressed, and can be encrypted in order to keep the code secure.
Thanks very much for your feedback.
| Tags: Elevate Web Builder, 2.07 Progress Update, Server-Side Applications | Permanent Link • 37 Comments |
ElevateDB 2.26 Build 7 Released
Posted by Tim Young on Fri, Nov 24 2017
ElevateDB 2.26 Build 7 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions. This build contains several important bug fixes, which are detailed here.
| Tags: ElevateDB, New Builds | Permanent Link • 0 Comments |
ElevateDB 2.26 Build 6 Released
Posted by Tim Young on Mon, Oct 30 2017
ElevateDB 2.26 Build 6 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.
This build contains one important bug fix:
# 4590 Querying an Updateable View with Sub-Query SELECT Expressions Can Cause AV
| Tags: ElevateDB, New Builds | Permanent Link • 0 Comments |
Previous Entries: 1-6 7-12 13-18 19-24 25-30 31-36 37-42 43-48 49-54 55-60 61-66 67-72 73-78 79-84 85-90 91-96 97-102 103-108 109-114 115-120 121-126 127-132 133-138 139-144 145-150 151-156 157-162 163-168 169-174 175-180 181-186 187-192 193-198 199-204 205-210 211-216 217-222 223-228 229-234 235-240 241-246 247-252 253-258 259-264 265-270 271-276 277-282 283-288 289-294 295-300 301-306 307-312 313-318 319-324
Tags2.07 Progress Update, ADUG, Beta, Blasts from the Past, Built With, C++Builder, Case Study, Casual Friday, CodeRage, Congratulations, DBISAM, Delphi, Delphi XE2, Distribution, Distributors, DLLs, Elevate Web Builder, Elevate Web Builder 2, ElevateDB, Embarcadero, Example Application, External Modules, Free Pascal, holiday, Holidays, Introductory Offer, JavaScript, Lazarus, license renewals, Linux, Logos, Migrations, Mirroring, New Builds, New Releases, PHP, Pre-Ordering, Preview, Promotions, RAD Studio 10.3 Support, Replication, Roadmap, Server Hard Drive Failure, Server-Side Applications, Starter Editions, Status Update, Subscriptions, Support, Support Costs, Support Sessions, Technical Article, Threads, Update, Upgrade, Upgrade Pricing, Upgrades, Video Tour, Web Builder, Web Site, Where In The World Is, Windows CE, Windows Mobile
This web page was last updated on Friday, December 15, 2023 at 08:56 AM | Privacy Policy Site Map© 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ?  E-mail us at info@elevatesoft.com |
