Tooling Icon

Tooling

Tooling and apps used to create and deliver awesome software.
319 Stories
All Topics

Go Time Go Time #285

The tools we love

The Go ecosystem has a hoard of tools and editors for Gophers to choose from and it can be difficult to find ones that are a good fit for each individual. In this episode, we discuss what tools and editors we’re using, the ones we wish existed, how we go about finding new ones, and why we sometimes choose to write our own tools.

Practical AI Practical AI #225

Controlled and compliant AI applications

You can’t build robust systems with inconsistent, unstructured text output from LLMs. Moreover, LLM integrations scare corporate lawyers, finance departments, and security professionals due to hallucinations, cost, lack of compliance (e.g., HIPAA), leaked IP/PII, and “injection” vulnerabilities.

In this episode, Chris interviews Daniel about his new company called Prediction Guard, which addresses these issues. They discuss some practical methodologies for getting consistent, structured output from compliant AI systems. These systems, driven by open access models and various kinds of LLM wrappers, can help you delight customers AND navigate the increasing restrictions on “GPT” models.

Martin Heinz martinheinz.dev

Make your CLI demos a breeze with zero stress and zero mistakes

Running live demos can be stressful. You know what you want to say and show. You prepare the CLI commands you want to run to best showcase what you’ve built, but then you waste time typing long commands; you make typos; the commands fail or take way too long to complete. Maybe they depend on external system (network, APIs, cloud, …) and of course it’s not cooperating while you’re running your live demo.

Here’s how you can avoid all of the above by scripting, automating and recording your demos, so that you never have to stress about showcasing ever again…

Django suor.github.io

Ban 1+N in Django

Alex Schepanovski:

I always thought of 1+N as a thing that you just keep in your head, catch on code reviews or via performance regressions. This worked well for a long time, however, the less control we have over our SQL queries the more likely it will sneak through those guards…

I tumbled on a couple of 1+Ns while reading a project code for an unrelated reason and it got me thinking – do I ever want Django to do that lazy loading stuff? And the answer was never.

Turns out the implementation of this is quite easy. ~15 loc for the naive version and ~35 for a more robust version. Give it a try if you, like Alex, never want to allow a 1+N in your Django app again.

Go github.com

pgrok is a poor man's ngrok

A multi-tenant HTTP reverse tunnel solution through remote port forwarding from the SSH protocol.

This is intended for small teams that need to expose the local development environment to the public internet, and you need to bring your own domain name and SSO provider.

It gives stable subdomain for every user, and gated by your SSO through OIDC protocol.

Think this as a bare-bone alternative to the ngrok’s $65/user/month enterprise tier. Try to put this behind a production system will blow up your SLA.

For individuals and production systems, just buy ngrok, it is still my favorite.

PostgreSQL mathesar.org

Mathesar slaps a web-based spreadsheet UI on your Postgres database

You know how collaborating with Google Sheets, Airtable & friends is super easy because anybody with a web browser and the correct permissions can get in on it? With Mathesar, you can enable that kind of access to any Postgres database!

Super powerful? I think so. Super risky?! Likely, especially if a lot of your data-related logic is in app code. Worth it? That’s up to you to decide…

Mathesar slaps a web-based spreadsheet UI on your Postgres database

JavaScript deno.com

You don't need a build step

Andy Jiang and Deno’s content team are really speaking my language lately:

Sites take time to build these days. A large Next.js 11 site will take several minutes to build. This is wasted time in the development cycle. Build tools like Vite or Turbopack highlight their ability to get this number down.

But the deeper question hasn’t been considered:

Why do we even need a build step?

Evil Martians Icon Evil Martians

OK, OKLCH: a color picker made to help think perceptively

The UI of the open source OKLCH Color Picker & Converter was created with community education in mind as the driving design principle. Beyond being a handy tool, there was a secondary goal: speeding up familiarity and adoption of OKLCH and perceptual color spaces.

To that end, this article explains how the underlying reality of the color space itself guided the UI design.

OK, OKLCH: a color picker made to help think perceptively

Tooling molodtsov.me

How to start your blog in 2023

Yury Molodtsov:

Running your own blog in 2023 is still needlessly complicated, especially if you have any kind of taste. Why have one in the first place?

Social apps and networks are obviously the easiest options, but they’re geared toward vastly different things, and I just don’t trust their longevity. Having your own platform enables flexibility and portability, so your content can be kept online practically forever.

This!

There are many options out there, ranging from WordPress and Ghost to static blogs to managed online platforms and Micro.blog. How do you choose between them?

What follows is a survey of some of the popular tools and what Yury thinks about them. My advice is this: don’t worry too much about tooling. That’s the easy part. Writing’s the hard part. We often bike shed the easy parts to avoid the hard part. Yuri seems to agree:

Having the right tool certainly helps, but at the end of the day, what matters is what you write there. Focus more on the content and just ensure the process of writing and posting is simple enough.

Jeffrey Aven stackql.io

Query, provision, secure & operate cloud resources using SQL

StackQL allows you to create, modify and query the state of services and resources across all three major public cloud providers (Google, AWS and Azure) using a common, widely known DSL…SQL.

I have to admit, it does look pretty darn simple:

SELECT * FROM google.compute.instances 
WHERE zone = 'australia-southeast1-b' 
AND project = 'my-project';

Tooling jeremiak.com

Datasette is my data hammer

Jeremia Kimelman:

Datasette is an open source tool that takes an SQLite database and gives you an out-of-the-box, web-based UI built specifically for exploring data. Need an example? Here’s a database of all of Motley Fool’s earning transcripts that I used to look for talk of their California campaign activity. And here’s a bunch of other examples of Datasette from the official site.

And the thing is: I love Datasette. It recently turned 5 years old and I wanted to write down the thing that makes it an absolutely delightful data hammer.

Rust github.com

z-tokens – random tokens generation and related tools

I have (re)written my password generator in Rust with support for many different patterns. From completely random ASCII, to memorable diceware-like passphrases, and anything in between, plus extras such as private IP addresses or MACs.

I’ve also classified these patterns for easy accessing, and based on the pattern entropy I provide guesstimates about the effort for a brute force attack.

Player art
  0:00 / 0:00