8 ms·
> Dealing with even sqlite is a pain in the ass when you just need to tweak or read something, especially if you're not the dev. How? With SQL is super easy to
by giva 5mo ago
> Dealing with even sqlite is a pain in the ass when you just need to tweak or read something, especially if you're not the dev.
How? With SQL is super easy to search, compare, and update data. That's what it’s built for.
- freedomben 5mo agoPain in the ass was way too strong, I retract that. Mainly I meant relative. For example `nvim <filename>.json` and then /search for what I want, versus tracking down the sqlite file, opening, examining the schema, figuring out where the most likely place is that I care about, writing a SQL statement to query, etc.
- giva 5mo agoWell, you still need to track down the <filename> part and knowing what you want to search, so you need to examine the schema anyway. However, if your all application state can be represented in a single json file of less than a dozen MB, yes, a database can be overkill.
- freedomben 5mo ago> Well, you still need to track down the <filename> part and knowing what you want to search, so you need to examine the schema anyway. Yes agreed, but it's usually a lot easier to find the filename part, especially if the application follows XDG. Sqlite databases are usually buried somewhere because they aren't expected to be looked at.
- the_pwner224 5mo agoSqliteBrowser will let you open up your tables in an Excel-type view. You can also edit directly from the GUI. Still not as frictionless as a plain text file, and I'm not sure how good the search functionality is, but it lets you skip having to write any SQL.
- deleted 5mo ago[deleted]