Sosna

Timestamps, dependent filters, and misbehaving left joinsPhoto by Saffu on UnsplashSQL is a deceptively simple language. Across its many dialects, users can query databases in a syntax similar to English. What you see is what you get… until you don’t.Every now and then I come across a query that produces a result completely different from what I expected, teaching me little nuances about the language. I’ve compiled three recent head-scratchers in this post, and I’ve arranged them as riddles to make them more interesting.…

Understanding and deploying EC2 and Lambda servicesPhoto by Nick Owuor (astro.nic.visuals) on UnsplashSo you’ve built a cool app and want to show it off to the world. Maybe it’s an AI that generates cat pictures from scribbles, a viral LinkedIn post generator, or an English to RegEx translator. You want a user to just click a link and immediately start interacting with your app, rather than needing to download and run it on their computer.This “immediate interactivity” is going to require a server, which takes user…

Understanding and deploying S3, RDS, and DynamoDB servicesPhoto by Tech Daily on UnsplashDo you have a store your music, videos, and personal files in a garage full of hard drives? My bet is… no. Unless you’ve avoided iCloud, Dropbox, and Google Drive the last fifteen years − and if you have, props to you! − then you’re likely using storage. You can recover your texts if you lose your phone; you can share files with links instead of massive email attachments; you can organize and search your photos by who’s in them.But…