* docs: add Oracle Database setup guide
Hindsight supports Oracle Database 23ai as a storage backend, but the docs
only mentioned it in passing — a one-paragraph note on the Storage page and a
couple of Configuration reference rows, with no `oracle+oracledb://` example
anywhere. This adds a dedicated Oracle Database page under Hosting.
The guide covers requirements (Oracle 23ai, the ASSM-tablespace requirement
for VECTOR columns, Oracle Text / CTXAPP), installing the python-oracledb
driver, a local quick start via scripts/dev/start-oracle.sh, production
provisioning SQL + connection URL + env vars + migrations, a config reference,
the differences from PostgreSQL, and troubleshooting. Content is grounded in
the CI Oracle job, the dev script, and the backend code.
Registered in the sidebar and cross-linked from Storage and Configuration.
Regenerated the docs agent-skill and mirrored the change into
versioned_docs/version-0.8 so it ships on the currently-served version.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01PginSDrapXsoDd6gN5Pszo
* docs(oracle): correct managed-service note, add connection caveat
The connection layer builds the Oracle DSN from the URL as a plain
host:port/service_name descriptor — wallet-based mTLS, TLS/TCPS, and TNS
aliases / full connect descriptors are not wired up. The previous "Least
privilege" note implied Oracle Autonomous Database works via an
ADMIN-provisioned user, which is misleading since ADB defaults to wallet/mTLS.
- Reworded the managed-service note to drop the specific ADB claim while
keeping the accurate requirement (ASSM tablespace + CTXAPP).
- Added an "Easy Connect only" warning documenting that wallet/mTLS/TLS and
TNS descriptors are unsupported, and that transport encryption must be
handled at the network layer.
Applied to the current and version-0.8 copies; regenerated the docs skill.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01PginSDrapXsoDd6gN5Pszo
---------
Co-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Storage page referenced `DATABASE_URL` but the actual env var is
`HINDSIGHT_API_DATABASE_URL` (matches configuration.md and admin-cli.md).
The admonition heading uses a gradient via `-webkit-text-fill-color: transparent`,
which inline `<code>` children inherited — making backtick content in titles
like `:::tip Set a stable HINDSIGHT_API_WORKER_ID in production` invisible.
Reset the fill color on code inside admonition headings.
Closes#1722
* docs: add Oracle Database as supported enterprise storage option
PostgreSQL remains the primary and recommended backend. Oracle is
mentioned as a drop-in alternative for enterprise environments with
full feature parity.
* docs: remove untested Oracle managed services list
* docs: specify Oracle AI Database 26ai as the supported version
* docs: use "Oracle AI Database" consistently, drop version suffix
* bump pg0 0.11.x and improve documentation
* bump pg0 0.11.x and improve documentation
* bump pg0 0.11.x and improve documentation
* ci: test notebooks on ci
* ci: test notebooks on ci
* rm llms-full from repo
* formatting
* formatting