Base
Hardened build
minimal ports, security patches applied at build time
PostgreSQL 16 with PGroonga on Ubuntu 24.04 LTS
Azure
Databases
PostgreSQL with PGroonga, an open source extension for fast multilingual full text search inside the database engine.
Overview
This appliance pairs the PostgreSQL relational database with PGroonga, an extension that adds fast, accurate full text search backed by the Groonga search engine. You build an index on a text column and query it with the full text match operator, and because the search runs inside the database on an inverted index it stays quick as the table grows.
What sets PGroonga apart is language coverage. The same index searches English and CJK text, Japanese, Chinese and Korean, from one index with no extra configuration, where the built in tokenizers struggle with languages that do not separate words with spaces. A scoring function returns a relevance score for every match, so results can be ordered with the best hits first behind a search box.
Why the cloudimg image
cloudimg ships PGroonga already installed and ready, with a demonstration database of mixed English and Japanese documents and PGroonga indexes already built, so you can run a full text query in either language within a minute of first boot. There is no default password to change: on first boot each instance mints its own database passwords and its own TLS certificate into a file only the root user can read, and remote connections are accepted only over TLS. A least privilege application role is provided for your app, separate from the administrator, and a credential guard runs on every boot and stops the database rather than serve a credential that appears in any published example. The paired deployment guide walks through search in both languages, and every instance carries 24/7 support.
Common uses
- Adding fast full text search to an application without running a separate search service
- Searching multilingual content, including Japanese, Chinese and Korean, from one index
- Ranking search results by relevance inside PostgreSQL with a scoring function