Not sure if people interested, but since I use sqlite in a lot of my own projects, I am working on a lightweight monitoring and safety layer for production SQLite.
The idea is pretty simple: SQLite is amazing, but once it’s running in production you basically have zero observability. If something weird happens (unexpected writes, schema changes, background jobs touching tables, etc.) you only find out after the fact. It tries to solve that without touching application code. It's a Rust agent that runs next to your sqlite file, and connects to the server where everything is logged in. My current challenge right now is encryption and trust, mostly.
Curious if others here are running SQLite in production and if you would be interested in something like this.
This may not be the post, but there is something I hate about wifi on airplanes. I don't fly that often but when I do I pay for wifi.
Most airlines redirects you to a website to pay for the wifi, and it seems they block all requests to different domains. Problem is, these platforms suggest to pay with Google Pay / Google Wallet, but if you try to do that, Google Pay DNS are blocked, so the request fails and you can't use your card with Google Pay. So I need to take my card from my physical wallet and type all the digits.
Yeah, I've experienced this as well. It's frustrating. Wish I could offer a fix for that here. It is becoming more of a standard that airlines offer free wifi - e.g. United went from ~$8 low-quality service to free Starlink. So, hopefully you encounter this less often as time goes on.
> I definitely get this. The thing that gives me hope is that you only need to poison a very small % of content to damage AI models pretty significantly. It helps combat the mass scraping, because a significant chunk of the data they get will be useless, and its very difficult to filter it by hand
It'd be great if the code returned by this project is code that doesn't work. Imagine if all these models are being trained with code that looks OK but in the end it just bullshit. I'd be amazing.
Miasma is just a wrapper around the "Poison Fountain". You can check out the explanation and sample some of their content here: https://rnsaffn.com/poison3/
It's pretty much exactly what you're describing: content that looks correct but is deeply insane.
This is wonderful but I feel bad for all the people who doesnt have the resources to go through the same. For 99.9% of the population, a diagnostic like his means a really different outcome. I know he is trying to fix this with his investments and companies, but sharing this story could be seen as "boasting"... "I went through this and I survived, while your loved ones wouldn't"
While that is just a natural reaction to "unfair" world where not everyone gets the same level of access to the best level of care, I'd also say that it's a reminder that money can't and won't solve all problems people are hit with in their lifetimes (or he'd not be facing cancer diagnosis in the first place).
This story is of someone with resources putting them to good use to save themselves, but also have that benefit others: medical research is expensive and for good reason restricted, and just like lots of open source was driven by individual's need, so lots of good stuff can come out of this. I suggest to see it that way.
The novel part of his post is the summary of what worked. That information you cannot get except from him. You need his experience.
But this extra text you want can be obtained from LLM so if you require this “decoration” on top of information why not simply write yourself Chrome extension that reads page and adds that text to it at the bottom?
Oh c'mon. Here's what Sid's done to help others in the process
* Started 10 companies to enable access to others
* Detailed policy proposals to make this easier process for others
* Open sourced the entire process and all of the associated data (25TB)
and probably other things I missed.
But nah, what would reaaally help is an acknowledgement.
A beautiful trend that has been going for 30 years ;-)
One of the happiest moments of my childhood (I'm exagerating) was when my button was placed in that website that I loved to visit everyday. It was one of the best validations I ever received :)
What inspired me to pursue computer related fields was making little badges and forum signatures in Photoshop as a teen. Heartwarming to see this tradition has persisted
My similar happy childhood moment was when my home page made the Netscape "Rants and Raves" page for my extensive tribute to Lindsey Wagner (the actress who played the Bionic Woman), and that leading to my local newspaper interviewing me for an article on what the heck this "World Wide Web" was. I went on and on about how the web was revolutionary as an equalizer, allowing anybody to publish and actually be heard without the old barriers to entry. Sounded good, but the web hasn't exactly fully lived up to my vision.
Pamphleteering has a storied tradition. Self-publishing remains accessible today.
What confuses me are the reflexive "why would I publish if I'm not getting the ad revenue" and "why would anyone take their time w/o getting paid" type remarks.
Same comments about music: nobody will record songs without getting paid. And games: what's even the point in playing a shooter without dropping loot?
The last one encapsulates the whole problem well.
Over on /r/division2 a majority of players are baffled by a one month only "Realism" mode (all March, worth trying!) that turns off loot boxes and loot drops from tangos. You can solo or co-op the Division 2 Warlords of New York expansion, set in Manhattan, receiving a couple additional base weapons and weapon mods each mission completed. It's refreshing to enjoy beating scenarios while liberated from opening every scrap pile on the street then sorting through inventory for hours.
Gamers on reddit seem universally convinced the gameplay loop for a tactical PvE shooter should be about getting the next loot, rather than executing a mission cleanly or enjoying a strategically cooperative evening with friends defeating a zip code and its boss.
"I won't play a game that's not rewarding." "I won't write a song that doesn't make me a millionaire." "I won't capture my thoughts on a subject unless I get $0.003 an eyeball."
Sounds like classic crowding-out of intrinsic motivation.
There's a story, I can't find the page at the moment, of someone who was getting pranked all the time (his house TPed or egged or something). So he offered the miscreants $1 to do it tomorrow. He kept on doing it like this, and then a few days later, he offered a quarter. By the time he had got down to a dime, they said "there's no way we're going to do it for such a measly sum" and left.
Better sourced examples also exist: fewer citizens supported a decision to build a nuclear waste repository in Switzerland enjoyed more support if they would be offered compensation: https://www.bsfrey.ch/wp-content/uploads/2021/08/crowding-ef... p. 96 (sixth page of the PDF).
> What confuses me are the reflexive "why would I publish if I'm not getting the ad revenue" and "why would anyone take their time w/o getting paid" type remarks.
I published free content during the 90s and early 2000s in the internet, so I lived through that moment when you write something just for the pleasure of it. What I think it changed is that back at the time, it was you and your keyboard and that was your gun. The best content (that is, the best idea+writing) won. People would share in forums, MSN, emails, with friends, etc. It was more democratic in the sense that we were all equal.
Today that doesn't work anymore. You can write a very good piece but no one will discover it because the behaviour has changed. You probably will have to invest in ads, or being someone already known in the topic, etc. And I am talking before AI, with all the AI noise/slop/content, it's impossible today. So if I am going to fight against big media who are also writing shitting content about the same topics, or Instagram influencers who are posting silly memes, and I need to invest money, may as well try to earn something back.
Curious if others here are running SQLite in production and if you would be interested in something like this.
reply