Vik Fearing's Avatar

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. πŸ³οΈβ€πŸŒˆ

230
Followers
119
Following
463
Posts
12.10.2023
Joined
Posts Following

Latest posts by Vik Fearing @vik.thegresqlpost.org

One of the best parts of visiting Brazil is discovering that cashew juice is a thing. It doesn't taste like the nuts, but it sure is delicious!

07.03.2026 16:41 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Parma or parmy?

06.03.2026 00:54 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

No, the mission is to get politicians who actually represent us.

04.03.2026 17:30 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

If she wouldn’t change her position when she needed our votes, what makes you think she would have changed her position afterwards?

04.03.2026 13:54 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

I wonder why they don’t make left handed motorcycles.

01.03.2026 11:06 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Imagine that, Donald Trump not obtaining required consent.

28.02.2026 17:54 πŸ‘ 50 πŸ” 16 πŸ’¬ 1 πŸ“Œ 0

I am a Vinyl Crate!

28.02.2026 22:57 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Bring cheese!

28.02.2026 17:40 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Thanks!

26.02.2026 14:20 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

That is clearly a bug in postgres. Probably too late to change it now, but it's worth reporting.

25.02.2026 12:57 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Post image

Huh, interesting. It appears that PostgreSQL decided to go against the SQL standard here

ISO/IEC 9075-2:2023(E) 6.34 <JSON value constructor> GR 4) b) i) says that empty tables should produce a JSON array with no elements (intuitively), not NULL.

Why this behaviour in PG?

25.02.2026 12:12 πŸ‘ 3 πŸ” 1 πŸ’¬ 1 πŸ“Œ 0

Come see Luigi Nardi and Marc Linster (@marclinster.bsky.social) talk about "A framework for self-driving databases"!

#PostgreSQL #pgDayParis #Conference

https://www.postgres...

23.02.2026 08:34 πŸ‘ 0 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

I know I am in the minority, but I am one of the few non-Brits that actually appreciates British cuisine.

20.02.2026 11:22 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

It's getting late... EARLYBIRD discounts end tonight!
Get yours if you haven't already!

#PostgreSQL #pgDayParis #Conference

https://2026.pgday.p...

20.02.2026 09:01 πŸ‘ 0 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

TIL: Oracle has custom aggregates

16.02.2026 18:37 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
pgDay Paris 2026 Schedule pgDay Paris 2026 Schedule

www.postgresql.eu/events/pgday...

16.02.2026 14:10 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Have you seen the schedule for pgDay Paris? Such an amazing lineup!

#PostgreSQL #pgDayParis #Conference

https://2026.pgday.p...

16.02.2026 14:04 πŸ‘ 0 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

I am using #MySQL for the first time in my life. Don't judge me, I have a good reason.

16.02.2026 11:35 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

I really enjoy when postgresql crashes for no reason and takes my entire instance down with it! It's so much fun!

15.02.2026 22:40 πŸ‘ 0 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

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...

12.02.2026 13:30 πŸ‘ 0 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0
Preview
Postgresql Icon | Font Awesome Postgresql icon in the Classic Solid style. Available now in Font Awesome.

#PostgreSQL *finally* got its logo in @fontawesome.com!

fontawesome.com/icons/postgr...

11.02.2026 08:05 πŸ‘ 6 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Right. Your statistics were stale. Interesting that autoanalyze didn’t run.

10.02.2026 22:36 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

That's not true, but if your statistics are off, it might think the Seq San is better.

10.02.2026 22:23 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
WOMEN AND METAL
HAVE 5 MINUTES?
HELP A GIRL OUT AND FILL OUT MY SURVEY ABOUT YOUR EXPERIENCES AS FEMALE METAL FAN AND MISOGYNY
ALL RESPONSES ARE ANONYMOUS
Goldsmiths

WOMEN AND METAL HAVE 5 MINUTES? HELP A GIRL OUT AND FILL OUT MY SURVEY ABOUT YOUR EXPERIENCES AS FEMALE METAL FAN AND MISOGYNY ALL RESPONSES ARE ANONYMOUS Goldsmiths

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.”

10.02.2026 13:52 πŸ‘ 53 πŸ” 70 πŸ’¬ 3 πŸ“Œ 4

Schedule announced! https://www.postgres...

#postgresql #database #helsinki

09.02.2026 11:52 πŸ‘ 0 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

They will completely wreck your tires and leave marks all over the road!

08.02.2026 15:23 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

OH: "One of these days, #PostgreSQL is going to get found out and we are all going to lose our jobs."

08.02.2026 10:44 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Jr Level Software Developer
Fort Meade, MD
In Order to Join the --- Team you will need:

You must have a current or active security clearance with a poly.  
Possess Seven (7) + years of experience as a software engineer in programs and contracts of similar scope, type, and complexity is required or 4 more years experience
Bachelor’s degree in Computer Science or related discipline from an accredited college or university is required OR 4 years of additional Software Engineer experience on projects with similar software processes may be substituted for a bachelor’s degree.
 Required Skills/Experience:
β€’ Java Application (no front end necessary), REST
β€’ Agile
β€’ Ability to multitask and pivot to different tasks quickly
β€’ Experience with Atlassian tools, Git
β€’ Experience with IntelliJ or Eclipse IDE

Desired Skills:
β€’ Kotlin
β€’ Mongo
β€’ Spring or Spring Boot
β€’ Python
β€’ Kubernetes
β€’ NiFi
β€’ RabbitMQ

Jr Level Software Developer Fort Meade, MD In Order to Join the --- Team you will need: You must have a current or active security clearance with a poly. Possess Seven (7) + years of experience as a software engineer in programs and contracts of similar scope, type, and complexity is required or 4 more years experience Bachelor’s degree in Computer Science or related discipline from an accredited college or university is required OR 4 years of additional Software Engineer experience on projects with similar software processes may be substituted for a bachelor’s degree. Required Skills/Experience: β€’ Java Application (no front end necessary), REST β€’ Agile β€’ Ability to multitask and pivot to different tasks quickly β€’ Experience with Atlassian tools, Git β€’ Experience with IntelliJ or Eclipse IDE Desired Skills: β€’ Kotlin β€’ Mongo β€’ Spring or Spring Boot β€’ Python β€’ Kubernetes β€’ NiFi β€’ RabbitMQ

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.

06.02.2026 18:03 πŸ‘ 25 πŸ” 3 πŸ’¬ 7 πŸ“Œ 1
Preview
Comments Inside SQL Statements C-style comments work in SQL, with nesting

SQL Comments, Please!
modern-sql.com/caniuse/comm...

05.02.2026 08:18 πŸ‘ 10 πŸ” 2 πŸ’¬ 2 πŸ“Œ 0

For a moment there, I thought you cooked it with an iron.

03.02.2026 01:00 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0