Home > Oracle Database / Applications News > Oracle updates free Application Express developer tool
Oracle Database / Applications News:
EMAIL THIS

Oracle updates free Application Express developer tool

By Mark Brunelli, News Editor
31 Aug 2006 | SearchOracle.com

Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

Oracle says the newest version of its free Application Express software makes it easier for developers to build applications for Database 10g using nothing but a Web browser.

The newly released Oracle Application Express 2.2, which first debuted as HTML DB in 2004, promotes the reuse of Web applications by letting users bundle applications and dependent objects like tables, images and seed data into one file. The database giant says this makes for a plug-n-play scenario because those bundles can then be quickly installed into other Oracle databases running APEX.

More on Application Express:

University shreds paper problem with HTML DB

Ten things Oracle developers should never do

Other new features of APEX include an item finder that lets users search within applications, the ability to conduct component-level export, and an Access Control Wizard for controlling who gets access to applications.

"What we liked about it was that all you needed was a brain and a browser," said Larry Foster, vice president of technology with Fairpont, N.Y.-based Paetec, a software company that uses APEX to build its Pinnacle Communications Management Suite. "In the beginning, when it was HTML DB, you had to install it separately, but now it installs with Oracle 10g and up."

Foster said that early incarnations of APEX were too lightweight and of little use to Paetec, but as the technology matured, newly added features made the software worth a second look. Today, he says, Paetec's customers are pleased that most of Pinnacle's functionality resides within the database, making it easier to support and customize the suite.

APEX now supports standard software deployment requirements such as the ability to export not only applications but individual windows, Foster said. The vice president said he's also pleased that the software includes a development environment for SQL and that creating sophisticated forms is now an easier process.

"Some of this stuff was already inherent to client-server applications," Foster explained. "But then you had to buy a client developer's kit and you had to buy all this other stuff, where here, everything is on the database."

Foster said his firm considered developing in Java but decided to opt for APEX. With Java, Paetec would have needed to manage a separate application server, he said.

"You've got one backup command. Just using the standard Oracle backup procedure, you can back up literally everything in the application, including the interface and all the customizations," Foster said. "The customers can port it from platform to platform, and we think that's a very powerful feature as far as our customers being able to cut down the lifecycle costs of the application."

Oracle says it's had upward of 260,000 downloads of APEX since its first release, and the company estimates that there are about 20,000 regular users of the software. Cambridge, Mass.-based Forrester Research has reported a twofold increase in developer adoption of the software over the past year.

Michael Hichwa, Oracle's vice president of software development, says that most of the people getting good use out of APEX have a solid comprehension of SQL, in that they generally know how to mine their databases for data using SQL statements.

"This tool is perfect for that because it really complements our installed base's confidence in the SQL language," Hichwa said. "You don't have to know JavaScript, you don't have to know HTTP or HTML or cascading style sheets -- all of those Web things that are just getting more complicated by the day."

Not all wine and roses

Despite Paetec's generally positive experience with APEX, there are some areas where Foster thinks the software could improve. Specifically, he'd like to see the system improve its graphics and get more robust dashboard capabilities.

Foster added that he would like to see the product scale better to meet the needs of large operations like Paetec, where as many as 30 engineers are working with the product at any given time.

"It wasn't designed for that," he said, "but [Oracle is] starting to see more environments like us using it now."

Tags: Oracle database design and architectureOracle database backup and recoveryOracle Java and J2EEOracle stored proceduresOracle and SQLVIEW ALL TAGS

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Oracle database design and architecture
How to use V$SEGMENT_STATISTICS to find the most accessed Oracle table
Can I install an Oracle client on Windows 7?
How to use the Oracle Database Upgrade Assistant (DBUA)
Can I specify Oracle column order in my database table?
Can I have a single Oracle 11g RAC instance across multiple databases?
How to use the Oracle export utility to duplicate database structure
How to choose the primary key columns in an Oracle table
Understanding the data archiving definition
Review: Oracle's 11g R2 database has some good and bad
Scaling an Oracle database: What is the best strategy for you?

Oracle database backup and recovery
How to perform Oracle database recovery with a corrupt online redo log
Can I create an Oracle Catalog Database with the Enterprise Console?
Do I need to recreate views after an Oracle table reorg?
Client-based apps vs. web-based apps in Developer 2000
Can I move the tablespace online with missing datafiles in Oracle?
How to perform an Oracle 8i to 10g migration
Oracle upgrade process vs. Oracle exp/imp for 9i to 10g migration
How to use RMAN CONVERT to migrate from Solaris to Oracle 11g RHEL
Why am I having trouble installing Oracle 10g on Vista?
Can I load Oracle 8 on Windows Server 2003?
Oracle database backup and recovery Research

Oracle Java and J2EE
Ellison sees new opportunities for Oracle with Java on mobile devices
Oracle and Java: Some think advisory board would comfort users
Will Sun help Oracle eclipse IBM?
Unable to view Oracle tables in NetBeans
Can I make a second connection to Oracle without losing the first?
Oracle updates Microsoft developer tools
Oracle vs. SAP: The SOA factor
Impact of Oracle 9i upgrade on Java front end
Oracle updates free Web development tool
Oracle open sources TopLink at EclipseCon

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
E. F. Codd  (SearchOracle.com)
extent  (SearchOracle.com)
flexfield  (SearchOracle.com)
foreign key  (SearchOracle.com)
multidimensional database  (SearchOracle.com)
object-oriented database management system  (SearchOracle.com)
quad tree  (SearchOracle.com)
relational online analytical processing  (SearchOracle.com)
row  (SearchOracle.com)
splay tree  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Oracle News, Oracle Training, Oracle Management
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts