Database Access Guide

Direct database operations for plugin developers using named_jdbc

When to Use Database Access

Use direct database access when you need to:

Query data from the database
Create custom tables for plugin-specific data
Perform complex SQL operations
Generate reports or analytics from stored data

Quick Start

Reading Data

// MVEL - Count transactions for an address
params = ["address": "addr1..."];
result = named_jdbc.queryForMap(
    "SELECT COUNT(distinct tx_hash) as tx_count FROM address_utxo WHERE owner_addr = :address",
    params
);
txCount = result["tx_count"];
System.out.println("Address has " + txCount + " transactions");

Writing Data

// JavaScript - Insert custom data
const params = {
    txHash: transaction.getTxHash(),
    processed: true,
    timestamp: Date.now()
};
named_jdbc.update(
    "INSERT INTO plugin_tracking (tx_hash, processed, timestamp) VALUES (:txHash, :processed, :timestamp)",
    params
);

Available Methods

named_jdbc provide these core methods:

queryForMap - Get single row as map
queryForList - Get multiple rows as list of maps
update - Execute INSERT, UPDATE, DELETE
batchUpdate - Execute multiple updates efficiently

API Reference

named_jdbc Methods

// Query for single row
params = ["blockNumber": 12345];
block = named_jdbc.queryForMap(
    "SELECT * FROM block WHERE number = :blockNumber",
    params
);
 
// Query for multiple rows
params = ["epoch": 400];
blocks = named_jdbc.queryForList(
    "SELECT * FROM block WHERE epoch = :epoch ORDER BY slot",
    params
);
 
// Update operations
params = ["status": "processed", "id": recordId];
rowsUpdated = named_jdbc.update(
    "UPDATE processing_queue SET status = :status WHERE id = :id",
    params
);

Best Practices

1. Use Parameterized Queries

🚫

Never concatenate user input directly into SQL strings - this creates SQL injection vulnerabilities!

// ❌ BAD - SQL Injection risk
query = "SELECT * FROM tx WHERE hash = '" + userInput + "'";
 
// ✅ GOOD - Safe parameterized query
params = ["hash": userInput];
named_jdbc.queryForMap("SELECT * FROM tx WHERE hash = :hash", params);

2. Handle Null Results

// JavaScript - Safe null handling
const result = named_jdbc.queryForMap(
    "SELECT * FROM block WHERE number = :num",
    { num: blockNumber }
);
 
if (result && result.hash) {
    processBlock(result);
} else {
    console.log("Block not found");
}

Quick Reference HTTP Client (http)