Drupal CMS News Digest

developments tricks, articles and reviews from Drupal specialists

News Categories: SEO  Design  Marketing
rachel_norfolk: Pay Your Speakers
Pay Your Speakers A twitter thread by Heather Burns has yet again struck me as so important at this time and it makes me want to re-state something that I feel is so important in open source conferences: pay your speakers — all of them. Tags Drupal Read more about Pay Your Speakers Log in with GitHub, LinkedIn, or Google to post comments
Pixelite: How many JOINs is too many? Tuning optimizer_search_depth for MySQL with Drupal
BackgroundI was recently part of a migration from AWS (Amazon Aurora - MySQL-Compatible) to Azure (Azure database for MariaDB 10.3) for a large suite of applications. This platform contains a number of Drupal 8 sites, which surface content through JSONAPI (now part of core in Drupal 8).The issueDrupal is extremely flexible, and creates a highly normalised table structure, 2 tables per field on a piece of content (1 for revisions, and another for active data). A given piece of content can contain dozens of fields. When loading a piece of content, it is not uncommon in Drupal to have 20+ joins on a single SQL query.These SQL queries the end developers do not write by hand, Drupal abstracts this detail away through the entity API.We were seeing SQL queries appear to never complete when they had lots of JOINs in them. One query I found that was 'stuck' had 53 joins. In saying that, the database overall data size was tiny, with only 228 pieces of content in Drupal (this is very low, some Drupal sites can have millions of items of content).

Running a SHOW FULL PROCESSLIST showed these queries were all stuck in a Statistics phase.The issue seemed to disproportionately impact SQL queries with > 40 joins in a single query.

These queries did not appear to ever complete, and the CPU was pegged at 100%.CPU (in blue) being pegged at 100%Upsizing the vCPU count in the...
MidCamp - Midwest Drupal Camp: MidCamp 2021: Get Started with Drupal
MidCamp 2021: Get Started with Drupal MidCamp 2021 is less than two weeks away, and tickets are on sale now. We’re accepting topic submissions for Thursday’s “Meet the Drupal Community” day and Friday’s “Share Your Knowledge” Unconference. Our job board is filling up, and next week is NERD Summit—a three-day inclusive, community building tech event based in New England.  This email is focused on our activities for folks new to Drupal or our community. If you’re already a friend of MidCamp, stop now and forward this email to a friend or colleague, please! Where to begin If you’re not even sure about Drupal, let alone MidCamp, join us (for free!) for a few hours on Wednesday morning. We’ll introduce you to Drupal, the community, and MidCamp. After these three sessions, you’ll have all you need to make the most out of the rest of camp as an attendee. Find your voice Attending MidCamp is a great start, but the best way to learn something is to teach it. On Wednesday afternoon, we’ll hold a series of (also free) workshops for folks who are interested in public speaking. During these hands-on sessions, we’ll look at what has stopped you from speaking in the past—and explore how to move past your fears. We will discuss some common myths about public speaking, different talk formats, and we will focus on finding your...
OpenSense Labs: A Peak Into the Marvellous World of Drupal Security: Essential Modules
A Peak Into the Marvellous World of Drupal Security: Essential Modules Gurpreet Kaur Fri, 03/12/2021 - 20:38 Whenever we build something, we always ensure or at least hope that it doesn’t get damaged. Take our homes, for instance, we have more than a few locks at our places to protect and keep it secure. The same goes for our gadgets, our vehicles and most importantly our livelihoods.  This brings me to the world of website development, wherein security is a major issue. An ill protected site is all but setting its demise, bugs and hacks will become its doom eventually. So, what should be done about it? I have an answer and that is Drupal.  Drupal, being a content management software, comes with an array of tools and features that protect its sites from every security breach. You will have to optimise Drupal properly to make that happen. Drupal is one of the safest open source CMSs out there.  Percentage of security issues in a sample group. Source: AcunetixThese numbers are proof of the competence of Drupal's security measures. The entire responsibility of ensuring optimal security lies on Drupal security modules. And that is what we are going to be talking about today. With the launch of Drupal 9, security has become all the more important. So, we’ll be discussing all the essential modules required for this task. I have taken the liberty to segregate the...
Aten Design Group: Drupal 7 to Drupal 8, 9 and beyond: Your last major upgrade?
Drupal 7 to Drupal 8, 9 and beyond: Your last major upgrade? Eric Toupin Thu, 03/11/2021 - 11:41 Drupal Upgrading from Drupal 7 to Drupal 8 is a major project (a full rebuild in most cases) that can rival or even top the original cost of application development. Upgrading from Drupal 8 to 9 and beyond, in comparison, requires just a tiny fraction of that effort. Here’s a look at why — and why you should take the leap from Drupal 7 to Drupal 8 and 9. The upgrade from Drupal 7 to Drupal 8 was a major theme for plenty of our clients over the last few years. Drupal 8 — and versions beyond — boast a wide range of benefits that stem from a more modern architecture, but one of the biggest wins in my mind is the advent of semantic versioning (for Drupal) and a renewed commitment to making Drupal upgrades easy forever. Moving to Drupal 8 could be your last major upgrade. The ghost of Drupal past The move from Drupal 7 to Drupal 8 isn’t easy. While it’s often still touted as an “upgrade process” the reality is that it boils down to a complete rewrite of the codebase and a content migration. We’ve worked on more than a handful of Drupal 7 to Drupal 8 upgrades in the last years, and the majority...
Jacob Rockowitz: To Drupal or not Drupal… Drupal versus all those other Digital Experience Platforms
The organization where I work is building a Digital Experience Platform (DXP), and one of the platform's products they chose is Sitecore. We are migrating away from Drupal to Sitecore and this move away from Drupal inspired me to write a series of blog posts about whether I should continue "to Drupal or not to Drupal."Considering how much I have contributed to Drupal combined with my overall experience with Content Management Systems, I hope to provide a unique perspective as to whether or not to use Drupal as part of a Digital Experience Platform.What is a DXP?A Digital Experience Platform (DXP) is simply a platform for providing rich cross-channel personalized digital experiences. It consists of multiple pieces of software, which generally include a CMS, CRM, and a personalization engine, working together to create and manage digital user experiences. In the meantime, how we define a digital experience and how we provide it, is continually changing.I began my career building static HTML pages and then moved on to building Content Management Systems. Over the years, I have iterated through many versions of the same website with my current organization. With each iteration, we strive to improve the user's digital experience. In order to understand the value and approach to building and leveraging a DXP, I had to stop seeing everything as web pages and instead, view everything...
Drupal Core News: Demo of CKEditor 5 core integration for Drupal 9 under development, feedback needed
Peter Weber leads CKEditor 5 integration development for Drupal 9. While Drupal 9 already comes with CKEditor 4, that will go end of life in 2023, so we need to upgrade to CKEditor 5 to provide this replacement for Drupal 10. The target release date for Drupal 10 in June 2022 (in 15 months!). We plan to add CKEditor 5 integration to Drupal 9 even sooner though, to help the Drupal contributed ecosystem catch up and prepare in time. There are various moving parts and several items left on the roadmap for beta level core inclusion. Peter presented a demo today to showcase where the current state stands primarily to get more feedback about the developer interface. A simple infobox CKEditor 5 plugin was also showcased to asses the integration developer experience. Check out the video recording here: Discuss in the #ckeditor5 channel on Drupal Slack. CKEditor 5 integration meetings are every other Thursday at 15:30 UTC in the same channel.
Drudesk: 10 reasons to choose Drupal 8 for your eCommerce website
Ecommerce sites are booming today, in part due to Covid. For your business to succeed, it is important that the platform on which you build your website is scalable, reliable, secure, and flexible. Given this, Drupal 8 is the best option for building an eCommerce site today.
OpenSense Labs: Understanding Technical Leadership
Understanding Technical Leadership Akanksha Mehta Thu, 03/11/2021 - 18:09 Technical leadership means overseeing a team of technical professionals at a software company. The led teams usually deal with software development and engineering. It is a designation of high responsibility, balancing thinly between being a strong leader figure and being approachable and personable while dealing with the team members. There is also a huge amount of accountability involved in the role with respect to both the organisation and team members, as a technical leader forms the essential link between both and coordinates the overall working of the tech departments to the board, and conveys essential inputs back to the teams.  Thus, a technical leader ensures that ideas from the top are appropriately represented in the final product and that communication among various groups within the organisation is never derailed.  The principles of technical leadership Like any other position of fundamental importance, there are certain principles on which technical leadership basis itself on. The right technical knowledge There are multiple roles and responsibilities associated with technical leadership. One of the first things that the leader must be proficient in is a broad knowledge base about his craft. Every member of the team turns to the leader whenever any issue arises, hence...
Drupal Core News: New starterkit will change how you create themes in Drupal 10
Drupal has been providing subtheming capabilities for over a decade. When you create a theme for Drupal 8 or 9, a best practice is to subtheme the core Classy theme, so you get common CSS classes and usual markup for a Drupal site. This means the Classy theme is used in the runtime as part of your theme. As a consequence, Classy has not been receiving updates since Drupal 8.0.0, because most changes are not possible while retaining backwards compatibility. We need to retain backwards compatibility because design requirements of themes depending on Classy could depend on markup and/or CSS provided by Classy. To solve this problem, we are working on a new custom theme creation process and base theme with the goal of replacing Classy in Drupal 10.  The new starterkit theme we are working on is not going to serve as a base theme to be subthemed, but rather a theme to be copied on a new theme's creation. It will allow front-end developers to get a copy as a starting point for their theme. Tooling is provided as part of the included Drupal command line interface for automating this: php core/scripts/drupal generate-theme mythemeWe believe that this new process will serve front-end developers better because it will allow us to provide more frequent updates to the default markup and CSS shipped as part of Drupal core. Subtheming as a concept will continue to exist even after this...
Spinning Code: SCDUG March 2021 – AWS: How an online retailer came to conquer the Internet
Chris Zietlow from Mindgrub gave his new talk on AWS: How an online retailer came to conquer the Internet. He explores the Genesis of Amazon Web Services, how it became widely adopted, and a birds eye view of some of the more common problems their services can solve. If you would like to join us please check out our up coming events on MeetUp for meeting times, locations, and remote connection information. We frequently use these presentations to practice new presentations, try out heavily revised versions, and test out new ideas with a friendly audience. So if some of the content of these videos seems a bit rough please understand we are all learning all the time and we are open to constructive feedback. If you want to see a polished version checkout our group members’ talks at camps and cons. If you are interested in giving a practice talk, leave me a comment here, contact me through Drupal.org, or find me on Drupal Slack. We’re excited to hear new voices and ideas. We want to support the community, and that means you. The post SCDUG March 2021 – AWS: How an online retailer came to conquer the Internet appeared first on Spinning Code.
Agaric Collective: Create and use a custom permission in your module
You can define your own permissions for the Drupal permissions page (/admin/people/permissions in modern Drupal, Drupal 8, 9, 10, and beyond) and then add conditional options to your code to do different things based on the role of the user and the permissions configured by a site administrator. Here's how. Create a modulename.permissions.yml file This simple file has the permission machine name (lower case with spaces) and a title (Sentence case) with an optional description. For our module, which has a particularly long name, that file is drutopia_findit_site_management.permissions.yml and its contents are like so: access meta tab: title: 'Access meta tab' description: 'Access meta information (author, creation date, boost information) in Meta vertical tab.' You can repeat lines like these in the same file for as many permissions as you wish to define. Check for that permission in your code The process for checking permissions is simply to use a user object if that's handed into your code, or to load the current user if it's not, and use the hasPermission() method which returns TRUE if that user has permission and FALSE if not. For example, in a form alter in our drutopia_findit_site_management.module file: /** * Implements hook_form_BASE_FORM_ID_alter() for node_form. * * Completely hide the Meta vertical tab (field group) from people without permission. * */...
Lullabot: How to Get Excited About Drupal Again
Drupal has been around for a long time. Officially, it’s been around for at least 20 years. Even if you jumped on the wagon around Drupal 5 or 6, that is still over 12 years of Drupal. You might have started to look longingly at the greener grasses of other ecosystems, new technology stacks, and polished products that feel fresh and new. 
Sooper Drupal Themes: Bootstrap 4 Support! DXPR Builder Security Update
We celebrated many milestones in the past year (like our complete rebrand and new website!), and looking back, we can't help but feel overwhelmingly grateful for our community. Without you Drupal would not have the fully featured visual layout editor it has today! Bootstrap 4 support  DXPR Builder now supports Bootstrap 4! This means that you can use a Bootstrap 4 theme on your next project and bring in DXPR Builder to produce awesome content with "Cards" and modern responsive "flexbox CSS"!
This addition was incredibly complex to produce and deliver but it's incredibly easy to use. DXPR Builder automatically switches between modes based on what Bootstrap library is loaded on your website.  In order to be able to deliver this release to you today we aimed for "feature parity" with our Bootstrap 3 release. Expect further developments like equal-height card decks soon! Read about other new features in the release notes. Security Update This release includes a moderately critical security update. We chose to release the security patch for Glazed Builder as well. Officially we stopped supporting Glazed Builder September last year. Unfortunately we see that many clients did not receive this message. We feel that we did not communicate the "unsupported status" of Glazed Builder successfully and for that we apologize sincerely....
Matt Glaman: It's almost time for MidCamp! Are you going (because you should!)
Promet Source: How to Optimize a Drupal Site for SEO
In the current, digitally driven climate, search engines serve as gatekeepers, determining whether and where a site appears on search engine results pages (SERP). Latest stats indicate that 93 percent of all web traffic is routed through search engines, with Google accounting for the vast majority -- 76 percent of all desktop search traffic and 86 percent of all mobile search traffic. 

Number of Total Worldwide Registered Domains Updated: Apr 19 2021