pkg.sopackage field notes

brew / rank 7356

Install derby with Homebrew

Apache Derby is an embedded relational database running on JVM. Version 10.17.1.0 via Homebrew; verified 2026-06-06.

install

Additional install commands

macOS

Homebrewverified · 100%
brew install derby

provider-native install command

overview

Package summary

Apache Derby is an embedded relational database running on JVM

Commands and aliases

  • NetworkServerControl
  • dblook
  • ij
  • setEmbeddedCP
  • setNetworkClientCP
  • setNetworkServerCP
  • startNetworkServer
  • stopNetworkServer
  • sysinfo

history

Project history and usage

Apache Derby is an Apache DB relational database implemented entirely in Java. It is packaged as an embedded JDBC engine and as a client/server database with the Derby Network Server, which made it useful to Java developers who wanted a small SQL database without operating a separate database service.

Project history

Derby entered Apache through the Incubator in 2004, when the Apache DB PMC voted to sponsor the project. The project graduated to an Apache DB subproject in July 2005, then continued releasing 10.x versions for nearly two decades before the developers voted on 2025-10-10 to retire Derby into a read-only state.

Adoption history

Derby was adopted in Java and JDBC workflows because it could run embedded in an application, while still offering a network server mode when a more familiar client/server deployment was needed. Its release history shows steady maintenance from the first incubating 10.0 release in 2004 through the 10.17.1.0 release announced in November 2023.

How it is used

Package users usually encounter Derby through command-line tools such as ij, dblook, sysinfo, and NetworkServerControl, plus scripts for setting embedded, client, or server classpaths. Its configuration centers on Derby system properties, including the derby.properties file under derby.system.home.

Why package nerds care

Derby matters in package-manager history as a compact pure-Java SQL engine: one install gives both a JDBC library and small administrative tools, making it a useful test database, embedded database, and compatibility target for Java packaging ecosystems.

Timeline

  • 2004: Apache DB PMC voted to sponsor Derby.
  • 2004: Derby 10.0.2.1 Incubator Release was published.
  • 2005: Derby graduated to an Apache DB subproject.
  • 2023: Derby 10.17.1.0 was announced.
  • 2025: Derby developers voted to retire the project into a read-only state.

Related projects

  • Related Apache DB and Java database projects include Apache Torque, Apache JDO, and other JVM-oriented persistence tools; Derby's closest user-facing peers are embedded SQL databases and JDBC test databases.

security posture

Risk level: orange

broad file, network, media, or database tool signal. formula declares a Homebrew service.

Risk classifier

orange risk · medium confidence · infrastructure

Why

  • broad file, network, media, or database tool signal
  • formula declares a Homebrew service

Signals

  • metadata:service
  • text:network,database,client,server

Install behavior

  • No Homebrew bottle metadata was recorded.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

local files

Configuration and credential file locations

These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.

Configuration files

Config paths the tool may read or write during local use.

Unix
${derby.system.home}/derby.properties

executables

Installed executables

CommandKindExposureNote
NetworkServerControlexecutableindexed executableDiscovered from the local executable index.
dblookexecutableindexed executableDiscovered from the local executable index.
ijexecutableindexed executableDiscovered from the local executable index.
setEmbeddedCPexecutableindexed executableDiscovered from the local executable index.
setNetworkClientCPexecutableindexed executableDiscovered from the local executable index.
setNetworkServerCPexecutableindexed executableDiscovered from the local executable index.
startNetworkServerexecutableindexed executableDiscovered from the local executable index.
stopNetworkServerexecutableindexed executableDiscovered from the local executable index.
sysinfoexecutableindexed executableDiscovered from the local executable index.

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-08-03
manager version10.17.1.0
manager updated2026-06-06
local dataunknown
upstreamnot available
latest detectednot detected
  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:derby
Version10.17.1.0
Package managerHomebrew
Homepagehttps://db.apache.org/derby/
Last updated2026-06-06T11:29:12Z
Pulseupdated
Bottlenot recorded
Servicenone declared

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

  • Geiger risk classifier
  • Nucleus package database
  • curated configuration and credential file locations
  • curated package history
  • pkgdb category and tag curation