Weeknotes 87

Development environment improvements were on the agenda this week. Mainly setting up LSP, and various completions using nvim-cmp. This has been on my TODO list for a long time but I think I have the basics configured now: Ruby completions using solargraph, and git with commit, PR, and issues refs.

I even started hacking on my own nvim-cmp source for Jira tickets and have it mostly working with the exception of not fully understanding how the triggering of the source works. I plan on adding other ticketing systems as and when the need arises.

Over time, with some real work, I’m sure it will need tweaking.

Last week I wrote mentioned Twitter discontinuing 2FA by SMS, and cited a blog post by Ricky Mondello. In that article they mention that Passkeys are where we want to be eventually. If, like me, you didn’t understand how they work take a look at this short video Ricky presented as part of a WWDC session.

I verified the links on my Mastodon profile. There are two methods to chose from. I went with adding a <link> element like this to various websites of mine:

<link rel="me" href="https://hachyderm.io/@jordelver" />

Easy peasy.

After talking about SQLite quite a bit I decided to try out a Rails app with SQLite in “production”. And Fly is the obvious choice given their interest in pushing SQLite to the edges.

Firing up a new Rails app, something I hardly ever do, was surprisingly delightful. (Perhaps it’s all those creaky old codebases I’m sick of rather than Rails after all 😉).

A few niggles, but getting a brand-new-does-nothing app running on Fly was a nice experience. The problem with this default approach is that database will be wiped on each deploy as the VM is pulled and replaced. What you need is a persistent volume where you can put the db file and mount in each app when started. This too, was easy by following the Fly docs.

So there it is. SQLite running in production. True, it’s no real test, but I think it might be the start of something.

Backups and restores are the missing piece at the moment. Litestream streaming to S3 seems to be the way.

“How I use ChatGPT to improve my executive functioning and productivity” – seems to me that ChatGPT has many benefits if you understand the limitations. For someone like me, who often struggles with starting, I can see a conversation with ChatGPT being a great help. Even if it lies and talks shit.