Vik Fearing
@vik.thegresqlpost.org
Member of the ISO/IEC working group for SQL. Performance is an implementation detail.
Major Contributor to PostgreSQL.
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. 🏳️🌈
Major Contributor to PostgreSQL.
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. 🏳️🌈
Pinned
Vik Fearing
@vik.thegresqlpost.org
· Jan 4
The #SQL Standard does not mandate implementations, it anticipates them.
Reposted by Vik Fearing
Have you seen the schedule for pgDay Paris? Such an amazing lineup!
##PostgreSQL ##pgDayParis ##Conference
https://2026.pgday.p...
##PostgreSQL ##pgDayParis ##Conference
https://2026.pgday.p...
February 16, 2026 at 2:04 PM
Have you seen the schedule for pgDay Paris? Such an amazing lineup!
##PostgreSQL ##pgDayParis ##Conference
https://2026.pgday.p...
##PostgreSQL ##pgDayParis ##Conference
https://2026.pgday.p...
Reposted by Vik Fearing
I really enjoy when postgresql crashes for no reason and takes my entire instance down with it! It's so much fun!
February 15, 2026 at 10:42 PM
I really enjoy when postgresql crashes for no reason and takes my entire instance down with it! It's so much fun!
Reposted by Vik Fearing
Only ONE WEEK LEFT for the earlybird tickets. Make sure you get yours before it's too late!
##PostgreSQL ##pgDayParis ##Conference
https://2026.pgday.p...
##PostgreSQL ##pgDayParis ##Conference
https://2026.pgday.p...
February 12, 2026 at 1:30 PM
Only ONE WEEK LEFT for the earlybird tickets. Make sure you get yours before it's too late!
##PostgreSQL ##pgDayParis ##Conference
https://2026.pgday.p...
##PostgreSQL ##pgDayParis ##Conference
https://2026.pgday.p...
Reposted by Vik Fearing
Please share and/or fill this out if it applies to you: forms.gle/6TuZYUzhAznR...
"Female identifying metal fans- I need your input for my university research! I am currently gathering some stats around misogyny in metal music scenes…All reponses will be recorded as anonymous.”
"Female identifying metal fans- I need your input for my university research! I am currently gathering some stats around misogyny in metal music scenes…All reponses will be recorded as anonymous.”
February 10, 2026 at 1:52 PM
Please share and/or fill this out if it applies to you: forms.gle/6TuZYUzhAznR...
"Female identifying metal fans- I need your input for my university research! I am currently gathering some stats around misogyny in metal music scenes…All reponses will be recorded as anonymous.”
"Female identifying metal fans- I need your input for my university research! I am currently gathering some stats around misogyny in metal music scenes…All reponses will be recorded as anonymous.”
Reposted by Vik Fearing
February 9, 2026 at 11:52 AM
OH: "One of these days, #PostgreSQL is going to get found out and we are all going to lose our jobs."
February 8, 2026 at 10:44 AM
OH: "One of these days, #PostgreSQL is going to get found out and we are all going to lose our jobs."
Reposted by Vik Fearing
What is this madness?!
7 years of experience for a junior role.
I have a script that helps me find entry-level roles to share in the @diversifytech.com newsletter. I then manually check all the roles because of things like this.
7 years of experience for a junior role.
I have a script that helps me find entry-level roles to share in the @diversifytech.com newsletter. I then manually check all the roles because of things like this.
February 6, 2026 at 6:04 PM
What is this madness?!
7 years of experience for a junior role.
I have a script that helps me find entry-level roles to share in the @diversifytech.com newsletter. I then manually check all the roles because of things like this.
7 years of experience for a junior role.
I have a script that helps me find entry-level roles to share in the @diversifytech.com newsletter. I then manually check all the roles because of things like this.
Reposted by Vik Fearing
SQL Comments, Please!
modern-sql.com/caniuse/comm...
modern-sql.com/caniuse/comm...
Comments Inside SQL Statements
C-style comments work in SQL, with nesting
modern-sql.com
February 5, 2026 at 8:18 AM
SQL Comments, Please!
modern-sql.com/caniuse/comm...
modern-sql.com/caniuse/comm...
Reposted by Vik Fearing
Infinite Recursion Guards
modern-sql.com/caniuse/with...
With recursive is the only SQL construct that is not guaranteed to terminate, eventually. As the DBMS is typically a very crucial system, infinite loops must be prevented at all times. See how various SQL systems help you.
modern-sql.com/caniuse/with...
With recursive is the only SQL construct that is not guaranteed to terminate, eventually. As the DBMS is typically a very crucial system, infinite loops must be prevented at all times. See how various SQL systems help you.
Infinite Recursion Guards
Protection against infinite loops for WITH RECURSIVE.
modern-sql.com
February 2, 2026 at 2:37 PM
Infinite Recursion Guards
modern-sql.com/caniuse/with...
With recursive is the only SQL construct that is not guaranteed to terminate, eventually. As the DBMS is typically a very crucial system, infinite loops must be prevented at all times. See how various SQL systems help you.
modern-sql.com/caniuse/with...
With recursive is the only SQL construct that is not guaranteed to terminate, eventually. As the DBMS is typically a very crucial system, infinite loops must be prevented at all times. See how various SQL systems help you.
Reposted by Vik Fearing
PASSION RULES EVERYTHING AROUND ME.
January 29, 2026 at 10:33 AM
PASSION RULES EVERYTHING AROUND ME.
He looks much better with long hair (but who doesn’t?).
January 29, 2026 at 12:27 AM
He looks much better with long hair (but who doesn’t?).
Reposted by Vik Fearing
Amis devs, vous prononcez PostgreSQL comment ?
Perso je dis tout le temps " Postegressquel " xD
Perso je dis tout le temps " Postegressquel " xD
January 26, 2026 at 12:07 PM
Amis devs, vous prononcez PostgreSQL comment ?
Perso je dis tout le temps " Postegressquel " xD
Perso je dis tout le temps " Postegressquel " xD
Reposted by Vik Fearing
The schedule for pgDay Paris 2026 has been published! Earlybird tickets are still available!
##pgDay ##Paris ##PostgreSQL ##Conference
https://2026.pgday.p...
##pgDay ##Paris ##PostgreSQL ##Conference
https://2026.pgday.p...
January 26, 2026 at 8:01 AM
The schedule for pgDay Paris 2026 has been published! Earlybird tickets are still available!
##pgDay ##Paris ##PostgreSQL ##Conference
https://2026.pgday.p...
##pgDay ##Paris ##PostgreSQL ##Conference
https://2026.pgday.p...
OMG. This YouTube playlist I am listening to just rickrolled me. #selfloathing #loveitanyway
January 22, 2026 at 8:14 PM
OMG. This YouTube playlist I am listening to just rickrolled me. #selfloathing #loveitanyway
Reposted by Vik Fearing
I genuinely think SQL might be the best bit of technology ever.
I'm not very good at it, but it just works, for so many things, and if it doesn't work, it's probably because you're wrong
I'm not very good at it, but it just works, for so many things, and if it doesn't work, it's probably because you're wrong
January 20, 2026 at 8:40 PM
I genuinely think SQL might be the best bit of technology ever.
I'm not very good at it, but it just works, for so many things, and if it doesn't work, it's probably because you're wrong
I'm not very good at it, but it just works, for so many things, and if it doesn't work, it's probably because you're wrong
I have not interviewed for a job since 2008, and I have been poached four times since then.
Let your work and knowledge speak for you. Become a part of a community where people want to poach you.
You can do this.
Let your work and knowledge speak for you. Become a part of a community where people want to poach you.
You can do this.
January 19, 2026 at 12:14 PM
I have not interviewed for a job since 2008, and I have been poached four times since then.
Let your work and knowledge speak for you. Become a part of a community where people want to poach you.
You can do this.
Let your work and knowledge speak for you. Become a part of a community where people want to poach you.
You can do this.
Reposted by Vik Fearing
The best thing you can do is take a step back and let the onions caramelize themselves.
January 18, 2026 at 3:01 AM
The best thing you can do is take a step back and let the onions caramelize themselves.
Reposted by Vik Fearing
Limit the rows returned in ISO standard #SQL with
FETCH FIRST n ROWS ...
ONLY => At most n
WITH TIES => Up to n + all rows with the same sort value as the Nth
Get a fraction of the total rows with
... n PERCENT ROWS ...
Without ORDER BY, the rows returned are undefined
FETCH FIRST n ROWS ...
ONLY => At most n
WITH TIES => Up to n + all rows with the same sort value as the Nth
Get a fraction of the total rows with
... n PERCENT ROWS ...
Without ORDER BY, the rows returned are undefined
January 16, 2026 at 12:01 PM
Limit the rows returned in ISO standard #SQL with
FETCH FIRST n ROWS ...
ONLY => At most n
WITH TIES => Up to n + all rows with the same sort value as the Nth
Get a fraction of the total rows with
... n PERCENT ROWS ...
Without ORDER BY, the rows returned are undefined
FETCH FIRST n ROWS ...
ONLY => At most n
WITH TIES => Up to n + all rows with the same sort value as the Nth
Get a fraction of the total rows with
... n PERCENT ROWS ...
Without ORDER BY, the rows returned are undefined
I strongly oppose extensions like this one. They offer a false sense of security. #PostgreSQL
Introducing pg_strict for Postgres.
Our new extension adds a safety net to Postgres, catching dangerous queries before they run.
www.youtube.com/watch?v=noPn...
Our new extension adds a safety net to Postgres, catching dangerous queries before they run.
www.youtube.com/watch?v=noPn...
Protect your database. Use the pg_strict Postgres extension.
YouTube video by PlanetScale
www.youtube.com
January 15, 2026 at 5:59 PM
I strongly oppose extensions like this one. They offer a false sense of security. #PostgreSQL
Reposted by Vik Fearing
Sort the output of #SQL queries with
ORDER BY exp1, exp2, ...
This sorts in ascending order: low to high, A-Z
For high to low, use
ORDER BY exp DESC
Rows with ties for exp1 are then sorted by exp2, etc.
The order is undefined for rows with the same value for all exps
ORDER BY exp1, exp2, ...
This sorts in ascending order: low to high, A-Z
For high to low, use
ORDER BY exp DESC
Rows with ties for exp1 are then sorted by exp2, etc.
The order is undefined for rows with the same value for all exps
January 15, 2026 at 12:01 PM
Sort the output of #SQL queries with
ORDER BY exp1, exp2, ...
This sorts in ascending order: low to high, A-Z
For high to low, use
ORDER BY exp DESC
Rows with ties for exp1 are then sorted by exp2, etc.
The order is undefined for rows with the same value for all exps
ORDER BY exp1, exp2, ...
This sorts in ascending order: low to high, A-Z
For high to low, use
ORDER BY exp DESC
Rows with ties for exp1 are then sorted by exp2, etc.
The order is undefined for rows with the same value for all exps