News for hackers. Stuff that matters.
Re:Local-first software: You own your data, in spite of the ... by crossroadsguy on Sunday July 06, 2025 @10:18AM (#44481026)
Yes, I feel the same. A rock solid app dismantled by just one developer choice. Still I won't diss the devs because it's their choice but "a text note" is the last thing I would want "locked" in a sqlite db and bear is a "plain text note taking app" really. So just sad.
Re:Local-first software: You own your data, in spite of the ... by nylonstrung on Sunday July 06, 2025 @12:15PM (#44481988)
Is SQLite really "locked in"?

It's possible most ubiquitous open source software ever (far more common than markdown) and your notes exist in fully readable text form inside it

Bear being proprietary is the real threat of lock in

Re:Local-first software: You own your data, in spite of the ... by strken on Sunday July 06, 2025 @10:39AM (#44481174)
From memory the sqlite3 API is something like

    sqlite3 data.db 'select text from notes'
I use sqlite3 to load and query random CSVs all the time. It feels a bit weird to hear data described as "locked" within a SQLite DB, because it's one of the simplest non-text formats for me to read data from. It would surprise me of it took more than five minutes to set up a one-way cron job to dump your notes into plain text files.
Re:Local-first software: You own your data, in spite of the ... by crossroadsguy on Sunday July 06, 2025 @01:32PM (#44482549)
My god! Really? What is this subthread now - bear app fan version of discussions.apple.com?

This is just unbelievable! Fucking pitchforks are out literally!

I am dealing with plain text notes and you all want me to write sql queries and scripts to access those fucking text files?

Are you all (these few people who just jumped in the subthread) pulling some sort of prank of so?

Re:Local-first software: You own your data, in spite of the ... by strken on Sunday July 06, 2025 @07:35PM (#44485155)
I don't even use Bear app, I'm just confused by the idea that anything's "locked" inside sqlite when I deliberately put data there for ease of use.

I don't want you to do anything. Use whatever you want! But if you love your tool except for the fact it uses an open database format instead of text files, then lucky you, there's a solution, and it takes all of five minutes.