Topic cluster
How-to guide
A goal-oriented document that gives practical steps for a specific outcome.
View topic page7 items
The remaining keywords do not make a useful further split. All matching documentation is listed below.
Add a database query when models are not enough
Prefer Zotonic models for resources and edges. Use z_db for application tables or queries that the model APIs do not cover.
Check or change a site database connection
Verify host, role, database, and schema before restarting a site.
Prepare local PostgreSQL
Create and check the database used by a native development installation.
Search
Query arguments and terms for searching pages using the search APIs.
Test the database connection
Run bin/zotonic connectdb to test a connection using the global Zotonic database configuration. It does not open PostgreSQL’s interactive client and has no site selector in this checkout.
Trace database queries for your session
Enable module#mod_server_storage if the Development page says it is needed for database tracing. On the Development page, enable Trace all database queries for the current session.
Upgrade a module's data schema
Version schema changes through the module's installation and upgrade mechanism. Inspect a module using -mod_schema and manage_schema/2 before adding your own versioned step.