SQL Tips and Tricks

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  1. SQL-tips-and-tricks

    SQL tips and tricks

    Maybe off-topic, but: is "just closing without comment or discussion" an acceptable way of a maintainer to deal with pull requests?

    Asking as someone who only occasionally contributed (or tried to) with a repository.

    Examples: https://github.com/ben-n93/SQL-tips-and-tricks/pulls?q=is%3A...

  2. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  3. sqlglot

    Python SQL Parser and Transpiler

    SQLFluff is a linter formatter written in Python https://sqlfluff.com/

    Heard there is a faster one called sqruff, but I have not tried it

    https://www.quary.dev/blog/sqruff-launch

    Might also be able to cajole sqlglot into being a formatter but it's designed for forgiving dialect conversion, not formatting

    https://github.com/tobymao/sqlglot

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Show HN: Synmetrix – production-ready open source semantic layer on Cube

    1 project | news.ycombinator.com | 30 Aug 2024
  • Google's New Pipe Syntax in SQL

    11 projects | news.ycombinator.com | 28 Aug 2024
  • Loading a trillion rows of weather data into TimescaleDB

    8 projects | news.ycombinator.com | 16 Apr 2024
  • This Week In Python

    5 projects | dev.to | 17 Mar 2024
  • Pql, a pipelined query language that compiles to SQL (written in Go)

    6 projects | news.ycombinator.com | 28 Feb 2024

Did you know that Python is
the 2nd most popular programming language
based on number of references?