What is DBSP ?

DBSP (Data Base Scripting Pages) is a server side scripting technology designed specifically for accelerate the construction process of any kind dynamic content and data oriented web sites (B2B, B2C, B2E, etc).

How does DBSP works?

DBSP works as an extension of the existent HTML language. Certain DBSP TAGS are inserted inside the HTML code, enabling an easy way to bring information from some database into the document.

In addition, DBSP incorporates different mechanisms that allow you to solve common tasks to all the bulk of data aware web sites of these days: authentication, user privileges, concurrency, performance and stability. This capabilities are ready to use, demanding a minimum effort to the programmer or web designer to implement them; so construction cycles are shorter and production costs are lower.

Even though the nature of the Internet brings more and more complexities for the developers every day, the main goal of DBSP is to keep things simple. The simplicity of the language and the applications provided contributes to have a short learning curve and helps to obtain results since the first day.

Main features

Native database connection. No ODBC or JDBC connection is needed. Instead, DBSP connects directly to the database client of the most popular and powerfull relational databases on the market. This improves the connection performance, eliminating unnecessary layers for obtaining data. In addition, the DBSP engine uses some other techniques (like database pooling), to improve the performance of the database connections and all the web site in general. The current supported databases are: Interbase®, Oracle®, IBM DB2® and Microsoft SQL Server® but the list is still growing.

Keep important information secure. DBSP incorporates a robust encrypting algorithm that uses a 128 bits key, that allow you to encrypt your information before being stored in the database. This mitigates the risk of compromising sensible data, inside or outside your facilities. In addition, all the database constructs of your application (like the SQL Sentences) are stored inside the related database. This feature offer the developer a simple and effective technique for managing and test the SQL objects in large scale applications.

Active users list. Know at any time who is accessing to your system, the current IP, what OS and browser is being used, how much time the user has been active on the system, etc. In addition, the authentication methods of DBSP manage virtual sessions through keeping all the session information in both sides of the connection: one copy on the server and the other in the browser. If at anytime the information differs in any side, the access is forbidden. This schema reduces the risk of unauthorized access or user impersonation.

Superior performance to similar technologies. DBSP achieve a better performance than CGI architecture or Java Servlets DBSP executes as an ISAPI library on the Windows platform and as a SO library on Linux platform (not yet released). Both architectures allows DBSP to benefit from the multithreading capabilities of the OS and at the same time, keep the database connections active, eliminating unnecessary authentication processes.

Short learning curve. One of the most interesting features of DBSP is its learning curve. By experience, any person that knows the basis of SQL and the basis of HTML could be producing medium to complex DBSP pages in TWO weeks. Want to see DBSP in action? Review some DBSP code in the Learn by example section.

Next topic