Urgent.News

What's breaking now, across thousands of outlets.

Tech

SQL beginners: what should happen after your first query?

Running a ready-made SQL query is easy. Changing it yourself is where a lesson has to earn its keep. I'm building SQLBrief, and this is the bit I want feedback on. The first task gives you a query to run. The next asks you to make a small change, with instructions and hints instead of filling in the answer for you. If you're new to SQL, could you try those two tasks and tell me the first place…

We haven't written up this one. Dev.to has the full story — the link below goes straight to it.

Read the original at dev.to →

More in Tech

One Oxygen template, different page content

Two service pages can share an introduction strip and a contact section without sharing every sentence. In Oxygen 6, Template Content Area supplies the place where each page's own layout appears…

I Stopped Scheduling My n8n Workflows on the Hour — My 429s Disappeared

I Stopped Scheduling My n8n Workflows on the Hour — My 429s Disappeared Part of my build-in-public series on running LLM workflows in n8n in production.

  • Reporter's workflows failed due to scheduling issues
  • 429 Too Many Requests error caused by parallel LLM calls
  • Staggering schedules and adding random delay resolved issue

Yaadein: Building a Memory Companion for Families, in 24 Hours

This is a submission for the MLH x DEV Writing Challenge What I Built Imagine waking up one morning and your grandmother doesn't recognize you — not your face, not your name, not even the fact that…

  • Yaadein is a memory companion web app developed in 24 hours.
  • Created for families and elderly with early memory loss.
  • Features include Family Photo Quiz, Memory Match game, and Family Dashboard.

I Gave an EC2 Instance Zero Internet and It Still Uploaded to S3

The challenge The client's requirement fit in one sentence: The private backend must talk to Amazon S3 without ever touching the public internet.

  • Private EC2 instance communicated with S3 without internet access
  • VPC Peering, route tables, security groups, IAM role, Gateway Endpoint used
  • Authentication via IAM roles, all traffic within AWS network

Why page 2 repeats the same posts in an Oxygen loop

A pagination link can change the URL while leaving the cards exactly as they were. That happened in a private Oxygen 6.2.0-beta.9 test: a static Text query returned six posts on page 1, and clicking…

  • Same posts repeat on page 2 due to URL alteration without changing content.
  • Component pulls data from Custom query, displays six posts on page 1.
  • Identical Read guide URLs confirm query stuck on first six posts.

More from Saturday 17 October →