Vik Fearing
@vik.thegresqlpost.org
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
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
Reposted by Vik Fearing
anyways on another note
i hate SQL xD
i hate SQL xD
November 13, 2025 at 2:04 PM
anyways on another note
i hate SQL xD
i hate SQL xD
Reposted by Vik Fearing
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
October 30, 2025 at 2:40 PM
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
That’s ridiculous.
October 14, 2025 at 6:07 PM
That’s ridiculous.
Reposted by Vik Fearing
Reposted by Vik Fearing
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/~zives/03f/c...
#sql
www.seas.upenn.edu
October 7, 2025 at 12:18 PM
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/~zives/03f/c...
#sql
Reposted by Vik Fearing
My calendar only goes up to 12 months, so this must be fake news.
We are thrilled to announce that our NEW Large Language Model will be released on 11.18.25.
October 1, 2025 at 3:38 PM
My calendar only goes up to 12 months, so this must be fake news.
Reposted by Vik Fearing
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...
dev.to
September 17, 2025 at 9:14 PM
Postgres is Too Good (And Why That's Actually a Problem): dev.to/shayy/postgr... #PostgreSQL
Reposted by Vik Fearing
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
September 15, 2025 at 4:27 PM
13 reasons SQL has got to go (but never will?)
Reposted by Vik Fearing
And we're live! Come hang as we dig into why Postgres isn't always the answer.
CEO Bobby DeSimone, Senior SWE Caleb Doxsey, and Developer Advocate @nickyt.online are going live to discuss Pomerium’s move away from Postgres in the databroker.
Catch the stream tomorrow at 12:30PM ET:
www.youtube.com/watch?v=jKah...
Catch the stream tomorrow at 12:30PM ET:
www.youtube.com/watch?v=jKah...
September 12, 2025 at 5:04 PM
And we're live! Come hang as we dig into why Postgres isn't always the answer.
Reposted by Vik Fearing
everyone: you cant just always use postgres
postgres users: i beg your fucking pardon
postgres users: i beg your fucking pardon
September 7, 2025 at 1:42 PM
everyone: you cant just always use postgres
postgres users: i beg your fucking pardon
postgres users: i beg your fucking pardon
Reposted by Vik Fearing
Supercharge Your PostgreSQL Queries with Materialized Views! 🚀 https://cstu.io/39416d #startup #computerscience #d
Supercharge Your PostgreSQL Queries with Materialized Views! 🚀
Are your complex SELECT queries with multiple JOINs and GROUP BY clauses slowing down your...
cstu.io
September 6, 2025 at 3:11 PM
Supercharge Your PostgreSQL Queries with Materialized Views! 🚀 https://cstu.io/39416d #startup #computerscience #d
Theoretical SQL... AI instructor...
September 6, 2025 at 2:55 PM
Theoretical SQL... AI instructor...
Reposted by Vik Fearing
Backups are important but not always a panacea. What happens if it takes days to recover your backup? Matrix.org is finding that out right now. #backups #outage #restore #postgresql
Matrix.org homeserver grinds to a halt after RAID meltdown
: Engineers wrangle 55 TB restore and traffic replay as millions of messages queue up
www.theregister.com
September 4, 2025 at 9:24 PM
Backups are important but not always a panacea. What happens if it takes days to recover your backup? Matrix.org is finding that out right now. #backups #outage #restore #postgresql
Reposted by Vik Fearing
Get values from the previous or next row in #SQL with
( val ) OVER ( ORDER BY ... )
Where is either
LAG - previous
LEAD - next
By default these look one row forward/back
Use the second parameter to get the value from N rows before/after the current
Where
LAG - previous
LEAD - next
By default these look one row forward/back
Use the second parameter to get the value from N rows before/after the current
September 4, 2025 at 11:02 AM
Get values from the previous or next row in #SQL with
( val ) OVER ( ORDER BY ... )
Where is either
LAG - previous
LEAD - next
By default these look one row forward/back
Use the second parameter to get the value from N rows before/after the current
Where
LAG - previous
LEAD - next
By default these look one row forward/back
Use the second parameter to get the value from N rows before/after the current
Reposted by Vik Fearing
The row numbering functions in #SQL are
ROW_NUMBER => Consecutive integers starting at one
RANK => Rows with the same sort value have the same number; the next row after ties has the same value as ROW_NUMBER
DENSE_RANK => Like RANK, but numbers are consecutive after ties
ROW_NUMBER => Consecutive integers starting at one
RANK => Rows with the same sort value have the same number; the next row after ties has the same value as ROW_NUMBER
DENSE_RANK => Like RANK, but numbers are consecutive after ties
September 1, 2025 at 11:02 AM
The row numbering functions in #SQL are
ROW_NUMBER => Consecutive integers starting at one
RANK => Rows with the same sort value have the same number; the next row after ties has the same value as ROW_NUMBER
DENSE_RANK => Like RANK, but numbers are consecutive after ties
ROW_NUMBER => Consecutive integers starting at one
RANK => Rows with the same sort value have the same number; the next row after ties has the same value as ROW_NUMBER
DENSE_RANK => Like RANK, but numbers are consecutive after ties
Reposted by Vik Fearing
Hey what's the point of right joins in SQL?
August 30, 2025 at 1:24 PM
Hey what's the point of right joins in SQL?
Reposted by Vik Fearing
Question for the database experts of BlueSky. What in your opinion is the best free, open source package for building relatively small relational databases that are easy to query + edit and interface nicely with R? Asking for me!
a woman says well what do you think on a paramount network ad
ALT: a woman says well what do you think on a paramount network ad
media.tenor.com
August 26, 2025 at 11:03 AM
Question for the database experts of BlueSky. What in your opinion is the best free, open source package for building relatively small relational databases that are easy to query + edit and interface nicely with R? Asking for me!