Developing with Derby
Use Cases and Deployment Scope
Pros
- Much easier to use and learn than most commercial databases.
- Derby database errors are well documented.
- Most complex queries supported as well as by other database vendors.
Cons
- It may not scale as well as some more mature database products.
- Used it primarily from the command line with openjpa and jdbc, and from third-party clients such as Squirrel.
- May benefit by providing more sophisticated tools to optimize query performance.

