--- title: Best TimescaleDB posts of 2024 | daily.dev description: The most upvoted TimescaleDB posts of 2024, curated by the daily.dev community. canonical: https://daily.dev/tags/timescaledb/best-of/2024 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/tags/timescaledb/best-of/2024 og:type: website og:site_name: daily.dev og:title: Best TimescaleDB posts of 2024 | daily.dev og:description: The most upvoted TimescaleDB posts of 2024, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of TimescaleDB — 2024 1. 1 [](/posts/building-a-high-performance-sensor-data-api-with-fastapi-and-postgres-timescaledb-extension-gvfsxlgvo "Building a High-Performance Sensor Data API with FastAPI and Postgres' TimescaleDB Extension") Article Community Picks · 2y Building a High-Performance Sensor Data API with FastAPI and Postgres' TimescaleDB Extension This guide helps you build a high-performance API for streaming, storing, and querying sensor data using FastAPI and TimescaleDB. It covers setting up the project, database, and creating API endpoints that efficiently manage and analyze sensor data, leveraging TimescaleDB's advanced time-series features for optimal performance. 29 2. 2 [](/posts/timescale-timescaledb-an-open-source-time-series-sql-database-optimized-for-fast-ingest-and-complex-q1pvlxtcb "timescale/timescaledb: An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.") Article Community Picks · 2y timescale/timescaledb: An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension. TimescaleDB is an open-source, time-series SQL database built as a PostgreSQL extension, offering automatic partitioning and full SQL support. It presents data as hypertables, which are abstractions of many individual tables, making management and usage similar to standard PostgreSQL. Timescale also offers a fully managed cloud version with a 30-day free trial. The post includes details on creating tables, converting them to hypertables, and performing SQL queries. 19 3. 3 [](/posts/industrial-iot-visualization-why-united-manufacturing-hub-chose-grafana-to-power-its-iiot-platform-qc39nsjjn "Industrial IoT visualization: Why United Manufacturing Hub chose Grafana to power its IIoT platform") Article Grafana Labs · 2y Industrial IoT visualization: Why United Manufacturing Hub chose Grafana to power its IIoT platform United Manufacturing Hub (UMH) has chosen Grafana for its industrial IoT (IIoT) platform due to its flexibility, cost-effectiveness, and ease of use. Unlike traditional industrial tools, Grafana offers visually compelling dashboards and an extensive online community for support. Integrating seamlessly with TimescaleDB, it allows for real-time data visualization from various sources. While Grafana cannot directly interface with industrial controllers, workarounds exist to facilitate this communication. UMH also leverages Grafana Cloud for monitoring internal systems. 16 4. 4 [](/posts/postgresql-data-cleaning-vs-python-data-cleaning-ptvdx6a37 "PostgreSQL Data Cleaning vs. Python Data Cleaning") Article TigerData (Creators of TimescaleDB) · 2y PostgreSQL Data Cleaning vs. Python Data Cleaning This post explores how PostgreSQL and TimescaleDB can be used for efficient data cleaning tasks, replacing the need for tools like Excel, R, or Python. By cleaning data directly within the database, tasks can be performed more efficiently, saving time in the long run. 12 1 [See all TimescaleDB archives](/tags/timescaledb/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/tags/timescaledb/best-of/2024#page","url":"https://daily.dev/tags/timescaledb/best-of/2024","name":"Best TimescaleDB Posts of 2024","description":"The most upvoted TimescaleDB posts of 2024, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/timescaledb/best-of/2024#items","numberOfItems":4,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/building-a-high-performance-sensor-data-api-with-fastapi-and-postgres-timescaledb-extension-gvfsxlgvo","name":"Building a High-Performance Sensor Data API with FastAPI and Postgres' TimescaleDB Extension"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/timescale-timescaledb-an-open-source-time-series-sql-database-optimized-for-fast-ingest-and-complex-q1pvlxtcb","name":"timescale/timescaledb: An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension."},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/industrial-iot-visualization-why-united-manufacturing-hub-chose-grafana-to-power-its-iiot-platform-qc39nsjjn","name":"Industrial IoT visualization: Why United Manufacturing Hub chose Grafana to power its IIoT platform"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/postgresql-data-cleaning-vs-python-data-cleaning-ptvdx6a37","name":"PostgreSQL Data Cleaning vs. Python Data Cleaning"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tags","item":"https://daily.dev/tags"},{"@type":"ListItem","position":3,"name":"TimescaleDB","item":"https://daily.dev/tags/timescaledb"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/tags/timescaledb/best-of"},{"@type":"ListItem","position":5,"name":"2024"}]}]} ```