khamas

PostsComments

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