jmg_

> We built chproxy specifically because ClickHouse doesn't like thousands of tiny inserts. It's a Go service that buffers events and sends them in large batches. Each Cloudflare Worker would send individual analytics events to chproxy, which would then aggregate and send them to ClickHouse.

While I understand how this isn't the only thing that needed to be buffered, for Clickhouse data specifically I'd be curious why they built a separate service rather than use asynchronous inserts:

https://clickhouse.com/docs/optimize/asynchronous-inserts

I’m having the same realization regarding Turbo.

Always thought it was a creatively simple solution, but had no idea the pattern had existed (and was used) for so long.

I'm very happy with my Wahoo Kickr, although it is trainer (BYOBike) rather than exercise bike:

https://www.wahoofitness.com/devices/indoor-cycling/bike-tra...

The trainer connects to their app (and a variety of other apps) over bluetooth.

Care to comment on how CDC resources for primary care providers have been removed related to contraceptive eligibility?

https://www.cdc.gov/contraception/hcp/provider-tools/index.h...

https://web.archive.org/web/20241219075518/https://www.cdc.g...

https://play.google.com/store/apps/details?id=gov.cdc.ondieh...

https://web.archive.org/web/20241231085620/https://play.goog...

For a lot of the ways I see friends and family use Mac products, 256gb is often good enough.

I'd argue for people that care about storage space the default acts as a price anchor.

Funnily, I’m actively working on rewriting a stored procedure which parses an XML snippet as one of its arguments

Luckily it’s not a handwritten XML parser though: https://learn.microsoft.com/en-us/sql/t-sql/functions/openxm...

FWIW, I'm in a similar situation right now. I was able to massively decrease noise (and air flow) by switching to Noctua NF- A4x10 FLX fans. As long as my workloads aren't sustained temperatures are fine and noise has from gone ~70-80dB to ~40dB, with the power supply fans being the loudest part now.

Upgrade took me an hour and cost $80 via Amazon.

Note they're comparing to CPython v3.7 and while https://speed.python.org doesn't go back to 3.7, the improvements between 3.8 to 3.12 are pretty massive.

I don't doubt PyPy is faster than CPython, but it would be very interesting to see latest PyPy compared to latest CPython.

Mind linking the ERB recommendation? Can’t see the replies without an account.

While I'm not currently using rspec, rswag/rswag is library for rspec I envy:

https://github.com/rswag/rswag

I'm currently using thoughtbot/json_matchers w/ partials of my OpenAPI spec, but its not nearly as user friendly:

https://github.com/thoughtbot/json_matchers

I maintain a Brewfile (https://github.com/Homebrew/homebrew-bundle) which contains the majority of the non-project specific applications that I like to install on any new Mac:

https://github.com/jonahgeorge/dotfiles/tree/main

What's really nice is the `cask` & `mas` keywords allow you to install .dmg files & directly from the App Store.

---

While its not included in there yet, I've been experimenting with maintaining a private Homebrew tap which contains my ~/bin directory as opposed to shell aliases.

Does anyone know if the performance regressions between 5.7 and 8.0 have been fixed? I no longer use MySQL regularly so I haven't been following this.

If I recall correctly, this was one of the major reasons why people were deferring this upgrade.

---

> Most notably, we encountered a problem where queries with large WHERE IN clauses would crash MySQL. We had large WHERE IN queries containing over tens of thousands of values.

The need to rewrite queries is mildly concerning. If this was part of their Rails codebase, I'm curious if these patches will make it into the ORM.

Calling out limitations like this in the documentation would go a long way in building confidence in the project. Better yet, if there's an example of how to deal with "day-2" operational concerns like this.

Simply looking at the docs on these two pages, its unclear to me whether there's a way to update the mirror definition when a schema change occurs or if I need to drop & recreate the mirror (and what the effects of this are in the destination):

- https://docs.peerdb.io/sql/commands/create-mirror

- https://docs.peerdb.io/usecases/Streaming%20Query%20Replicat...

All-in-all, very excited to see this project and will be watching it closely!

Funnily, more than a few Electron apps use SumatraPDF under the hood:

https://github.com/artiebits/pdf-to-printer/blob/master/src/...

Unfortunately it seems post-Facebook acquisition they ended support for (at least some of) those platforms.

https://blog.whatsapp.com/whats-app-support-for-mobile-devic...

I've always been curious to see how project owners respond to someone re-implementing portions of paid features in an open source project.

Assuming the patch is valid, do they decline it citing the paid feature or do something like making a straw man argument against it?

1) Due to covid its highly likely that many of the companies in NY are listing as remote rather than NY-based.

2) Just an opinion, but I would guess the majority of companies on Dice would trend towards older tech stacks. My employer has 4 open Go positions but is not found on Dice.

- Angel.co shows 10 Go-related jobs in NYC

- Linkedin shows 293 Go-related jobs in NYC

If you’re interested in this, there’s a great short video about the USAF Heavy Press Program: https://m.youtube.com/watch?v=hpgK51w6uhk

Fwiw CMUSphinx supports wake words in the pocketsphinx project: https://cmusphinx.github.io/wiki/faq/#q-how-to-implement-hot...

While not quite finished, there's also Slate (https://github.com/slate/slate) by Holowaychuk

Thinking back to some of the exercises that I did:

+ Calculate the nth term of Fibonacci Sequence

+ Comparing the efficiency sorting algorithms

+ Calculating the resulting angles of the hands of a clock based on a digital-time input.

You could probably apply many of the easier Project Euler questions for your competition with little modification.

Alternately, if you want more computer-related problems some of the /r/dailyprogrammer exercises might be applicable (however most require a computer and programming knowledge)