Most ints are not floats

All integers are real numbers, but most computer representations of integers do not equal computer representations of real numbers. To make the statement above precise, we have to be more specific about what we mean by computer integers and floating point numbers. I’ll use int32 and int64 to refer to

You’ve got 99 problems but data shouldn’t be one

Ryan is joined by Tobiko Data co-founders Toby Mao and Iaroslav Zeigerman to talk about the crucial role of rigorous data practices and tooling, the innovations of Tobiko Data’s SQLMesh and SQLGlot, and their insights into the future of data engineering with the rise of AI.

Determine whether a large integer is a square

Years ago I wrote about a fast way to test whether an integer n is a square. The algorithm rules out a few numbers that cannot be squares based on their last (hexidecimal) digit. If the the integer passes through this initial screening, the algorithm takes the square root of n as

Droip Review: Why You Should Choose Droip Over Traditional WordPress Page Builders in 2025

Traditional WordPress builders are outdated. See how Droip's modern visual builder delivers true design freedom, clean code, and powerful features without the bloat. Continue reading Droip Review: Why You Should Choose Droip Over Traditional WordPress Page Builders in 2025 on SitePoint.

5 Best Payment Gateways for SaaS: Your Ultimate Guide

Your ultimate guide to the 5 best payment gateways for SaaS. Choose the best SaaS payment gateway to optimize your SaaS payment process today! Continue reading 5 Best Payment Gateways for SaaS: Your Ultimate Guide on SitePoint.

Legendre and Ethereum

What does an eighteenth century French mathematician have to do with the Ethereum cryptocurrency? A pseudorandom number generator based on Legendre symbols, known as Legendre PRF, has been proposed as part of a zero knowledge proof mechanism to demonstrate proof of custody in Ethereum 2.0. I’ll explain what each of

Unleashing the Power of ArgoCD by Streamlining Kubernetes Deployments

Learn what ArgoCD is and why it's a leading GitOps tool for Kubernetes. This guide covers core concepts, architecture, and how to automate your continuous delivery pipeline. Continue reading Unleashing the Power of ArgoCD by Streamlining Kubernetes Deployments on SitePoint.

Not an option, but a necessity: How organizations are adopting and implementing AI internally

AI is no longer just a luxury for the most tech savvy companies — it's now a necessity for organizational transformation. How are real teams successfully leveraging and innovating with these new tools?

Patching functions together

The previous post looked at a function formed by patching together the function f(x) = log(1 + x) for positive x and f(x) = x for negative x. The functions have a mediocre fit, which may be adequate for some applications, such as plotting data points, but not for others, such as visual design.

In Landmark Ruling, Court Declares Training AI Is Fair Use But Draws a Hard Line on Piracy