Drawing with a compass on a globe
Take a compass and draw a circle on a globe. Then take the same compass, opened to the same width, and draw a circle on a flat piece of paper. Which circle has more area? If the circle is small compared to the radius of the globe, then the two
Read moreMobile Observability: monitoring performance through cracked screens, old batteries, and crappy Wi-Fi
Today we chat with Austin Emmons, an iOS developer at Embrace, where he spent time rebuilding their SDK to work with OpenTelemetry. He discusses the challenge of tracking performance and watching for edge cases when your app is deployed across dozens of devices with enormous variability in their hardware, software,
Read more28 SQL interview questions and answers from beginner to senior level
Whether you’re just starting your career as a developer, data scientist, or business analyst—or you have a few years of experience under your belt—using structured query language (SQL) is a core skill for a wide range of roles that involve database management, data analysis, and back-end development. And, it pays
Read moreThe negative binomial distribution and Pascal’s triangle
The Poisson probability distribution gives a simple, elegant model for count data. You can even derive from certain assumptions that data must have a Poisson distribution. Unfortunately reality doesn’t often go along with those assumptions. A Poisson random variable with mean λ also has variance λ. But it’s often the
Read moreA strange take on the harmonic series
It is well known that the harmonic series 1 + ½ + ⅓ + ¼ + … diverges. But if you take the denominators as numbers in base 11 or higher, the series converges [1]. I wonder what inspired this observation. Maybe Brewster was bored, teaching yet another cohort of
Read moreComparing Docker and Podman: A Guide to Container Management Tools
Docker vs. Podman: Understand key differences in container management, security enhancements, and Kubernetes integration to choose the best tool for your project. Continue reading Comparing Docker and Podman: A Guide to Container Management Tools on SitePoint.
Read moreHow to Deploy Flask Applications on Vultr
Flask on Vultr: Complete deployment guide covering Python setup, app security, Nginx reverse proxy, and SSL certificate integration. Continue reading How to Deploy Flask Applications on Vultr on SitePoint.
Read moreWhere does Postgres fit in a world of GenAI and vector databases?
Today we chat with Avthar Sewrathan, AI Lead at Timescale, about adapting developers’ favorite database management system, Postgres, to support a range of new technologies involved in the GenAI ecosystem, especially vector databases. Avthar details his long history with Postgres and how clients are weighing the build vs. buy question
Read more