benoit

benoit, 1 year ago to random French

I was quite impressed with the impact of specifying the order column (when there is limit) in your index in #postgresql

> An important special case is ORDER BY in combination with LIMIT n: an explicit sort will have to process all the data to identify the first n rows, but if there is an index matching the ORDER BY, the first n rows can be retrieved directly, without scanning the remainder at all.

https://www.postgresql.org/docs/current/indexes-ordering.html

julienxx, 1 year ago to random

Psychoactive Substance Use by Professional Programmers https://neverworkintheory.org/2023/05/10/psychoactive-substance-use-by-professional-programmers.html

sstephenson, 1 year ago to random

I’m building an attention tracking app for macOS called N₁₀, and it’s far enough along now that I feel comfortable talking about it.

Here’s the onboarding animation I’ve been working on. There’s more to the app that I want to illustrate, but this video explains the core functionality. Everything you see is drawn with #SwiftUI

Screencast of an onboarding animation for N₁₀. The captions read: N₁₀ helps you stay focused while you work. When you’re ready to focus, choose Start Session from the N₁₀ menu. Set your intention by typing in what you’re going to do. Then choose how long you want to see your intention on screen. A calming effect every minute reminds you of what you set out to do.