JoelJacobson

5 ms·

31.
Ask HN: How do/did you use PostgreSQL's LISTEN/NOTIFY in production?
2 points by JoelJacobson 1y ago|4 comments
32.
by JoelJacobson 1y ago
Fun fact: CBOR is used within the WebAuthn (Passkey) protocol. To do Passkey-verification server-side, I had to implement a pure-SQL/PLpgSQL CBOR parser, out of fear that a C-implementation could crash the PostgreSQL server: https:&#x
33.
by JoelJacobson 1y ago
Hey folks, I ran into similar scalability issues and ended up building a benchmark tool to analyze exactly how LISTEN/NOTIFY behaves as you scale up the number of listeners. Turns out that all Postgres versions from 9.6 through current
34.
by JoelJacobson 1y ago
Could anyone clarify what the author means regarding duty drawback? He writes: "There is no duty drawback for exporting. In the past, even in the United States, if you imported something and then exported it, the tariff you paid on the
35.
by JoelJacobson 2y ago
Thanks for creating, really useful! Would be nice with a [Download Combined Rendered] button to download a self-contained .html web page of the rendered combined page.
36.
by JoelJacobson 2y ago
Thanks for sharing your perspective—I really appreciate it. In hindsight, I should have given more weight to the "Any better approaches?" part of the original post. I fully acknowledge that my proposal involves trade-offs and isn&
37.
by JoelJacobson 2y ago
I agree that having options is crucial, but we also need to consider how these options fit together to ensure system-wide safety by design. To actually mitigate screen-sharing risks, you need a combined hardware/OS and secure communica
38.
Proposal: Add "No Screen Sharing" Flag for Secure Messaging Apps
2 points by JoelJacobson 2y ago|5 comments
39.
by JoelJacobson 2y ago
https://grok.com/ 500 Internal Server Error nginx/1.27.4
40.
by JoelJacobson 2y ago
I tested PostgreSQL vs Neo4j with a friends-of-friends query two years ago, and to my surprise it was Neo4j that crashed, not PostgreSQL. https://github.com/joelonsql/graph-query-benchmarks I haven't tried the lat
41.
by JoelJacobson 2y ago
So that the operating system could recognize it automatically, and to include a potentially long URL to the retail bank's web service to initiate the protocol, such as signing a document or an identification protocol.
42.
by JoelJacobson 2y ago
Imagine using the ID card emoji (U+1FAAA) as a universal carrier for digital ID tokens. A dumb demo is available at https://pit.lovable.app/ which—without any secure protocol—simply encodes a National Identification Number
43.
by JoelJacobson 2y ago
I love the idea of Reason/ReScript. I hope they can figure out a way to work together and join forces somehow, the contributions to both repos seems to have faded over the last years, but maybe that's because the projects have sta
44.
by JoelJacobson 2y ago
Here is another interesting BOLT article, this one on PostgreSQL optimization: https://vondra.me/posts/playing-with-bolt-and-postgres/ "results are unexpectedly good, in some cases up to 40%"
45.
by JoelJacobson 2y ago
In Sweden too
46.
by JoelJacobson 2y ago
I wish there was a similar tool for relational algebraic expressions, to make relational database research papers more accessible.
47.
by JoelJacobson 2y ago
Strange, I haven't found any articles that mention the "Find People Nearby" and "Make Myself Visible" features, which seems to be core features criminals use to sell drugs/sex, finding new random clients in the
48.
Telegram vs. Signal(gist.github.com)
4 points by JoelJacobson 2y ago|0 comments
49.
by JoelJacobson 2y ago
Can you please share the SQL queries? If tables/columns are sensitive, maybe it can be anonymized replacing tables with t1,t2,t3 and columns c1,c2,c3.
50.
by JoelJacobson 2y ago
Why is this [flagged]? Sounds like The Register has plausible reasons to also, like the OP, question if this is genuinely caused by a DDoS attack.
51.
by JoelJacobson 2y ago
> What 32-bit systems are being used today? I found these in the PostgreSQL Build Farm: - AIX 7100-05-06-2028 gcc 8.3.0 (32 bit) ppc64 (POWER7) - Debian 7.0 gcc 4.7.2 i686 - Debian Sid gcc recent i386 Source: https://buildfarm
52.
Poll: Are You Running PostgreSQL on 32-Bit Hardware?
3 points by JoelJacobson 2y ago|2 comments
53.
by JoelJacobson 2y ago
No, I'm not running a PostgreSQL server on 32-bit hardware.
54.
by JoelJacobson 2y ago
Yes, but my PostgreSQL server on 32-bit hardware have modest performance demands.
55.
by JoelJacobson 2y ago
Yes, and maintaining high performance on my 32-bit PostgreSQL server is crucial.
56.
by JoelJacobson 2y ago
Author here of the PostgreSQL raw queries feature mentioned in the release notes, which allows users to use PostgreSQL's native placeholders ($1, $2, etc.) instead of the standard %s placeholder [1]. from psycopg import connect,
57.
by JoelJacobson 3y ago
Do the two 4090 GPUs need to be on the same machine, or is it possible to somehow use two separate machines, each with its own 4090, and link them somehow via e.g. InfiniBand?
58.
by JoelJacobson 3y ago
Depends on what quality you desire. Quite nice quality is indeed not costly. But if you need top color rendering quality, such LEDs are still very expensive compared to incandescent bulbs. The official IKEA specs for [1] says nothing about
59.
by JoelJacobson 3y ago
While the video at 28:09 asserts "virtually no downsides" to LED bulbs, it overlooks a crucial aspect: light quality. The quality of light is a critical parameter, typically measured by CRI (Color Rendering Index) or the more comp
60.
by JoelJacobson 3y ago
The recent DeepMind paper on FunSearch highlighted their use of pre-trained large language models (LLMs) for generating code improvements. Interestingly, while the main LLM used was Codey, built on the PaLM2 model family, they also referenc

More ›