Dude, when you were teaching MySQL back then, I really wished you’d do Postgres. Now that it’s happening, I’m really happy!
@aarondfrancis4 ай бұрын
❤️ the universe conspired
@glitchinLife11 күн бұрын
You have no idea how frustrating that inverted sign of the tz was the first time I found it, funny enough the same issue can be found when using the TZ in POSIX shell. You explained it perfectly, hopefully no one else will struggle with it ❤
@MrZax-kl5si4 ай бұрын
These videos are the best. Keep pumping this content Aaron
@awksedgreepАй бұрын
Great video! DBA of over 1400 databases and the most successful groups I support stopped the video at 2:26. ;)
@Voltra_4 ай бұрын
My personal go-to is to store dates as UTC timestamps in the database, and parse the UTC timestamp on the client side (sometimes directly, or with Date.UTC). Oh, and to never manipulate timezones (or worse, offsets)
@additionaddict55244 ай бұрын
aaron is the godfather
@CodingWithTaaxo4 ай бұрын
Hey Aaron, If you're still putting together that course, I'd be down if you could throw in a section on cron jobs. I'm learning Postgres, and your teaching style is the bomb. Can't wait to grab your course!
@aarondfrancis4 ай бұрын
Oh nice, added to my list!
@dalcod4 ай бұрын
That is a good suggestion.
@FrankGehann4 ай бұрын
This was a really great sum up. Thank you very much!
@coffeeowl864 ай бұрын
Amazing content as always! I'm glad you're also covering Postgres. Best wishes 🤗 Update: I joined the wait list for the course :D
@dnukeranged4 ай бұрын
full course hype
@aarondfrancis4 ай бұрын
😮💨 it's coming so soon! I gotta hurry!
@gilesbbb4 ай бұрын
This is set up for covering special relativity in the next video, yes?
@fabriai3 ай бұрын
@Aaron, do you touch on PG Trunk in the course?
@nolocobralink4 ай бұрын
is there a way to show the offset on the final date without having to change the time zone on the session? for example, I'm in the America/Santiago timezone (currently on daylight saving time), and a former colleague made a small application using Postgres as the db and set UTC as the overall time zone (not just in the db), if I use the REST API of the app to check the records, all the dates will be on UTC with the offset "+00", if I ever added a query parameter that allowed me to show all the dates on a specific time zone (in this case America/Santiago), how can I implement that without changing the time zone on the session and still get the offset? ("-04" or "-03" depending on daylight saving)
@jrheaberlin4 ай бұрын
What client are you using?
@aarondfrancis4 ай бұрын
TablePlus!
@hectoreduardosolanopestana69644 ай бұрын
Hello Aaron, I heard in one of your videos that you were an accountant by profession. I would like to know how you transitioned to becoming a PHP developer and working with Laravel, or if you have a video where you share this story. Best regards, and thank you for your content!
@HashimWarren4 ай бұрын
Is the course project based? Looking forward to it
@djasnive4 ай бұрын
Since when did you use Postgres
@aarondfrancis4 ай бұрын
I'm a free agent now!
@jricardoprog4 ай бұрын
Comparing timestamp is also annoying in pg, I need to remove 1ms to find the same record
@HolgerJakobs3 ай бұрын
Can you provide an example?
@quintenkamphuis4 ай бұрын
8:30 base because Docker haha
@aarondfrancis4 ай бұрын
haha I dont know what I was thinking
@sahaj.r4 ай бұрын
Time stone 😄
@djordje19994 ай бұрын
Why not just store unix timestamp?
@HolgerJakobs3 ай бұрын
1. Who can read and write them? 2. Unix timestamps are by defintion UTC. Let PostgreSQL do the work for you. Having each session set to the timestamp the person is residing in, everybody will be fine naively handling all timestamps.
@estebanmurcia84514 ай бұрын
6:42 guilty as charged
@aarondfrancis4 ай бұрын
gottem
@saryakan4 ай бұрын
Best tip on handling time zones? Don't.
@HolgerJakobs3 ай бұрын
Exactly. Let PostgreSQL do this for you. The PostgreSQL Global Developer Group are more of experts than you (and I) are.
@luca44794 ай бұрын
What kind of camera do you use to film your videos? Your camera quality is on par with MKBHD and LTT, I’m in awe!
@aarondfrancis4 ай бұрын
Canon R6!
@codedusting4 ай бұрын
Timezones of all things should have been a physics problem, not politics. How did that even happen?
@aarondfrancis4 ай бұрын
Geeze, I dunno. It sucks though
@codedusting4 ай бұрын
@@aarondfrancis yes. I had to make a real estate auction site for Dubai UAE but international buyers. It was quite hell back in 2020.
@melvillespence67684 ай бұрын
Where do you set the origin? Greenwich was chosen in 1884 at the Meridian Conference, when the UK was the preeminent power. GMT was adopted within the UK in 1847 because of the railways. BST came in WW1 to make best use of the working day, in WW2 we had double summer time for the same reason. In an ideal world we would use 15 degrees of longitude = 1 hour, but 🤣
@HolgerJakobs3 ай бұрын
Who has the power to determine? And clearly, it's a good idea to have a single time zone in at least most countries. Only a few countries stretch so far east-west that several time zones are necessary. Having physics strictly determining the time zone would mean that most countries (except the very small ones) have several time zones, which would not come in handy. We have the same time zone in a lot of countries: Norway, Sweden, Denmark, Poland, Czech Republic, Slovakia, Slovenia, Germany, Austria, Italy, Switzerland, France, Luxemburg, Netherlands, Belgium, Andorra, Spain.
@dalcod4 ай бұрын
October 15 is too far for me lol.
@prashlovessamosa3 ай бұрын
Your background is too good.
@jrdnrc4 ай бұрын
thanks i hate timezones
@HolgerJakobs3 ай бұрын
No need do. Let PostgreSQL handle everything for you and you'll be fine. Just make sure that every session has the time zone set to the place where the person resides running it.