MarkusWinand

9 ms·

61.
Internals of PostgreSQL – Online book covering PostrgreSQL 11(interdb.jp)
3 points by MarkusWinand 8y ago|0 comments
62.
SQLite in 2018: A state of the art SQL dialect(modern-sql.com)
4 points by MarkusWinand 8y ago|0 comments
63.
SQL Is No Excuse to Avoid DevOps(queue.acm.org)
2 points by MarkusWinand 8y ago|0 comments
64.
What every developer should know about SQL performance(use-the-index-luke.com)
4 points by MarkusWinand 8y ago|0 comments
65.
The Mother of All Query Languages: SQL in Modern Times [15 Min Talk](youtube.com)
8 points by MarkusWinand 8y ago|0 comments
66.
The Revival of Great SQL Ideas(winand.at)
90 points by MarkusWinand 8y ago|17 comments
67.
Database News Review: Consistency, Cloud, JIT(winand.at)
2 points by MarkusWinand 8y ago|0 comments
68.
Modern SQL: What’s New in Oracle Database 18c(modern-sql.com)
2 points by MarkusWinand 8y ago|0 comments
69.
PostgreSQL 11 Released(postgresql.org)
621 points by MarkusWinand 8y ago|161 comments
70.
My JavaZone talk: “Modern SQL: Evolution of a dinosaur” [56 minutes](vimeo.com)
2 points by MarkusWinand 8y ago|0 comments
71.
What’s New in MariaDB 10.3 – Time traveling, sequences, percentiles(modern-sql.com)
1 points by MarkusWinand 8y ago|0 comments
72.
What’s New in MariaDB 10.3 – They now embrace modern SQL standards(modern-sql.com)
3 points by MarkusWinand 8y ago|0 comments
73.
by MarkusWinand 8y ago
I've just built the snapshot. The binary is still less than 2MB. And it works: sqlite> with t(x) as (values (1), (2)) select sum(x) over (order by x) from t; 1 3
74.
SQLite Release 3.25.0 adds support for window functions(sqlite.org)
333 points by MarkusWinand 8y ago|115 comments
75.
by MarkusWinand 8y ago
Thanks for pointing out! The syntax used by SQL Server doesn't follow the standard. Or, in other words, the standard syntax gives an error in SQL server. However, I'll note that there is an alternative syntax in future versions of
76.
How PostgreSQL’s SQL dialect stays ahead of its competitors [PDF slides](modern-sql.com)
4 points by MarkusWinand 8y ago|2 comments
77.
by MarkusWinand 8y ago
SQL uses nesting as you have shown instead of a "pipe" (think of it like functional programming). The difference is just the syntax, not the expressiveness.
78.
by MarkusWinand 8y ago
Just FYI: The SQL standard supports both types. The other one (valid time) is called "application versioning" in SQL. Read this paper if you'd like to learn more about it: http://cs.ulb.ac.be/public/_medi
79.
by MarkusWinand 8y ago
Ah, "dozen of extra lines" is not exactly what I was expecting for "isn't as powerful" ;)
80.
by MarkusWinand 8y ago
> For one, there's no official specification I'd take ISO/IEC 9075 as an official specification: https://webstore.iec.ch/publication/59685 > and isn't as powerful as I'd always want it to
81.
Important database news from the last few months(winand.at)
123 points by MarkusWinand 8y ago|81 comments
82.
by MarkusWinand 8y ago
I've recently blogged something in the same vein. “MySQL is under new management since Oracle bought it through Sun. I must admit: it might have been the best thing that happened to SQL in the past 10 years, and I really mean SQL—not M
83.
How Oracle's Acquisition Was Actually the Best Thing to Happen to MySQL(itprotoday.com)
1 points by MarkusWinand 8y ago|1 comments
84.
by MarkusWinand 8y ago
This is something we have to blame the vendors for. There is an international SQL standard from ISO, it's just not commonly followed. However, sometimes the standard isn't very useful in itself. For this example, FETCH FIRST x ROW
85.
Truth First, or Why You Should Mostly Implement Database-First Designs(blog.jooq.org)
205 points by MarkusWinand 8y ago|93 comments
86.
PGCon 2018: PostgreSQL Standard SQL Gap Analysis(modern-sql.com)
2 points by MarkusWinand 8y ago|0 comments
87.
MariaDB 10.3 released – features “System-versioned tables” aka “time traveling”(mariadb.com)
5 points by MarkusWinand 8y ago|0 comments
88.
by MarkusWinand 8y ago
Full quote. > MySQL is very popular. According to db-engines.com, it’s the second most popular SQL database overall. More importantly: it is, by a huge margin, the most popular free SQL database. The second sentence is linked: https:&#x
89.
by MarkusWinand 8y ago
In SQL:2016, it is > 4.24.13 Known functional dependencies in the result of a <group by clause> Not that this is about the result of a <group by clause> edit : The matrix I have in the article is not complete. I've ju
90.
by MarkusWinand 8y ago
The adoption of standard SQL is really poor on many SQL products. I mentioned that in the article: > I believe the main reasons are a lack of knowledge and interest among developers along with poor support for modern SQL in database prod

More ›