Salesmate to TimescaleDB integration — real-time, two-way sync

Yes. Stacksync provides a managed, real-time two-way integration between Salesmate and TimescaleDB: authenticate both systems, choose the objects to sync (such as Salesmate's Products and Notes), map fields visually, and changes propagate both ways in milliseconds — no code required.

Change detection on Salesmate: Webhook triggers via the platform's automation features, with scheduled polling on modified timestamps as fallback. On TimescaleDB: Log-based capture via PostgreSQL logical decoding where the deployment allows it — hypertable changes surface on the underlying chunk tables and must be remapped to the parent — or timestamp-based polling on time columns; regular Postgres tables replicate through standard logical replication. Each detected change propagates to the other side in milliseconds, with field-level conflict resolution and an inspectable event log.

On the Salesmate side: Notes, Users, Contacts, Companies, plus custom fields where Salesmate exposes them. On the TimescaleDB side: Chunks, Continuous Aggregates, Regular PostgreSQL Tables, Views. Stacksync auto-detects both schemas and converts types between the two systems.

Yes. Each object mapping can be bidirectional or restricted to a single direction (both systems accept writes). Read-only mirrors, one-way pushes, and full two-way sync can be mixed in the same integration.

Common patterns for Salesmate and TimescaleDB: Internal tools without API code; Trigger workflows from CRM changes; Query the CRM like a database. Back-office apps read and write the synced tables; Stacksync handles the Salesmate API, limits, and retries.

Salesmate: REST API. Authentication: Access token (API key) sent as a request header. TimescaleDB: SQL wire protocol (PostgreSQL). Authentication: Database credentials. Stacksync manages authentication, retries, and rate limits on both sides.