delive (u/delive) - Readit News

Deleted Comment

delive commented on Show HN: BemiDB – Postgres read replica optimized for analytics github.com/BemiHQ/BemiDB... · Posted by u/exAspArk

exAspArk · 10 months ago

We haven't tested this with 1TB Postgres databases yet, assuming that most companies operating at this scale already built analytics data pipelines :) I'm curious if you currently move the data from this Postgres to somewhere else, or not yet?

delive · 10 months ago

Not yet, mostly just kicked the can down the road due to costs. Like you said in another post, careful indexes on postgres get you quite far, but not nearly as flexible as a columnar DB.

I think your project is great. I suspect incremental updates will be a big feature for most uptake (one we would need to try this out at least).

delive commented on Show HN: BemiDB – Postgres read replica optimized for analytics github.com/BemiHQ/BemiDB... · Posted by u/exAspArk

exAspArk · 10 months ago

Fair point. We think that BemiDB currently can be useful when used with small and medium Postgres databases. Running complex analytics queries on Postgres can work, but it usually requires tuning it and adding indexes tailored to these queries, which may negatively impact the write performance on the OLTP side or may not be possible if these are ad-hoc queries.

> (multi-TB databases under load) is where logical replication won't be able to sync your tables in time

I think the ceiling for logical replication (and optimization techniques around it) is quite high. But I wonder what people do when it doesn't work and scale?

delive · 10 months ago

What would you consider to be small or medium? I have a use case for analytics on ~1 billion rows that are about 1TB in postgres. Have you tried on that volume?

Posted by u/delive a year ago

Postmortem of my 9 year journey at Google tinystruggles.com/posts/g...

delive commented on E3 Is Officially Dead washingtonpost.com/entert... · Posted by u/eXpl0it3r

0cf8612b2e1e · 2 years ago

I would go further and state that many probably owe gaming for their tech career. In the dark ages, installing and running a game could take significant technical effort. Scouring forums and looking for magical configuration or patches that could make it work. That technical knowledge builds upon itself.

delive · 2 years ago

Agree! What got me into programming was building/running my own Counter-Strike server and corresponding stats website. Now with companies running their own servers internally, that isn't nearly as common.

delive commented on 1Password detects "suspicious activity" in its internal Okta account arstechnica.com/security/... · Posted by u/simonpure

jrockway · 2 years ago

That is fascinating:

> A member of the IT team was engaged with Okta support, and at their request, created a HAR file from the Chrome Dev Tools and uploaded it to the Okta Support Portal. This HAR file contains a record of all traffic between the browser and the Okta servers, including sensitive information such as session cookies. In the early morning hours of Friday, Sept. 29th, an unknown actor used the same Okta session that was used to create the HAR file to access the Okta administrative portal

Like your bank tells you, don't give the support person your password.

delive · 2 years ago

I thought so too, but then was surprised to see:

   Based on the activity logs provided by Okta for their Support Portal, the HAR file had not been accessed by their support engineer until after the events of the incident

delive commented on Threads profile can only be deleted by deleting Instagram account, Meta says techcrunch.com/2023/07/06... · Posted by u/jmsflknr

Solvency · 2 years ago

Why has everyone on here been comparing Threads to Twitter when threads.com literally says its a Slack alternative for makers? The product has absolutely nothing to do with a Twitter style social network.

Edit: lol so FAANG just steals any and all actively used product names now. Got it.

delive · 2 years ago

The social app uses .net - Threads.net

delive commented on Hackers used Slack to break into EA Games vice.com/en/article/7kvkq... · Posted by u/danso

mcoliver · 4 years ago

So cookie gets them into Slack. But how were they able to get into the network, spin up a vm and connect to p4? That doesn't happen with a cookie and MFA token.

They either had a username/password combo already, or support also allowed them to reset the compromised users password (ex through a one time link to set a new pw, or perhaps more egregiously "here is your new password: welcome2EA".

A video call and a few questions could have stopped this. Or a password reset flow that requires some sort of previous information. Would love more details here.

delive · 4 years ago

This is where I'm confused as well and yours is the first comment mentioning it.

A more plausible scenario is that IT reset their AD/IDP password because of the lost device and gave them the temp pw over slack + some MFA token.

delive commented on Hackers take over prominent Twitter accounts in simultaneous attack coindesk.com/hackers-take... · Posted by u/megadeth

jackschultz · 5 years ago

An incredibly number of people in the entire world who have seen these tweets, and currently, 5:16 eastern, shows 271 transactions.

Not like everyone who sees these tweets has bitcoin accounts, but less than 300 falling for the fake tweets is such a small number in terms of populations.

delive · 5 years ago

It's probably because the subset of people who would fall for it likely don't have BTC.

delive commented on Lessons learned using single-table design with DynamoDB and GraphQL servicefull.cloud/blog/dy... · Posted by u/ranman

erik_seaberg · 6 years ago

Yeah, partition size is only limited if you create a local index, because those are strongly consistent.

delive · 6 years ago

Ah interesting, it looks like you are right. If the any partition grows to > 10GB on the main table or a GSI, that partition splits into sub-partitions using the sort key as part of the hashing function. If there is no sort key, the partitioning scheme equally distributes items across partitions, so all partitions sub-divide at the same time.

https://stackoverflow.com/questions/40272600/is-there-a-dyna...

u/delive

KarmaCake day110February 3, 2012View Original