SQL: The difference between WHERE and HAVING

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com
SQL relational-model Query Language Database

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

  • SQLToy

    Learn SQL by creating a SQL database in JavaScript

    • You might look at SQLToy which is a DB and blog I wrote to teach how SQL processing works internally: https://github.com/weinberg/SQLToy

  • FunSQL.jl

    Julia library for compositional construction of SQL queries

    • There is no HAVING and the you can use any tabular operators in any order. Aggregates are also separated from grouping and can be used in any context after Group is applied.

    [0] https://github.com/MechanicalRabbit/FunSQL.jl

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • TablaM

    The practical relational programing language for data-oriented applications

    • Building https://tablam.org I learn a bit about the relational model and found that the whole having/group by is plain bad "hack".

    GROUP BY is totally the opposite of what you expect. It NOT "group by"!,

    This is group by:

        1:

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