Author | Lightnews

Markus Winand @winand.at · 5d

Ich hab den standard nie so interpretiert. Aktuell (SQL:2023) wurde es aber konfigurierbar gemacht: modern-sql.com/caniuse/F292

F292, “UNIQUE null treatment”

Explicit null treatment in unique constraints is not widely supported

modern-sql.com

Reposted by Markus Winand

Erik C. Thauvin @erik.thauvin.net · 10d

Derby DB to be retired!

#apache #database #java

issues.apache.org/jira/...

2 3

Markus Winand @winand.at · 10d

Oracle 26ai¹ was released yesterday.

From the SQL standpoint it's worth mentioning that is has got the QUALIFY clause:

I bet this starts an avalanche (there are already PostgreSQL patches).

modern-sql.com/caniuse/qual...

¹ 26ai is the marketing version, 23.26.0 is the technical version.

QUALIFY clause (window functions)

QUALIFY: filter rows based on window functions

modern-sql.com

2 6 10

Markus Winand @winand.at · Sep 24

Because it is a list of lists.

1 1

Markus Winand @winand.at · Sep 13

The best thing is how they “solved” the problem ;)

nixCraft @cyberciti.biz · Sep 13

they used AI to uppercase text? lol.

A Reddit post titled "Wow... we've been burning money for 6 months." The post's author, u/me_z, describes how their company's OpenAI usage was costing around $1200 a month. They are using GPT-4 for simple tasks like extracting phone numbers, checking for profanity, reformatting JSON, and uppercasing text. The author ends by asking, "Am I an idiot? How much are you guys spending?"

1 2 9

Reposted by Markus Winand

Markus Winand @winand.at · Sep 5

After being « gone fishin' » during summertime I just updated my website for the releases that happened during that time:

* MariaDB 11.8 and 12.0
* Oracle 23.9
* Db2 12.1.2

All charts on modern-sql.com and use-the-index-luke.com are updated.

Modern SQL: A lot has changed since SQL-92

SQL has evolved. Beyond the relational model. Discover it now.

modern-sql.com

1 3 12

Markus Winand @winand.at · Sep 5

My favorite change is that MariaDB got an improved implementation of the WHERE year(...) = ? rewriting. use-the-index-luke.com/blog/2024-12...

In picture: the green check mark used to be yellow, with the "a" footnote: Unconditionally rewritten — even if only a matching function-based index exists

2 6

Markus Winand @winand.at · Sep 5

After being « gone fishin' » during summertime I just updated my website for the releases that happened during that time:

* MariaDB 11.8 and 12.0
* Oracle 23.9
* Db2 12.1.2

All charts on modern-sql.com and use-the-index-luke.com are updated.

Modern SQL: A lot has changed since SQL-92

SQL has evolved. Beyond the relational model. Discover it now.

modern-sql.com

1 3 12

Reposted by Markus Winand

nixCraft @cyberciti.biz · Aug 28

💯

A screenshot of social media posts by user "Observer" reads: "The longer you spend in tech, the stronger the urge to buy a farm and never touch a computer again in your life."

18 55 280

Reposted by Markus Winand

Ben @benjdd.com · Aug 25

Index your database with caution.

Every new index causes:

(a) Increased storage overhead (and in turn, data duplication)
(b) Increased write over head for INSERTs

The general principle here is that indexing improves read performance but hurts write performance.

4 2 4

Reposted by Markus Winand

Giacomo Cavalieri @giacomocavalieri.me · Aug 9

Reading “SQL Performance Explained” and I’m taking this as an excuse to draw tree/squirrel shaped Pokémons

A picture of a notebook with notes from the first chapter of the book “SQL Performance Explained”, on the page there’s a drawing of Sudowoodo, a tree-shaped Pokemon

6 3 56

Reposted by Markus Winand

Json Momoa @jotatx.bsky.social · Jul 21

SQL is the biggest gift to humankind, sliced bread would come in second place

2 18

Reposted by Markus Winand

Eric Roby @codingwithroby.bsky.social · Jul 18

Do you still manually write SQL queries or rely entirely on ORMs?

5 1 2

Reposted by Markus Winand

SQLDaily @sqldaily.bsky.social · Jun 25

Test whether a value is valid #JSON or not with

WHERE val IS JSON

You can also use this to test if the value is a JSON

Object
Array

And check if there are duplicate key names

@winand.at‬ investigates

… IS JSON [ARRAY|OBJECT|SCALAR]

Check JSON syntax in SQL, test for Arrays, Objects or Scalars

buff.ly

2 2

Markus Winand @winand.at · Jun 23

Hallo Wien!

Das ViennaDB Meetup findet im klimatisierten Office statt ;)

Spannende Vorträge über Datenbanken, wie man sie loswird und wie man selbst eine macht.

Heute ab 18:30, nähe Praterstern.

www.meetup.com/viennadb-the...

Datentypen, NoDB und NoSleep, Mon, Jun 23, 2025, 6:30 PM | Meetup

[As an exception, our next meetup will be held in German] Am Montag, dem 23. Juni, ist es (schon) wieder so weit. In drei Vorträgen geht es um Datentypen, das Leben ohne D

www.meetup.com

1

Reposted by Markus Winand

Florian Helmberger @datensegler.at · Jun 16

Datentypen, NoDB und NoSleep - nächsten Montag beim ViennaDB-Meetup, hosted by @winand.at. Es sind noch Plätze frei!

Datentypen, NoDB und NoSleep, Mon, Jun 23, 2025, 6:30 PM | Meetup

[As an exception, our next meetup will be held in German] Am Montag, dem 23. Juni, ist es (schon) wieder so weit. In drei Vorträgen geht es um Datentypen, das Leben ohne D

www.meetup.com

1

Markus Winand @winand.at · Jun 16

Https://use-the-index-luke.com/ :)

1

Markus Winand @winand.at · Jun 16

Nächsten Montag bei ViennaDB: Braucht man denn überhaupt eine Datenbank? Hinken RDBM-Systeme anderen Sprachen hinterher? Wofür opfert man seinen Schlaf?
Drei Praxis-Vorträge, nähe Praterstern, für Verpflegung ist gesorgt
Kostenlose Anmeldung zwecks Planung erwünscht: www.meetup.com/viennadb-the...

Datentypen, NoDB und NoSleep, Mon, Jun 23, 2025, 6:30 PM | Meetup

[As an exception, our next meetup will be held in German] Am Montag, dem 23. Juni, ist es (schon) wieder so weit. In drei Vorträgen geht es um Datentypen, das Leben ohne D

www.meetup.com

Markus Winand @winand.at · Jun 7

This? modern-sql.com/blog/2023-12...

The Curious Case of the Aggregation Query

You won’t guess the result of that query

modern-sql.com

1 3 4

Reposted by Markus Winand

Hacker News Companion @hncompanion.com · May 26

SQLite can serve as a robust container format, offering transactions, indexing, and SQL querying. Compared to ZIP, it adds structure but also overhead. It's a powerful option for complex structured data files. #Databases 6/6

1 4

Markus Winand @winand.at · May 13

sqlite-internal.pages.dev

Cool :)

SQLite File Format Viewer

sqlite-internal.pages.dev

1 2

Markus Winand @winand.at · May 10

That “*” indeed causes lot of misconceptions in both areas: NULL treatment and performance.

Lætitia @l-avrot.bsky.social · May 10

Do you remember I tried to change Postgres code to remember the not meaningful necessity for the star in count(*)? Well, I’m just saying that other DBMS like @clickhouse.com did.

tyler perry 's house of payne is being advertised on bet

Alt: A man is raising his hands in the air in a “not my fault” gesture.

media.tenor.com

1 4

Markus Winand @winand.at · May 8

Good morning and have a nice day :)

3

Reposted by Markus Winand

Markus Winand @winand.at · May 7

New PostgreSQL tag: REL_18_BETA1

So many features to check out…

2 12

Markus Winand @winand.at · May 7

New PostgreSQL tag: REL_18_BETA1

So many features to check out…

2 12