Author | Lightnews

Vik Fearing

Vik Fearing

@vik.thegresqlpost.org

190 followers 110 following 360 posts

Member of the ISO/IEC working group for SQL. Performance is an implementation detail. HUGE fan of MLB and WFTDA, and pretty much not interested in any other sport. he/him by default but will happily answer to anything. A cheeseburger in paradise. #IYKYK

Posts Media Videos Starter Packs

Reposted by Vik Fearing

Jacob Pomrenke @buckweaver.bsky.social · 6h

Big news from SABR: For the first time ever, complete Negro Leagues player and team statistics are now available for download in the Lahman Baseball Database. sabr.org/latest/negro... @seanlahman.bsky.social

Photo credits (clockwise from top-left): Cool Papa Bell, Satchel Paige, Oscar Charleston, Turkey Stearnes, Josh Gibson, Sol White from the SABR-Rucker Archive.

Vik Fearing @vik.thegresqlpost.org · 16d

That’s ridiculous.

Vik Fearing @vik.thegresqlpost.org · 17d

If you're parsing postgres's text representation of arrays, are you handling custom separators?

For example, the box type uses ';' instead of ',' and any custom type can choose their own.

Vik Fearing @vik.thegresqlpost.org · 19d

Now that you know it exists, you have to implement it in @jooq.org. I don’t make the rules.

Vik Fearing @vik.thegresqlpost.org · 19d

The bounds get lost during pretty much any operation. One day I will go spelunking to see why this exists in the first place.

#PostgreSQLQuirks

Vik Fearing @vik.thegresqlpost.org · 20d

My indexing starts where I tell it to.

VALUES ((CAST('[-1:1]={1,2,3}' AS INTEGER ARRAY))[0])

=> 2

Reposted by Vik Fearing

Arthur Clune @clune.org · 22d

Also Claude, 🔥

Output from Claude: "The verbosity you'll encounter isn't accidental; it's COBOL heritage, designed for business analysts to supposedly read. Whether that goal was achieved is debatable."

Reposted by Vik Fearing

Data Code 101 @datacode101.bsky.social · 23d

Edgar F. Codd. In 1970, working at IBM, Codd published his paper, “A Relational Model of Data for Large Shared Data Banks.” It introduced a new model for managing data, now accepted as the dominant approach for Relational Database Management Systems (RDBMS).
www.seas.upenn.edu/~zives/03f/c...
#sql

www.seas.upenn.edu

Vik Fearing @vik.thegresqlpost.org · 23d

Yes. You can change the default storage properties for a lot of data types, but it only operates on single values.

Vik Fearing @vik.thegresqlpost.org · 24d

They are not compressed. Certain values might be (see TOAST) but not the page itself.

Reposted by Vik Fearing

ليثيوم @lithium-rose.at.app.wafrn.net · 25d

I hate SQL

Vik Fearing @vik.thegresqlpost.org · 29d

My calendar only goes up to 12 months, so this must be fake news.

Merriam-Webster @merriam-webster.com · 29d

We are thrilled to announce that our NEW Large Language Model will be released on 11.18.25.

Vik Fearing @vik.thegresqlpost.org · Sep 26

Then what is it?

Vik Fearing @vik.thegresqlpost.org · Sep 26

Which is exactly the wrong time to start testing. At the very latest you should have been testing RC1.

Vik Fearing @vik.thegresqlpost.org · Sep 26

Why would you only start testing now? You should have been testing weeks ago!

Vik Fearing @vik.thegresqlpost.org · Sep 25

www.postgresql.org/about/news/p...

PostgreSQL 18 Released!

The [PostgreSQL Global Development Group](https://www.postgresql.org) today announced the release of [PostgreSQL 18](https://www.postgresql.org/docs/18/release-18.html), the latest version of the worl...

www.postgresql.org

Vik Fearing @vik.thegresqlpost.org · Sep 22

huh?

Vik Fearing @vik.thegresqlpost.org · Sep 19

Simple solution: don't migrate!

Vik Fearing @vik.thegresqlpost.org · Sep 19

Correct. We write SQL for fun (and profits).

Reposted by Vik Fearing

Klaus Aschenbrenner @sqlpassion.at · Sep 17

Postgres is Too Good (And Why That's Actually a Problem): dev.to/shayy/postgr... #PostgreSQL

Postgres is Too Good (And Why That's Actually a Problem)

We need to talk about something that's been bothering me for months. I've been watching indie hackers...

Vik Fearing @vik.thegresqlpost.org · Sep 17

Why PostgreSQL indexes feel like magic (and when they backfire)

toxigon.com/understandin...

Reposted by Vik Fearing

StasB @stasb.bsky.social · Sep 16

Did you know you could compare multiple fields at a time in #SQL?

Vik Fearing @vik.thegresqlpost.org · Sep 16

I did know that. 😜

Reposted by Vik Fearing

davidi @davidi99.bsky.social · Sep 15

13 reasons SQL has got to go (but never will?)

13 reasons SQL has got to go

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't.

www.infoworld.com