khamas
khamas
Explore posts from servers
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
ok so I'll just create an offset based on a DateOnly
35 replies
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
alright
35 replies
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
and DTO can output me a DT as UTC anyways
35 replies
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
say like I want to gather reports from 01/01/2024 to 31/01/2024 as CEST time
35 replies
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
I just want the client app to have it's own timezone and I'll convert to UTC when sending to server
35 replies
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
there is no need for offset
35 replies
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
anyways DB doesn't matter, it's all UTC
35 replies
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
postgres
35 replies
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
in DB and server side it would be UTC, just that the clients work on their own time zone
35 replies
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
I'd want to get like 01/03/2024 at 00:00 in the specific timezone
35 replies
CC#
Created by khamas on 3/6/2024 in #help
✅ Creating a datetime with a timezone
yeah got it, but then how would I get the time of the first day of the month?
35 replies
CC#
Created by khamas on 8/4/2023 in #help
❔ how do delay the process exit for a graceful shutdown in a console app?
I might need to create my own "role-based" lock
72 replies
CC#
Created by khamas on 8/4/2023 in #help
❔ how do delay the process exit for a graceful shutdown in a console app?
I plan on using a lot of reader-writer locks
72 replies
CC#
Created by khamas on 8/4/2023 in #help
❔ how do delay the process exit for a graceful shutdown in a console app?
so thread safety is paramount
72 replies
CC#
Created by khamas on 8/4/2023 in #help
❔ how do delay the process exit for a graceful shutdown in a console app?
this relies on a ton of shared state
72 replies
CC#
Created by khamas on 8/4/2023 in #help
❔ how do delay the process exit for a graceful shutdown in a console app?
then T2 will resume where it left off
72 replies
CC#
Created by khamas on 8/4/2023 in #help
❔ how do delay the process exit for a graceful shutdown in a console app?
if it deems the work to be too much, it will unclaim the query
72 replies
CC#
Created by khamas on 8/4/2023 in #help
❔ how do delay the process exit for a graceful shutdown in a console app?
well T1 can always access the transaction context
72 replies
CC#
Created by khamas on 8/4/2023 in #help
❔ how do delay the process exit for a graceful shutdown in a console app?
so like if thread T1 is reading rows 10M-50M for query Q1, query Q2 can delegate a part of the query to T1, then thread T2 could read 0-10M(+ offset from T1) rows
72 replies
CC#
Created by khamas on 8/4/2023 in #help
❔ how do delay the process exit for a graceful shutdown in a console app?
then execute both queries on the same thread
72 replies