I Love Xbase++ (ILX)
The portal for Xbase++ developers worldwide
-
Why configuration of your PostgreSQL Server is essential!
Background As you may have already realized, a PostgreSQL server or any SQL server in general is a "relatively" complicated story. The reason for that is basically that the server with the planner tries to replace you as a human. In ISAM you have the data model in mind, also the requirements of... -
V2.0 Remote Filters in Xbase++ with PostgreSQL ISAM Emulation
Xbase++ developers often use ISAM (Indexed Sequential Access Method) for data management because of its efficiency and straightforward approach to handling database operations. Moving to PostgreSQL, a robust SQL database, offers enhanced capabilities but requires an understanding of new... -
Explore Xbase++ Why re-implementation of software systems so often fails
The re-implementation of existing legacy software systems often faces significant challenges, and understanding these can illuminate why such projects frequently fail. This little write-up is far from complete but tries to create awareness regarding these important and very often underrated... -
V2.0 Using SQL Constraints for Data Integrity in Xbase++ with PostgreSQL
Background Xbase++ allows seamless integration with SQL backends like PostgreSQL using the DacSession() object. When working with SQL databases, enforcing data integrity through application logic alone is not always sufficient. Native SQL constraints (such as CHECK, UNIQUE, or FOREIGN KEY)... -
Design Understanding Member Variables and Visibility Design in Xbase++
Introduction When working with object-oriented programming (OOP), the concept of member variables and their visibility is fundamental. Xbase++ follows these principles, offering various visibility levels for member variables in classes. This article intends to explore these concepts in the...
Introduction
Xbase++ is a versatile programming language that allows developers to create multi-threaded applications easily. In this article, we will explore how to use the Thread class in Xbase++ to create and manage an operating system thread capable of executing different tasks. We will...
Introduction
Xbase++ is a development tool that offers Xbase Parts for building Windows Desktop applications. One feature that Xbase++ programmers can leverage is the ability to configure these Xbase Parts through subclassing. Not only does this approach allow for personalized coloring and UI...
Background
In the realm of software development, keeping a software product current, reliable, and robust requires a strategic approach. Alaska Software, the vendor of the programming language and development platform Xbase++, has adopted a strategy known as Continuous Delivery to maintain the...
Introduction
Composition and inheritance are two major concepts in object-oriented programming (OOP) that allow for creating complex types.
Inheritance is a mechanism where you can derive a class from another class for a hierarchy of classes that share a set of variables and methods. The...
Background
The XbpHtmlViewer2 class has a data folder that serves as an integral mechanism for session isolation. This feature is critical for applications using the class, which internally relies on the Microsoft WebView2 runtime. By ensuring that every process employing XbpHTMLViewer2...
Prolog
In the realm of software development, it's imperative for companies to adopt versioning strategies that are both meaningful to developers and aligned with modern development methodologies. Alaska Software, as the vendor of the Xbase++ platform, has seamlessly integrated these...
Introduction
Interfaces in Object-Oriented Programming (OOP) play a critical role in designing robust software. In the following we will try to explain the benefits of using interfaces and how to implement them in Xbase++. Generally, benefits of using interface are:
Abstraction: Interfaces...
In this article we will have a deeper look into how to implement different types of REST APIs using Xbase++ 2.0. We assume that a user management REST API exposes two endpoints.:
1. "POST /users" - This creates a new user. For this request, we need to send user data in the request body. The API...
Let's start and create an example where we'll retrieve posts from a public REST API, such as JSONPlaceholder which is a free online REST API that you can use for demonstration and testing purposes.
Here's the URL endpoint to retrieve posts: https://jsonplaceholder.typicode.com/posts
Now, let's...
Background
The SQL command ALTER TABLE can be used to modify the structure of an ISAM emulated SQL table on the PostgreSQL server. However, in order to preserve the ISAM emulation characteristic, some details have to be taken into account which are described in this article. This article does...
Overview
In this article it is shown how the class AesCrypt() can be specialized to implement some padding schemes for encrypting and decrypting messages.
Background
The Advanced Encryption Standard (AES) standard is a block cipher algorithm that only allows for the encryption of messages in the...
The Asset Manager integrated into the Xbase++ Workbench provides an easy interface for viewing, (de-) installing and updating the assets being used in your projects. Behind the scene, the Asset Manager in conjunction with the Workbench, performs the following tasks for you:
Manage asset...
Positioning
If a Smtp or Pop3 endpoint for e-mail exchange requests authorization via the OAuth 2.0 protocol, then this flow-based protocol must be used when communicating with the server to authenticating the client. This may also require displaying a user interface for obtaining the user's...
Background
One of the largest differences in how data is managed between SQL and ISAM is how deleted records are handled. In short:
ISAM: does mark a record as deleted. This way it is out of scope. To really get rid of the record you need to do a time consuming PACK operation.
SQL: does really...
Using native SQL for manipulating data as well as structure (schema) of ISAM-emulated tables is a supported scenario, for example, for being able to share data with non-Xbase++ applications. In the following, the potential pitfalls and general requirements are discussed which must be put into...
Background
Generally making a service more reliable does not mean to ensure the service works 24/7. This is an old school no more working approach from times where software solutions have been simple, working in defined environments and under full control. But today, even simple software become...
Background
The PGDBE automatically tracks record locks in ISAM-emulated tables, which are set by clients connected to the PostgreSQL server. This is done with the help of the __lock_owner field in the table's meta data. However, when a client dies unexpectantly, has it's network go down or does...
Background
Since the ISAM emulating tables of the PostgreSQL DatabaseEngine are in fact regular SQL tables, it is possible to manipulate them using SQL statements. However, some SQL operations are problematic, as they may lead to inconsistent/incorrect ISAM behavior. In the following, we will...
Background
As you may have already realized, a PostgreSQL server or any SQL server in general is a "relatively" complicated story. The reason for that is basically that the server with the planner tries to replace you as a human. In ISAM you have the data model in mind, also the requirements of...
Overview
By default, the target (.dll or .exe) is created in the directory as implied in the target node of the project file (.xpj). The target [example.exe] is created in the directory where the project file is located. The target [bin\example.dll], on the other hand, is created in the...
Latest articles
-
Xbase++ Workbench's Regular Expression Engine Cheat-SheetOverview This document serves as a cheat sheet for the syntax of the regular expressions that...
- Anna Hristova
- Updated:
- 2 min read
-
Design Understanding Member Variables and Visibility Design in Xbase++Introduction When working with object-oriented programming (OOP), the concept of member...- Steffen F. Pirsig
- Updated:
- 3 min read
-
Reviewing Primary Key Definitions When Migrating from ADS to PostgreSQL with Xbase++ ISAM EmulationBackground The Advantage Database Server (ADS), commonly used with Xbase++, has long served...
- Steffen F. Pirsig
- Updated:
- 2 min read
-
Correcting Image Orientation Using EXIF Metadata in Xbase++When displaying images in Xbase++, you might encounter image files that appear rotated or...- Andreas Herdt
- Updated:
- 3 min read
-
V2.0 Using SQL Constraints for Data Integrity in Xbase++ with PostgreSQLBackground Xbase++ allows seamless integration with SQL backends like PostgreSQL using the...- Jeffrey Wulf
- Updated:
- 3 min read