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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
