Hacker News Reader

compton93on Edit store price tags using Flipper Zero

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.

compton93on Define policy forbidding use of AI code generators

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.

compton93on Game Hacking – Valve Anti-Cheat (VAC)

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.

compton93on Game Hacking – Valve Anti-Cheat (VAC)

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).

compton93on Snowflake to buy Crunchy Data for $250M

> 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.

compton93on Conformance checking at MongoDB: Testing that our code matches our TLA+ specs

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.

compton93on Migrating to Postgres

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.

compton93on Migrating to Postgres

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.

compton93on Migrating to Postgres

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.

compton93on Migrating to Postgres

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).

compton93on Migrating to Postgres

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.

compton93on Migrating to Postgres

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 the indexes they suspect were used 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.

It's a great feature but CRDB's optimizer would prefer a zig zag join over a covering index, getting around this required indexes be written in a way to persuade the optimizer to not plan for a zig zag join.

compton93on Migrating to Postgres

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.

compton93on Mac Themes Garden

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.

compton93on SheepShaver is an open source PowerPC Apple Macintosh emulator

PearPC?

compton93on Exercise to Strengthen Esophageal Sphincter and Eliminate Gastric Reflux (2022)

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.

compton93on Exercise to Strengthen Esophageal Sphincter and Eliminate Gastric Reflux (2022)

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.

compton93on New anti-speeding system coming to Australia is dangerous

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.

compton93on Whither CockroachDB?

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.

compton93on Ask HN: Has GitHub Search always been broken?

Old search was better for global searches, I find the new search great for searching within an org.

compton93on Ryzen 7950X3D review: An expensive but efficient 16-core CPU

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.

compton93on What's the worst codebase you've ever worked on?

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.

compton93on Open RuneScape Classic

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.

compton93on Ask HN: Anyone doing some absurd stuff after getting laid off?

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.

compton93on Show HN: Otterkit – COBOL compiler for .NET

Funnily enough, Cyberduck (the FTP, SSH, s3 mounting software for Mac/Windows) uses IKVM for their windows release.

compton93on Show HN: Otterkit – COBOL compiler for .NET

That's awesome, I did a similar thing with J# to port a basic Java library to C# a while ago.

compton93on Ask HN: Is DBA still a good job?

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.

compton93on Ask HN: Is DBA still a good job?

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.

compton93on Microsoft confirms Lapsus$ hackers stole source code via ‘limited’ access

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.