HackerTrans
TopNewTrendsCommentsPastAskShowJobs

compton93

no profile record

comments

compton93
·3 ay önce·discuss
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.
compton93
·geçen yıl·discuss
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.
compton93
·geçen yıl·discuss
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.
compton93
·geçen yıl·discuss
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).
compton93
·geçen yıl·discuss
> 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.
compton93
·geçen yıl·discuss
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.
compton93
·geçen yıl·discuss
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.
compton93
·geçen yıl·discuss
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.
compton93
·geçen yıl·discuss
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.
compton93
·geçen yıl·discuss
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).
compton93
·geçen yıl·discuss
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.
compton93
·geçen yıl·discuss
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.
compton93
·geçen yıl·discuss
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.
compton93
·geçen yıl·discuss
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.
compton93
·geçen yıl·discuss
PearPC?