Here's a way to create an in-memory cache in Elixir. Fun!Use caseI thought I needed Redis. But, like many other things, Erlang OTP can handle that for you. Simplify the stack!Erlang (and thus Elixir) has what's called Erlang Term Storage (ETS). It's an in-memory store. When you create a cache table ...

What is the order of null in sql? Nestle in close, and I'll tell you.Showdev=# SELECT 1 AS value UNION SELECT null AS value ORDER BY value desc; value ------- 1 (2 rows) dev=# SELECT 1 AS value UNION SELECT 0 AS value ORDER BY value desc; value ------- 1 0 (2 rows)Tellasc means smaller to biggerdesc...

An AI is not inspired because a computer doesn't have a soul.AI has a limited ability to inspire.Humans are better-inspired by other inspired humans.The human soulHumans have an inner spirit. When we give expression to our inspiration, we create in the world what had started on the inside. My though...

How to pick which parts of what files you want to stage in git.Stage everythingOften, we want to stage and then commit all our changes in git. To change everything in the working directory,git add .Stage selectivelyTo stage selectively, git allows us an interactive interface for staging. Add the -i ...

Or, when AI tries again.As coders, we try many solutions. Sometimes it's because we're stupid and haven't learned any better yet. Sometimes it's because we're not happy with the result yet. Maybe something gnaws at us. Maybe a thrill to betterment invites us. We care about certain principles related...

Talk about AI is talk about the future. Performance reviews in the age of AI -- I can see it coming.I have heard in various forms that in the future those who don't use AI will be replaced by those that do.This is usually put forward by the techno-optimists. But this isnt't brought up in the same br...

Here's a way to create a create a toast UI that toggles visible with CSS only.This has come in handy for me in a form submission scenario. After submission, I want to show a "thank you" message.First, style the toast however you prefer. Then, importantly, hide it:.toast { /* ... */ display: none; }A...

Sometimes when we're using AI, we're showing our base tendencies.When we use AIWhen we use AI, in some sense it means that we're done creating.We're remixing and reusing.We're ok with average.We're getting it done.We're not concerned about quality.We're focused on quantity.We're making money, not ar...

Here's a way to how to rank score rows returned in SQL.Let's say we have many instances of a thing in our database. In this case, let's say we have many books. We want to create a list of books where we recommend to our friends the best books to read in each genre. If we have read the book, we recom...

Here's how to map a Postgrex wow to a struct.Postgrex RowsPostgrex is a postgres driver for Elixir. It's great for running raw sql against your Postgres database. Your selection/projection gets returned as rows/columns. The columns are returned as a list of strings. The rows are returned as a list o...

Here's how to test for a bytestring in Elixir.Non-solutionsA couple things that won't work:You can't use is_binary on its own, because it returns true for string type as well:iex> is_binary("wow") trueYou can't use String.valid? inside a guard. You get an error like this:iex> defmodule MyModule do ....

Here's how to import a Jinja macro and use it in a for loop. We're going to do it all! Work, Jinja, work!Define MacroA macro is nice, because you have a template-ready function to reuse. Let's say that we want a macro that will insert nice svg icons for us. It'll take a name parameter out return svg...

Here's how to narrow a TypeScript union type on a nested value in an object.Type NarrowingNarrowing a type means we start with a more-general super type and determine which more-specific sub type we're actually dealing with.In this case, we want to know if something is either a magazine or a book. B...

Here's how to order Tailwind CSS styles in CSS @layers.This articles has been updated for Tailwind v4. The original article for v3 is preserved below.Insertion OrderThis is for the veterans out there.You find yourself using Tailwind to compile your CSS. It's your pal because you haven't had to creat...

What response shapes will different error conditions return in GraphQL. There have seemed to be a lot.These are the ones I checked and catalogued.Bad query syntaxQuerying unknown fieldsFilter/arg not foundBad argumentsBad/unreachable hostUnset variables in queryUnset variables in mutationInvalid var...

This is how to restore a pg_dump to an Postgres database managed by Ash. Bet you're excited.I like to do data only dump/restores. This is so that Ash can keep track of all the initial table creation and migrations.Dump ItLet's dump the data from a Postgres data source. Let's say it's production data...

Here are a few keystrokes and facts about how to use Conjure to eval Clojure in Neovim.Conjure is a Neovim plugin that supports multiple languages but works great for lisps. You can evaluate code in your editor.These examples are done with vim.g.maplocalleader = ",".I graduated from :ConjureSchool w...

Here's how to style a child based on a parent in Tailwind CSS.Parent ClassThere's a special Tailwind class called group. group is the class that identifies the parent. Put it on that parent node.You can create special named groups too (eg, group/my-name). If you have nested groups, you might need th...

People still make MP3 CDs, don't they?Gather up some mp3s, put them in a directory, let's say here (.).Then generate an ISO image (with genisoimage) with those files and pipe it into a process to burn the CD (with cdrecord).genisoimage -J -r -pad -graft-points . | \ wodim dev=/dev/sr0 speed=8 -For g...

Here's how to implement Ash policies for authentication and authorization in GraphQL.Ash.Policies provide a way to declare auth around entities defined in the Ash framework. ash_graphql exposes entities via a GraphQl endpoint.Authentication is proving that someone is who they say they are. Authoriza...

Here's how to count the number of lines in current files by author.This doesn't give you total lines added or deleted by author. It doesn't deal with files that used to be there. It only accounts for the latest author on the git blame. And it only accounts for current files.It will give you a snapsh...

Here's how to save variables in sql for use later in the query.A with statement will provide the key feature. Make a selection (rows) and projection (columns), and you can bind that 2D result to a name.Only a single with statement is allowed in an sql script. You can create multiple variables by sep...

You get what you get, and you don't throw a fit.I've seen headlines recently like, "OSS is Dead." This has got me thinking about gratitude and the good it would do us if we were more grateful for the code we're given.Have you ever served a kid food, and while they were eating it, mouth full, they as...

Here's how to export multiple stylesheets to postcss-import.postcss-import is a postcss plugin that allows you to import other CSS files into your CSS stylesheet.Node.js has named imports, and there's magic to them. There's magic here too, but it's next-level, because Node packages were designed to ...

Here's how to publish an NPM package to JFrog Artifactory.Create a JFrog Artifactory TokenYou use JFrog Artifactory when you want to publish a package to a private registry. The normal, public one at npmjs.com is too public. You want privacy and/or control. Get Artifactory deployed, set up the repos...

Here's a way to transfer music to a classic iPod on Linux.You know the story: your son wants new music on that classic iPod Nano that we haven't touched in months. You forgot how we did it last time. There's a new computer in play. It didn't work. Linux -- that'll do anything, if you only you can fi...

Here are some alternative options to using the spread operator in an array reduce.ScenarioLet's say that I have an array of objects:const arr = [ { key: 'c', value: 33 }, { key: 'b', value: 2 }, { key: 'a', value: 44 }, { key: 'a', value: 1 }, { key: 'c', value: 3 }, ]And you want to transform it in...

Here's how to capture right click in React.Event HandlerTo capture a click, you use an onClick. That's for a left click.If you're living on the edge and want to capture a right click, use onContextMenu. It does the same thing, but for the right mouse button.function MyComponent() { function handleRi...

Here's how to sort an array of objects by two fields in JavaScript. This is sometimes called a secondary sort.If you sort by multiple fields, it means that the first field is the primary thing to sort by, and the next is secondary, and so on.The only reason you'd get to a secondary sort is if the pr...

You have a change to make in a distributed system. How many pull requests will it take to make a change?An Easily-distributed AppA distributed system has two or more independent deployables. In this most common of scenarios, we have a frontend (FE) client and a backend (BE) server. It's just so easy...