|
WSL2 also has fantastic integration with Docker Desktop in Windows proper. I'm very impressed how well all that works to get the benefits of a fully functional Linux env right on Windows now. Too bad about the rest of Windows these days, but this isn't really the thread for that rant
|
# ? Aug 30, 2023 23:18 |
|
|
# ? May 23, 2024 21:32 |
|
Yeah Docker Desktop has a slick interface but only gives you 1% of the power of a CLI user and just lol at ever using a Windows CLI, I am very glad that Microsoft decided that maybe it was time to let it be the year of linux on the desktop
|
# ? Aug 31, 2023 02:44 |
|
Microsoft showing ads everywhere in the "Professional" edition of their OS is one of those really strong arguments to finally give up on Windows for development.
|
# ? Aug 31, 2023 09:04 |
|
Xarn posted:Microsoft showing ads everywhere in the "Professional" edition of their OS is one of those really strong arguments to finally give up on Windows for development. Don't worry! If you configure group policy ~*just so*~, you can avoid...most of them. Thanks Microsoft!
|
# ? Aug 31, 2023 17:00 |
|
Canine Blues Arooo posted:Don't worry! If you configure group policy ~*just so*~, you can avoid...most of them. Wow maybe I owe my endpoint team some credit because I see no ads on my corporate W10 device. I also can’t install WSL2 or anything requiring Administrator privileges. Ah, well, nevertheless
|
# ? Aug 31, 2023 17:48 |
|
ExcessBLarg! posted:Perhaps a simpler solution would be to run the IPTV software as a dedicated user and then set an ip rule on the uid to use the VPN interface. What do you know, I'm not the first person in the world to want to run 1 application under a VPN. https://github.com/ausbin/nsdo/ does everything I need and works as expected. edit: I was wrong. Sound doesn't work for some reason. I have pipewire with the pulseaudio module and probably is trying to run it over the network within that namespace and fails. Plus, the VPN seems to be failing in weird ways so that ffmpeg doesn't catch on the fact that the stream is over and restart it (as instructed). All in all ... the container solution is still the best one that I have for now. Will keep on investigating other options. Volguus fucked around with this message at 22:25 on Sep 1, 2023 |
# ? Sep 1, 2023 01:37 |
|
If I had to pick between not having WSL and seeing occasional ads, give me the ads tbh
|
# ? Sep 1, 2023 11:08 |
|
Xarn posted:If I had to pick between not having WSL and seeing occasional ads, give me the ads tbh Seems like it's more running ads vs just using Linux. Valve increased compatibility for wine so I'm leaning toward Linux. At this point wine has longer backward compatibility than windows, too.
|
# ? Sep 1, 2023 14:53 |
|
Yeah if we're talking about a work computer then just give me linux from the jump
|
# ? Sep 1, 2023 15:07 |
|
neosloth posted:The hardest thing Ive had to do in all my time working is setting up an older version of ruby on a freshly updated mac When I had to do this with Ruby 2.4 (IIRC) the only way I found that worked was to run the project in a Docker container.
|
# ? Sep 2, 2023 17:17 |
|
I heard somewhere google runs all their servers on pacific time instead of UTC but I don't know the details.
|
# ? Sep 3, 2023 13:40 |
|
I would blow Dane Cook posted:I heard somewhere google runs all their servers on pacific time instead of UTC but I don't know the details. They do not. It's mainly human readable stuff sometimes defaulting to PST, or times being given without a timezone, but all of that is much less common than it used to be. The joke is that it's Google Standard Time.
|
# ? Sep 3, 2023 16:31 |
|
something something leap second smear
|
# ? Sep 3, 2023 16:59 |
|
I worked on a product once where all the timestamps were stored in the database in local time. I think that was just how DB2 worked by default back in the day? Then we sold the entire thing to another company who had their data centers in a different time zone and so when they moved the database all the timestamps changed. Amazingly, I think the decision was just “eh, whatever, it’s just three hours.”
|
# ? Sep 3, 2023 17:03 |
|
Back when I worked at Experts Exchange, our extra push to market to folks outside the US made it painfully clear that we were sorting comments by local time as everything got all mixed up during the two hours between 1:00 and 2:00 on the night DST ended every year. So we changed it to sort by ID. Then we did a big migration and everything got all scrambled again. I forget if we ever fixed it.
|
# ? Sep 3, 2023 17:44 |
|
Volmarias posted:They do not. It's mainly human readable stuff sometimes defaulting to PST, or times being given without a timezone, but all of that is much less common than it used to be. The joke is that it's Google Standard Time. Well at least they refuse to observe daylight saving time!
|
# ? Sep 3, 2023 17:58 |
|
I would blow Dane Cook posted:I heard somewhere google runs all their servers on pacific time instead of UTC but I don't know the details. Not quite the same scale but Twitch runs all their servers (the thousands that aren't just AWS, anyway) on Pacific time.
|
# ? Sep 3, 2023 18:20 |
|
CPColin posted:Experts Exchange
|
# ? Sep 3, 2023 20:29 |
|
About 10 years ago a middle manager at the place I work went “I want some milliseconds on this execution time stamp column” So the outsourced IT worker dutifully looked through every semi-related table in the db and updated the execution column to the only source he could find that included milliseconds, and that’s why ever since the execution time stamp column has in fact recorded the time the row was written to the database and not the execution time.
|
# ? Sep 3, 2023 23:46 |
|
smackfu posted:I worked on a product once where all the timestamps were stored in the database in local time.
|
# ? Sep 4, 2023 03:57 |
|
Only pathetic wieners store timestamps in UTC, real rockstars use JD. I have a dentist appointment at 2460190.94803
|
# ? Sep 4, 2023 04:16 |
|
ExcessBLarg! posted:You'd think that timestamps should always be stored in UTC and converted to localtime for presentation but sometimes there's strong reason to store them in local-to-particular-venue time regardless of a given machine's local zone, and future timestamps should follow DST policy for that venue that may not yet be defined. and in this case, if you're not storing a time zone identifier (not the offset) to go with the timestamp, you're doing it wrong
|
# ? Sep 4, 2023 07:12 |
|
Extra lols if you’ve changed vendors multiple times and the data has correspondingly changed time zones, but you kept storing it in a tz-naive format the whole time.
|
# ? Sep 4, 2023 12:14 |
|
DoctorTristan posted:Extra lols if you’ve changed vendors multiple times and the data has correspondingly changed time zones, but you kept storing it in a tz-naive format the whole time. It’s all EST to me!
|
# ? Sep 5, 2023 00:04 |
|
All timestamps should be in ISO8601 format set to UTC.
|
# ? Sep 5, 2023 02:45 |
|
FlapYoJacks posted:All timestamps should be in ISO8601 format set to UTC. except, of course, when they shouldn't
|
# ? Sep 5, 2023 04:07 |
|
redleader posted:except, of course, when they shouldn't There is never a time they shouldn't be. If you need to display the time the conversion happens when converting the timestamp to the user set time zone.
|
# ? Sep 5, 2023 04:21 |
|
FlapYoJacks posted:There is never a time they shouldn't be. If you need to display the time the conversion happens when converting the timestamp to the user set time zone.
|
# ? Sep 5, 2023 04:26 |
FlapYoJacks posted:All timestamps should be in ISO8601 format set to UTC. What if you have an event planned for 5 years in the future that must happen at 10 am local time, but the event is set in a location near the border between two time zones and both of those time zones are considering dropping DST and the municipality is considering moving from one time zone to the other? And you don't know if any of those changes will take place, but you do know that the event needs to start at 10 am local time, regardless of what time that would be in UTC.
|
|
# ? Sep 5, 2023 04:27 |
|
nielsm posted:What if you have an event planned for 5 years in the future that must happen at 10 am local time, but the event is set in a location near the border between two time zones and both of those time zones are considering dropping DST and the municipality is considering moving from one time zone to the other? And you don't know if any of those changes will take place, but you do know that the event needs to start at 10 am local time, regardless of what time that would be in UTC. You quit.
|
# ? Sep 5, 2023 04:30 |
|
FlapYoJacks posted:There is never a time they shouldn't be. If you need to display the time the conversion happens when converting the timestamp to the user set time zone. Enjoy waking up to your alarm clock at 3am after a flight
|
# ? Sep 5, 2023 11:31 |
|
FlapYoJacks posted:There is never a time they shouldn't be. If you need to display the time the conversion happens when converting the timestamp to the user set time zone. are you our dba who ‘fixed’ the problem a couple of years later by converting the column to a sql server datetimeoffset and just setting the timezone to ‘Z’
|
# ? Sep 5, 2023 12:30 |
|
we also moved the whole thing to the cloud a little while back and aws keep calling up to say this is the largest EC2 sql server cluster in their entire global infrastructure and have we considered managed db services instead i mean yes we have but it takes a while to complete a migration when it’s full of things like a datetime column with so many gotchas that only 2-3 ppl in the organisation know how to get the correct values out
|
# ? Sep 5, 2023 12:40 |
|
DoctorTristan posted:we also moved the whole thing to the cloud a little while back and aws keep calling up to say this is the largest EC2 sql server cluster in their entire global infrastructure and have we considered managed db services instead The real fun will start once that number goes to zero.
|
# ? Sep 5, 2023 12:54 |
|
swatch internet time is the answer.
|
# ? Sep 5, 2023 13:22 |
|
DoctorTristan posted:we also moved the whole thing to the cloud a little while back and aws keep calling up to say this is the largest EC2 sql server cluster in their entire global infrastructure and have we considered managed db services instead wouldn't managed db service at your scale end up being prohibitively expensive?
|
# ? Sep 5, 2023 23:59 |
|
redleader posted:wouldn't managed db service at your scale end up being prohibitively expensive? Yes, and Amazon is also horrible for “managed X”, at least when it isn’t something they built internally in my experience.
|
# ? Sep 6, 2023 00:14 |
|
DoctorTristan posted:we also moved the whole thing to the cloud a little while back and aws keep calling up to say this is the largest EC2 sql server cluster in their entire global infrastructure and have we considered managed db services instead Not sure if we work at the same place or they tell this to everyone who lifted a giant on-prem cluster into EC2. How many x1e.32xlarge we talking?
|
# ? Sep 6, 2023 00:45 |
|
Has anyone else had to endure an IdeaGuy, who, after playing with ChatGPT, declares with supreme confidence that he doesn’t need devs to build his dream app now!
|
# ? Sep 6, 2023 00:48 |
|
|
# ? May 23, 2024 21:32 |
|
redleader posted:wouldn't managed db service at your scale end up being prohibitively expensive? We’re not all that huge by today’s reckoning - total db storage is measured in low numbers of terabytes including a whole bunch of duplication and archives, and most of it all ran on one beefy windows server until about 4-5 years ago. Maybe the AWS rep meant no-one at this scale or higher is using sql server, or maybe all the other orgs with a large sql server cluster, business processes built around sharepoint + onedrive, and dev processes that rely heavily on azure dev ops and aad chose a different cloud provider for some strange reason.
|
# ? Sep 6, 2023 00:57 |