_{Official ZPE/YASS documentation}Working with databases

Overview

ZPE provides driver-neutral JDBC access through the built-in Database and DatabaseStatement structures. The packaged runtime includes drivers for MySQL, MariaDB, Microsoft SQL Server and PostgreSQL.

Database operations require permission level 3. Keep credentials outside source code in real applications and use named parameters for user-supplied values.

Connecting

$database = new Database(
  "postgresql", "localhost", 5432,
  "school", "zpe_user", "secret"
)

if ($database->is_open())
  print("Connected")
end if
  

Queries and updates

query returns a list of maps, with each map representing one row. execute returns the affected-row count for an update.

$people = $database->query(
  "SELECT id, name FROM people WHERE age >= :age",
  ["age" => 18]
)

$updated = $database->execute(
  "UPDATE people SET active = :active WHERE id = :id",
  ["active" => true, "id" => 42]
)
  

Prepared statements

$statement = $database->prepare(
  "SELECT id, name FROM people WHERE surname = :surname"
)
$statement->bind(["surname" => "Balfour"])
$rows = $statement->query()
$statement->close()
  

Named placeholders use :name. Names inside quoted SQL text or SQL comments are not interpreted as placeholders.

Transactions

if ($database->begin())
  if ($database->execute("UPDATE accounts SET balance = balance - 10 WHERE id = :id", ["id" => 1]))
    $database->commit()
  else
    $database->rollback()
  end if
end if
  

Errors and cleanup

Call get_last_error() after a failed operation. Close statements and database connections when they are no longer required.

Its implementation was made available in ZPE 1.14.9 (Spurriergate, September 2026).