jssmith

6 ms·

1.
by jssmith 1mo ago
I agree, I too found this barely readable. Interestingly, ChatGPT was able to parse and explain it to me. I got a lot out of its presentation.
2.
by jssmith 2mo ago
I get it. But I never would have until I built muscle memory for the keyboard shortcut.
3.
by jssmith 1y ago
I see JSON parse errors on occasion when using OpeanAI structured outputs that resolve upon retry. It seems it’s giving instructions to the LLM but validation is still up to the caller. Wondering if others see this too.
4.
What counts as a "slow database query"? It's surprisingly hard to say(dev.to)
1 points by jssmith 1y ago|0 comments
5.
by jssmith 1y ago
We've been focusing on indexing but query rewrites are probably next. It looks like LLMs can do a pretty good job at generating ideas, particularly if you prompt them right. After that, you have to: 1/ make sure that the SQL produ
6.
by jssmith 1y ago
Right. Why build another MCP server for Postgres? There's a lot of value in just getting a database connection. But the LLMs hit limits pretty quickly when it comes to index tuning, etc. Classical algorithms still have their place.
7.
Show HN: AI-Driven Index Tuning With Postgres MCP Server(github.com)
11 points by jssmith 1y ago|4 comments
8.
U.S. Tariff Calculator(tariffs.inasimonovska.com)
2 points by jssmith 1y ago|1 comments
9.
by jssmith 1y ago
Confused about the new US tariffs? We built an interactive US Tariff Calculator—a simple tool to help you instantly calculate the new tariffs per country.
10.
by jssmith 5y ago
Yes, but it is more restrictive, e.g., it is not Turing complete. I’m not sure whether this directly addresses Spectre risks though. An analysis of Spectre and software isolation is here: https://arxiv.org/abs/1902.0517
11.
by jssmith 6y ago
Fair enough. American companies (and people) definitely have a home bias. I guess to be constructive, I would suggest that perhaps there are parallels in your country.
12.
by jssmith 6y ago
I don't remember exactly how it broke the first time, but the cognitive overhead shows up in various places. E.g., start a new project, create a branch, then merge back to master... oh wait, it's main now? But then I'm back t
13.
by jssmith 6y ago
I want to share my own reactions to the name change since this is a really interesting topic. For context, I'm an African American, so many of my ancestors were slaves. - The first time it occurred to me that "master" in
14.
by jssmith 6y ago
Yes, the idea is that the cloud provider should offer something like this. We intercepted system calls to simulate what it would look like.
15.
by jssmith 6y ago
Thanks for sharing your writeup and the potential use cases therein. We've been building an experimental shared file system that specifically targets the FaaS setting. It supports SQLite and gets big performance gains over NFS/EFS
16.
by jssmith 6y ago
Would any of these be useful for working with Johns Hopkins Covid-19 data? There are some web interfaces but analyzing and visualizing with Python would be more flexible. ( https://data.humdata.org/dataset/novel-coronavi
17.
by jssmith 6y ago
This capability is compelling from a public-health standpoint but has serious privacy implications. It looks like every phone shares a unique id, but encrypts it in a frequently rotating way, using a public key provided by a government auth
18.
by jssmith 7y ago
If you’ve used some heavyweight framework then performance will probably be hard to add later. If you wrote the code yourself then I’m with Knuth, it’s not a big deal to optimize it later and that’s a much better way to go. I’ve found the f
19.
by jssmith 8y ago
One startup that’s working on this is unitQ: https://www.unitq.com
20.
by jssmith 8y ago
I think this has been the case for the case for the past 20 years, probably longer, though I'm optimistic that improvement is possible. E.g., perhaps serverless computing is inefficient today but it could help improve hardware utilizat
21.
by jssmith 8y ago
> Many researchers are now arguing that we should, more generally, move away from using statistics to make all-or-none decisions and instead use them for "estimation". In other words, instead of asking whether an effect is nul
22.
by jssmith 8y ago
This view on sharing hardware seems too pessimistic to me. Strong isolation should be achievable when it is the design objective and and priority. On the end-user/device side, JavaScript has proven that sharing hardware with untrusted
23.
by jssmith 8y ago
As a command-line tool it could serve as a more powerful replacement for unix utilities that I often use for simple analysis jobs: sort, uniq, wc, awk, sometimes cut and sed. I'm going to give it a try. It looks like textql loads every
24.
by jssmith 9y ago
This is a really interesting comparison. Plumbing jobs have a reputation for high pay, as do jobs in tech. Is hooking up APIs as miserable as fixing faucets? Maybe, but I really think that self-reinforcing cultural patterns play a big role
25.
by jssmith 9y ago
One reason why we should care about culture at other companies is because it drags down the appeal of our industry. When talented people with lots of options choose a career outside of tech it hurts all of us.
26.
by jssmith 9y ago
Oracle does pretty well running OLTP and analytics workloads concurrently against the same schema. While I don't generally recommend doing so, you can fire off massive scans or complex joins against a production system doing thousands
27.
by jssmith 9y ago
Great observation. So if we have to choose between diversity as a target and as a measure, which would be better ? I wouldn't take the comparison to affirmative action too far here. Our startup / VC ecosystem exists to drive radic
28.
Let’s Stop Talking About the Sexism in Venture(linkedin.com)
2 points by jssmith 9y ago|2 comments
29.
by jssmith 9y ago
Somebody isn't keeping an eye on the calendar... licenses need to be tracked and renewed, just like domain registrations and SSL certificates, otherwise things break. Unfortunately, I've seen this before, more than once. I've
30.
by jssmith 9y ago
I searched for years for the right fit in earplugs, purchasing perhaps a dozen types along the way. In hindsight I would suggest purchasing a variety pack. I think it would have saved me a lot of time and money. Something like: http:/

More ›