Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
bshipp
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
8 ms
·
31.
▲
by
bshipp
3y ago
I saw his talk live in 2014 and the dude is amazing. I loved his summary of building Python libraries from the ground up during legal discovery because he discovered a hidden Python installation on the terminal his opponents gave him that a
32.
▲
by
bshipp
3y ago
Different strokes for different folks. I thought Portainer and Netdata were overkill the first time I spun them up and now I can't live without them.
33.
▲
by
bshipp
3y ago
I'm pretty sure the main reason for throwing out old tools that still function in favor of the new hotness is developer boredom.
34.
▲
by
bshipp
3y ago
That's an excellent point. I think one complex agriculture issue I've encountered that LP would struggle to handle is something like inventory control of perishable goods, where there's variance in incoming quality, degradati
35.
▲
by
bshipp
3y ago
Fair enough. I'm not invested in LP or RL, but my background is in agriculture and LP forms the basis of a lot of cropping/feeding decision trees. I'd be curious to explore new techniques, but it sounds like the discussion he
36.
▲
by
bshipp
3y ago
I also am curious about this statement. If a problem becomes too complex for linear programming solutions, how easy is it to know that a reinforcement learning solution is actually a global optima and not just local?
37.
▲
by
bshipp
3y ago
If the green squares were sufficient to give me a dopamine hit, my half-abandoned repos with stars, pull requests, and conversations would be a much higher priority in my life. As it stands, responding to user requests on Github just feels
38.
▲
by
bshipp
3y ago
That makes perfect sense. I'm no lawyer and am only discussing this out of idle curiosity, so I'm sure my comments were a naive take. The situation I'm envisioning is an audio recording from a 2-party consent state outlining
39.
▲
by
bshipp
3y ago
As long as the material presented in court is acquired via legal methods, no laws are being broken, are they? Now, if officers use legal loopholes to take illegally-acquired evidence and somehow make it legal, that's a practice that s
40.
▲
by
bshipp
3y ago
I'm guessing the evidence of actual harm from aspartame consumption is also orders of magnitude lower than the damage from sugar-induced diabetes.
41.
▲
by
bshipp
3y ago
I hadn't heard that, but a cursory Google search indicates that Kodiak is building one of these systems. https://kodiak.ai/ Given the significant weight and danger of death for other drivers, it'll be years until
42.
▲
by
bshipp
3y ago
I'm debating about renewing my truck license for this reason. If it's taking this long for automobiles to be approved and accepted, it'll be 30 years before trucking is automated. The two decades during which human oversight
43.
▲
by
bshipp
3y ago
I don't even know if you'd need two servers. Spin up a few Docker containers on the 512gb raid array and you could serve the forum and mods on the same machine. It's not like OpenTTD has the user demands of Reddit or Hugging
44.
▲
by
bshipp
3y ago
I use similar analogies to describe AI to friends and family. "When AI attempts to solve a maze, it just smashes into every wall over and over until it inevitably finds its way to the exit." If it wasn't for high-powered grap
45.
▲
by
bshipp
3y ago
Putin has been in power for 20 years and the invasions of Georgia and Crimea gave all evidence necessary that he had imperialistic goals. Considering the pride Russians proclaim regarding their role in defeating a WWII dictator, it's i
46.
▲
by
bshipp
3y ago
Unfortunately for Russians, the fact they allowed their country to invade a peaceful neighbor in an unprovoked war of aggression and then repeatedly lied about almost every facet of that invasion means that the rest of the world will likely
47.
▲
by
bshipp
3y ago
I think the point is that most of those requirements could be met with a $60/month hetzner server containing a 512 GB raid array. I think that comes with 100GB free backup and if you pay another 10 bucks or so you can upgrade to a tera
48.
▲
by
bshipp
3y ago
Having played (and lost countless hours) Transport Tycoon Deluxe in the 90s and then OpenTTD 10 or 15 years ago, I'm just tickled that this game adaptation is still going strong. Chris Sawyer's ability to create addictive building
49.
▲
by
bshipp
3y ago
I think this comment highlights the two separate discussions going on in this thread. If you're building a customer-facing search engine, avoid reinventing the wheel by leveraging powerful tools like elastisearch. On the flip side, if
50.
▲
by
bshipp
3y ago
You're absolutely correct. Caching common search queries allows the site to allocate hardware for processing "expensive" queries, with the objective of having both complete at near the same time. Without caching, the cost of
51.
▲
by
bshipp
3y ago
I'm not trying to be argumentative. As long as people find a solution they're happy with, I think that's great. For me, I'm far less interested in handling typos, but I can see how it would be valuable in many applicatio
52.
▲
by
bshipp
3y ago
If you're looking for a turn-key solution, I'd have to dig a little. I generally write a scraper in python that dumps into a database or flat file (depending on number of records I'm hunting). Scraping is a separate subject,
53.
▲
by
bshipp
3y ago
It depends on what the user requirements are. FTS works pretty well with both Postgres and SQLite, in my experience. Here's a git repo someone can modify to do a cross comparison on a specific dataset, if they are interested. It doesn&
54.
▲
by
bshipp
3y ago
For sure, but the approach is quite viable. If 19 out of 20 searches by a user are almost instantaneous and single novel one requires a few seconds, they'll assume a hiccup in their internet connection and still view the site as "
55.
▲
by
bshipp
3y ago
For such a light demand and fixed site requirements, a single-file sqlite dB is probably best. Modern Sqlite has full-text capabilities that are quite powerful and relatively easy to implement. https://www.sqlite.org/fts5.h
56.
▲
by
bshipp
3y ago
Using measured comparisons and making informed choices is certainly the best way. If you can start with Postgres to have a relational database with the benefit of Full Text Search (i.e. avoid Elastisearch) as well as JSON fields (i.e. avoid
57.
▲
by
bshipp
3y ago
Sqlite is extremely powerful for any locally-embedded databases, such as apps with an offline component. For example, searching text in notes, books, cached news, etc. It's very simple to implement inside Sqlite with much less overhe
58.
▲
by
bshipp
3y ago
I've had good luck using FTS5 in Sqlite for small-scale use scenarios, such as examining scraped data, etc. It's remarkably powerful and quick. https://www.sqlitetutorial.net/sqlite-full-text-search/ https:
59.
▲
by
bshipp
3y ago
I usually don't have an issue installing Linux on a computer. The issue generally pops up when the recipient wants a piece of software that is only available on windows (which is also true for people migration to Macs). It's one t
60.
▲
by
bshipp
3y ago
Agreed, and I'm far more concerned about the impact of the walled gardens between mobile app companies than the old desktop wars. At the moment, this feels like the nostalgia of a comfortable old debate between two elderly men sitting
More ›