1. Introduction

This tutorial will help you understand how OneWebSQL™ fits into the application development process. It explains how OneWebSQL™ can be incorporated into your development workflow to make your work easier and more streamlined, and it details the types of team members who will find this tool useful.

This guide is intended to provide a general overview of OneWebSQL™ without too many technical details. The details are fully laid out in the other guides.

2. Overview of the process

Let's begin with the people who drive the development process.

3. Changes, changes, changes

In the previous sections we've taken a close look at the system development process, from the initial user requirements to the final system. No development process would be complete, however, without accounting for lots and lots of changes. Projects go through a cycle of changes, implementations, and tests.

Let's see how OneWebSQL™ supports this development model.

Change usually starts with updated user requirements, which necessitate a change in the system. Often, the vision for the system changes and it is necessary to change the data model.

At this point OneWebSQL™ comes back into play. The updated data model is re-processed by the OneWebSQL™ code generator.

This will make new versions of the Java classes that reflect the changes in the database. Here is where OneWebSQL™ really saves time: these new Java classes will cause compilation errors, so that the developer doesn't have to manually comb through the code looking for outdated classes. Instead, the developer can use the compilation errors to easily locate and update the necessary areas of code.

4. Maintenance phase

This often-forgotten phase is nevertheless important to any project: the part where the system is up and running. In this phase it is important that any problems that may come up are identified and solved quickly.

OneWebSQL™ is ideal for maintenance because it exists as a very thin layer between the application and the database. In large systems, this simplicity makes optimization easier and helps administrators more quickly find the reasons behind any system crash.

There is no magic in the OneWebSQL™ layer: no caches, no lazy loading, no deferred writes, etc. Database operations are performed in exactly the same order as they are written in the code. This makes for transparent troubleshooting.