Top all-time · #11683
Philipe Fatio
Personal blog · phili.pe/posts · on HN as fphilipeprogrammingdata
Philipe Fatio's personal blog at phili.pe covers programming and data. Since 2015, 6 different Hacker News readers have linked it 25 times, most often “Timestamps and Time Zones in PostgreSQL (2016)”. No feed was found, so read it on the site itself.
Too few sampled comments (4) to say how often HN recommends it.?
Why HN links it
HN readers link Philipe Fatio's PostgreSQL posts, mainly his timestamps and time zones article, which commenters use as a reference, plus a guide to PostgreSQL on the command line.
Summarised by Claude from a sample of 4 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Personal website of Philipe Fatio
Most-linked posts?
- Timestamps and Time Zones in PostgreSQL (2016)3 people · 3 mentions · first linked 2019-03-30
- Timestamps and Time Zones in PostgreSQL2 people · 3 mentions · first linked 2016-06-20
- PostgreSQL on the Command Line2 people · 3 mentions · first linked 2015-10-26
What Hacker News says?
I've written about this topic before. Maybe it convinces you that you should (almost) always use timestamptz. https://phili.pe/posts/timestamps-and-time-zones-in-postgres...
Comment linking /posts/timestamps-and-time-zones-in-postgresql/
on “Common mistakes in PostgreSQL”Submitted PostgreSQL on the Command Line as a story · 254 points
HN discussionI've written a post about timestamp vs timestamptz and the only valid reason for timestamp I could come up with is exactly this, scheduling events in the future: https://phili.pe/posts/timestamps-and-time-zones-in-postgres...
Comment linking /posts/timestamps-and-time-zones-in-postgresql/
on “Common mistakes in PostgreSQL”Submitted Timestamps and Time Zones in PostgreSQL (2016) as a story · 189 points
HN discussionMight sound "dumb" or confusing (which it is), but makes a lot of sense. I've written a post explaining the difference between "timestamp with/without time zone": http://phili.pe/posts/timestamps-and-time-zones-in-postgresq...
Comment linking /posts/timestamps-and-time-zones-in-postgresql/
on “UTC Is Enough for Everyone, Right?”Submitted Grep one-liners as CI tasks as a story · 111 points
HN discussionSame here: https://phili.pe/ I've used CSS variables though, which make it even simpler. E.g. I have `--page-background-color` and `--text-color-primary` that are set to a certain default value. In dark mode, these variables are set to other values, removing the need to redefine the actual selectors.
Comment linking /
on “Dark mode in a website with CSS”Submitted Free Concurrency with GNU Parallel as a story · 6 points
HN discussionWell I would use timestamptz, using user's timezone only to convert for display. Use cases for timestamp are very limited. Just make sure you include a timezone info in string representations in your SQL queries. For example '2000-01-01T00:00:00Z' where Z stands for UTC. Otherwise that would insert a timestamp into a timestamptz column, in which case postgres uses local timezone setting for conversion, implicitly; t…
Comment linking /posts/timestamps-and-time-zones-in-postgresql/
on “Working with time in Postgres”Submitted PostgreSQL on the Command Line as a story · 6 points
HN discussionHi, just have a look here : http://phili.pe/posts/postgresql-on-the-command-line/
Comment linking /posts/postgresql-on-the-command-line/
on “PostgreSQL on the Command Line”Submitted Grep one-liners as CI tasks as a story · 5 points
HN discussionAnd thank you so much for the chart[0] mapping absolute to wall time. I always have a hard time visualizing DST changes ( usually I am mentally "sliding" bars of time against each other and get confused), but that one just gave me a click . [0] https://phili.pe/posts/timestamps-and-time-zones-in-postgres...
Comment linking /posts/timestamps-and-time-zones-in-postgresql/map.svg
on “Timestamps and Time Zones in PostgreSQL (2016)”Submitted Exporting CSV from PostgreSQL as a story · 3 points
HN discussionI often refer to this article https://phili.pe/posts/timestamps-and-time-zones-in-postgres... regarding timestamp and timestamptz >> Because the vast majority of our use cases for storing timestamps is to represent specific, unambiguous moments in time, we pretty much always want to use the timestamptz type. > This advice is not great. One needs to specifically know their data. I think the advice is good advice: whe…
Comment linking /posts/timestamps-and-time-zones-in-postgresql/
on “Dbcritic: Constructively criticizing your Postgres schema (using Idris)”Submitted PageExtender for Safari as a story · 3 points
HN discussionhttps://phili.pe Did hit the front page a few times with some of my posts: - http://phili.pe/posts/postgresql-on-the-command-line/ - 4th on https://news.ycombinator.com/front?day=2015-10-27 - https://phili.pe/posts/timestamps-and-time-zones-in-postgres... - 7th on https://news.ycombinator.com/front?day=2019-03-31 - https://phili.pe/posts/using-grep-for-simple-ci-tasks/ - 29th on https://news.ycombinator.com/front?da…
Comment linking /posts/using-grep-for-simple-ci-tasks/
on “Ask HN: Could you share your personal blog here?”Submitted Timestamps and Time Zones in PostgreSQL as a story · 3 points
HN discussionSubmitted Git aliases supporting main and master as a story · 2 points
HN discussionSubmitted Configuring Git for Work as a story · 2 points
HN discussionSubmitted Exporting CSV from PostgreSQL as a story · 2 points
HN discussionSubmitted Is There a Better Way? as a story · 1 points
HN discussion
