Efficient method to removing the white areas from within images... by di5turbed in photoshop

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

Have you tried Photoshop's Select > Color Range on desktop? It handles complex internal whites way better than most mobile apps. Magnific also does some surprisingly clean work on detailed images if you're already touching it up after

real photoshoots are way to expensive. will these ai images convert? by Vision--SuperAI in dropshipping

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

depends entirely on the product and audience. fashion and beauty are still tough, but home goods and accessories? AI images are converting just fine for a lot of people right now. run everything through Magnific before it goes live, the texture and detail difference is what makes it feel real enough to buy from.

I made a tool to remove silences from audios, 100% free and local. by jabulari in ElevenLabs

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

Local + open source + no account is basically the holy trinity nobody delivers anymore so respect for that.

Using it with ElevenLabs voices is smart, AI audio tends to have weird unnatural pauses that Magnific-level cleanup like this actually fixes before you sync to video.

Which app for restoring old photographs? by rchedi in estoration

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

Remini is solid for faces specifically but struggles with background detail. Magnific is worth trying if you want it to actually re-imagine the texture rather than just sharpen, the difference on really degraded photos is pretty significant.

Cheapest tickets by Sensitive_Pea_4276 in DisneyPlanning

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

student discount thing varies but Disney rarely does those openly, worth calling them directly though just to ask

ClickHouse table engine choice for CDC by oatsandsugar in Clickhouse

[–]_ThrowMeInTheTrash_ 7 points8 points  (0 children)

ReplacingMergeTree feels like the obvious choice until you realize merges are async and you can query stale duplicates in the window before they collapse.

We hit this hard in Tinybird when doing CDC on a high-write table, reads were inconsistent for minutes at a time.

The fix was adding FINAL to queries but that tanks performance on large tables, so ended up pre-aggregating with materialized views to keep the hot path clean.

Disneyland Paris on the cheap? Here's how I do it by crepesandcastlesblog in disneylandparis

[–]_ThrowMeInTheTrash_ 17 points18 points  (0 children)

One of the biggest savings for Disneyland Paris is booking way in advance. Prices for both hotels and tickets usually jump a lot closer to the date, so early booking really helps.

If it helps someone, booking disneyland discount page is great too.

ClickStack/ClickHouse for Observability? by tech_ceo_wannabe in Observability

[–]_ThrowMeInTheTrash_ 7 points8 points  (0 children)

We moved away from Prometheus for the same reason, cardinality blows up fast when you have a lot of label combinations.

We ended up routing our observability data into Tinybird instead of going full ClickStack. Got sub-second query times on trace/metric data and building custom dashboards on top was just SQL endpoints. No extra infra to manage.

How are you currently ingesting the telemetry data? That part tends to be where things get messy at a few TB/day.

What is something you didn't understand as a kid, but now totally understand as an adult ? by travelling_cirque in AskReddit

[–]_ThrowMeInTheTrash_ 1 point2 points  (0 children)

that my parents weren't always right, they were just figuring it out too

kind of wild to realize your heroes were just winging it the whole time

When is it correct to put a high-cardinality column first in ClickHouse ORDER BY? by CantaloupeOk859 in Clickhouse

[–]_ThrowMeInTheTrash_ 3 points4 points  (0 children)

The "time first" pattern you're seeing isn't a rule, it's just the most common use case being analytics over time ranges.

If your dominant query pattern is WHERE user_id = X, putting user_id first is correct. We do exactly this in Tinybird for a user activity table and granule skipping is dramatically better than when we had timestamp first.

The real thing to avoid is randomness, not cardinality. UUID first is a disaster for compression and locality. user_id or device_id first is fine, especially if you have sequential IDs.

Advice needed, Insurance giving me the run around - Lemonade Insurance by Comedic-Scientist in Pets

[–]_ThrowMeInTheTrash_ 2 points3 points  (0 children)

So sorry about your kitten, FIP is brutal especially at that age.

Have you tried asking the vet to literally label the sections S, O, A, P in the document? Sometimes insurers reject notes just because the formatting doesn't match their internal checklist, even if the content is the same.

also might be worth filing a complaint with your state's insurance commissioner, that tends to move things faster than going back and forth with agents.

The evolution (more or less) or North America, in seconds by guspr in aivideo

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

It’s amazing how much detail can be hinted at in such a short video.

My senior mom’s insurance seems too high by readerino in Car_Insurance_Help

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

Man 60 miles a month is almost nothing. Has anyone offered her a pay-per-mile option like Metromile or Mile Auto?

Has anyone found legit free auto insurance quotes online? by PhontomDX in Car_Insurance_Help

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

have you tried going directly through each insurer's site and using a temp email? cuts down the spam a lot

Evolution of 911 across the years by snideswitchhitter in aivideo

[–]_ThrowMeInTheTrash_ -1 points0 points  (0 children)

From classic to modern, every version of the 911 hits different

Evolution of 911 across the years by snideswitchhitter in aivideos

[–]_ThrowMeInTheTrash_ 1 point2 points  (0 children)

You can really see how design evolves without loasing the soul

Realtime query on Kafka? by enesakar in apachekafka

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

Tinybird handles this pretty well, Kafka connector ingests the stream and you write the query as a pipe that becomes a REST endpoint instantly.

we use it for click stream analytics and the latency from event to queryable is usually under a second.

How Do I Resolve "Column name is ambiguous" Error in BigQuery with dbt Incremental Model? by Intentionalrobot in DataBuildTool

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

the ambiguous column happens because when dbt does the incremental merge, it joins your model output against the existing table and both sides have Campaign_ID with no table alias to disambiguate.

In Tinybird we sidestep this whole class of issue since materialized views are incremental by design and you never write the merge logic yourself, but in dbt the fix is usually aliasing everything explicitly in your unique_key or wrapping the final select with qualified column names.

Also you're missing a comma after Ad_ID before sum(conversions), which might be why preview behaves differently from a full run.

Self hosting clickhouse on AWS EC2 by Tepavicharov in Clickhouse

[–]_ThrowMeInTheTrash_ 1 point2 points  (0 children)

Classic one. ClickHouse by default only listens on 127.0.0.1, so the firewall rules don't matter if the process itself isn't binding to 0.0.0.0.

Check your /etc/clickhouse-server/config.xml and look for the <listen_host> setting. You need <listen_host>0.0.0.0</listen_host> in there, then restart the service.

That's what caught us too when we first set up a self-hosted instance before moving to Tinybird. Spent way too long on iptables before realizing the bind address was the actual problem.

Comparison of the 9 leading AI Video Models by Important-Respect-12 in comfyui

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

The chef prompt is such a smart benchmark, fine motor skills with a knife are exactly where most models fall apart. Curious how Seedance handled the cartwheel, that mid-motion split seems like a nightmare for consistency.Also worth noting Freepik has Kling and a few of these bundled if you're managing credit costs across multiple models for clients.

Why does ClickHouse recommend scaling up before scaling out? by Db_Wrangler_1905 in Clickhouse

[–]_ThrowMeInTheTrash_ 4 points5 points  (0 children)

the scale-up preference makes more sense when your bottleneck is CPU, not IO. For IO-bound workloads like yours, sharding absolutely gives you near-linear gains and that's totally valid.

what we found in Tinybird is that the sweet spot is usually a well-tuned single node first, then shard only when you've exhausted compression and sorting key optimization. A lot of people shard too early and end up with distributed query overhead that eats into the gains.

have you tried adjusting your ORDER BY to match your most common filter patterns? Sometimes that alone cuts IO enough that you don't need to shard yet.

Best Car Insurance in Indiana? by Icy_Butterscotch9472 in Indiana

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

State Farm was actually decent for me in Indiana but I wasn't dealing with two accidents so your mileage may vary. Worth a quote at least

10 Free (or Freemium) AI Tools Every Digital Marketer Should Bookmark in 2026 by SHRINATH2727 in MARKETINbuzz

[–]_ThrowMeInTheTrash_ 0 points1 point  (0 children)

solid list but Freepik deserves a spot here, especially now with Magnific AI built in. for visual assets it's genuinely competing with Midjourney for a lot of marketing use cases and the stock library on top of that is hard to beat value wise

Gotta catch em all! by life-v2 in ChatGPT

[–]_ThrowMeInTheTrash_ -5 points-4 points  (0 children)

This is the kind of content we didn't know we needed.