HN user

jmg_

56 karma

building lightlabs.com

Posts0

Comments21

No posts found.

Leaving serverless led to performance improvement and a simplified architecture 9 months ago

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

0Thread HN

Why does target="_blank" have an underscore in front? 1 year ago

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.

0Thread HN

Ask HN: What's a good stationary exercise bike with a Bluetooth protocol? 1 year ago

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.

0Thread HN

CDC: Unpublished manuscripts mentioning certain topics must be pulled or revised 1 year ago

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...

0Thread HN

Apple and the AI Divide 2 years ago

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.

0Thread HN

Advent of Code 2024 in pure SQL 2 years ago

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...

0Thread HN

Ask HN: What are your most regretted tech purchases? 2 years ago

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.

0Thread HN

PyPy v7.3.16 2 years ago

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.

0Thread HN

A decent VS Code and Ruby on Rails setup 2 years ago

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

0Thread HN

A Deep Dive into RSpec Tests in Ruby on Rails 2 years ago

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

0Thread HN

Ask HN: How do you setup a new Mac? 2 years ago

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.

0Thread HN

Upgrading GitHub.com to MySQL 8.0 3 years ago

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.

0Thread HN

Launch HN: PeerDB (YC S23) – Fast, Native ETL/ELT for Postgres 3 years ago

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!

0Thread HN

Lessons learned from 15 years of SumatraPDF, an open source Windows app (2021) 3 years ago

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

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

0Thread HN

Why Apple’s iMessage is winning: teens dread the green text bubble 5 years ago

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...

0Thread HN

Using Nginx as an Object Storage Gateway 5 years ago

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?

0Thread HN

Eleven Years of Go 6 years ago

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

0Thread HN

Alcoa 50k ton forging press 6 years ago

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

0Thread HN

Ask HN: Are there any open source alternatives to Alexa, Siri, etc? 9 years ago

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

0Thread HN

Show HN: A browser-based IRC client built on Node.js – first Node project 12 years ago

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

0Thread HN

Ask HN: Good 15-20 min. CS challenge for high school students? 12 years ago

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)

0Thread HN