LOGIN | REGISTER NOW | SUBSCRIBE
 

Keeping Up With the Joneses’ Database


FirstSQL gets triggers, constraints; mobile version on tap

By Edward J. Correia
Email    print   
June 1, 2005 —  Application-specific database developer FFE Software in early May released FirstSQL 3.0, adding features that its CEO characterized as lacking in his own product but present in major competitors. It also plans a mobile edition this summer.

“We’re just playing catch-up,” admitted Lee Fesperman, CEO of the 16-year-old company based in El Cerrito, Calif. Version 3.0 adds support for database triggers, constraints and JDBC 3, and is the first major update since the company reorganized and renamed in June 2004; it was formerly known as FirstSQL Inc.

New to version 3.0 is the ability to create Java-based database triggers to kick off procedures from database activities. “Uses might include change validations, data-type validations and to optionally abort a change if it decides things aren’t proper. It’s also convenient for logging.”

Another useful new feature, Fesperman said, is sequence keys, which give developers the ability to automatically generate identity or surrogate keys for each new table. “Sometimes there’s confusion over which key should be used” during development, he said. Present in many competitive databases, the auto-increment capability helps avoid that confusion, he said.

He said the features also allow FirstSQL to work more easily with Hibernate—the popular Java object-relational persistence and query engine—including the Add Constraint and Drop Constraint commands that Hibernate assumes are present. FirstSQL 3.0 also now supports JDBC 3, which Fesperman said gives it the ability to retrieve generated keys and the Last Sequence function in SQL. “That’s an extra function for retrieving those.” The driver is sold separately and works with the server version only. “This expands our usability and makes it possible to talk to [FirstSQL] from .NET applications,” he said.

Available now, single-user Professional pricing has been reduced to US$495 per developer seat from $695 for version 2.75; Multiuser Enterprise edition pricing remains at $1,495. Runtime pricing starts at $50.

Going Mobile
Fesperman said that the price reduction was intended in part to seize on an opportunity. “There seems to be a certain fading by PointBase since its acquisition” by DataMirror in December 2003. “We’re trying to attract more developers in the mobile market.”

The company sometime this summer plans to release a version of its Professional edition with the object capability stripped out. “The object capability is expensive and doesn’t always work on some mobile devices. So we’d leave that out and [release] a pure SQL relational database.” Pricing was not disclosed.




Share this link: http://sdt.bz/28665
 
Most Read Latest News Blog Resources
Zeichick’s Take: Radio moves from analog waveforms to digital packets
Streaming radio highlights the need for streaming applications to be designed to take up as little bandwidth as possible
Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans
Appcelerator Acquires Cocoafish to Add Instant Mobile Cloud Capabilities to its Industry Leading Titanium Platform
Appcelerator Offers Messaging, Social, Location and Storage Mobile Cloud Services to All Mobile App Publishers
ComponentOne Releases a Collection of 40+ UI Widgets Powered by HTML5 and jQuery
ComponentOne has announced the 2012 release of Wijmo: a kit of UI widgets for HTML5 and jQuery development
Digg!  Digg
Reddit  Reddit
Slashdot  Slashdot
Share on facebook  Facebook
Share on Twitter  Twitter


Add comment


Name*
Email*  
Country     


  • Comment
Loading




close
NEXT ARTICLE
Devart Lightweight Database Drivers Beef Up the Direct Mode Functionality for Oracle and Speed Up Working with PostgreSQL!
Support for connection using Service Name in the Direct mode is added to Devart dbExpress driver for Oracle Read More...
 
 
 
 
News on Monday
more>>
SharePoint Tech Report
more>>


   

 
 

Download Current Issue
FEBRUARY 2012 PDF ISSUE

Need Back Issues?
DOWNLOAD HERE

Want to subscribe?


 
blogs tab
Are you at risk for burnout?
Burnout is a severe problem and it can strike at any time. Here's how to tell if you are nearing the edge.
02/09/2012 02:16 PM EST

Agility, mom, and apple pie
If we're to evaluate the state-of-the-art in software development, we should start with the values espoused in the Agile Manifesto.
02/07/2012 11:57 AM EST

RIM woos developers with free tablet
How do you get more apps ported to the BlackBerry PlayBook? By giving every developer a free tablet, of course!
02/04/2012 01:57 PM EST

GitHire: Use Headhunters to Find Your Perfect Programmer
Are you a hiring manager tired of scouring the job boards? Check out this new service that will find 5 people interested in your jobs.
02/03/2012 12:17 PM EST

Facebook claims hacker cred
Facebook's SEC S-1 filing form includes a short essay on the Hacker Way by Mark Zuckerberg himself.
02/02/2012 08:26 AM EST

Ryan Dahl steps down
Ryan Dahl, creator of Node.js, steps back from his position as gatekeeper for the project.
02/01/2012 04:58 PM EST

 
Events calendar tab
Cloud Connect
2/13/2012 to 2/16/2012
Santa Clara
TechWeb

SPTechCon: The SharePoint Technology Conf.
2/26/2012 to 2/29/2012
San Francisco
BZ Media

RSA Conf.
2/27/2012 to 3/2/2012
San Francisco
RSA

IBM Pulse Conf.
3/4/2012 to 3/7/2012
Las Vegas
IBM Tivoli

Game Developer Conf.
3/5/2012 to 3/9/2012
San Francisco
TechWeb