billythemaniam

6 ms·

1.
by billythemaniam 2y ago
Yes, federated queries (external tables) are supported but that is a lot slower than ingesting the data into Snowflake's storage and querying it. Since Snowflake's pricing model is based on computation time, querying external tabl
2.
by billythemaniam 3y ago
I suspect ignoring them is more effective than essentially complaining back.
3.
by billythemaniam 3y ago
Trial and error. I recommend looking up non-weighted exercise, stretches, and activities that target the body parts you are interested in, and start trying them.
4.
by billythemaniam 3y ago
I'm not surprised. LLMs are not good at those problems. There is a lot of hype, it not good at every problem, but it is quite good at some of them. If you have a classical NLP task, then it is good, particularly GPT4. If you have a gen
5.
by billythemaniam 3y ago
Similar experience for me. I found that many of my aches and pains as I get older are resolved by exercise and stretching. For example, I hurt my lower back in my 20s. Not extremely bad, but bad enough that it still gets sore if my back get
6.
by billythemaniam 3y ago
CockroachDB and Yugabyte are Postgres compatible. GCP Spanner also has a Postgres compatibility layer. CockroachDB and Spanner support foreign keys across shards which is an interesting feature.
7.
by billythemaniam 3y ago
Google engineers invented most of the primary innovations in NLP in the last decade, such as transformers and word2vec which started it all, that led to the current stack that OpenAI is built on. Their best public models certainly lag OpenA
8.
by billythemaniam 3y ago
Without hard evidence, that's a great example of a conspiracy theory.
9.
by billythemaniam 3y ago
Drug trials are already double-blind and highly regulated, particularly stage 3, so further controlling for the corruption you are suggesting doesn't seem necessary. If there is evidence (hard evidence not hearsay or conspiracy theorie
10.
by billythemaniam 3y ago
It is extremely common among research universities where they try to own all your ideas. I remember a professor had a side business cleaning pools which had nothing to do with his research area. The university found out and wanted their cut
11.
by billythemaniam 3y ago
I agree LLMs alone aren't good at search but their embeddings replace the need for stemming, manual synonym lists, etc in most cases. LLMs can also be used for query understanding which can improve the keywords submitted to the engine
12.
by billythemaniam 3y ago
> 99% of apps are basic CRUD apps Citation needed.
13.
by billythemaniam 3y ago
There are definitely use cases where you want a render loop in web, pioneered by React, instead of traditional approaches for a web application. I think the pendulum swung too far and too many sites are being built as a SPA, but there are a
14.
by billythemaniam 3y ago
That is machine learning or more colloquially: AI. A pretty cool result regardless.
15.
by billythemaniam 3y ago
I found that stemming the text before generating vectors helps increase recall and the vectors still capture context, etc. However it does hurt precision because some information is lost by stemming. The more recent vector training algorith
16.
by billythemaniam 3y ago
Awesome!
17.
by billythemaniam 3y ago
Imagine if every big box store parking lot was covered with a solar panel roof? Customers walk to the store in shade and out of rain, cars aren't extremely hot in summer when customer returns, electricity for EVs right there, excess ca
18.
by billythemaniam 3y ago
No it's designed to generate text: summarize some text, grocery list for a steak dinner, name ideas, short stories, etc. I think a lot of people want LLMs to be encyclopedias, but that's not what they are designed to be or good at
19.
by billythemaniam 3y ago
Yeah pretty much. The data is pretty clear that life for most of the global population is getting objectively better overall such as declining poverty rates. Climate change is certainly looming and starting to have a real effect, but it is
20.
by billythemaniam 3y ago
Classic NLP tasks (eg classification, summarization, translation, etc) just work with GPT-4 mostly. It is probably still possible to beat GPT-4 with a fine-tuned model, but it isn't easy. The open source LLMs are pretty good too at the
21.
by billythemaniam 3y ago
Because they are simply not that interested in trying the new thing. I will drink craft beer, but if someone invented the most amazing craft beer ever, I wouldn't go out of my way to try it even if it was free. I just don't care t
22.
by billythemaniam 3y ago
Storage costs are an excellent reason as someone else said. Another reason is security, less data sitting around to be leaked, either accidentally or purposely, the better. Another reason is privacy, less data sitting around that can be use
23.
by billythemaniam 3y ago
Crypto isn't some completely new thing that needs a new set of regulatory rules. The tech behind it is new, but it's really just another currency for the most part. Are there some differences? Yes! But it is not so different that
24.
by billythemaniam 3y ago
In an ideal world, regulatory agencies would also spend significant resources on education. Unfortunately many of them don't have enough resources for rule making and enforcement, their primary mandate. However, there are plenty of edu
25.
by billythemaniam 3y ago
It's not that weird, its there job is to enforce not teach. The FDA, EPA, etc set the rules and enforce those rules. They do not hold a company's hand following those rules.
26.
by billythemaniam 3y ago
I really hope just using static types alone doesn't give people confidence to refactor. It of course depends what "refactor" really means. Are we talking about a function, class, module/library, an entire application? Ma
27.
by billythemaniam 3y ago
In addition to other answers in this thread, those languages came first. Java's main motivation initially was to fix all the memory bugs that come from manually managing memory in C/C++ and give a pure OOP development experience.
28.
by billythemaniam 3y ago
While true, GPT-4 kinda just gets a lot of the classic NLP tasks, such as NER, right with zero fine-tuning or minimal prompt engineering (or whatever you want to call it). I haven't done an extensive study, but I do NLP daily as part o
29.
by billythemaniam 3y ago
Public transit isn't as good, wildfires, and lack of rain means whatever is in the air lingers for longer.
30.
by billythemaniam 3y ago
How come? Genuinely curious.

More ›