root-at-skic
d9777fb90e
The six models from extension 0.11.0 (arc42 by section, ArchiMate by layer) next to the three C4 ones; model:scaffold --example offers them and the tests validate each with 0 problems.
21 lines
736 B
Plaintext
21 lines
736 B
Plaintext
schema_version: 1
|
|
decision:
|
|
id: postgres-full-text-search
|
|
title: PostgreSQL full-text search, no search engine
|
|
status: accepted
|
|
date: 2026-10-05
|
|
elements: [api, db]
|
|
diagrams: [0500-building-blocks/level-1.archify, 0500-building-blocks/wiki-api.archify]
|
|
context: >
|
|
The wiki holds a few thousand pages for one team. A
|
|
separate search engine would be one more service to run,
|
|
back up and keep in sync.
|
|
decision: >
|
|
Search uses PostgreSQL full-text search on a generated
|
|
column of each page. The API queries it in the same
|
|
transaction as the page data.
|
|
consequences: >
|
|
Results are never stale and backups cover search too.
|
|
Ranking is simpler than a search engine. Revisit when
|
|
the wiki grows past 100000 pages.
|