Neat project! I’ve seen a few analytics tools starting to use SQLite over Clickhouse. It’s great for small to medium sized projects, and can potentially scale (but I haven’t tested it over 200k hits per month).

I rolled out a similar project a few months ago using Django + SQLite.

https://github.com/HermanMartinus/bearlytics

Wow. It looks like the two of us were responding to the same underlying needs. Great to see your project.

Interestingly enough, this is how I tricked myself into quitting smoking.

I withdrew $100, and told my good friend that I’d give it to him if I used anything with nicotine in it. It worked pretty well since it turns that first cigarette into a $100 cigarette. Not worth it at all.

And I haven’t smoked in 7 years :)

Good job! But I would caution that you probably were just not addicted to nicotine. You may not have the genes for addiction, or it just was not yet activated.

It can often be the habits and routines that are hard to stop than the physical addiction.

Most people aren't addicted to nicotine. They are addicted to the burnt additives.

This is why vaping tends to work really well if you want to quit. It's just water and nicotine.

That's wildly untrue. Many people just end up addicted to vaping instead.

This is so cool! Always good to see projects like this on Hacker News.

I can attest to this. I run Bear Blog, and it has seen a dramatic rise in signups month-over-month. My suspicion is that other platforms are getting covered in AI generated content, and while Bear isn’t perfect, there is a lot more curation and a strict no advertising policy.

Definitely. Even if no one reads my blog, the act of articulating ideas in a format that others can understand helps me better understand those ideas and concepts myself.

I’m also bias, since I run the Bear blogging platform. There are thousands of very happy personal bloggers there with close to zero SEO goop (strict review process, and all that).

You obviously didn’t read the article and just wrote this comment on looking at the headline and picture. The circling the room twice is referring to an actual dragon fly. Also, it’s not ICE but fluidic motors driven by lithium nitrate crystals.

There’s also cover how it is very hard to control and how they do it manually with IR lasers. There’s even a video at the end of the prototype flying.

It has been synthesised. It's a mild stimulant but has a not-so-great toxicity profile. Probably best to leave it with the fibre you need to chew through.

https://en.wikipedia.org/wiki/Arecoline

Hey, author here. I decided on the 16 since its support lifetime started this year. If I'd gotten the SE (which I seriously considered since it has a more appealing form factor and touchID) I would only have a 4 year support lifetime as opposed to the full 6.

On the other hand the SE3 is 54% of the price of the 16 (assuming base models of both), so long term it could be cheaper to go with the SE3 even though you would have replace it sooner.

I recently tried to self-host Umami and Plausible, and failed so spectacularly I decided to build a Django/SQLite web-analytics platform myself.

These other open-source tools are great, but are incredibly difficult to get running yourself since there's no incentive for those companies to make it easy since they sell managed hosting.

Is Bearlytics better? No, but it's certainly simpler, and everything I personally need.

Congrats on building Bearlytics!

I agree with you, it's weird most cloud analytics offer self-hosted versions, when that goes directly against their business model. In the best case, the self-hosted version can act as a lead magnet, attracting customers for the cloud offerring, but in that case, it's still in their best interested to not make the self-hosted version as good as the cloud one.

This is a very cool demo! Well done!

One suggestion for fixing the cursor drift during finger taps is instead of using hand position, use index finger. Then tap the middle finger to the thumb for selection. Since this doesn’t change the cursor position, yet is still a comfortable and easy to parse action.

Thanks Herman, glad you enjoyed it! I agree with your suggestion, having the middle finger + thumb for tap and index finger for the movement will mitigate the cursor drift. The only reason I used index finger + thumb is so that it is like the Apple Vision Pro input. But definitely could be an improvement.

Unrelated, but shoutout to bearblog. My first blog was on bearblog, which made me start writing. Although I later ended up self-hosting my own blog.