SQLite Reviews

1Password CLI Reviews

SQLite mentions (18)

• Can I have my Lightroom catalogue pointing at two sources...?

  Yes. A Lightroom catalog file is, after all, just a SQLite database. (Srsly, make a copy of your catalog file, rename it whatever.sqlite and use your favorite SQLite GUI to rip it open and look at the tables and fields). It's just storing the pathame to the RAW file for that file's record in the database. Source: about 3 years ago

• Building a database to search Excel files

  I use visidata with a playback script I recorded to open the sheet to a specific Excel tab, add a column, save the sheet as a csv file. Then I have a sqlite script that takes the csv file and puts it in a database, partitioned by monthYear. Source: over 3 years ago

• Saw this on my friends Snapchat story, this hurts my heart

  Use the most-used database in the world: https://sqlite.org/index.html. Source: over 3 years ago

• "Managing" a SQLite Database with J (Part 2)

  With this in mind, I wrote a few versions of this post, but I hated them all. Then I realized that jodliterate PDF documents mostly do what I want. So, instead of rewriting MirrorXref.pdf, I will make a few comments about jodliterate group documents in general. If you're interested in using SQLite with J, download the self-contained GitHub files MirrorXref.ijs and MirrorXref.pdf and have a look. - Source: dev.to / about 4 years ago

• "Managing" a SQLite Database with J (Part 1)

  SQLite, by many estimates, is the most widely deployed SQL database system on Earth. It's everywhere. It's in your phone, your laptop, your cameras, your car, your cloud, and your breakfast cereal. SQLite's global triumph is a gratifying testament to the virtues of technical excellence and the philosophy of "less is more.". - Source: dev.to / about 4 years ago

1Password CLI mentions (8)

• The GITHUB_TOKEN in Your .zshrc Is a Time Bomb (And So Is Your .npmrc)

  I found both of these problems in my own dotfiles last week, despite having the 1Password CLI installed for months. Turns out "having the tool" and "actually using the tool" are very different states of being. Here's what I found, how I fixed it, and a debugging detour that taught me something I should've known a long time ago about how config files and environment variables actually interact. - Source: dev.to / 8 days ago

• Seamless Local Development with MFA-Enabled Roles on AWS

  In this example, generate_token is configured to fetch the OTP for "AWS Account" using the 1Password CLI. - Source: dev.to / about 2 years ago

• Optimize Your Git Setup: Strategies for Handling Multiple GitHub Accounts

  To get started with the 1Password CLI, visit the official 1Password CLI documentation. Here, you'll find installation guides, usage examples, and how to integrate it with various tools and workflows, including Git and SSH authentication. - Source: dev.to / over 2 years ago

• Join the 1Password Hackathon hosted by Hashnode and compete for $10,000 in prizes

  1Password CLI: Automate administrative tasks, securely provision secrets across development environments, and use biometrics to authenticate in the terminal. - Source: dev.to / about 3 years ago

• 1Password CLI, AWS and Terraform

  1Password CLI is great, having a single source for managing access keys and being able to use fingerprint ID on a Mac is such a cool feature. The AWS plugin works great, but if you want to use AWS through a third party (in this case Terraform), I failed to get it to work. - Source: dev.to / over 3 years ago