Urgent.News

What's breaking now, across hundreds of outlets.

Continued

Tech

Your competitor's price is not a float

You add competitor pricing to a dashboard and start with the obvious model: SKU, competitor, price. It works for retailer pages.

  • Prices are observations, not static properties.
  • Store prices in priceobservations table with SKU, competitor SKU, channel, timestamp, fees.
  • Consider full fee stack for accurate competitive gap analysis.

Tech

DuckDB 2.0 alpha's triggers cost three times more per row than per statement

DuckDB's preview post for version 2.0 promised triggers with "BEFORE and AFTER triggers, FOR EACH ROW and FOR EACH STATEMENT".

  • DuckDB 2.0 alpha introduces triggers with BEFORE, AFTER, and FOR EACH ROW options
  • FOR EACH ROW triggers consume more resources than FOR EACH STATEMENT triggers
  • Statement-level triggers work for all three events without issues

Tech

Bloody agents

Deploying agents turns out to be the easy part. Proving what they are worth is where projects are coming undone.

Continue reading →