lenwood

Just yesterday it occurred to me that it had been a while since I last saw an SQLite post at the top of HN.

I really like the simplicity and speed of SQLite, I've used in both personal and professional projects. For day-to-day work I still end up in Excel, not because I like it more (I don't), but because its ubiquity makes it the lowest friction way to share & explore datasets with less technical stakeholders and execs.

I noticed that, too. Technically I think this is a version of JS conversion. Interesting that he doesn't specifically mention XOR in the article. He does suggest combining methods though. I suspect this is effective.

> So allowing housing prices to surge is literally taxing the poor for the benefit of the rich.

How do we limit home prices increasing? I see your point but solving this isn't trivial.

Agree that most leave something to be desired. TC Electronic polytune is great and I also use the pedal to mute my signal. I'm surprised to say this, but my favorite tuner is the one in the L6 Helix.

I agree with the majority of your comment. I haven't yet found a use case to justify running this myself. I did find one use case that impressed me though. There's an OpenClaw agent that's actively answering questions on the #help channel of their Discord server[1]. So I asked it a question as I was getting started. It answered in < 2 mins with a detailed explanation of my issue, how to fix it, and asked relevant questions to guide me. The answer was better than I received from Claude or Gemini. I'm still not sure if I personally need OpenClaw, but the Krill bot offers pretty great support. I would be curious to know what it costs them to provide this.

[1] https://discord.com/invite/clawd

Awesome to see a project deal with prompt injection. Using a WASM is clever. How does this ensure that tools adhere to capability-based permissions without breaking the sandbox?

I know very little about cybersecurity, but my understand of TOR is that a node host wouldn't be able to offer much about the traffic coming across their server(s). The packages are encrypted and there is no entry or destination info, so he may be able to say how much traffic was coming across, but what else could he possibly know? Info on other nodes?

I like the NotebookLM podcasting feature, have used it a few times to come up to speed. There's one quirk of the dialogue that I find annoying though, the two speakers finish one another's sentences. At first I thought that was a nice touch, but it happens often enough that it became distracting. I should experiment with the prompt to limit how often it happens.

I think this comment belongs in the sister thread, Who wants to be hired? [1].

[1]: https://news.ycombinator.com/item?id=42017578

Thanks, I'm one of the lucky 10k today. This is great and I'd never seen it before.

I'm sorry for your loss.

I'm usually skeptical of this type of content, but this seems useful.

I accidentally did something similar, which has been very instructive. I play guitar as a hobby, and aspire to able to play improvisationally. I've struggled with this and at one point had all but given up. I realized the silliness of giving up because I can't do it now, and wondered is it possible for me to do this in 10 years? And if so, what can I practice today to be a better player next month?

This has worked. I'm less than a year into this and I'm already a better player. I'm more disciplined in my practice, I'm enjoying it more-and therefore more motivated to stick with it. When I sit in with a band I feel more prepared and am slowly getting comfortable experimenting.

I still have a lot of work to do, and I'm more eager than ever to do it. I've been wondering what other areas of my life would benefit from this attention.

I wondered the same, but apparently not. Excerpt from their About page[1].

> IMSLP, also known as the International Music Score Library Project or Petrucci Music Library, was started in 2006. The logo on the main page is a capital letter A. It was taken from the beginning of the very first printed book of music, the Harmonice Musices Odhecaton. It was published in Venice in 1501 by Ottaviano Petrucci, the library's namesake.

[1] https://imslp.org/wiki/IMSLP:About

I just learned about this engine. It's different because instead of a camshaft its valves are operated by pneumatic actuators. This detail makes it possible to switch between 2 and 4 stroke cycles depending on engine RPMs and load. The engine's controller can adjust valve timing to maximize performance, minimize fuel consumption or regulate emissions. The model that Koenigsegg is working on will be a 2L inline-3 capable of producing 300 HP (220kW) naturally aspirated. Pretty impressive.

Why do they require a phone number to begin with?

> Shouldn't their support care about the customer's personal info being shared with you?

I agree. The company is pretty large and has a support team. I'm guessing here but I think I'm a challenge for them because I'm not a client. They don't have a defined process for how to field my question.

> show up there looking for MyName and tell him/her about all the info you have on them...

The events are in another state (I'm in US), I'm not going to travel to chat up the individual. I have looked through the info to see if there's a way to contact them directly, its not a straightforward path. Thanks for your suggestion.

I like the certified letter approach, I'll check into this. I've considered getting an attorney involved but that could get expensive quick. Thanks for your suggestions.

I've known about Gmail rules but I didn't know that I could set it to delete. I'll check into this. Thanks you.

Agree. I've completed data pipelines for several projects and have found that the cleanest, and often fastest solution is to use SQL to structure the data as needed. This is anecdotal and I'm not an expert with SQL, but I haven't come across a situation where R or Pandas dataframes worked better than a well written query for data manipulation. This has the benefit of simplifying collaboration across teams because within my company not everyone uses the same toolset for analysis, but we all have access to the same database. Other tools are better suited to analysis or expansion of the data with input from other sources, but within our own data SQL wins.

Have a look at Lobe [0]. I haven't found a use case for it personally but it looks promising. The caveat is that this would only handle cat identification, you would need to build & implement the opening mechanism.

[0] https://www.lobe.ai/

Yikes! Lucy did a nice job talking around the ethics question at the end. She may be good at her job, but its pretty offensive that her job even exists.

Wow this is cool! It would be awesome to learn more about its history. The nameplate (visible at 11:10 [0]) says patented with a date of 1901, which is 10 years before IBM was founded [1]. This was curious to me so I looked up the patent [2], which was granted in 1905. Based on this it seems that IBM must have purchased the rights to this patent and that it was either made or refurbished after 1911.

[0]: https://www.youtube.com/watch?v=z8VhNF_0I5c&t=670s [1]: https://en.wikipedia.org/wiki/IBM [2]: https://patents.google.com/patent/US800979A/en

> by no means is this different from the store branded products you find at Safeway or Walgreens

It is different because Amazon controls exposure to products. In the store if I want ketchup, Heinz and the store brand are right next to each other and easily distinguishable. Amazon can bury the original product on page 2 of the search results. Also, its not always obvious in Amazon's search results that there is a viable option other than the Amazon branded product.

Your point is valid. Any business model that is dependent on collecting visitor data is flawed and its appropriate for these companies to either change or wither. I hear the concern, but IMO the need for privacy is greater.

Very interesting. I think anyone with ambition has been rejected and its interesting to see how much OP is putting themselves out there. I chose to keep a list of all of the times I or my work has been recognized. I guess it comes down to what motivates you, but I'd rather not dwell on the times I've been rejected.

If the goal is to avoid capricious removal of content then this is great. If the goal is to avoid the platform being used for harm then this seems insufficient. The law cannot move fast enough to stay current with social trends.

> modern Android designs are cleaner than iPhone looks

Design is about more than the way apps & interface looks. I recently switched from Android and the thing that most struck me is that iPhone usability is more consistent. I was able to do everything I wanted with Android and honestly I loved it, but its not as intuitive as iOS.

I haven't kept up with this space at all. I'm a bit surprised to learn that all that's required is a windshield attachment & software update. I find this simultaneously fascinating & scary.

How do you contact a miner? Can you give an example of this? I've read this before but I'm curious to learn more specifics.