🗄️

Databases

Articles about databases

3 articles

Databases topic guide

Start with the key guides, then use the references and troubleshooting material below as you need them.

Documentation and reference

Concise material to keep nearby while you work.

DocumentationDatabases

PostgreSQL Full-Text Search Drops Text in Angle Brackets (ts_headline, to_tsvector)

PostgreSQL's text search parser treats <word> as an HTML tag, dropping it from ts_headline snippets and the index. Escape < before parsing to keep it.

Adam Birds

4 views2 min read

DocumentationDatabases

Move MySQL to Home Partition

Adam Birds

327 views1 min read

DocumentationDatabases

Create MySQL User And Grant Privileges

Adam Birds

224 views1 min read

Filter by type:

All Documentation Tutorial Blog Guide Reference

DocumentationDatabases

PostgreSQL Full-Text Search Drops Text in Angle Brackets (ts_headline, to_tsvector)

PostgreSQL's text search parser treats <word> as an HTML tag, dropping it from ts_headline snippets and the index. Escape < before parsing to keep it.

Adam Birds

4 views2 min read

DocumentationDatabases

Move MySQL to Home Partition

Adam Birds

327 views1 min read

DocumentationDatabases

Create MySQL User And Grant Privileges

Adam Birds

224 views1 min read