no-sql-wx-mp-sdk_skill

Overview

This skill explains how to use the CloudBase document database SDK inside WeChat MiniProgram projects to query, create, update, and delete records. It covers initialization, collection references, query operators, pagination, aggregation, and geolocation queries, with practical guidance for safer, typed usage. The goal is to help you integrate CloudBase document DB operations into MiniProgram code reliably and efficiently.

How this skill works

Initialize a database handle via wx.cloud.database(), optionally specifying an env id to target a particular CloudBase environment. Use db.collection('name') and doc(id) to reference collections and documents; use db.command (alias _) for query operators and complex expressions. The SDK supports CRUD, pagination, aggregation pipelines, and geo-queries, while MiniProgram runtime provides built-in authentication and cloud context access.

When to use it

• Building MiniProgram features that need persistent structured storage (todos, profiles, posts).
• Performing complex reads with filters, joins, or aggregation (analytics, dashboards).
• Implementing location-aware features using geolocation queries (nearby search).
• Needing serverless data access without maintaining a separate backend.
• Working with paginated lists or cursor-based infinite scroll UIs.

Best practices

• Define TypeScript types and a model layer for each collection to enforce schema and reduce runtime errors.
• Prefix collection names consistently per project or domain to avoid collisions.
• Configure and test database security rules before enabling write operations.
• Use db.command operators for server-side filtering and atomic updates rather than client-side joins or merges.
• Use pagination and limit clauses to avoid fetching large datasets at once.

Example use cases

• A task manager MiniProgram: create, query, and update todo items with typed models and pagination.
• A local business finder: store locations and use geolocation queries to return nearby results.
• An analytics view: run aggregation pipelines to compute daily active counts or top items.
• A social feed: combine complex queries and pagination to power infinite-scroll post lists.