Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
fizx
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
15 ms
·
151.
▲
by
fizx
5y ago
sqlite is itself a full text search engine. It's gotten pretty good over the years. https://www.sqlite.org/fts5.html
152.
▲
by
fizx
5y ago
Lucene has the concept of "minimum match," [1] which is what you're playing with. You can implement your algorithm on top of this relatively trivially, by re-querying with min_match=n, min_match=n-1, etc until you get result
153.
▲
by
fizx
5y ago
You're thinking of cryptographic hashes. There are many kinds of hash (geographic, perceptual, semantic, etc), many of which are designed to only be slightly different.
154.
▲
by
fizx
5y ago
We also logged everything, and then re-planted with the most profitable trees assuming we'd log it all again. Who knew that densely planted tall pine trees burn so much?
155.
▲
by
fizx
5y ago
Hi, Person currently in middle management here. While we'd love to pay our good people more, at a moderately sized company and up, we operate under an unbelievable number of constraints, from HR, finance, etc.
156.
▲
by
fizx
5y ago
Hi, I started an Elasticsearch hosting company, since sold, and have built products on PG's search and SQLite FTS search. There are in my mind two reasons to not use PG's search. 1. Elasticsearch allows you to build sophisticated
157.
▲
by
fizx
5y ago
It's easy to put a block cache in front of the index, and I'm sure they'll get to it sooner or later. The benefit of using S3 in that case is that unlike e.g. Elastic, your block cache servers don't need replication, and
158.
▲
by
fizx
5y ago
Workday is also a CRUD app-builder, but for HR professionals. What other typical company functions have this sort of provider? Conversely, what other company functions need this sort of provider?
159.
▲
by
fizx
5y ago
GQL isn't really much like a graphdb (e.g. SPARQL). The goal of GQL is to gather a useful subset of your microservice data into a single tree for your frontend to render. In a facebook context, a typical query is "give me all the
160.
▲
by
fizx
6y ago
As a side effect, I imagine that this will lead to a very high hiring bar. Without the ability & incentive to hire someone "junior," every interviewer will compare the new hire to their inflated view of themselves.
161.
▲
by
fizx
6y ago
I mean, at this scale, why aren't you at least running in Heroku so you can have some niceties and not have to scramble when your VPS craps the bed?
162.
▲
by
fizx
6y ago
> One final tip for asynchronous code reviews: Roundtrips (from teammate to reviewer back to teammate) are expensive, costing up to two working days of a sprint each time. Um, we're doing it wrong.
163.
▲
by
fizx
6y ago
Go makes pretty bad WebAssembly. It only embeds in Javascript, and it's at least 2MB for Hello World. You can't really use it in server-side engines like wasmer/wasmtime. TinyGo is far better, but only supports a subset of
164.
▲
by
fizx
6y ago
Yup, also, as someone who's done sustained 60+ (maybe even a month of 80+), there's very little room for creativity. It works ok for pursuing the solution to that one clear, looming problem. I much prefer 5hrs/day of focus,
165.
▲
by
fizx
6y ago
Bikes expensive enough to have a tracking device will largely be carbon fiber.
166.
▲
by
fizx
6y ago
Oh yeah, I forgot about them. Thanks for the pointer! Still looking for something OSS though :/
167.
▲
by
fizx
6y ago
It's ~200LOC to implement a Lucene block cache over S3, and because Lucene uses log-structured storage, that block cache will be quite effective.
168.
▲
by
fizx
6y ago
I can't wait until someone "Snowflake"s Elasticsearch and separates compute from storage. There's not a great reason for there to be "shards" and "clusters". In 2021, I'd appreciate search runni
169.
▲
by
fizx
6y ago
The typical tech lawyer has seen this exact scenario ~20 times. You probably have some leverage, and spending $1-2k to figure out how much and how best to apply it, given the lawyer's experience, makes tons of sense.
170.
▲
by
fizx
6y ago
Any problems you see are likely on the video players side, not the CDN/hosting side. If you like working on this stuff, there's a job open! https://boards.greenhouse.io/reddit/jobs/2168814
171.
▲
by
fizx
6y ago
I assume you mean expensive mistakes! Making cheap mistakes is a great way to learn!
172.
▲
by
fizx
6y ago
Which platform?
173.
▲
by
fizx
6y ago
Which platform?
174.
▲
by
fizx
6y ago
You can take it all the way into the db with OSS if you like https://github.com/FoundationDB/fdb-record-layer/blob/master...
175.
▲
by
fizx
6y ago
You can whitelist queries!
176.
▲
by
fizx
6y ago
I split time between a successful side project and early Twitter, both at around 30 hours a week, with spikes up to 50hrs. While they both netted positive outcomes for me, if I had gone all-in on either one, I think I would have had an orde
177.
▲
by
fizx
6y ago
I think we now understand much of the legend of the original damascus steel to have come from trace amounts of vanadium in the ore.
178.
▲
by
fizx
6y ago
Introducing Gizzard, a framework for creating distributed datastores https://blog.twitter.com/engineering/en_us/a/2010/introducin...
179.
▲
by
fizx
6y ago
Four years in the AI space is like two lifetimes.
180.
▲
by
fizx
6y ago
Decoherence describes the spectrum of behavior between quantum and classical. As you mention, the probability density converges to multiple outcomes, but then I believe that you're in more of an Everett Many Worlds between the outcomes
More ›