Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
gregw2
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
36 ms
·
421.
▲
by
gregw2
3y ago
This assumes your stream has the full event history … or that history/state is irrelevant, correct? If not, did you leave out a ‘copy history from source to target’ step?
422.
▲
by
gregw2
3y ago
An explicit shard id can ensure all related data across all tables can be on the same shard. Helpful for SQL JOIN operations. Picking the N least significant bits only a single table has good distribution and sort qualities, no cross-table
423.
▲
by
gregw2
3y ago
Overall death rates shouldn’t be affected by this. Were they?
424.
▲
by
gregw2
3y ago
I think that’s the virtue of setting a high price on what you don’t want to do as your “not saying no”/funding strategy. It’s a reflection of your perceived opportunity cost. But you are right to suggest time-bounding your engagement u
425.
▲
by
gregw2
3y ago
Thanks, that was a good piece. It makes me want to share a story about an additional piece of perspective on what happened with Japan. I worked for a CEO in the early 90s who was midwestern ex-WallStreet-analyst deeply concerned about Ameri
426.
▲
by
gregw2
3y ago
I suspect there's no way ESR even got $1 million out of VA Linux. 1) ESR was on the Board of Directors of VA Linux and subject to the 180-day lockup so there is NO WAY he could sell under SEC regs until after 180 days so he couldn'
427.
▲
by
gregw2
3y ago
My grandfather, who devoted his life to nonprofit work, liberated concentrations camps firsthand as a US Army officer, and observed in his later years how common it was for people to remember the six million Jews who died but forget the six
428.
▲
by
gregw2
3y ago
Re ‘UPSERT is really for OLTP’, I find that claim surprising. If you mean the oracle UPSERT command, you may be right and should ignore my post, but if you mean upsert concept/terminology/MERGE-usage, I’m not sure I agree. I admit
429.
▲
by
gregw2
3y ago
You are bringing data from a transactional (OLTP) system into a reporting/analytics (OLAP, lakehouse, data warehouse, data hub) system. The analytic database is expected to maintain a list of all customers and their transactions going
430.
▲
by
gregw2
3y ago
The problem with plain/primitive upset/merge operations is they don’t always support handling of what should happen when a row is deleted from the source. People new to data engineering don’t always recognize this. Im those cases,
431.
▲
by
gregw2
3y ago
FYI, article doesn’t say it but Redshift nowdays supports MERGE: https://docs.aws.amazon.com/redshift/latest/dg/r_MERGE.html
432.
▲
by
gregw2
3y ago
I poked around trying to find a high level understanding. Here's the best place to start from what I could tell: https://docs.pinot.apache.org/basics/concepts Based on that, it's a MPP columnar database focus
433.
▲
by
gregw2
3y ago
It’s worth reading Ray Ozzie’s (Lotus Notes creator)’s comment on this from a HN 2013 discussion: https://news.ycombinator.com/item?id=5846189 Before the software was released, Ray Ozzie and Kauffman openly described what t
434.
▲
by
gregw2
3y ago
Candidly this is not my area of expertise but I always thought it was multi-vendor. Lacking first-hand knowledge, a curious quick web search does imply that at least the Open/XA standard was supposed to be multi-vendor: The Open Grou
435.
▲
by
gregw2
3y ago
How heterogeneous do you mean? But basically, "yes". IBM had CICS transactions back in the day for some definition of heterogeneity. Tuxedo did this in the 80s across broader platforms. In the 90s (when I heard of it) there was a
436.
▲
by
gregw2
3y ago
Not exactly what I was looking for in terms of the security side of things but perhaps more sophisticated in terms of the editing handling. Cool, thanks for the reply! Money quote from https://mosh.org/#techinfo : Remote-
437.
▲
by
gregw2
3y ago
Does anyone know any SSH clients that support line-buffering of input? I.e. where what you type doesn't get transmitted until you hit or click return/send? I had one of these clients (but for telnet) back in more active MUD gaming
438.
▲
by
gregw2
3y ago
Err no, it was not just Juniper. Many other systems were fuzzed, half a dozen vendors were fine, another 5 weren’t and some remain unpatched and vulnerable. If it were just a Juniper implementation flaw it’d be less interesting than explain
439.
▲
by
gregw2
3y ago
The verbiage you cite makes it seem dull. I thought it was actually pretty interesting. The take away I got was that people whose fields are too similar don’t knowledge share and generate good knowledge creation nearly as well as situations
440.
▲
by
gregw2
3y ago
Thanks. Is there a list somewhere of Postgres-based columnar datastores (and which are MPP/clustered vs single/SMP-node)? * Citus (cstore_fwd) extension * Azure CosmosDB for PostgreSQL * GCP AlloyDB for PostgreSQL * AWS Redshift (
441.
▲
by
gregw2
3y ago
Good Warnock interview with tech details and history I haven't seen elsewhere: https://programmersatwork.wordpress.com/john-warnock/ A good interview detailing among other things why he succesfully made type1 font
442.
▲
by
gregw2
3y ago
I hate to say it but certain advertisers might pay more for ads that play while people are sleeping (ie placement during 8 hour tracks of white noise). This is not a $38m-in-costs crisis for Spotify, this is a revenue opportunity! ... 60
443.
▲
by
gregw2
3y ago
Agreed. But you are 27 years late to this argument at least in the US. In 1996, when the Internet was hot, telcom providers promised to spend tens of billions building out fiber infra US-wide as long as Congress guaranteed them they owned
444.
▲
by
gregw2
3y ago
With TDD you write tests first, then ensure your tests fail, then write code, ... for the reasons you mention.
445.
▲
by
gregw2
3y ago
I had a boss once with a similar viewpoint, so I learned from him how they automated database deployments for Java/Scala apps using Liquibase+Maven and found I could apply and integrate the same principles to testing and deploying a da
446.
▲
by
gregw2
3y ago
Funny! Thanks
447.
▲
by
gregw2
3y ago
When I was younger and worried about how we were going to execute on some project a veteran (ex-DEC) salesperson had sold, he pulled me aside and laid some gnomic-to-a-young-engineer sales wisdom on me… “Look, never confuse the sales cycle
448.
▲
by
gregw2
3y ago
Re: "analog computing", I presume you have seen the following recent Wired survey/review of recent interest in it, but if not, see: https://www.wired.com/story/unbelievable-zombie-comeback-ana... My per
449.
▲
by
gregw2
3y ago
From the outside, their backend tech has loopholes they don’t notice that bleed money for them. I had a pair of modest-sized accounts with them that I didn’t use much. I kept them at $3000 to avoid hitting monthly minimums and paying fees.
450.
▲
by
gregw2
3y ago
I dunno, I used to use ISO linux images because they were write-once and assuming I had a trusted source of the ISO or system writing the ISO, I didn't have to worry about the Linux system getting compromised and I could just run Linux
More ›