News for hackers. Stuff that matters.

compton93

Re:Edit store price tags using Flipper Zero on Tuesday April 21, 2026 @08:26AM (#47847819)
That's crazy. But coming from someone who wrote a book on retail fraud and worked as a retail fraud analyst for several years... you could have just walked straight out with those items.

Transacting was your way of leaving a calling card for the investigators/analysts to find you... You stole regardless of how you did it.

Re:QEMU: Define policy forbidding use of AI code generators on Wednesday June 25, 2025 @08:15PM (#44383040)
I don't want to review code the author doesn't understand

This really bothers me. I've had people ask me to do some task except they get AI to provide instructions on how to do the task and send me the instructions, rather than saying "Hey can you please do X". It's insulting.

Re:Game Hacking – Valve Anti-Cheat (VAC) on Thursday June 19, 2025 @01:13AM (#44315640)
No they just read the memory. The whole point of an external cheat is to only read memory. They can still use Win32 to send inputs.
Re:Game Hacking – Valve Anti-Cheat (VAC) on Thursday June 19, 2025 @12:25AM (#44315434)
Win32 API mouse input and trigger a mouse click in Windows when crosshair on enemy head (more likely when crosshair is within enemy head position).
Re:Snowflake to Buy Crunchy Data for $250M on Monday June 02, 2025 @07:07PM (#44164264)
> literally name themselves as "Postgresql Data Warehouse" but correct me if I'm wrong

That's not their primary product. Crunchy Postgres is their primary offering and they recently announced Crunchy Data Warehouse.

I consulted on a project that was using MongoDB even though it was obvious from the concept that an RDBMS would be better, however I went in with an open mind and gave MongoDB a red hot crack. It straight up ignored indexes with no explainable reason why. We had a support contract and they just gave us the run around.
Re:Migrating to Postgres on Wednesday May 14, 2025 @09:54PM (#43991103)
They've had flags and work arounds for ages. Not sure what point you are trying to make? But like you said I've never used it, only heard of it lol.
Re:Migrating to Postgres on Wednesday May 14, 2025 @09:25PM (#43990925)
When you get a chance can you take a look my reply here: https://news.ycombinator.com/item?id=43990502

When I first stepped into a DBA role with CockroachDB I was confused why indexes we obviously need were in unused indexes. It wasn't until I did an explain on the queries I learned the planner was doing zig-zag joins instead.

Re:Migrating to Postgres on Wednesday May 14, 2025 @09:07PM (#43990828)
They've been saying that for 3 years. We actually had a discount for being an early adopter. But hey its obvious Ive never used it and only heard of it.
Re:Migrating to Postgres on Wednesday May 14, 2025 @08:33PM (#43990627)
What are your thoughts on Fujitsu's VCI? I typically work for ERP's but im always advocating to offload the right queries to columnar DB's (not for DB performance but for end user experience).
Re:Migrating to Postgres on Wednesday May 14, 2025 @08:23PM (#43990582)
It is. But wait... it doesn't join the data on the application level of your application. You have to deploy their proxy service which joins the data on the application level.
Re:Migrating to Postgres on Wednesday May 14, 2025 @08:07PM (#43990502)
I'm curious about Motion's experience with "Unused Indices". They suggest Cockroach's dashboard listed used indexes in the "Unused Indices" list.

I think though they are unused but Motion didn't realize CockroachDB was doing zigzag joins on other indexes to accomplish the same thing, leaving the indexes that would be obviously used as genuinely not used.

Re:Migrating to Postgres on Wednesday May 14, 2025 @07:56PM (#43990447)
I worked for startup who did all of these things on CockroachDB. We could of used a single m5.xlarge PostgreSQL instance (1000 basic QPS on 150GB of data) if we optimized our queries and went back to basics, instead we had 1TB of RAM dedicated to Cockroach.

I added about 4 indexes and halved the resources overnight. But Prisma, SELECT *, graphql and what other resume building shit people implemented was the bane of my existence, typically engineers did this believing it would be faster. I remember 1 engineer had a standing ovation in slack for his refactor which was supposedly going to save us $$$$$ except our DB CPU went up 30% because he decided to validate every company every second in every session. In his defense, he added 1 line of code that caused it, and it was obscured through prisma and graphql to an inefficient query.

FWIW; I love CockroachDB but the price is directly linked to how much your software engineers shit on the database.

Re:Mac Themes Garden on Wednesday May 07, 2025 @06:51PM (#43921315)
A guy on reddit was working on one named PrismWM but he went AWOL. There was a mac os 9 lookandfeel in JDK 1.1 that could be updated to a modern version of Java as well.
PearPC?
I suspect thats the case, but EoE became a thing for me within months of that ordeal so I suspect there is a connection. My EoE symptoms are difficulty swallowing and esophageal spasms. I have access to oral budesonide which does stop it however it elevates my heart rate.
I used to get acid reflux, it was really noticeable while trying to sleep, but that changed after I drank some water (by accident) from inside a cave of a small island near Vanuatu. This led to the worst throat infection I've ever had, after treating it with antibiotics, I stopped having acid reflux altogether. It's been 5 years now without any acid reflux. However, I've now been diagnosed with eosinophilic esophagitis (EoE).

Honestly I wonder how much of acid reflux is connected to the gut bacteria.

Re:New anti-speeding system coming to Australia is dangerous on Wednesday August 21, 2024 @06:41PM (#41314909)
Or when a car behind you tries to double dip on the overtake so you are forced to commit with them barreling up behind you.
Re:Whither CockroachDB? on Saturday August 17, 2024 @06:58AM (#41273503)
Clock sync issues also sucked, we had a recurring issue which would cause the cluster to become unstable due to clock syncs and support would throw it in the to hard basket.
Re:Ask HN: Has GitHub Search always been broken? on Monday March 13, 2023 @08:14PM (#35145305)
Old search was better for global searches, I find the new search great for searching within an org.
I picked up a 7900X3D last week, I wanted the X3D cache for Rust (the game). Since upgrading from a 5900 I have gone from 90ish FPS to 200FPS, no graphics card upgrade just CPU. I've seen some media/youtube reviews that don't recommend these CPU's because of the whole CCU debacle, but this is easily the best CPU I have had in years. I wanted 12 cores as a minimum for running VM's compiling PostgreSQL etc, only reason I didn't get the 7950X3D is they were out of stock.
Re:What's the worst codebase you've ever worked on? on Wednesday February 22, 2023 @11:55PM (#34906939)
Worked for 5 years old a ColdFusion codebase that is still in use for a large SaaS. 1 Big monolith, no tests, all procedural code and changing any code would break something somewhere else.

But honestly now I work on a typescript monolith thats moving to microservices and its probably worse than the ColdFusion code base. I'd rather work on the ColdFusion codebase.

Re:Play Runescape Classic Again on Tuesday February 07, 2023 @11:07PM (#34704001)
Modern bots use reflection on the client itself, including faking the MouseEvent to the canvas/applet. Some bots use typical autohotkey style automation of just moving the mouse around and using color pickers/opencv to validate actions. Packet bots are rare but still do exist, AutoRune was one of them and it was used to duplicate items etc.
Haven’t been laid off but I see it coming in the next few months. I do DBA/performance tuning on MySQL, Postgres, SQL Server (and recently Cockroach). Being remote in Australia makes it hard to get another job so I’m thinking to learn a trade and exit tech as a career.

Recently I got into using mono.Cecil to rewrite c# assemblies (specifically assemblies created by IKVM). I haven’t had a personal project in years but this has definitely reignited a spark, so I’m going to try for a remote software engineering job first.

Funnily enough, Cyberduck (the FTP, SSH, s3 mounting software for Mac/Windows) uses IKVM for their windows release.
That's awesome, I did a similar thing with J# to port a basic Java library to C# a while ago.
Re:Ask HN: Is DBA still a good job? on Monday May 09, 2022 @12:04AM (#31310490)
I think it depends. I've seen bootcampers who are motivated by being a Software Engineer at FAANG on 500k yet they don't understand why turning off your computer stops programs from running. But I've also met bootcampers who spent several years writing bots for runescape or coding in their spare time and are using the bootcamps as a way in to the industry.
Re:Ask HN: Is DBA still a good job? on Sunday May 08, 2022 @11:37PM (#31310323)
I hate to imagine how many startups out there don't even create indexes and just consider it to be a database problem and increase CPU/RAM and look the other way.

I worked for several years at a semi-startup as a Database Engineer where my role was to guide developers in writing performant SQL (and writing indexes for them) and architect their schema to be inline with our future plans and various other database tasks (managing query plans, being an expert on the database feature set etc). I even created an internal course: SQL School, that I included the directors/customer support teams in.

To that specific company my role was priceless, new features could be built in 1/2 the time with an expert writing the queries and handling the database. My programmatic analysis of our 20 year old code base had 5000 unique queries and 3000 more when accounting for dynamic SQL. Not gonna lie it was a complete mess but if I didn't exist they would have needed a lot more database resources. It was a terrible code base and any plan to refactor and avoid this mess would still need my role to do the transition.

I loved that job but its extremely hard to transition to any other roles and nowadays its easier to use alternative solutions.

I feel for the victims of any source code leak, but I am disappointed SQL Server didn't make it into this one. So much could be learned from the source code.