Delphi XE8 video

PostgresDAC new release
Microolap released the new major version 3.0.0 of PostgresDAC component suite.
It introduces Fetch-On-Demand asynchronous mode for TPSQLQuery, support for
built-in range types, support for geometric types.
New major 3.0.0 version introduces Fetch-On-Demand asynchronous mode for TPSQLQuery, support for built-in range types, support for geometric types.

Meet the PostgresDAC v3.0.0

03/03/2015 We've released our new major version of PostgresDAC component suite. It’s been a long way started almost two years ago. The goals were complicated, and not all of them were accomplished. However, in general we may proudly say without a doubt that this release is a significant milestone.

Dump and restore functionality

TPSQLDump and TPSQLRestore components is a pair that is one of a kind on the whole market. There are no more such facilities not only in the Delphi or C Builder world, but for any other IDE's or toolchains. That is why our first goal was to keep this classes up to date. A huge amount of work was done and a year ago the brand new v3 TPSQLDump and TPSQLRestore components were published as part of v2.11.0 release.
TPSQLDump and TPSQLRestore are fully compatible with native pg_dump and pg_restore utilities. Each and every native feature is supported out of the box:

• output formats (binary, text, directory, gzipped),
• parallel dumping and restoring,
• comprehensive selection, filtering and reordering of archived items,
• SQL-92 specific output options, etc.

Asynchronous Fetch-On-Demand mode

The default TPSQLQuery's mode is suitable for submitting commands and getting result sets in normal, synchronous applications. However, there are few drawbacks, that may be of importance to developers:

• TPSQLQuery.Open waits for the command to be completed. The application might have other work to do (such as maintaining a user interface), in which case it won’t be a good decision to block while waiting for a response.
• Since the execution of the client application is suspended while it waits for the result, it is hard for the application to decide that it would like to try to cancel the ongoing command.
• TPSQLQuery in default mode always collects a command's entire result, buffering it in a single place. While this behavior simplifies some internal logic, it can be impractical for results containing many rows.

To avoid such limitations developers now can use the brand new Fetch-On-Demand mode, which is turned on by dsoFetchOnDemand option in the TPSQLQuery.Options set.
There are limitations of course:

• To get advantages of the Fetch-On-Demand mode one should use read-only TPSQLQuery objects. This restriction will be removed with time probably.
• Each read-only TPSQLQuery component must have its separate TPSQLDatabase component since Fetch-On-Demand command flow will block a connection until getting the last row of the result set.

Support for built-in range and geometric field types

Previously these specific types were mapped to TStringField class. Now PostgresDAC provides new TField descendants for this:

• TPSQLRangeField
• TPSQLPointField
• TPSQLCircleField
• TPSQLBoxField
• TPSQLLSegField

All of them will be created automatically if needed, or may be added manually in design time.
TPSQLRangeField encapsulates all built-in PostgreSQL range types: int4range, int8range, numrange, tsrange, tstzrange and daterange. Information about range value is stored in the TPSQLRange record by storing values for each bound using TPSQLRangeBound record. Depending on the underlying table field type developer may access bound values using appropriate methods AsInteger, AsFloat, etc.

Enhanced Manual

We've finished the new help system. It's rewritten it from scratch. Support for such formats provided:

• chm,
• pdf.
• epub (in progress).

Full change log:

[!] Fetch-On-Demand mode introduced for readonly TPSQLQuery objects
[!] Support for geometric types added
[!] TPSQLRangeField added
[!] Support for pre-8.0 PostgreSQL servers is discontinued
[!] v9.4.0 client libraries added
[!] v9.4.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
[*] Components TPSQLUser and TBDE2PSQLDAC marked as deprecated and will be removed shortly
[*] EPSQLDatabaseError is raised if TPSQLDatabase is used in non-exclusive mode for TPSQLQuery with dsoFetchOnDemand
[*] TPSQLDatabase.CancelBackend checks for connection now to prevent AV
[-] "AV may occur if SQL parameter name consists from incorrect characters chain" bug fixed
[-] "EPSQLDatabaseError detail error properties are empty after error in TPSQLDirectQuery.Open" bug fixed

Update
i have added some minor updates for my free Delphi component to help database programmers more. I added the fellowing procedures:

_storeBlob(); save pictures to blob field.
_loadBlob(); Diplay a stored blob field in the TImage.
_loadBlobDX(); Display blob in the TcxImage of DevExpress.
_execSQL(); Execute an SQL commands.
_sqlOrderASC(); Order by ASC a collection of rows.
_sqlOrderDESC(); Order by DESC.
_selectRange(); Select a range of rows in database.

Note: the component is deveoped for Absolute Database, but you can add another databases without remove anything and send me a copy by e-mail.

The component is very easy to use, put it in the Form, click a button and type "_" to let IDE show you all the procedures and functions.

Please, download the full source code here.

Breaking news

"Castalia for Delphi is not currently available. Thank you for your interest."

this is what TwoDesk company told in theire website!
they didn't told why they reloved the link, or why closed it!

 

 

 by Julian M Bucknall

As you may have already heard, the next major release of the DevExpress VCL Subscription has just been published and active subscribers can download and use our newest version at their convenience. For an overview of the new products and features we're shipping inside v14.2, please take a moment to review our What's New in v14.2 or watch the webinar I presented on December 18.

Read full article on DevExpress website..

 

TMS VCL Subscription

One subscription:
All current VCL components for Windows application development
+ free : all regular component updates for 2 years
+ free : priority support for 2 years
+ free : updates for upcoming new Delphi & C++Builder versions
+ free : new VCL components that we include in subscription

Save over 50% now and even more with new free VCL component releases