Questions? Feedback?powered byOlark live chat software

PowerBuilder 2019*
Customer Beta Program 

*PowerBuilder 2019 is originally named as PowerBuilder 2018

Thanks to the high engagement of all the beta testers, PowerBuilder 2019 Customer Beta has successfully ended on March 21.   Considering the problems and the feedback collected during the beta cycles, we’ve scheduled the GA date of PowerBuilder 2019 for May 31.

PowerBuilder 2019 Highlights

Appeon PowerBuilder 2019 brings C# Web API & assembly development to PowerBuilder with the productivity that is the hallmark of PowerBuilder. A C# migration solution (framework and tools) is also provided so you can leverage existing project assets. PowerBuilder client app development also gets ground-breaking new features, such as UI themes to modernize your application’s user interface in a codeless fashion.

C# DataStore 

The C# DataStore is a C# implementation of the PowerScript DataStore, which is compatible with the .NET Core and is developed with the PowerBuilder IDE.  It brings the heart of PowerBuilder to C# development and with fast performance.

High Productivity.  The C# DataStore requires just as little coding as the PowerScript DataStore, and the C# DataObject can also be visually created using the DataWindow painter.   
Easy to Learn.  The C# DataStore works in the same manner as the PowerScript DataStore, providing virtually the same APIs (Properties/Events/Functions) and approach to transaction management. 
​Fast Performance.  Unlike the obsolete PB.NET, the C# DataStore has been designed for highly-concurrent server applications, delivering drastic improvements in performance and scalability.

SnapObjects Framework 

SnapObjects is a lightweight yet powerful ORM framework for C#, which is compatible with the .NET Core and can be developed with any C# IDE.  It was designed to surpass the shortcomings of leading C# ORM frameworks, especially in terms of simplicity, transaction management, and performance. 

ModelMapper

The C# ModelMapper is arguably the most powerful object in the SnapObjects framework, ideal for handling complex transactions.  It should offer a drastically shorter learning curve than many leading C# ORM frameworks and greater developer productivity than the C# DataStore.

Centralized Data Access. The model defines both the data structure and database queries, which serves as a centralized point for data access logic and improves code maintainability.  Database queries can be built using SQL attributes (cross-database approach) or embedded SQLs. (Model Query Attributes, Raw SQLs Embedded Attributes)
Automated SQL Generation & Testing.  Unlike leading C# ORM frameworks, you can easily control the generated SQL through SQL attributes in the model.  Also, the framework will automatically validate the SQL according to the attributes specified.  You no longer need to spend time running your app to discover basic SQL issues.
Powerful Transaction Management.  Unlike leading C# ORM frameworks, the ModelMapper not only supports tracking changes in models, but it also supports tracking hand-coded SQL statements as well as various actions that you specify.  As such, automatic (implicit) transactions can support more complex scenarios and it requires no additional coding.  See more on what can be tracked. (ModelMapper Tracking Methods, IDetailTracker Methods)
Fast PerformanceAll model changes, SQL changes, and actions are executed in a single batch.  Especially for complex transactions processing large amounts of data, this feature of the ModelMapper should help you achieve maximum performance.

C# ModelStore

The C# ModelStore is an alternative to the C# DataStore.  While it may require more coding than the C# DataStore, if you need an object that works with any C# IDE it offers the absolute lowest learning curve (after the C# DataStore of course).   

Centralized Data Access.   The model defines both the data structure and database queries, which serves as a centralized point for data access logic and improves code maintainability.  Database queries are built using SQL attributes (cross-database approach). (Model Query Attributes)
Automated SQL Generation & Testing.  Unlike leading C# ORM frameworks, you can easily control the generated SQL through SQL attributes in the model.  Also, the framework will automatically validate the SQL according to the attributes specified.  You no longer need to spend time running your app to discover basic SQL issues.  
Provides DataStore Features.  The C# ModelStore can often times be used in place of a C# DataStore.  It offers much of the same features as the C# DataStore, such as data caching, filtering, sorting, status tracking, data traversing, and statistical analysis, etc. (See More of the ModelStore Properties and Methods)
Supports Migration.  The models generated from existing DataWindows and DataStores by the PowerBuilder IDE’s conversion utility can be also used by the C# ModelStore to perform CUD operations, leaving only queries to be hand-coded.   

PowerBuilder 2019 provides a migration tool and framework to make migration of PowerScript NVOs to C# assemblies or Web APIs as easy and fast as possible. 

DataWindow Conversion Utility.  You can automatically migrate the PowerScript data objects to C# Data Models.  The DataWindow conversion utility also supports batch conversion, automatically migrating hundreds or even thousands of DataWindows and DataStores.  
​Embedded SQL Reuse.  You can essentially copy & paste existing embedded SQLs using the new C# SQLExecutor object.  If your project has made heavy use of embedded SQLs, this feature should save significant time and effort.
PowerScript Porting.  While you do need to hand-code C#, this effort is a “port” of the original PowerScript rather than a rewrite.  The C# DataStore works in the same manner as the PowerScript DataStore, providing virtually the same APIs (Properties/Events/Functions) and approach to transaction management.  In fact, the APIs even follow the same naming convention as the PowerScript DataStore. 

PowerBuilder 2019 also includes a lightweight yet relatively full-featured C# IDE (SnapDevelop) for developing non-visual C# projects, such as C# Web APIs, non-visual assemblies, and unit testing (with xUnit).  It provides valuable developer productivity features, such as project wizards, advanced auto-scripting, C# language services, solution management, and more.  While C# projects that make use of the SnapObjects framework can be used with any C# IDE, SnapDevelop does not have the price tag of its rivals and should offer better IDE performance.

More SnapDevelop Features

UI Themes

With PowerBuilder’s UI Themes, you can instantly bring a modern look and feel to your application without any significant code changes (in most cases). By default, it comes with 3 pre-built themes: Flat Design Blue, Flat Design Grey, and Flat Design Silver. You can also customize these UI themes by editing the corresponding JSON file, which is similar to working with CSS, or create your own UI theme.

DataWindow JSON Retrieve/Update

The RESTClient will power your DataWindows with RESTful Web API data sources (in JSON data format), no matter your DataWindows are reports or have full CRUD functionality. All you need to do is write just a few lines of code. The RESTClient also supports popular access tokens (OAuth 2.0 or JWT) in case the RESTful Web APIs you are calling requires this more secure form of authentication.

DataWindow Large Dataset Handling

The RESTClient handles DataWindows with very large datasets efficiently in terms of both bandwidth and performance. Specifically, the RESTClient supports and will automatically handle a resultset that is compressed. It also supports submitting minimally-required data (i.e. submit only the changed data) to the RESTful Web API.

For more new features, refer to the PowerBuilder Help.

Schedule 

January 3 – February 20

The first beta includes only the PowerScript features

February 21 – March 21

The second beta includes all the features of PowerBuilder 2019.  It also incorporates some fixes and enhancements since the first beta.

May 31, 2019 

Benefits

Be the first to try revolutionary new features like UI themes and rapid C# Web API development.
Work closely with the Appeon tech staff to resolve any showstopper issues before the product is generally available (GA).
Influence the feature enhancements of the upcoming revisions of PowerBuilder 2019.