| | SQLite in 2018: A state of the art Sql dialect (modern-sql.com) |
| 1 point by fforflo on Jan 28, 2019 | past |
|
| | SQLite in 2018: A state of the art SQL dialect (modern-sql.com) |
| 4 points by ingve on Jan 16, 2019 | past |
|
| | SQLite in 2018: A state of the art SQL dialect (modern-sql.com) |
| 4 points by MarkusWinand on Jan 15, 2019 | past |
|
| | Modern SQL: What’s New in Oracle Database 18c (modern-sql.com) |
| 2 points by MarkusWinand on Nov 21, 2018 | past |
|
| | What’s New in MariaDB 10.3 – Time traveling, sequences, percentiles (modern-sql.com) |
| 1 point by MarkusWinand on Aug 24, 2018 | past |
|
| | What’s New in MariaDB 10.3 – They now embrace modern SQL standards (modern-sql.com) |
| 3 points by MarkusWinand on Aug 22, 2018 | past |
|
| | How Postgres's SQL Dialect Stays Ahead of Its Competitors [pdf] (modern-sql.com) |
| 2 points by craigkerstiens on July 25, 2018 | past |
|
| | How PostgreSQL’s SQL dialect stays ahead of its competitors [PDF slides] (modern-sql.com) |
| 4 points by MarkusWinand on July 20, 2018 | past | 2 comments |
|
| | PostgreSQL Standard SQL Gap Analysis (modern-sql.com) |
| 4 points by dmmalam on June 7, 2018 | past |
|
| | PGCon 2018: PostgreSQL Standard SQL Gap Analysis (modern-sql.com) |
| 2 points by MarkusWinand on June 6, 2018 | past |
|
| | One Giant Leap for SQL: MySQL 8.0 Released (modern-sql.com) |
| 136 points by dhd415 on April 25, 2018 | past | 152 comments |
|
| | Aliasing Table and Column Names in the FROM Clause (modern-sql.com) |
| 1 point by okket on March 11, 2018 | past |
|
| | Pivot – Rows to Columns (modern-sql.com) |
| 145 points by mooreds on Feb 5, 2018 | past | 40 comments |
|
| | Three-Valued Logic (modern-sql.com) |
| 138 points by okket on Dec 14, 2017 | past | 72 comments |
|
| | IS DISTINCT FROM – A comparison operator that treats two NULL values as the same (modern-sql.com) |
| 2 points by okket on Dec 6, 2017 | past |
|
| | NULL in SQL: Indicating the Absence of Data (modern-sql.com) |
| 1 point by kawera on Dec 2, 2017 | past |
|
| | SQL Pivot in All Databases: MySQL, MariaDB, SQLite, PostgreSQL, Oracle, … (modern-sql.com) |
| 2 points by okket on Oct 9, 2017 | past |
|
| | Modern SQL: Extract – Get a Field from a DATE or TIME Value (modern-sql.com) |
| 1 point by MarkusWinand on Sept 21, 2017 | past |
|
| | Modern SQL: EXTRACT Components from a Date or Time in MySQL, Oracle, PostgreSQL (modern-sql.com) |
| 2 points by okket on Sept 20, 2017 | past |
|
| | Literate SQL (modern-sql.com) |
| 221 points by mshenfield on June 25, 2017 | past | 95 comments |
|
| | What's New in SQL:2016 (modern-sql.com) |
| 4 points by okket on June 15, 2017 | past |
|
| | SQL:2016 got listagg: turning rows into delimited strings (modern-sql.com) |
| 1 point by MarkusWinand on April 6, 2017 | past |
|
| | The SQL:2016 Standard Introduced MATCH_RECOGNIZE: Regular Expressions Over Rows (modern-sql.com) |
| 1 point by MarkusWinand on March 23, 2017 | past |
|
| | The performance impact of SQL WITH clause on all major relational databases (modern-sql.com) |
| 3 points by lukaseder on Feb 2, 2017 | past |
|
| | How to PIVOT in SQL (modern-sql.com) |
| 3 points by mariuz on Jan 24, 2017 | past |
|
| | Pivot in pure SQL, with an application to the entity-attribute-value model (modern-sql.com) |
| 6 points by MarkusWinand on June 28, 2016 | past |
|
| | The SQL filter clause: selective aggregates (modern-sql.com) |
| 138 points by MarkusWinand on May 30, 2016 | past | 47 comments |
|
| | Literate SQL (modern-sql.com) |
| 68 points by based2 on Dec 19, 2015 | past | 36 comments |
|
| | Literate SQL (modern-sql.com) |
| 4 points by MarkusWinand on Dec 14, 2015 | past |
|
| | Modern SQL: With – Organize Complex Queries (modern-sql.com) |
| 165 points by MarkusWinand on Nov 24, 2015 | past | 61 comments |
|
|
| More |
