Join us for a virtual meetup on Zoom at 8 PM, July 31 (PDT) about using One Time Series Database for Both Metrics and Logs 👉🏻 Register Now

Skip to content
On this page
Engineering
January 8, 2025

GreptimeDB Sends Early New Year's Greetings with Features like Skipping Index, PG Metadata Storage, Loki JSON Write, and More! | Greptime Biweekly Report

A recap of the past 3 weeks progress and changes happened on GreptimeDB.

Together with our global community of contributors, GreptimeDB continues to evolve and flourish as a growing open-source project. We are grateful to each and every one of you.

Below are the highlights among recent commits:

  • Introduce New SKIPPING INDEX
  • PostgreSQL as meta storage backend
  • Ingest with Grafana Loki JSON
  • COPY TO with SELECT query
  • Enhanced FLOW usability and error handling

Contributors

For the past three weeks, our community has been super active with a total of 134 PRs merged. 9 PRs from 5 individual contributors merged successfully and lots pending to be merged.

Congrats on becoming our most active contributors in the past 2 weeks:

👏 Welcome @yihong0618 @zzzdong to the community as a new contributor with a successfully merged PR, and more PRs from other individual contributors are waiting to be merged.

New Contributors of GreptimeDB
New Contributors of GreptimeDB

🎉 A big THANK YOU to all our members and contributors! It is people like you who are making GreptimeDB a great product. Let's build an even greater community together.

Highlights of Recent PRs

db#5176 Experimental SKIPPING INDEX

We are thrilled to announce our newest cutting-edge index type, SKIPPING INDEX, which can accelerate query by a lot, especially on high-cardinality scenarios, with a relatively small storage overhead. Notice that this experimental index is in the early preview phase.

db#5208 PostgreSQL as New Meta Storage Option

After the election feature is implemented, we can now use PostgreSQL-compatible RDS as our meta storage, providing a new option against etcd.

db#5288 Grafana Loki JSON Write Protocol

We have supported Grafana Loki gRPC write protocol for a while. This time we add support for JSON protocol as well so that users can shift from Loki to GreptimeDB more easily.

db#5250 COPY TO with SELECT Query

We can now write SELECT query in the COPY TO clause, for example:

sql
COPY (select host, cpu, ts from demo where host = 'host2') TO '/tmp/export/demo.parquet';

db#5112 db#4890 db#5203 db#5251 db#5234 Enhanced Flow Usability and Error Handling

In the past weeks, we've devoted ourselves to making Flow easier to use. Now it has better in-time validations, more informative error messages, and more intelligent type inference.

db#5273 db#5254 Critical Bug Fixes

Two edge cases may lead to unexpected behavior. Specifically in concurrent automatic table alteration. Though these cases are hard to meet, we still recommend upgrading our latest release v0.11.2.

Good First Issue

db#5296 Refactor QueryContext Struct to Reduce Duplicate Information

  • Level: Medium

  • Keyword: Query, Refactor


About Greptime

Greptime offers industry-leading time series database products and solutions to empower IoT and Observability scenarios, enabling enterprises to uncover valuable insights from their data with less time, complexity, and cost.

GreptimeDB is an open-source, high-performance time-series database offering unified storage and analysis for metrics, logs, and events. Try it out instantly with GreptimeCloud, a fully-managed DBaaS solution—no deployment needed!

The Edge-Cloud Integrated Solution combines multimodal edge databases with cloud-based GreptimeDB to optimize IoT edge scenarios, cutting costs while boosting data performance.

Star us on GitHub or join GreptimeDB Community on Slack to get connected.

Join our community

Get the latest updates and discuss with other users.