DEV Community

Cover image for Time-saver: This IDEA plugin can help you write FlinkSQL faster
DogeKing
DogeKing

Posted on

Time-saver: This IDEA plugin can help you write FlinkSQL faster

I often find my development efficiency affected by lacking a good Grammar-checking tool during big data development. Common issues include:

  • Missing commas, semicolons, or parentheses
  • Omitting certain keywords within CASE WHEN statements
  • Overlooking some keywords in nested queries
  • ……

These problems become quite common once SQL statements get lengthy.

so I wanted a tool to provide an IDE-like experience while writing FlinkSQL. then I developed an IDEA plugin specifically for FlinkSQL.

Address: https://plugins.jetbrains.com/plugin/25912-flink-sql-helper

This plugin currently supports all statements of FlinkSQL version 1.20 Its main features include grammar checking, code formatting, and code completion.

Let me introduce the features of this plugin.

Grammar check

SQL Format

Code Completion Proposals

Refactorings

Finally, I will provide a one-month activation code(valid until December 31, 2024). I hope everyone enjoys using it:

  • 88YTG-UYMBT-UAF7E-NZN48-MNBZ3
  • 3H52G-Y33JM-Q9QS6-7KLBL-PY5QE
  • FSQNR-UP5X7-6F5WN-M54YJ-QXEF8
  • Z7FJJ-X2XS8-MB2FF-BG43S-M4QW2
  • HDHYN-AEZSS-CFGC8-KAV2V-MXLAM

Image of Timescale

🚀 pgai Vectorizer: SQLAlchemy and LiteLLM Make Vector Search Simple

We built pgai Vectorizer to simplify embedding management for AI applications—without needing a separate database or complex infrastructure. Since launch, developers have created over 3,000 vectorizers on Timescale Cloud, with many more self-hosted.

Read full post →

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more