SQL Design

SQL Design™ is a computer-aided software environment used for the design, development and execution of client-server applications, targeting medium and large organizations. SQL Design helps you create information systems quickly and efficiently. It manages automatically all aspects of a hierarchical transaction by taking charge of the whole process.

More than a development environment, more than a framework, SQL Design is a record management application that you customize to your context. All you need is to do is to describe your transaction, namely the card and the groups it contains, and to add some code for validation and event processing. SQL Design then creates for you a custom program and manages all aspects of it.

One of the distinctive features of SQL Design is its centralized, dynamic repository. This repository manages the development standards of your organization and allows the sharing and documentation of the components. It also ensures the total synchronization and coherence of all components affected by modifications, and guarantees a high quality level from the resulting systems.

As opposed to other repositories, SQL Design's repository is linked in real time to every application and workstation via its micro-repository. The micro-repository manages the update, synchronization and security of the systems. It is installed and automatically updated on every workstation throughout your organization to ensure an effortless deployment.

Another important feature of SQL Design is the automatic management of data access. SQL Design uses native drivers to ensure the best performance. It also generates SQL commands according the the metadata stored in the repository. Consequently, communication with your database is all taken care of.

Unquestionably, the main feature of SQL Design is its exceptional performance. When implementing critical applications that affect hundreds, even thousands of users, performance is a crucial challenge. SQL Design is optimized for handling transactions such a context. This is where it demonstrates its full power.

Rep++ vs. SQL Design

In the early 2000s, the Microsoft® development platform (Visual Studio®, VB6 and .NET) was on its way to become the most commonly used platform in organizations. Consyst, wishing to offer Microsoft users the same benefits that SQL Design provided to its clients, used its expertise to start the development of Rep++, which seamlessly complements Microsoft tools. Rep++ thus originated from SQL Design, inheriting, among other things, the centralized, dynamic repository, which made possible the extended reflection capability. The two products then evolved in parallel, SQL Design following its original path while Rep++ adopted the object oriented approach. Rep++ detached itself from the SQL Design development environment to attach instead to Visual Studio and offer greater flexibility to the developer in both programming environment and user interface. The goal of Rep++: systematically increase productivity in application development.

Rep++ for SQL Design

Today, Rep++ for SQL Design takes advantage of the object oriented approach of Rep++ while remaining faithful to its origin as computer-aided software environment, with its own development language. The Rep++ repository editor allows you to manage your metadata, define your transaction, view your cards, and customize your SQL commands, while developing your application using SQL Design's script language. You have access to a whole new set of objects with their methods and properties, as easily as before.