If you work in IoT, environmental sensing, or data systems, forest soil monitoring is one of the most technically interesting problems you'll encounter. The system you're trying to measure is extraordinarily complex, the variables are deeply interdependent, and the consequences of getting it wrong — or not monitoring at all — are significant. The Problem Space: What You're Actually Measuring Soil
SQL is widely known for data querying and manipulation but systems do grow; data becomes larger; processes become repetitive and operations become sensitive. SQL has some features which enables it to be considered a fully fledged programming language. Some of the features which I discuss in this article are procedures, functions and transactions. Each of these concepts serve distinct purposes. Sto
Hi 👋, In this post we shall explore Bedrock's structured KB with this architecture: Upload CSVs to S3 > SNS Queue > Crawl data with Glue > Query with Redshift > Bedrock KB > Query with LLM. Let's do some of this with code. Let's get started. Clone the repo and switch to the project directory. git clone [email protected]:networkandcode/networkandcode.github.io.git cd structured-kb-demo/ Do a uv sync
There's about $400 of meat, milk, and miscellaneous condiments in my kitchen fridge at any given time. It runs 24/7, makes a quiet humming noise, and gives no indication when something's wrong until you open the door three days later and recoil. The freezer compartment is worse: a slow failure can defrost everything before you notice the puddle. I already had a TP-Link P110 smart plug on the fridg
Subqueries vs. CTEs in SQL: A Practical Guide to Writing Cleaner, Smarter Queries Whether you're just getting comfortable with SQL or leveling up your data skills, two tools will come up again and again when working with complex queries: subqueries and Common Table Expressions (CTEs). They solve similar problems — breaking a complex query into manageable pieces — but they do it in different ways
One of the recurring challenges while building IoT systems is testing device communication, telemetry handling, MQTT flows, and event-driven architectures without constantly relying on physical hardware. To solve this problem, I recently started building a lightweight IoT Simulator CLI focused on helping developers simulate virtual devices directly from the terminal. The project is designed for de
Every device you own has a speaker and a microphone. I decided to use them for something useful. Natural disasters knock out cell towers. WiFi dies at conferences. Underground sensors need to offload data where nothing reaches. Bluetooth pairing is painful and range-limited. LoRa is great but requires hardware you don't have. Sound doesn't care about any of that. Every phone, every laptop, every e
In a previous post, I explored Codd's connection trap in PostgreSQL and MongoDB — the classic pitfall where joining two independent many-to-many relationships through a shared attribute produces spurious combinations that look like facts but aren't. The example followed Codd's 1970 suppliers–parts–projects model: we know which suppliers supply which parts, and which projects use which parts, but j