Lightnews — Scholar-powered news

Reposted by Markus Winand

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

Derby DB to be retired!

#apache #database #java

issues.apache.org/jira/...

Markus Winand @winand.at · 1d

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 8

Markus Winand @winand.at · 22d

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 1 8

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

Markus Winand @winand.at · Apr 25

Laetitia Avrot wrote:

> I am announcing my resignation from my position as treasurer of our association, effective immediately.

It is not even saying "for private reasons". IMHO, something went terribly wrong (and might continue to go wrong).

Change my mind.

www.postgresql.org/message-id/C...

www.postgresql.org

1 2