Database interface support

Start with the task you need to complete. A checkmark means the linked guide contains a supported workflow for that interface; an em dash means to choose another interface.

Records and queries

Workflow	JavaScript	Python	REST	Console	Refine	Guide
Create, read, update, and delete one record	✓	✓	✓	✓	Read	Records
Create or update by primary key	✓	✓	✓	—	—	Records
Create, update, or delete an explicit batch	✓	✓	✓	—	—	Bulk operations
Filter, sort, and paginate	✓	✓	✓	✓	✓	Query records
Select response fields	✓	—	✓	—	✓	Query records
Nested AND and OR filters	✓	✓	✓	✓	✓	Filter operators
Logical NOT filters	—	✓	✓	—	—	Filter operators
Per-record allowed-action hints	✓	✓	✓	—	✓	Query records
Read related records with separate scoped queries	✓	✓	✓	—	✓	Relationships
Count, group, and aggregate	✓	✓	✓	—	—	Aggregations
Full-text search	✓	✓	✓	—	✓	Search
Vector and hybrid search	—	✓	✓	—	—	Search
Async record and query workflows	—	✓	—	—	—	Async Python
Parent-child and connection-table models	✓	✓	✓	✓	Read	Hierarchies and graphs
Application-controlled import and export	✓	✓	✓	—	—	Import and export

Tables and schemas

Database appears as Datatables in TaruviBase Console. Create and change tables there; applications work with records through the SDKs, REST, or Refine.

Task	Interface	Guide
Inspect table metadata and the stored schema	TaruviBase Console	TaruviBase Console
Design a table and its fields	Table schema	Tables and schemas
Create, change, or delete a table	TaruviBase Console	Table lifecycle
Plan a schema change	TaruviBase Console or REST API	Schema changes
Plan or verify indexes	Table schema	Indexes
Add, browse, filter, edit, and delete records	TaruviBase Console	TaruviBase Console

Production guidance

Requirement	Guide
Scope requests and apply least privilege	Security and limits
Test allowed, denied, anonymous, cross-app, and cross-site access	Access policy testing
Plan transactions, retries, concurrent writes, and batch recovery	Reliability
Design recoverable event consumers	Reliability
Handle success envelopes and structured errors	Requests, responses, and errors
Check flat-table and whole-table JSONB compatibility	Storage compatibility
Diagnose query, write, and SDK failures	Troubleshooting

Safe composition patterns

Use these patterns when a task spans several records or tables:

Requirement	Pattern
Insert or update by primary key	Use the primary-key upsert workflow
Insert or update by another unique field	Read and reconcile the field, then choose explicit create or update
Delete by a filter	Query a bounded set, review IDs, then use bulk delete
Filter, sort, or display related data	Read the related IDs first, then query the root table and join the results in application code
Traverse a hierarchy	Use parent identifiers or junction tables with bounded queries
Build a graph or edge model	Use ordinary node records plus an authorized junction table
Import or export a dataset	Use checkpointed record batches
Store structured JSON inside a record	Use an object field in a managed flat table
Use whole-table JSONB storage	Review the separate storage compatibility contract before choosing an interface
Automate a Database task	Use the JavaScript SDK, Python SDK, or REST API

Setup and reference

Interface	Setup	Reference
JavaScript SDK	Configure the client	Method signatures shown with each task
Python SDK	Configure the client	Method signatures shown with each task
REST API	Review direct HTTP setup	Request contracts shown with each task
TaruviBase Console	Open Datatables	This product guide
Refine provider	Connect Refine	Refine integration

The product guides explain task behavior and supported interface combinations. Each task keeps its supported SDK methods and REST request contract beside the behavior it implements.