DB Browser for SQLite

DB Browser for SQLite (DB4S) is a high quality, visual,open source tool designed for people who want to create, search, and edit SQLite database files. DB4S gives a familiar spreadsheet-like interface on the database in addition to providing a full SQL query facility. It works with Windows, macOS, and most versions of Linux and Unix. Documentation for the program is on the wiki.

A lot of apps use SQLite for storing in-app data. For example, the JWPUB file format is a compressed SQLite database file. 

By the way, did you know that SQlite is pronounced as See Queue Lite (not See Queuel -ite) because it's supposed to be a wordplay on rocks (Granulite, Perlite, Rhyolite, Kyanite… you get it).  

Mataroa on the madness of using AI

I Will … Piledrive You If You Mention AI Again — Ludicity

An executive at an institution that provides students with important credentials, used to verify suitability for potentially lifesaving work and immigration law, asked me if I could detect students cheating. I was going to say "No, probably not"... but I had a suspicion, so I instead said "I might be able to, but I'd estimate that upwards of 50% of the students are currently cheating which would have some serious impacts on the bottom line as we'd have to suspend them. Should I still investigate?"

We haven't spoken about it since.

Read it all here: https://ludic.mataroa.blog/

Avalon Nano 3

For about €125 you can be the proud owner of an electric home heater that earns itself back (a little bit) when being used, by mining for Bitcoin. 

The Avalon Nano 3, by Canaan. 

WatchParty

Watch videos together with friends anywhere. 

https://www.watchparty.me/

What if my video is an MP4 file but hosted on a site that's blocked in Russia, say www.jw.org. Can I watch together with a friend over there, yes or no?  

We throw around "anywhere" a lot, but the free world is shrinking 🤔 

Zapper - send tips to any event on Nostr

I want to embed an iframe into all my blogs to enable "zapping" aka Bitcoin Lightning ⚡️ payments. 

It seems this company has an easy solution for this: https://zapper.nostrapps.org/

Current ₿ price of $0.07m could last another 245 days before miner stashes are exhausted.

#Bitcoin miners have according to this chart, another 1.75m coins ready to be sold. 

This explains why the price isn't rising even with $500m-1bn inflows into ETFs per day. 

At  current price  we  have  245  more  days  to  go  before  we  could  break #btc at $0.07m. If the miners stop selling, all bets are off of course. 

Link: https://x.com/nicoffx/status/1798454351230357965

The sad state of calendar en to-do apps.

It is now the year of Our Lord 2024, and we have Machine Learning models that can do all kinds of weird stuff.

And yet, something as simple as a calendar app that does the following doesn’t exist yet:

1. Get to know my work and sleep schedule (for example, I sleep 8 hours a day, usually between 22:00 and 06:00).
2. Take all my to-do items (or reminders, whatever you want to call them) and put them in my calendar.
1. Preferably not back-to-back, but with some time in between to catch a breath.
3. If a to-do item is on-site, automatically add travel time.
4. If a to-do item isn’t finished or done at all, add it to my calendar again at the next opportunity 
5. Is there no hole in my schedule big enough to accommodate the calendar item? Skip until the next day/time when I do have the time.

Ronald pointed me to an article that says Apple will try to combine the Reminder and Calendar apps in iOS 18. I hope Apple doesn’t muck it up. For now, I’m disappointed at Fantastical, which I paid €7.99 per month for, in the hope that it would do the things described above.