Sunday, July 14, 2024

Europe and USA Yearly eSIM by MobiMatter


I use an iPad Air with built in LTE, so, whenever I'm traveling and don't want to use tethering I'll just buy a one-time eSIM and load that into my iPad. 

Where do you get those data-only eSims? I usually use bitrefill but I just discovered mobimatter which is cheaper in some instances (and they sell eSIM cards that are good for more then 30 days) 😊 

I'm considering just buying a big chuck of data (say, 50GB) and just have it on head for the next 365 days for whenever I need it. 

Pro tip: on new iPhones you can use an eSIM next to your nano SIM card as well. So even when your provider has technical problems , you can use another second SIM card in your phone as backup which could use roaming and just switch over to another provider that's still functioning. When SHTF this could be a useful option. Prepare accordingly 👍 

Tuesday, July 09, 2024

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).