480 posts in

Blog

The referenced entity insert was modified during ddl execution

I ran into an issue recently when trying to create triggers for a table on a SQL Server database using node and the tedious library. I was using a promise to generate and execute the DDL to create each trigger and using Promise.all() to wait until…

Fixing Faulty Dodge Ram Window Switches

Fixing Faulty Dodge Ram Window Switches

I have a 2003 Dodge Ram 1500 4x4 truck with a little over 100K miles on the odometer that has been babied. But time is starting to catch up with it and little things are breaking or wearing out. One of the things I have been become frustrated with is…

Gatsby: Paging Tags and Posts in Categories, Part 3

Gatsby: Paging Tags and Posts in Categories, Part 3

This is the third post of three explaining how I implemented paged posts and tags by category on this Gatsby site using gatsby-pagination . In Part 1 I showed most of the structure of gatsby-node.js and how to create pages using Gatsby’s…

Gatsby: Paging Tags and Posts in Categories, Part 2

Gatsby: Paging Tags and Posts in Categories, Part 2

This is the second post explaining how I implemented paged posts and tags by category on this Gatsby site using gatsby-pagination . In Part 1 I showed most of the structure of gatsby-node.js and how to create pages using Gatsby’s createPage…

Gatsby: Paging Tags and Posts in Categories, Part 1

Gatsby: Paging Tags and Posts in Categories, Part 1

This is the part 1 of a couple of posts explaining how I page tags and posts by category on this Gatsby site using gatsby-pagination . My previous blog(s) was a bit unique in that it had the concept of categories (like /blog, /some-other-blog…

This site's architecture was foretold 4-6 years ago

This site's architecture was foretold 4-6 years ago

In July 2013 I published a blog post, Outsourcing your Blog engine’s functionality , that foretold this site’s current architecture. I had originally written the post two years prior but forgot about it in my drafts folder. At the time I had no…

How to save $40/month by choosing Gatsby and GitHub

How to save $40/month by choosing Gatsby and GitHub

Now that the clickbait title is out of the way, here are the disclaimers: YMMV. You may not actually save $40/month but I did. I used to have a lot of personal project sites including this one. A decade ago I switched from hosting a couple of sites…

Unable to load Disqus on blog posts

Unable to load Disqus on blog posts

I had previously used Disqus for post comments on my Graffiti blog and I wanted to continue doing so for the new Gatsby blog using react-disqus-comments . The urls for posts were basically unchanged so it seemed like there should not be any…

Gatsby Filtering nodes by id contained in array of ids

Gatsby Filtering nodes by id contained in array of ids

Most, if not all, of the examples for Gatsby templates show using a graphQL query that retrieves the post/posts by slugs. I did things a little differently because my post slugs may not be unique across all categories (I could have /blog/hello-world…

Tips for Gatsby ElasticLunr Search plugin

Tips for Gatsby ElasticLunr Search plugin

You may not be able to index everything Wanting to add search to my blog I set about installing and configuring the gatsby-plugin-elasticlunr-search plugin. I followed the examples. I set it to index the fields of title and tags. And being a little…