00:11 < bridge> Doubt that 02:18 < bridge> "I'll teach 10individuals how to earn $100,000 in 72 hours from the crypto market. But you will pay me 10% commission when you receive your profit. if interested send me a direct message by asking me (HOW) for more details on how to get startedhttps://t.me/FloraGordon 04:23 < bridge> I did too 04:24 < bridge> after finishing the interview that is 05:46 < bridge> yo i haven't played in a while and was wondering if anyone knew why my mouse gets stuck at top left of ddnet when i start it up. and i cant move it at all ( on latest version for linux ) 05:47 < bridge> if you could pm me if you know because im not very active, reason being I'm at work most of the time 07:28 < bridge> left click once to grab focus 07:59 < bridge> Have you tried switching from x11 to wayland or vice versa? 07:59 < bridge> (@BloodDrippn) 09:01 < bridge> :kek: it's that time of the month again. really have no motivation to work 09:05 < bridge> During the week #off-topic is usually more active. I guess that is explained by the same reason 😂 09:06 < bridge> :kek: 09:06 < bridge> Good morning 10:10 < bridge> another beautiful day to code in rust 11:25 < bridge> Every morning is a blessing from god and is excellent in it's own way 11:27 < bridge> @Learath2 zeus will zap u 11:27 < bridge> He can't. That'd be a bad vibe, but they have been banned 14:19 < bridge> :f3: 15:12 < bridge> have you considered a boyfriend 15:57 < bridge> Yes, but I don't seem to have the system update required 15:58 < bridge> :poggers2: 15:59 < bridge> They only gave me a cis module at birth it seems 16:01 < bridge> are you implying cis male can not have a boyfriend 16:52 < bridge> https://lwn.net/Articles/844224/ 17:05 < bridge> 17:54 < bridge> https://tenor.com/view/silly-cat-mauzy-mice-boys-texting-gif-17756669638833090229 18:08 < ChillerDragon> watf gerdoe 18:10 < bridge> bruh💀 18:12 < bridge> you are surprised? 18:12 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1100091785272905838/image.png 18:12 < bridge> oh 18:12 < bridge> idk 18:12 < bridge> Just normal gerdoe: 18:37 < bridge> epic furry moment 19:44 < bridge> @Chairn @Learath2 http://sam.zeloof.xyz/second-ic/ 19:47 < bridge> dafuck? 19:47 < bridge> didn't know it was possible to do that yourself 19:49 < bridge> Well it is physically possible. I never thought someone would be motivated enough and have the skills to do it 19:53 < bridge> that guy has 10k$+ equipment though 19:53 < bridge> that guy has 10k$+ pieces equipment though 19:56 < bridge> He also has a cool startup now with Jim Keller: Atomic Semi 20:10 < ChillerDragon> are official ddnet integration tests also wonkey or is it just me? I just got a ``[-] Error: expected 1 rank got 3`` that seems weird 20:14 < bridge> ur wonky 20:16 < ChillerDragon> at least on github it passes :shrug: 20:23 < bridge> It is a lot, but it's also a lot less than what one might expect. This is an extremely expensive manufacturing process 20:29 < bridge> there you go 20:29 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1100126316017238167/fab_cost.pdf 20:29 < bridge> graph is from 2018 20:30 < bridge> https://cdn.discordapp.com/attachments/293493549758939136/1100126622197235812/image.png 20:30 < bridge> red is cost for each node 20:32 < bridge> if i get my 10 fps more i'd pay lot more 20:36 < bridge> the market of also grew a lot 😄 20:36 < bridge> so its probably rather cheap 22:06 < bridge> more stats like these from 2023 22:06 < bridge> where is it so outdated XD 22:10 < bridge> ` SELECT COUNT(*) as count, date(timezone('UTC', purchase_time)) as day from purchase GROUP BY date(timezone('UTC', purchase_time)) ORDER BY day DESC LIMIT 15;` 22:10 < bridge> any sql masters 22:10 < bridge> how can i make this faster 22:10 < bridge> i wanna count purchases by day 22:11 < bridge> `create index if not exists idx_purchase_purchase_time on purchase( date(timezone('UTC', purchase_time)) );` 22:11 < bridge> it has this index 22:11 < bridge> it has no primary key though 22:12 < bridge> ```sql 22:12 < bridge> explain analyze SELECT COUNT(*) as count, date(timezone('UTC', purchase_time)) as day from purchase GROUP BY date(timezone('UTC', purchase_time)) ORDER BY day DESC LIMIT 15; 22:12 < bridge> QUERY PLAN 22:12 < bridge> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 22:12 < bridge> Limit (cost=1000.46..11744.04 rows=15 width=12) (actual time=1667.304..1700.836 rows=15 loops=1) 22:12 < bridge> -> Finalize GroupAggregate (cost=1000.46..341213.86 rows=475 width=12) (actual time=1667.302..1700.832 rows=15 loops=1) 22:12 < bridge> Group Key: (date(timezone('UTC'::text, purchase_time))) 22:12 < bridge> -> Gather Merge (cost=1000.46..341201.99 rows=950 width=12) (actual time=1666.905..1700.817 rows=31 loops=1) 22:12 < bridge> Workers Planned: 2 22:12 < bridge> Workers Launched: 2 22:12 < bridge> -> Partial GroupAggregate (cost=0.43..340092.31 rows=475 width=12) (actual time=15.057..1098.931 rows=291 loops=3) 22:12 < bridge> Group Key: date(timezone('UTC'::text, purchase_time)) 22:12 < bridge> -> Parallel Index Scan Backward using idx_purchase_purchase_time on purchase (cost=0.43..323734.62 rows=3270114 width=4) (actual time=0.029..975.622 rows=2609251 loops=3) 22:12 < bridge> Planning Time: 0.235 ms 22:12 < bridge> Execution Time: 1700.887 ms 22:12 < bridge> ``` 22:23 < bridge> limited by o(m) time in a world of capitalism 22:24 < bridge> limited by o(n) time in a world of capitalism 22:34 < bridge> <Огурец> where to find the file game.cpp in the source of ddrace 22:39 < bridge> <Огурец> where to find the file game.cpp in the source of ddrace? 22:39 < bridge> He claims you can do 5nm for 500k 😉 https://twitter.com/szeloof/status/1549937044067172352 22:42 < bridge> <Огурец> . 22:46 < bridge> <Огурец> I am told that it is in scr/game, but there is only a similar gamecore file there, is that it? 22:48 < bridge> <𝐊𝐑𝐀𝐋> Hello, I'm thinking of creating a server for my game, how do you think I should do it? 22:55 < bridge> https://twitter.com/szeloof/status/1550111033582395392 well, i highly doubt that too 22:56 < bridge> yield is probably really shitty, like 90%+ defect 22:57 < bridge> not sure those machines linked can be used for 5nm 22:57 < bridge> electron microscope is useless too 22:59 < bridge> <Огурец> . 23:01 < bridge> what is your game? Is it based on DDNet/Teeworlds or an independent game? 23:02 < bridge> do you just want to run the server or write the source code for it? 23:02 < bridge> There is no game.cpp, what are you looking for? 23:03 < bridge> <Огурец> where to get it then? I search in the source archive from github ddrace 23:05 < bridge> <𝐊𝐑𝐀𝐋> an indie game 23:05 < bridge> There is no game.cpp in ddnet or teeworlds 23:05 < bridge> <Огурец> maybe it was renamed by the developers? 23:06 < bridge> <Огурец> what is it called then. similar code 23:06 < bridge> What code are you looking for? 23:06 < bridge> <𝐊𝐑𝐀𝐋> I want the server to record user information, such as level, etc. 23:07 < bridge> <Огурец> initial, where all the functionality is written 23:09 < bridge> huh? the functionality is spread amongst all the source files 23:09 < bridge> if you are looking for a specific functionality I can try to help you track it down, but there isn't one file with the entire game in it 😛 23:12 < bridge> <Огурец> Well, for example, I want to make arrows that will be public on a nearby player. In what file should I write it? 23:13 < bridge> Public arrows? I'm afraid I don't follow 23:15 < bridge> <Огурец> I didn't understand you, I'll use a translator 🙂 23:16 < bridge> <𝐊𝐑𝐀𝐋> I can explain in more detail @deen 🙂 23:18 < bridge> <Огурец> for example, I want to make a line go from my player to another, where to write it? 23:29 < bridge> That would probably belong in `src/game/client/components/` inside a new file, like how we added `freezebars.cpp` 23:32 < bridge> hmm, the actual quote is "there is no spoon" 23:32 < bridge> there is no cow level