JdbcStore

JDBC-backed BaseStore. Supports MySQL, PostgreSQL, SQLite, and H2 out of the box via JdbcStoreDialect.

Schema

`CREATE TABLE agentscope_store (
namespace_path -- VARCHAR (PG/MySQL/H2) or TEXT (SQLite), joined namespace + trailing 0x1F
item_key -- VARCHAR or TEXT, item key
value_json -- TEXT / LONGTEXT / CLOB, Jackson-serialised Map<String, Object>
version -- BIGINT, monotonically increasing per row
updated_at -- BIGINT, epoch millis of the last write
PRIMARY KEY (namespace_path, item_key)
)
`

The optional Builder#initializeSchema(true) flag runs the dialect's CREATE TABLE IF NOT EXISTS on construction.

Namespace encoding

To preserve the prefix-search behaviour of InMemoryStore, the namespace components are joined with the ASCII unit-separator 0x1F and stored with a trailing separator. Searching by namespace [a, b] translates into WHERE namespace_path LIKE 'ab%' ESCAPE '!', which matches both that exact namespace and any deeper sub-namespace. Namespace segments that contain 0x1F are rejected.

CAS

#putIfVersion runs a single-statement conditional UPDATE keyed on version. The expectedVersion == 0 case (create-if-absent) issues an INSERT instead and treats a primary-key violation as a failed CAS. Both paths are atomic without additional locking, so the store is safe to share among multiple JVMs writing to the same database.