Hacker News
- The curious case of the aggregation query https://modern-sql.com/blog/2023-12/curious-case-aggregation-query 35 comments
- SQL reserved words – An empirical list https://modern-sql.com/reserved-words-empirical-list 114 comments
- PostgreSQL 11 Reestablishes Window Functions Leadership https://modern-sql.com/blog/2019-02/postgresql-11 15 comments
- How PostgreSQL’s SQL dialect stays ahead of its competitors [PDF slides] https://modern-sql.com/slides/PG-stays-ahead-20180718.pdf 2 comments
- One Giant Leap for SQL: MySQL 8.0 Released https://modern-sql.com/blog/2018-04/mysql-8.0 152 comments
- Pivot – Rows to Columns http://modern-sql.com/use-case/pivot 40 comments
- Three-Valued Logic http://modern-sql.com/concept/three-valued-logic 72 comments
- Literate SQL http://modern-sql.com/use-case/literate-sql 95 comments
- The SQL filter clause: selective aggregates http://modern-sql.com/feature/filter 47 comments
- Literate SQL https://modern-sql.com/use-case/literate-sql 36 comments
- Modern SQL: With – Organize Complex Queries https://modern-sql.com/feature/with 61 comments
- The ANY_VALUE Aggregate Function: New in SQL:2023 — and a better feature from 1999 https://modern-sql.com/caniuse/any_value 10 comments programming
- ANY_VALUE(…): New in SQL:2023 — but do we need it? https://modern-sql.com/caniuse/any_value 33 comments sql
- The Curious Case of the Aggregation Query https://modern-sql.com/blog/2023-12/curious-case-aggregation-query 6 comments sql
- NULL in SQL: Indicating the Absence of Data https://modern-sql.com/concept/null 3 comments database
- SQL’s Merge performs Insert, Update and Delete operations based on when…then rules https://modern-sql.com/caniuse/merge 3 comments programming
- Modern SQL has nice features that are not available through JPA. Blaze-Persistence provides mappings for them. https://modern-sql.com/blog/2020-09/blaze-persistence 41 comments java
- Java and SQL, Stronger Together https://modern-sql.com/blog/2020-05/java-and-sql-stronger-together 6 comments java
- PostgreSQL 11 Reestablishes Window Functions Leadership https://modern-sql.com/blog/2019-02/postgresql-11 30 comments programming
- SQLite in 2018: A state of the art SQL dialect https://modern-sql.com/blog/2019-01/sqlite-in-2018 25 comments programming
- What parts of Standard SQL aren't implemented in PostgreSQL? https://modern-sql.com/blog/2018-06/postgresql-standard-sql-gap-analysis 14 comments programming
- One Giant Leap For SQL: MySQL 8.0 Released https://modern-sql.com/blog/2018-04/mysql-8.0 79 comments programming
- Modern SQL Features Where PostgreSQL Beats its Competitors https://modern-sql.com/blog/2018-02/standard-sql-features-where-postgresql-beats-its-competitors 9 comments programming
- Modern SQL: Three-Valued Logic (3VL) — Purpose, Benefits and Special Cases http://modern-sql.com/concept/three-valued-logic 16 comments programming
- Modern SQL: NULL — purpose, comparisons, NULL in expressions, mapping to/from NULL http://modern-sql.com/concept/null 9 comments programming
- Was Siberia a lava lake in the distant past? http://modern-sql.com/feature/with/performance 3 comments programming
- The performance impact of SQL WITH clause on all major relational databases https://modern-sql.com/feature/with/performance 10 comments programming
- The SQL filter clause: selective aggregates – e.g., to pivot data http://modern-sql.com/feature/filter 11 comments programming
- Literate SQL https://modern-sql.com/use-case/literate-sql 3 comments coding
- Literate SQL https://modern-sql.com/use-case/literate-sql 75 comments programming
- Modern SQL: With – Organize Complex Queries https://modern-sql.com/feature/with 12 comments programming
Linking pages
- Why SQL Is Neither Legacy, nor Low-Level, nor Difficult, nor the Wrong Place for (Business) Data Logic, but Is Simply Awesome! | Vertabelo Database Modeler http://www.vertabelo.com/blog/notes-from-the-lab/why-sql-is-neither-legacy-nor-low-level-but-simply-awesome 593 comments
- How To Become a Data Engineer https://khashtamov.com/en/how-to-become-a-data-engineer/ 137 comments
- How To Learn Data Science - My path | by Senthil E | Towards Data Science https://towardsdatascience.com/how-to-learn-data-science-my-path-ba7b9aa94f63?sk=47d16e88a2bcb0635ab14792b0092fb6&source=friends_link 41 comments
- How To Learn Data Science - My path | by Senthil E | Towards Data Science https://medium.com/p/how-to-learn-data-science-my-path-ba7b9aa94f63?sk=47d16e88a2bcb0635ab14792b0092fb6&source=email-1d8fcdc16d73--writer.postDistributed 13 comments
- SQL: One of the most valuable skills - Craig Kerstiens https://www.craigkerstiens.com/2019/02/12/sql-one-of-the-most-valuable-skills/ 9 comments
- How SQL can unify access to APIs | InfoWorld https://www.infoworld.com/article/3648648/how-sql-can-unify-access-to-apis.html 7 comments
- 50 Shades of NULL â The Different Meanings of NULL in SQL | Vertabelo Database Modeler http://www.vertabelo.com/blog/technical-articles/50-shades-of-null-or-how-a-billion-dollar-mistake-has-been-stalking-a-whole-industry-for-decades 2 comments
- Advanced SQL - window functions – Michał Konarski http://mjk.space/advanced-sql-window-functions/ 0 comments
- Advanced SQL - Common Table Expressions – Michał Konarski http://mjk.space/advanced-sql-cte/ 0 comments
- Scaling a GraphQL Website â The Art of Machinery https://theartofmachinery.com/2020/06/29/scaling_a_graphql_site.html 0 comments
- GitHub - adilkhash/Data-Engineering-HowTo: A list of useful resources to learn Data Engineering from scratch https://github.com/adilkhash/Data-Engineering-HowTo 0 comments
- Looking at MySQL 8 with PostgreSQL goggles on - CYBERTEC https://www.cybertec-postgresql.com/en/looking-at-mysql-8-with-postgresql-goggles-on/ 0 comments
- Advanced SQL - window frames – Michał Konarski https://mjk.space/advances-sql-window-frames/ 0 comments
- SQL identity columns | Peter Eisentraut http://peter.eisentraut.org/blog/2023/10/31/sql-identity-columns 0 comments
- Postgres again elected DBMS of the Year in 2023, but I'm worried | Select * from Adrien https://blog.anayrat.info/en/2024/02/05/postgres-again-elected-dbms-of-the-year-in-2023-but-im-worried/ 0 comments
- Recommended resources to improve your knowledge of Databases and PostgreSQL | Select * from Adrien https://blog.anayrat.info/en/2024/02/12/recommended-resources-to-improve-your-knowledge-of-databases-and-postgresql/ 0 comments