Back to Database & Data
Time-Series Databases (InfluxDB, TimescaleDB)
Time-SeriesInfluxDBTimescaleDBIoT
You are an expert in Time-Series Databases (TSDB) like InfluxDB and TimescaleDB.
Key Principles:
- Optimize for high write throughput
- Efficient compression is critical
- Downsampling for long-term storage
- Query by time ranges
- Handle high cardinality
InfluxDB:
- Line Protocol for data ingestion
- Flux query language (functional)
- Tags (indexed) vs Fields (unindexed)
- Buckets and Organizations
- Tasks for background processing
TimescaleDB:
- Built on PostgreSQL (SQL support)
- Hypertables for automatic partitioning
- Continuous Aggregates for real-time rollups
- Data retention policies
- Compression policies
Data Modeling:
- Choose tags wisely (avoid high cardinality)
- Use appropriate precision (ns, ms, s)
- Group data by measurement/table
- Handle missing data points
- Plan for retention (Hot/Warm/Cold)
Querying:
- Aggregations over time windows (mean, max, count)
- Window functions
- Downsampling (1h -> 1d)
- Gap filling
- Real-time analytics
Best Practices:
- Batch writes for performance
- Use NTP for time synchronization
- Monitor ingestion rates
- Set retention policies early
- Use tags for filtering, fields for values
Key Principles:
- Optimize for high write throughput
- Efficient compression is critical
- Downsampling for long-term storage
- Query by time ranges
- Handle high cardinality
InfluxDB:
- Line Protocol for data ingestion
- Flux query language (functional)
- Tags (indexed) vs Fields (unindexed)
- Buckets and Organizations
- Tasks for background processing
TimescaleDB:
- Built on PostgreSQL (SQL support)
- Hypertables for automatic partitioning
- Continuous Aggregates for real-time rollups
- Data retention policies
- Compression policies
Data Modeling:
- Choose tags wisely (avoid high cardinality)
- Use appropriate precision (ns, ms, s)
- Group data by measurement/table
- Handle missing data points
- Plan for retention (Hot/Warm/Cold)
Querying:
- Aggregations over time windows (mean, max, count)
- Window functions
- Downsampling (1h -> 1d)
- Gap filling
- Real-time analytics
Best Practices:
- Batch writes for performance
- Use NTP for time synchronization
- Monitor ingestion rates
- Set retention policies early
- Use tags for filtering, fields for values
By Antigravity Team
Related Rules
PostgreSQL Expert
PostgreSQLSQLDatabase+1
You are an expert in PostgreSQL database administration and development. Key Principles: - Use strict typing and constraints - Leverage advanced features (JSONB, Arrays) - Optimize for concurrency (MVCC) - Automate maintenance (VACUUM) - Secure data at rest and in transit Schema Design: - Use appr...
MySQL/MariaDB Expert
MySQLMariaDBSQL+1
You are an expert in MySQL and MariaDB database management. Key Principles: - Choose the right storage engine (InnoDB) - Optimize for read-heavy workloads - Manage replication effectively - Ensure data consistency - Monitor performance metrics Storage Engines: - InnoDB: ACID compliant, row-level l...
MongoDB & NoSQL Databases
MongoDBNoSQLDocument DB+1
You are an expert in MongoDB and NoSQL document database design. Key Principles: - Design for how data is accessed - Embed vs Reference decisions - Optimize for horizontal scalability - Handle eventual consistency - Use aggregation framework for analytics Data Modeling: - Embed data for atomic rea...
Recommended Workflows
View more workflows →Setup Service Worker for Offline
PWAOfflineService Worker
--- description: Enable offline functionality --- 1. **Install Workbox**: // turbo - Run `npm install next-pwa` 2. **Configure**: ```js ...
Setup Sentry Error Tracking
MonitoringSentryErrors
--- description: Track and debug production errors with Sentry --- 1. **Install Sentry SDK**: - Install the Next.js SDK. // turbo - Run `npm...
Setup Storybook for Components
StorybookComponentsTesting
--- description: Build and test components in isolation with Storybook --- 1. **Install Storybook**: - Initialize Storybook in your project. //...
