Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
kuzee
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
5 ms
·
1.
▲
by
kuzee
4y ago
We secretly agree and aren't sure why it's faster to do two queries, but it measurably is. We're going to try some of the suggestions littered in this conversation and will report back, this time with some EXPLAIN output. We
2.
▲
by
kuzee
4y ago
We shared the mistake so others don't accidentally make the same assumption; I'm sure a few people either learned it for the first time or appreciated the reminder. Rest easy this never made it to prod.
3.
▲
by
kuzee
4y ago
I'll gladly read anything you've written on the topic, sounds like you're pretty knowledgeable.
4.
▲
by
kuzee
4y ago
I wrote up my recent experience optimizing Postgres text search on a database with a few million records without relying on a new service like Elastic Search.
5.
▲
Improving Postgres text search speed
(charityapi.org)
131 points
by
kuzee
4y ago
|
57 comments
6.
▲
by
kuzee
5y ago
This thread from the publisher addresses this: https://twitter.com/burk504/status/1501618260466233344
7.
▲
by
kuzee
5y ago
Taking the author's post at face value, I think the solution should be: Upwork action item: Robin needs to add a new payment instrument to cover the $12000 debt. Freeze Robin's account until then. Any fraud being perpetrated requi
8.
▲
by
kuzee
5y ago
This makes sense, and I think you've taken the correct route. I look forward to trying this in one of my projects and comparing to my current postgres-only backed search strategy. For my use case losing the index between restarts isn&#
9.
▲
by
kuzee
5y ago
I think it's a strong move to give away so many tools for free and consolidate their income to align so closely with the charity's goals, and while time will tell, I think charities will find this works well for them. I'm inv
10.
▲
by
kuzee
5y ago
Anecdotally yes it's a problem if two classes (button choices) are similar, resulting in two "top answers" for a given task. This seems most common for "yes/no" task types where there are only two options, and
11.
▲
by
kuzee
5y ago
Sounds sweet. I bet a lot of companies relying on mturk built this for themselves and then sell a higher value service with better margins. You could build something right in the middle. I know Stanford's research teams all use a commo
12.
▲
by
kuzee
5y ago
Same! I created Cogmint.com ("cognition minting") to solve this problem for myself. You can submit known correct answers for questions, and those questions are then used as ground truth to score worker accuracy. Workers are then s
13.
▲
by
kuzee
5y ago
Wow, I had no idea that this existed, thanks. I agree that a drone for cleaning gutters would be incredibly hard due to the torque necessary. Less of a project, but a drone that picks up the Roomba Looj and can place in the gutter would be
14.
▲
by
kuzee
5y ago
Some ideas: Drone that can clean your gutters while avoiding obstacles like trees and chimneys. This might be very hard, but would be a challenge. A series of smart heating/AC vents that open/close based on whether people are in t
15.
▲
by
kuzee
5y ago
I can also highly recommend SpringRTS. Balanced Annihilation is fantastic. I've played it casually for years .
16.
▲
by
kuzee
5y ago
This is a hysterical application of technology, thanks for sharing. A small part of me worries that some cubicle company will add it as a feature to individual cubicles in offices. We already have aggressive proximity sensors controlling li
17.
▲
by
kuzee
5y ago
Total Annihilation, a classic, has been remade under the TA Spring RTS engine project: https://springrts.com/ . It's pretty fantastic.
18.
▲
by
kuzee
5y ago
Several fintech companies use it to power core logic, with or without phoenix, so it's used for general purpose computing where speed, resiliency, and parallel execution are important. I've seen hints that people are using it to r
19.
▲
by
kuzee
5y ago
Wow this site is fast. Well done. FWIW you can use AdSense/ad tags within LiveView, if you're using that. There's an attribute you need to set - Google it - I can't recall atm, but I got it working just fine on one of my
20.
▲
Using Machine Learning to count Mt.Dew bottles in super bowl commercial
(youtube.com)
2 points
by
kuzee
6y ago
|
0 comments
21.
▲
by
kuzee
6y ago
Elixir is a fantastic language. I wrote an app several years ago and haven't had to update or do any maintenance on it since and it has happily served several million requests a month without errors. Actually the only reason I've
22.
▲
by
kuzee
6y ago
Thanks for sharing. Their emphasis on the neglectedness of an issue and focusing on the margins is great.
23.
▲
by
kuzee
6y ago
Thanks for explaining. I am also surprised by this possibility given my limited physics knowledge. Do clothes substantially reduce the effectiveness? Is true line of sight required - visible or near visible spectrum? Secondly, can you expan
24.
▲
by
kuzee
6y ago
I've tried to build several Pi projects over the years, and I'll happily plug Nerves as probably the easiest way to develop software that runs on the Pi, especially for the reliability. Genservers supervising sensor inputs and man
25.
▲
by
kuzee
6y ago
Just learned a lot about the different hosted ML options, thanks for the write-up with backing data. How much did this cost you overall?
26.
▲
by
kuzee
6y ago
I think they're justified to make this clearly flagged (sent out emails), created with some of the leading privacy researchers, and provide an explicit opt-out, and in the service of revealing racism and discrimination on the platform.
27.
▲
by
kuzee
6y ago
I did get the email, fwiw. Thought it was pretty transparent, and clearly flagged how to opt-out. Email included link to their research paper on how they're doing it all.
28.
▲
by
kuzee
6y ago
Incredible book. Got me building simple neural nets out of 74AC240s rather than code before it was cool. Plan to build a 5 motor walker yet this year for old times sake.
29.
▲
by
kuzee
6y ago
Looks like ultralytics, not roboflow, is the one that named this model v5. Different people/companies.
30.
▲
by
kuzee
6y ago
Just read this. Nice overview of the history of the "YOLO" family, and summary of what YOLOv5 is/does.
More ›