1021
PostgreSQL and SQL:2023
In a previous article, I introduced what is new in SQL:2023. Now I want to show the status of SQL:2023 support in PostgreSQL. See the previous article for details on these features.
New
The latest blog posts to take off on Hacker News. 1,733 posts.
1022
Rust to Assembly: Understanding the Inner Workings of Rust
How Rust compiles to assembly: enum memory layout, smart pointers, static vs dynamic dispatch, vtables, closures, vector iteration and async state machines.
1023
It’s not wrong that "🤦🏼♂️".length == 7 (2019)
From time to time, someone shows that in JavaScript the .length of a string containing an emoji results in a number greater than 1 (typically 2) and then proceeds to the conclusion that haha JavaScript is so broken—and is rewarded with many likes. In this post, I will try to convince you that ridiculing JavaScript for…
1024
Notes on training BERT from scratch on an 8GB consumer GPU
I trained a BERT model (Devlin et al, 2019) from scratch on my desktop PC (which has a Nvidia 3060 Ti 8GB GPU). The model architecture, tokenizer, and trainer all came from Hugging Face libraries, and my contribution was mainly setting up the code, setting up the data (~20GB uncompressed text), and leaving my computer…
1025
What Vale taught me about linear types, borrowing, and memory safety
I've had some pretty surreal experiences while making Vale. 0 The weirdest was when I realized the hidden fundamental truth beneath a lot of the programming languages we use today.
1026
Brave Browser introduces vertical tabs
Brave's vertical tabs feature is now available for Windows, macOS, and Linux users to experience a new way to manage open tabs.
1027
Learn x86-64 assembly by writing a GUI from scratch
Most people think assembly is only to be used to write toy programs for learning purposes, or to write a highly optimized version of a specific function inside a codebase written in a high-level language.
1028
Zig is hard but worth it
"I learned Zig in a weekend! …Six hours! …6µs!" say the blissful lizards. Followed by something to the effect of, "It’s easy to pick up because the syntax is so simple."
1029
Zulip 7.0: Threaded open-source team chat
We’re excited to announce the release of Zulip Server 7.0, containing hundreds of new features and bug fixes! Zulip is an open-source team chat application designed to help people collaborate to solve any challenge. With conversations organized by topic, Zulip is ideal for both live and asynchronous …
1030
When LIMIT 9 works but LIMIT 10 hangs
I got a Slack message from colleagues at a major partner. They’d updated their dev environment to support WebSockets, so that Neon’s serverless driver could be used there, but then they’d run into a weird issue. The nub of it was this: This hangs: This works Reproducibly, the query without an ORDER BY ran fine […]
1031
1032
Directly compiling Scheme to WebAssembly: lambdas, recursion, iteration
It's been just over three months since we announced the Guile on WebAssembly project (codenamed Hoot ). Since then we've brought on two fantastic hackers to develop the project and progress has been quick.
1033
Language Pragmatics Engineering
On best practices and gradient descent.
1034
WASIX, the Superset of WASI Supporting Threads, Processes and Sockets
Today we are very excited to launch a new initiative that will start shaping the future of WebAssembly on both the browser and the server. WASI was ann...
1035
Dynamic Forms with LiveView Streams
Learn how to use to_form/1 and LiveView Streams to create a dynamic list of forms.
1036
Sigils are underappreciated (2022)
Sigils have a bit of a bad reputation. According to their detractors, sigils are “just a way of encoding type information” in variable names – basically a glorified version of apps Hungarian notati…
1037
Death by design patterns, or On the cognitive load of abstractions in the code
After many years coding in different teams — big and small — I think I can now finally explain to myself why and when do we need, or not…
1038
My first superoptimizer
I heard about these mythical programs that find optimal code through a brute-force search, but I didn't know how they worked. So I made one.
1039
1040
Connect() – a new API for creating TCP sockets from Cloudflare Workers
Today, we are excited to announce a new API in Cloudflare Workers for creating outbound TCP sockets, making it possible to connect directly to databases and any TCP-based service from Workers
1041
How to Get Started with Tree-Sitter
Emacs 29 introduces tree-sitter support, a powerful parsing library that enhances its understanding of source code. With this integration, Emacs gains features like precise syntax highlighting, accurate indentation and easier extensibility. Here's how you install and configure Emacs with tree-sitter support.
1042
Lua: The Little Language That Could
An ode to Lua
1043
Bcrypt at 25
As one of the creators of bcrypt back in 1997, I find it somewhat surprising that, 25 years later, we still rely heavily on passwords. My initial encounter with password security took place in 1993 at the University of Hamburg. Having just discovered Unix, I was fascinated by a service called Yellow Pages that allowed…
1044
Why Learn Compilers (2021)
A sufficient understanding of computers is impossible without learning how compilers and their parts work. It is like stepping into the computer's mind and seeing how it feels from the inside. Compil...
1045
Let's make a Teeny Tiny compiler (2020)
Make your own BASIC to C compiler in Python.
1046
1047
Integrating Zig and SwiftUI
Building a native GUI for a cross-platform application is a decades old problem. Nowadays, most people just don't and fallback to using a non-native experience such as Electron instead.
1048
Hard stuff when building products with LLMs
In this post, Phillip talks through the challenges & pitfalls of LLMs we faced when building our Query Assistant - and that you too may face.
1049
Defining a new HTTP method: HTTP Search (2021)
Nothing is ever finished or perfect, and HTTP is no exception. HTTP QUERY is a new HTTP method, for safe requests that include a request body. It's still...
1050
Oxidizing OCaml: Locality
OCaml with Jane Street extensions is available from our public opam repo. Only a slice of the features described in this series are currently implemented.