ellisv

15 ms·

241.
by ellisv 4y ago
I can’t wait for Property Graph Queries
242.
by ellisv 4y ago
That’d be cool but I don’t think most idle consumer GPUs (6-8GB) would have large enough memory for a single iteration (batch size 1) of modern LLMs. But I’d love to see more federated/distributed learning platforms.
243.
by ellisv 4y ago
It depends a lot on how connected the graph is and whether you can fit it in memory.
244.
by ellisv 4y ago
If you have an edge list like: A->B A->D B->C C->D Postgres will walk both paths from A to D in the recursive CTE and then you can filter them afterwards to keep only the shortest. You can use aggregate functions within the recu
245.
by ellisv 4y ago
I’ve considered using a column to store indicate 2nd, 3rd, etc degree relations instead of n-th order tables.
246.
by ellisv 4y ago
I haven't compared, but something like Kùzu is probably much more performant for a lot of use cases because it implements Worst-Case Optimal Joins. But I think Postgres is likely to get these improvements in a few years too.
247.
by ellisv 4y ago
It's not even that it always considers all edges, but that you can't exit the search early when a condition is met. In other words, you have to first find all the paths and then, outside the CTE, filter to the shortest. We push th
248.
by ellisv 4y ago
Postgres can detect cycles; see 7.8.2.2 in the docs: https://www.postgresql.org/docs/current/queries-with.html#QU...
249.
by ellisv 4y ago
My best guess is that transactional workloads are mostly improved by automatically adding the right indexes and parameter tuning. For example, OtterTune also advertises "2x on price/performance over unoptimized DBs".
250.
by ellisv 4y ago
It's worrying that a lot of companies aren't pushing these types of changes back. Particularly with Google, they'll have software patents that prevent others from implementing the same improvements but also, based on their tr
251.
by ellisv 4y ago
Eh, there are other options for this that are more mature and more likely to be supported in the long run. The Citus columnar store extension has been around for almost a decade.
252.
by ellisv 4y ago
Makes sense since it's not in their managed infra
253.
by ellisv 4y ago
I haven't tried AlloyDB yet but I've found most of GCP is this way. I've had to perform several Cloud SQL db migrations this year because storage will auto increase (due to ephemerally high tmp_data) and cannot decrease. Lots
254.
by ellisv 4y ago
If you were to name a company specifically, the company could fold and reopen under a new name. But moreover, laws should be about behavior. You don’t ban Philip Morris, you ban selling tobacco to kids and smoking indoors.
255.
by ellisv 4y ago
I agree that is one of the big issues with keychain. You can share keychain items with people but it is awkward.
256.
by ellisv 4y ago
This has the obvious measurement bias of only looking at packages, and not a wider sample of user code. But I think it’s likely that most users, and most code, are entirely unaware of lazy evaluation.
257.
by ellisv 4y ago
I just rephrased the title: “How should I use GPT to be productive?”
258.
by ellisv 4y ago
This makes me think of how the R language has been "slow" to make (some) changes and many people now use packages from the tidyverse. Writing R with the tidyverse can be practical unrecognizable to people writing with base R (and
259.
by ellisv 4y ago
GPT (Generative Pre-trained Transformer) is a powerful language model that can generate human-like text, complete sentences, paragraphs or even longer text based on a given prompt or input. Here are some ways you can use GPT to be productiv
260.
by ellisv 4y ago
It's not practical for Congress to dictate the exact mechanisms for implementation.
261.
by ellisv 4y ago
There is mandamus language that directs the DHS Director to "bolster the security of open source software", "support Federal efforts to strengthen the security of open source software", etc. but it's up to the direc
262.
by ellisv 4y ago
Here is the proposed legislation text: https://www.congress.gov/bill/117th-congress/senate-bill/491... pdf: https://www.congress.gov/117/bills/s4913/BILLS-117s4913rs.pd...
263.
by ellisv 4y ago
Nice write up. Another way would be to use Steampipe.
264.
by ellisv 4y ago
My view is that inflation was exacerbated by the sequence of events. The Russian invasion of Ukraine didn't cause inflation but disrupted the ability of the Fed to effectively manage it. That's not to say that inflation would have
265.
by ellisv 4y ago
> and the fed decided to fight it by fighting workers. I don't really understand this view (and certainly wouldn't attribute this sort of intent to the Fed). What did the Fed do? What should they have done?
266.
by ellisv 4y ago
The Fed has monetary policy powers – they can essentially modify the supply of money. Their primary tools are that they can raise/lower the Federal Funds Rate and can purchase/sell financial assets (quantitative easing/tighte
267.
by ellisv 4y ago
Sorry, I thought you made your prediction 18 months ago – the generally accepted start of the invasion is 2022-02-24. If your prediction was after, then yes I agree the Fed should have accounted better for the global landscape.
268.
by ellisv 4y ago
I don’t think the Fed anticipated the war in Ukraine.
269.
by ellisv 4y ago
Maybe. What's the conditional probability a bank's name starts with S?
270.
by ellisv 4y ago
Silvergate, SVB, and Signature were cooking for some time and I imagine a few others are too – but would foregoing an expected 25bps rate hike really change anything?

More ›