ForkFree

Data and analytics

timescaledb

by timescale

TimescaleDB is an extension for the PostgreSQL database that makes it faster at storing and querying data that arrives over time, such as sensor readings, logs or financial ticks. It is used for real-time analytics while keeping normal SQL and Postgres tools.

Worth a lookEstablished, with a few things to check (listed below).

View on GitHubProject website

Stars
23.8k +3 a day
Licence
Apache-2.0
Runs on
A small server
Setup
Moderate
Language
C
Age
3523 days

What you can do with it

  • Store millions of sensor or event readings in Postgres tables that scale well over time
  • Run fast SQL queries such as hourly or daily averages using time buckets
  • Compress older data into a columnar format to save disk space and speed up reports

Could replace

  • Amazon Timestream

Our suggestion based on what it does, not a feature-by-feature comparison.

Make money with it

A freelancer could set up and manage monitoring and analytics databases for small firms with sensors or event data, charging for setup and support.

An idea, not financial advice. Check the licence before charging for anything built on it.

Ways a business could use it

  • Keep IoT, energy or equipment monitoring data in one affordable Postgres database instead of a paid metrics service
  • Build usage, sales or financial dashboards that query large volumes of timestamped records quickly

Can you use it commercially?

Free to use, change and sell (Apache 2.0 in the licence file). Some folders may carry other terms.

Not legal advice. Read the project's licence file before building a product on it.

Getting it running

Run it with a one-line script or a Docker command, then connect with psql or pgAdmin; production installs follow a separate guide.

Follow the official instructions in the project README.

Things to check

  • Licence is listed as unclear (NOASSERTION); some features sit under a non-open Timescale licence, so check terms before commercial or hosted use
  • The quick-start script is for local testing only, not production
  • Needs SQL and Postgres knowledge to use well

Checked 30 Oct 2026. Summary drafted by AI from the project's README.

More in Data and analytics

Scrapling D4Vinci
Worth a look

Scrapling is a Python library for collecting data from websites, covering single page requests, JavaScript-heavy sites and large crawls. It is used to pull out text, prices, listings and other information and save it as JSON, CSV or Markdown.

90.4k stars +126 a day BSD-3-Clause
metabase metabase
Check the licence

Metabase is a business intelligence tool that connects to your databases so people can ask questions, build dashboards and share reports without needing to write SQL. It can be self-hosted or used as a paid cloud service, and it can also be embedded in other apps.

Could replace Tableau, Microsoft Power BI

50k stars +36 a day Unclear
daily_stock_analysis ZhuLinsen
Worth a look

A Python system that uses large language models to analyse a personal watchlist of shares across several markets, including China, Hong Kong, the US, Japan, Korea and Taiwan. It gathers market data and news, then sends a daily "decision dashboard" report to chat apps or email.

67.3k stars +44 a day MIT