Working around Postgres forcing DISTINCT fields to also be ORDER BY fields

Note: This one has an HN thread. I lost a Stripe dispute of USD $210 because the customer that purchased tickets from my site used an email that he claimed to his bank was not his. Stripe and the bank asked me to provide evidence that this wasn't fraudulent and I sent them: The invoice sent to the email the customer entered The actual tickets...

American people don’t seem to see what’s right in front of them. In this short post I’ll tackle one glaring phenomenon that gets zero air time from any of the Western media, be it the traditional propagandists like CNN, Fox and MSNBC to the more progressive style of outlets. It is this: the continuous wealth transfer that is happening from the...

Raptors Republic was acquired by Better Collective last week marking an end to my involvement with the company I founded in 2008 alongside Sam Holako, Brandon Larabie, Scott Phillips (rest in peace) and Josh Budd. The decision to sell the company was a culmination of a few things: Our expenses (primarily salary) were too high and we simply didn't...

I followed the announcement of onestack.dev which is embracing what I think of as the idea of a "complete stack", a singular project for all your data services, iOS/Android apps, and web. It's an ambitious project which uses Tamagui for styling and zerosync.dev for data retrieval and caching. This is the first time I'm introduced to an idea like...

I have to make an iPhone app for ticket scanning at the door and chose React Native/Expo as the stack. I had implemented this feature on the web using QR Code scanning libraries and things more or less worked fine. The main issues were the camera feeling a little clunky, especially when the browser tab went into the background, the constant asks...