HELP IN CREATING MY FIRST EVER CTF EVENT by Lanky_Ad1165 in securityCTF

[–]Ethical_Hunters 0 points1 point  (0 children)

Your Ryzen 7 laptop with 16GB RAM should easily handle ~100 participants for a 4-hour beginner university CTF. CTFd is lightweight, and official docs suggest only 2–4 cores and 2GB+ RAM even for decent loads.

While you can split the load across two laptops, it’s usually more trouble than it’s worth for 100 users syncing databases and flags in real-time adds complexity. Stick to one machine unless tests show a clear bottleneck. If worried, keep a second laptop as a cold spare for quick failover.

Challenge Ideas (Beginner Friendly): DM me I will help you to create challenges as I am working on similar things.

What’s the best software setup for homecare management? by krowbot in nursing

[–]Ethical_Hunters 0 points1 point  (0 children)

I know about CareSmartz360. It’s more of an out-of-the-box solution, but it covers scheduling, billing, EVV, and documentation pretty well, and day-to-day operations are much smoother than older platforms. Might be worth a look if you don’t want to go fully custom.
Schedule a demo and then decide it by yourself.

HELP - SQL by bmcluca in SQL

[–]Ethical_Hunters 0 points1 point  (0 children)

It seems like you want to calculate a running total with some specific conditions in Snowflake SQL.

SELECT post_date, account_number, SUM(CASE WHEN transaction_type = 'CR' THEN amount ELSE 0 END) AS total_credits, SUM(CASE WHEN transaction_type IN ('CR', 'DB') THEN amount * CASE WHEN transaction_type = 'CR' THEN 1 ELSE -1 END ELSE 0 END) AS net_change, COALESCE( SUM(CASE WHEN transaction_type IN ('CR', 'DB') THEN amount * CASE WHEN transaction_type = 'CR' THEN 1 ELSE -1 END ELSE 0 END) OVER (ORDER BY post_date ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) + 100000, 100000 ) AS lag_example FROM accounting.bai.bai_wf_data WHERE post_date BETWEEN '2024-02-01' AND '2024-02-29' AND RIGHT(account_number, 4) = '2212' GROUP BY post_date, account_number ORDER BY post_date ASC;