Craft CMS events, tips, plugins, and one broken heart 💔.
Hello, Craft friends. Welcome to issue 107 of Craft Link List.
As this issue hits the internet, we're just one day from Dot One in Melbourne. The sessions for the event looks really interesting. If there are links to slides or videos, they'll end up in a future issue.
The big Craft event of the year, Dot All, has been announced for Amsterdam on September 23-25; check the link below for early bird pricing. Plus, there are more posts on making you a better Craft developer, plugins and more.
If you have a link to share, head over to the submit a link page. It helps with putting each issue together.
Thank you to the sponsors of this issue.
Fortrabbit is looking for someone who loves Craft. Read what future-you could be doing, working at fortrabbit.
Freeform is the feature-filled form plugin for Craft CMS that includes ready-to-use templates to quickly get you up and running. Learn about the power of Freeform.
Let's hit the links.
Perfecting your technique
How to find all entries that use a particular matrix block type
James Smith shared a handy SQL query when you're refactoring matrix blocks and need to find all those entries using a particular block type:
SELECT DISTINCT title, craft_content.elementId, enabled FROM craft_content INNER JOIN craft_matrixblocks ON ownerId = craft_content.elementId INNER JOIN craft_elements ON craft_content.elementId = craft_elements.id WHERE typeId = ‘123' AND title IS NOT NULL AND revisionId is null AND draftId is null
Site backup options
The topic of backing up your site was recently discussed in Discord. For Forge users, backups were recently introduced into the control panel, but only for the "Business" level plan. There were several options mentioned that your fellow Craft devs use.
Here's a list of the services mention:
If you're of a "roll your own" developer, check out these options: