Viewing profile — Paul-E

Legion Intelligence | Senior/Staff Backend Engineer | REMOTE (US) Legion is building a platform for governed agentic AI, primarily for government customers. Legion has interesting …

Obsidian seems like a perfect candidate for a WASM/WASI based plugin system that would properly sandbox plugin code.

When queries get complicated enough, you end up writing a custom query builder to build your SQL. Ceci n'est pas une pipe

> And, IMO, making dynamic queries harder is preferable. Dynamic queries are inherently unsafe. Sometimes necessary, however you have to start considering things like sql injection…

I want to address this one point: > Similar thing can be said about writing SQL. I was really happy with using sqlx, which is a crate for compile-time checked SQL queries. By relyi…

I haven't tested that, so I'm not sure if it would work. The import only inserts rows, it doesn't delete, so I don't think that is the cause of fragmentation. I suspect this line i…

That's pretty neat! I did something similar. I build a tool[1] to import the Project Arctic Shift dumps[2] of reddit into sqlite. It was mostly an exercise to experiment with Rust …

I'm curious if you have tried SeaORM? I've used it a little bit (not too extensively) and really like it. It's like sqlalchemy in that you can declare your tables and have a type c…

This is what a number of startups, such as Yurts.ai and Vannevar Labs, are racing to build for organizations. I wouldn't be surprised if, in 5-10 years, most large corps and govern…

Has anyone tried to decentralize curation? Here is straw man proposal, similar to cert chains and webs of trust: Say I'm a "curator". I say on HN/Reddit/Discord "here is my key has…

A great paper on this topic is 'I've Got Nothing to Hide' and Other Misunderstandings of Privacy https://papers.ssrn.com/sol3/papers.cfm?abstract_id=998565

Thank you for making this point. I didn't articulate it, but this is part of why I felt I had to say something.

I've met Ross during my time at Princeton and he is a really genuine person, he is not trying to ruin anyone's life. This incident is the result of an uncharacteristic blind spot i…

This paper was published when there were big fights going on about whether the block size should be increased. Om camp argued for the status quo, which was causing high transaction…

One of the assumptions the authors make in this paper is that miners can turn their hardware on and off quickly, and that they will benefit financially for doing so. Mainly by payi…

The paper that relies on turns out to have some inaccurate assumptions. The paper assumes that miners can flip their hardware on/off at essentially instantaneous intervals. The ass…

Location: Los Angeles / Irvine, CA Remote: Yes Willing to relocate: Yes, western USA Technologies: Python, Rust, Numpy, Cython, Jupyter notebook, Linux, git, bash LinkedIn: https:/…