Development Within EnterpriseDB Advanced Server
Oracle Tips by
EnterpriseDB Advanced Server is a robust database that supports a
large set of programming languages. EnterpriseDB also provides a
robust development environment called Developer Studio. We briefly
covered some of the features of Developer Studio in Chapter 2. In
this chapter, I will walk through those features in detail.
addition to developing for EnterpriseDB, Developer Studio allows you
to develop applications for PostgreSQL databases and to browse Oracle
databases. This chapter will show you how to connect to those
databases, navigate around them and even copy data and objects between
also show you how to use Developer Studio to write SQL and procedural
code (for any of the supported languages). The SQL Interactive window
is the GUI interface to programming and the SQL Terminal is your
chapter will also cover tuning your queries by using the Visual
Explain tool. This tool graphically displays your SQL execution
is only as good as its debugger. Developer Studio provides an
excellent source level debugger to step through your programs. With
the PL Debugger, you can walk through SPL and PL/pgSQL at the source
code level; you can view and change program variables.
Developer Studio is a very robust and complete solution for developing
applications for EnterpriseDB. However, it is not the only tool that
you can use. Because EnterpriseDB is based on PostgreSQL, there is a
large supply of third party development tools. This chapter will also
cover three of the more feature rich tools: the free pgAdmin III GUI
IDE and EMS PostgreSQL
Manager Lite, and the commercial PremiumSoft Navicat for PostgreSQL
GUI front end.
Developer Studio (Figure 5.1) is an Open Source Java IDE to allow
developers and DBAs to code for, and monitor, EnterpriseDB databases.
Developer Studio is a cross platform application that can also connect
to PostgreSQL and Oracle databases.
5.1: EnterpriseDB Developer Studio Splash Screen
Developer Studio, click on the DevStudio icon (Figure 5.2) or select
Developer Studio from the EnterpriseDB Advanced Server menu.
5.2: Developer Studio Icon
Default, when Developer Studio starts, it should automatically connect
to your local database and you should see a screen much like that in
5.3: Developer Studio
Navigation within Developer Studio is provided via four panes:
Pane – The menu pane provides the drop down menu and the toolbar.
Navigator Pane – The navigator pane provides an Explorer-like,
tree-view of databases and database objects. You drill down from the
top level to lower levels by clicking the plus symbol (+).
Details Pane – The details pane provides detailed information about
the object selected in the navigator pane. For example, when you
select Schemas in the navigator pane, the details pane will contain a
list of all schemas. If you drill down and select a specific Schema,
the details pane will contain information relating to the specific
Pane – The SQL pane provides SQL scripts relating to the object
selected in the navigation pane. For example, when selecting Schemas
in the navigator pane, the SQL pane is empty because there is no SQL
associated with all schemas. If you drill down and select a specific
schema, you will see the SQL related to the specific schema.
also drill down to additional SQL information by selecting an object
within the details pane.
is an excerpt from the book "EnterpriseDB:
The Definitive Reference" by Rampant TechPress.