Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
ttfkam
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
66 ms
·
751.
▲
by
ttfkam
3y ago
That horse most likely left that particular barn a long, long time ago.
752.
▲
by
ttfkam
3y ago
> I can’t overstate how welcoming the people of Kemmerer are being. That may be true, but I can't help but think billionaires are horrible judges of this. Most folks are very polite to the people who cut huge checks. They also do
753.
▲
by
ttfkam
3y ago
You scored 15/102. Your score indicates low likelihood of having ASPD traits. There is a 2% chance of having Antisocial Personality Disorder. No concerning symptoms were found.
754.
▲
by
ttfkam
3y ago
A 3MB JavaScript runtime blob right out of the gate? ("Only" 275KB needed just to first render, like that's laudable on its own.) Other frameworks have already loaded dependent REST/GraphQL data before Angular has even i
755.
▲
by
ttfkam
3y ago
Ah, now I understand the miscommunication. Point is the technology, the phone, the FaceID, are immaterial. The ultimate goal is the protection of people. Having evidence of wrongdoing by government agents is important, but it is a means to
756.
▲
by
ttfkam
3y ago
* whoosh! * Yep, the 4,096-bit RSA will be enough to protect you from a rogue cop.
757.
▲
by
ttfkam
3y ago
Being unrealistic about the threat models they face? You mean like thinking if a cop can't manhandle you into unlocking your phone through FaceTime, the incriminating evidence of criminal behavior on it will simply be ignored? Especial
758.
▲
by
ttfkam
3y ago
Or use something like Svelte, which doesn't rely on Proxy objects for reactivity. Compilers > VDOMs + runtimes
759.
▲
by
ttfkam
4y ago
I'm surprised to see a discussion of queueing in Postgres without mentioning SKIP LOCKED.
760.
▲
by
ttfkam
4y ago
Postgraphile comes immediately to my mind. https://www.graphile.org/postgraphile/smart-tags-file/ JSON5 parsing is unfortunately slower than JSON. Not intrinsically, but JSON.parse/stringify are both natively
761.
▲
by
ttfkam
4y ago
English is obviously your first language. No one learning English as a second (or more) language would ever make such a ludicrous assertion. https://youtu.be/Mfz3kFNVopk English is not learned; it's memorized.
762.
▲
by
ttfkam
4y ago
You just "decimated" his proposal.
763.
▲
by
ttfkam
4y ago
Every other major language had a recognized central authority to do its work. Spanish, French, written Chinese, etc. all had a monarchy/dictatorship of some sort to mandate the change and enforce its use. England could have done it per
764.
▲
by
ttfkam
4y ago
Spanish is in fact younger. The language was standardized and normalized by royal edict about 500 years ago. While strongly based on Castilliano, it was not the same. "Spanish" as a single cohesive, consistent language did not exi
765.
▲
by
ttfkam
4y ago
A lot of this reminds me of present day web frameworks. "But you HAVE TO have a virtual DOM. You HAVE TO write all this boilerplate and ship a fat runtime. You HAVE TO manage the caching details to these performance problems and abstra
766.
▲
PostgreSQL v15 on AWS Aurora
(docs.aws.amazon.com)
2 points
by
ttfkam
4y ago
|
2 comments
767.
▲
by
ttfkam
4y ago
* MERGE * Much better sorting speed * Views can run as caller instead of owner * Various other performance improvements Aurora advantages over plain RDS: https://aws.amazon.com/rds/aurora/features/ (I'm
768.
▲
by
ttfkam
4y ago
How do we square a former president of the Harvard Law Review and Constitutional Law professor who has been faithful to his wife and devoted and loving to his children? Who actually wrote most of his own speeches. Who was not born wealthy b
769.
▲
by
ttfkam
4y ago
Once you get past the basics and the Rustonomicon, I think it's well worth your time to follow along with Jon Gjengset's video series. https://m.youtube.com/c/jongjengset
770.
▲
by
ttfkam
4y ago
https://stackoverflow.com/a/72397774 Note the use of new_table and old_table as aliases. Instead of single records in NEW and OLD, you can select against new and old sets of records.
771.
▲
by
ttfkam
4y ago
The decision between pl/pgsql and something like plv8 isn't LOC. It's whether the solution best fits a set-oriented model or a procedural model. Both are valid, just different use cases. There are a lot of cases where plv8 wi
772.
▲
by
ttfkam
4y ago
It's astounding to me how much less appealing Tesla has become as a brand since Musk decide to YOLO his way into Twitter. SpaceX is still so far ahead, no one questions it. But other auto manufacturers are already shipping alternatives
773.
▲
by
ttfkam
4y ago
I concur. Pl/pgsql isn't exactly elegant to be sure, but if you're already in a set-oriented mindset but need to add a sprinkling of imperative logic, it's well suited to the job.
774.
▲
by
ttfkam
4y ago
DB performance also comes from size efficiency of user-defined data types, user-defined operator functions (typically for use with those user-defined data types), etc. Smaller, more efficient types directly translate to less disk usage and
775.
▲
by
ttfkam
4y ago
Event triggers fire on DDL changes, not DML. You're thinking of statement-level triggers. As far as event triggers and DO-blocks, that omission seems fine to me. Especially DO-blocks, which are essentially an inline code, one-off esc
776.
▲
by
ttfkam
4y ago
It will be very hard for other database engines to keep up if this gets implemented by cloud vendors. MySQL would get marginalized further and further not just in the relative lack of SQL features, but all the easily available add-ons the c
777.
▲
by
ttfkam
4y ago
I have never heard of Castilian Spanish referred to as "accentless" before. The lisp always sounds odd to me. That and vosotros. The vast majority of Spanish speakers worldwide use neither.
778.
▲
by
ttfkam
4y ago
This looks amazing! This appears to perfectly fit the huge gulf between pl/pgsql and C in the Postgres stack. Pl/pgsql, while not exactly elegant, is well suited to bridging that gap between imperative and set-oriented business lo
779.
▲
by
ttfkam
4y ago
I really like the Wick movies and appreciate their dedication to safety and realism on set. That said, this bothered me: > John Wick isn’t a superhero. There are no computer-generated versions of Wick swinging from tall buildings. The ma
780.
▲
by
ttfkam
4y ago
npm create svelte my-app Creates a SvelteKit app now, not plain Svelte. That said, you can easily disable the server-side portion. export const ssr = false;
More ›