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 attacks with dynamic queries. Depends…
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 relying on macros in Rust, sqlx would…
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 in the vacuum docs: > The VACUUM command…
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 and SQLite (HN's two favorite topics).…
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 checked query builder, which is a big…
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 government agencies had these sort of…
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 hash…
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 in empathy: a mistake. I also have…
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 fees and long backlogs. The other camp…
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 paying lower electricity bills. It turns…
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 assume this to argue that miners will…
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://www.linkedin.com/in/ellenbogen/…
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 attacks with dynamic queries. Depends…
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 relying on macros in Rust, sqlx would…
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 in the vacuum docs: > The VACUUM command…
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 and SQLite (HN's two favorite topics).…
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 checked query builder, which is a big…
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 government agencies had these sort of…
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 hash…
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 in empathy: a mistake. I also have…
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 fees and long backlogs. The other camp…
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 paying lower electricity bills. It turns…
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 assume this to argue that miners will…
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://www.linkedin.com/in/ellenbogen/…