1,450 karma · joined August 4, 2012
Writing https://leanpub.com/aismarthome
Particularly with drizzle, it means I can use sqlite on device with expo-sqlite, and store our data format in a single field, with very little syntax, and the schema and queries all become fully type safe.
Also being able to use the same light orm abstraction server side with bun:sqlite is huge.
import { Database } from "bun:sqlite";
Database.setCustomSQLite("/opt/homebrew/opt/sqlite/lib/libsqlite3.dylib");
// Load extension first with a temp db
const temp = new Database(":memory:");
temp.loadExtension("/path/to/litestream.dylib", "sqlite3_litestreamvfs_init");
// Now open with litestream VFS
const db = new Database("file:my.db?vfs=litestream");
const fruits = db.query("SELECT * FROM fruits;").all();
console.log(fruits);brew install sqlite3, then change the bottom part:
/opt/homebrew/opt/sqlite/bin/sqlite3
.load litestream sqlite3_litestreamvfs_init
.open file:///my.db?vfs=litestream
you have to manually pass in the init function nameEdit:
need to set LITESTREAM_ACCESS_KEY_ID, LITESTREAM_SECRET_ACCESS_KEY, LITESTREAM_REPLICA_URL
then the module works
We have an iOS app in the store for 3 years and out of the blue apple is demanding we provide new licenses that don’t exist and threaten to kick our app out. Nothing changed in 3 years.
Getting sick of these companies able to have this level of control over everything, you can’t even self host anymore apparently.
To get coins fully controlled by circle.
On a chain with low fees controlled by Coinbase (base) for example.
In this case this new L1 won’t even be distributed by anyone initially too.
It all seems like a Ponzi scheme or small utility for international users. Otherwise I don’t know why you’d trust these centralized authorities.
What stops someone at circle deciding to issue more usdc without real dollar backing
Is this thanks to everyone thinking they can code now and not understanding what they’re doing.
Make it make sense
I really wish I just used something else or raw Ubuntu server.
The Time Machine backup feature corrupts itself.
You can’t have home assistant and Time Machine backups on at the same time. It just feels like a janky UI that has no polish too.
I’ve been using Tailscale ssh to a raspberry pi.
With Termix on iOS.
I can do all the same stuff on my own. Termix is awesome (I’m not affiliated)