Show HN: Ultra-realistic AI images at $9 for 500 images https://ift.tt/hog0Nad

Show HN: Ultra-realistic AI images at $9 for 500 images https://ift.tt/LRJvfxo September 28, 2024 at 03:33AM

Honoring Mr. Boston

Honoring Mr. Boston
By Madhu Unnikrishnan

Mike Delia, former Operator of the Year, operating a historic streetcar. During this year’s Muni Heritage Weekend, we commemorated the life and legacy of one of the greatest ambassadors for Muni, vintage vehicles and San Francisco itself: Mike Delia. A favorite among Muni riders, Mike, a.k.a “Mr. Boston,” was a cherished colleague who reached his final destination on Aug. 31, 2023 after a struggle with cancer. On Saturday, Mike’s family and colleagues gathered to dedicate PCC Car 1059 in his honor. Friends, family and colleagues of Mike Delia met in front of the SF Railway Museum to dedicate...

Published September 27, 2024 at 05:30AM
https://ift.tt/3AKz0oS

Show HN NGINIX Manager https://ift.tt/f9F6DEM

Show HN NGINIX Manager A simple NGINX manager https://ift.tt/UQyicDS September 27, 2024 at 01:39AM

Show HN: Structured, GitHub App for Automated DBT PR Reviews https://ift.tt/zwmrkTU

Show HN: Structured, GitHub App for Automated DBT PR Reviews Scaling data teams today means dealing with the complexity of the modern data stack. While DBT has become a core tool for transforming raw data into structured, analytics-ready tables, most teams are using it in ways that lead to chaos: duplicated models, inconsistent metrics, and inefficient SQL that directly impacts cloud spend. The real issue isn’t with DBT itself—it’s in how it’s applied across teams. Here’s the typical setup: Finance defines a revenue model, Marketing calculates customer lifetime value, and Product defines churn. All in DBT, but all with slightly different logic, leading to metric fragmentation. This results in data drift, conflicting reports, and a ton of unnecessary engineering time spent reconciling definitions. Worse, engineers end up re-inventing the wheel by duplicating logic that already exists in other models. The inefficiencies don’t stop there: suboptimal SQL patterns (e.g., full-table scans, poor joins) creep into production and drive up cloud costs. We designed our GitHub App to automate the grunt work of DBT model management, focusing on three key areas: preventing redundant logic, maintaining the semantic layer, and optimizing SQL performance. --- (1) Stop Redundant Models: A lot of teams waste time rebuilding models that already exist. Engineers aren’t aware of what’s been built, so they duplicate work. Our app automatically reviews pull requests, flags redundant models, and suggests reusing existing logic. This keeps your key metrics like revenue or churn consistent across teams and prevents conflicting reports. (2) Maintain the Semantic Layer: DBT’s value is in creating a semantic layer—a consistent definition of business metrics. But as teams scale, maintaining this layer gets tricky. People unknowingly break it with small changes, leading to inconsistencies. Our app checks every new model for deviations from the semantic layer, flagging inconsistencies before they go live. This prevents those all-too-common situations where two departments are debating whose revenue number is right. By ensuring everyone’s using the same definitions, you avoid trust issues with the data. (3) SQL Performance = Real Costs: Bad SQL isn’t just a performance problem—it’s a cost problem. Inefficient joins, full-table scans, and poorly written SQL in your DBT models can blow up your cloud bill. Our app reviews SQL in pull requests, flags inefficiencies, and suggests optimizations. Example: An engineer submits a model that joins two large tables without filtering. Our app flags the full-table scan and suggests using indexed columns and adding WHERE filters. This reduces query cost and improves performance before the code hits production. --- Data engineers are already stretched thin with the demands of modern data pipelines. By automating model consistency checks, semantic layer enforcement, and SQL performance reviews, our GitHub App frees up your team to focus on higher-impact work rather than wasting cycles on repetitive tasks or fighting fires caused by bad data logic. The app is live—give it a try, and let us know how it’s improving your workflow. Also, keep an eye out for our upcoming DBT code generation features—we’re automating more of the heavy lifting soon. https://ift.tt/gJiR0VW September 27, 2024 at 02:58AM

Show HN: Is Fair Source Cool Yet? https://ift.tt/fXLv2bK

Show HN: Is Fair Source Cool Yet? https://fss.cool September 27, 2024 at 03:04AM

Show HN: 1Minute Break – VS Code extension for developer well-being https://ift.tt/4zfNYiT

Show HN: 1Minute Break – VS Code extension for developer well-being As a developer, I often found myself working for hours without breaks, leading to eye strain and back pain. I created 1Minute Break to solve this problem for myself and others. that reminds developers to take short, regular breaks. Features include: - Customizable break intervals - Interactive break reminders with suggested activities - Water intake tracking - Ergonomic exercise prompts It's designed to improve productivity and health without disrupting workflow. Feedback welcome! https://ift.tt/4Ec10FN... https://ift.tt/nuGicJD September 26, 2024 at 11:29PM

Show HN: FastIndex, an open-source search engine indexation tool https://ift.tt/gHDSnN0

Show HN: FastIndex, an open-source search engine indexation tool There's a lot of paid search engine indexation tools out there and I wanted to create my own. Been working as an engineer for over a decade now and my open-source contribution has always been something I wanted to do. Thus I decided to create FastIndex, an open-source search engine indexation alternative to paid solutions such as TagParrot, URLMonitor, Omega Indexer and many more. Source: https://ift.tt/PVsA18i Wiki: https://ift.tt/F63nGfg https://ift.tt/PVsA18i September 26, 2024 at 06:46AM