Measuring your Website – The Real OpenSourcery

Measuring the Web

The Web is the20th Century’s Cauldron of Change. The Web is spilling out change that is innovative, widespread and intimidating. Innovative because with DIY- Do-It-yourself Web Development tools it is possible for individuals and teams to create online presences and services that would have been improbable before the Internet. Widespread because in 30 years the Web has burst from a few labs to worldwide adoption accelerating even in the Pandemic:

Intimidating because the Web has become infested with hackers and criminals who attack and paralyze indiviidual to organizational web users for profits or propaganda. The increase in malaware infections/hacks has been dramatic:

And the Purple_Sec report shows the changing nature of the attacks including shifts in technology used and how to extract money from victims. And security reports from Mcafee Security Reports and then Verizon 2020 Data Breach Report underline the scope of malicipus web attacks. Let us take a look at KeyCDN’s table of average webpage size which has increased by 5 times in the last ten years:

Year	2010	2012	2014	2016	2018	2020
Pagesize	702kb	1097kb	1850kb	2332kb	3010kb	3890kb

This 5-fold increase has not been evenly distributed but has seen rapid growth in videos, fonts, and scripting as seen here:

The result is that website and webpage tuning has become much more complicated just in the era when fast website respose time has become a website KPI. And to add to the challenge mobile devices now account for 55% of web usage but perform about 40% slower than their desktop counterparts on the same browsers. So Website Performance Measures below are a key part of this review. Finally look at the trend in retail sales as they move steadily to e-commerce websites:

The bottom line is that e-commerce sales have moved steadily from 9.9% to 14.5% of total US retail sales. But now the pandemic has changed sales patterns across dozens of retail markets. In sum the volatility and impact of the Web makes meaningful measures of Web trends an essential for organizations small and large.

Measure of an Organization

The 21st century has accelerated a 20th century trend – the rate of change across the World from technology thru the environment to social norms and governance – all are increasingly challenging to manage The Pandemic has heightened the issues as organizations find they must revisit their mission and strategy. Suddenly, organizations have had to change how they reach customers, deliver their services, support their own staff and keep their shareholders and suppliers in the know about their latest operational directions..

So it should not be a surprise that an Oranization’s Web systems now account for 1 in 7 direct sales and are instrumental in overall marketing, delivery and support operations. Thus, keeping tabs on your Website is actively supported by a wide array of tools tracking your website’s performance.

Website Measurement Tools

There are many measurement tools for providing broad website performance data. First are tools for overall KPI-Key Performance Indicators like security, mobile responsiveness, speed of operations, SEO status, and detailed usage statistics. Then there are numerous specialized tools that measure all aspects website performance such as web security, website speed, SEO success and data integrity. As you might expect, there is overlap of features even among different measurement tool categories. Overall website measurement tools provide a macro benchmark of how your own or competitor websites are doing. As you can see from the table below the number of tests for each measurement category varies widely among the tools; but rest assured each of the tools has detailed analysis and tips for users to track and improve their websites.

Tool/Measure	Cost	Speed	SEO	Mobile	Security	Stats	Access	Ops
Website Grader	freemium	8	3	4	2	0	0	0
Nibbler	freemium	1	11	2	0	8	3	4
Lighthouse	free	16	13	4	PWA	0	16	4
Geekflare	free	42	5	2	28	4	2	14
Screpy	Pro $24/year	54	16	4	0	18	24	18

As can be seen in the table, no one tool dominates. Screpy comes close but falls down in Security checks like most of the other tools with notable exception of Geekflare. But all the tools are weak in mobile responsive tests although Lighthouse has a special PWA mobile testing option. But the real surprise is the solid coverage of Website Performance Speed and then SEO plus Analytics ; however that is a mixed blessing as we shall see below.

Website Security Measures

Given the average annual increase in malaware attacks of 20% for small to large businesses it is surprising to see so many overall website measurement tools having sparse coverage of website security. Fortunately, there a number of specialized Website Security tools. However these tools are themselves fairly mixed in their coverage of Website applications and their prices vary widely. Here are the major options of security services on offer. The table tells the story on how each Website Security tool implements these options:

Malaware Cleanslng- immediate vs a staged cleaning, removal from blacklists, cost on a fixed rate vs hourly fees;
Web App Firewall – identify /repel DDoS attacks, brute force login/entry attacks, Bot & zero-day defense, SQL/XSS injection blocks,
Security Center – Dashboard, continuing scan for malaware hidden at endpoints, scan for Owasp top 10 vulnerabilities, black/white list clients, IPs, Urls, Uptime tracking, Endpoint Detection, Fileless attacks
Systems Supported – All, PHP CMS, HTML/JS,/CSS, HTML/Java, Enterprise servers;
Extra Services – CDN-Content Delivery Network, DNS-Domain Name Services, Backup
Client device vs Server Security scans

Tool/Measure	Cost	Firewall	Malaware Cleansing	Security Center	Systems	Extras
Bitdefender	Pro $250/year 10Clients & 3 servers	Block Brute Force, DDoS, Net exploits	$100 clears PC spyware	Cloud or CSOC EAD & Monitors	All	3 Add-ons
CleanTalk	Pro – $104 /year/5 sites	Malaware scan for Net Infections	NA	Cloud	CMS PHP	Comment, registration, spam block
cWatch	Pro $95/website	DDoS BadBot blocks.Blacklist,	Fast, free	Cloud CSOC, EDR	CMS PHP. HTML	CDN, DNS
OneHourSiteFix	Pro – $65 /year/site	Block DDoS, BadBot , Net Infections	fast, $250 Blacklist Cleanup	Cloud Sharkgate	CMS PHP	Free virus scan
Shape	Pro NA	Block BatBot, &Cred Stuffing,	Malaware repair	Cloud Virus Scan, block scraping	All	NA
Sitelock	Pro $300/site/year	DDoS BadBot blocking	$200+ Malaware Repair and Hardening	Cloud EDR scan & repair	CMS PHP HTML	DB Tune, Backup,
Securi	freemium	DDOS. Blacklist Cleanup, Brute Force Block	6hr $200, Blacklist	Scanner DNS, SSL, checks etc	WP Plugin	CDN, SSL, Free virus scan
Wordfence	Pro $100 /site/year	54	16	ClientScan updated b	CMS WP	DB Assist

As web attacks have proliferated and spread from large to small business targets, serious CyberSecurity is taking hold in small as well as enterprise businesses. Here is a 12 point plan for better cyber security:

Use both client PC and Website server firewalls. These firewalls detect phishing, download infections, web browsing malaware. The server firewall should also block DDos and Bad Bot attacks,, repair SSL and patch vulnerabilities;
Have site wide scheduled server-side backups and transaction level triggered backup to Cloud/3rd party especially for eCommerce and multi-user websites;
Update programs, apps, themes, plugins, libraries, APIs and OS software on server side. [note some hosting servers are responsible for the bulk of these updates]. On client PCs keep OS, browser and integration apps up to date – most often users are responsible for these updates;
Use sitewide SSL/HTTPS for encrypted messaging to all clients and integrated servers; – this cuts off keylogging, cookie corruption and SSL edits by hackers;
Use validation procedures to verify all client form input is verified to stymie XSS and SQL injection efforts by hackers;
Have a cloud or central server CSOC- Cyber Security Operations Center to act as dashboard monitoring the state of a system using EDR-Endpoint Detection & Response plus Antivirus apps tracking & controlling Bad Bot Activity and DDoS -Distributed Denial of Service attacks;
Use CSOC dashboards to spot fileless scripting attacks and compromised boot/API libraries which can elude EDR systems;
Actively use Malaware Recovery and Ransomware Remediation methods to repair attacks both on Client PC and local net devices as well as main website servers systems. Expect the repair vendors to accomplish most repairs within 48 hours for about $250 per repair. Expect the repair to include removal of Blacklisting by Google, Facebook , Apple and other web agents;
Use strong passwords [10-12 chars, 1-3 numbers, 1-3 special case chars, lower & uppercase letters] like this example – Bettor[Passworts](99%0fthetyme]) with no reused passwords, Change them every 3-4 months;
Have a Cyber Crisis action plan to know what you are going to do in the case of cyber breach, debilitating DDos attack, BadBot breakthrough, ransom-ware incapacitation, malaware infection etc . Also know how to recover from blacklisting by Google or other Cyber-security vendors;
Never leave a network connected device unattended/unmonitored. as these are targets of Bot agents. Also never decommision a PC, server or database device without purging all network activations and cleansing all associated data storage; and thus closing out Malaware aggregators and competitive scrapers.
Keep customers, clients and staff informed on a quarterly basis of the latest cyber security alerts and mandates. As a $6 trillion industry , criminal and governmental hacking has plenty of cash and incentives to create new cyber exploits and malaware technology.

Note that active client and employees alertness to malaware is crucial to controlling data breaches and cyber attacks. Finally, for WordPress users there are several high quality freemium plugins for WordPress Security.. Or youcan do free web security scans with the 11 free web security scanners – check out Securi and Upguard for their detailed security reports. Be advised – all of the tests take 2-5 minutes.

Web Trends

Following web development and design trends is a major source of information on whats happening on the web. many design studio and development consultancies follow and gauge the latest websites for breakthough opportunities. Here are some examples: Awwwards provides a filtered grid gallery of best design websites sorted by style and technology:

Codrops is a playground, collective, and tutorial source for clever Web UI ideas and free code:

[iframe src=”https://tympanus.net/codrops/category/playground/” width=”100%”height=”750″] 3Digital has an annotated list of 30 latest web development practices:

[iframe src=”https://www.theedigital.com/blog/web-design-trends” width=”100%”height=”750″] SPINX shows a collection of top web designs from 2010 to 2020:

[iframe src=”https://www.spinxdigital.com/blog/top-10-website-designs-2020/” width=”100%” height=”750″] Lanars is a consultancy reporting on annual Web development trends:

[iframe src=”https://lanars.com/blog/top-web-development-trends” width=”100%”height=”750″] McAfee provides a Web security report annually charting the fast changing hacking scene;

In sum, there are a number of high quality resources for keeping track of the latest web design, development and security issues. The time spent often turns to be very useful.

Website Analytics & SEO

One of the key drivers and measures for the web has been Website Analytics and the associated SEO Optimizations. And so I have done due diligence and have started to identify 10 Great Google Analytics Alternatives and some key SEO Optimization Tools. But I paused and decided to let others have the pleasure of filling in the latest details on the Web at the Edge of the Darkside. There are 4 reasons for this. First, hacking is not just for criminals and goverments . Now corporates are attacking each other with classic hack attacks as seen in this report from Shape Security:

And the list of ever wider cyber security problems is menacing. Second, cookies are portrayed as benign and benevolent web traffic expediters. And for transient cookies that are purged when you exit from a browser this is true. Persistent cookies which are retained in a browser’s cookie library are cited as necessary to retain settings from session to session on a favored website. But persistent cookies may collect and then send a user’s session data back to the visited website without permission or explanation for the use of this private data. Then the users collected data may be shared with 3rd parties . Tracking cookies are the culmination of persistent cookies sleight of hand. In exchange for datae or services supplied to the the visitor, the visitor browsing actions will be made available to 3rd parties with out the visitors permissioin. Tracking cookies are at the shredded edge of privacy. Third, and very telling, tracking cookies plus the open sale of users web actions and data are part of the Google business model. Thus, Google Mail, Google Search, Google Analytics, Android location, and Google Maps data all are available throughout Google as well as being on sale. Yes, all the data have been dutifully anonymized but are available to third parties. The problem is that “anonymized “data can be linked up with numerous secondary sources. with IP address, name, telephone numbers etc gathered through scraping processes or purchases from data breaches and Malaware bots collections. Net result – you see ads suddenly popping up from Funeral Services two days after you mention the need to arrange a funeral . It is no surprise that Pew Research finds nearly 2/3rds of Americans feel they have no control over their web data’s privacy. So it should not be a surprise that Google has faced substantial antitrust and data privacy fines in Europe. The GDPR-General Data Privacy Rules in Europe have partly spread to North America because many websites are implementing the GDPR rules on all their sites . More ominous, Google is now facing bipartisan antitrust actions not just in Congress but in many US State governments. The US Justice Department is planning for broad antitrust action in early October. Given bipartisan support, there is a strong likelihood the way Google and other social media do business will be changed profoundly – privacy rules will likely follow the GDPR template. The net result is how Google Analytics and SEO Optimization work likely will change profoundly over the next year, So expect major changes in how Web Analytics operates in North America.

SEO Savvy Approach

Given the prospect for major changes in how Web Analyticsand SEO will be done in the near future, we present an approach to SEO that discounts keyword analysis , search position monitoring, or crawling and bots manipulation – rather it supports some key website marketing precepts. Major SEO players such as SearchEngineLand have recogmized a set of SEO Toxins and so are recommending more benign and beneficial methods as seen in their SEO Periodic Table infographic:

Thus, some alternative approaches such as external back links from trusted websites, timely updates to tutorial and help notes internal cross links among related website pages, and helpful surveys with timely responses – all of these soft marketing methods get strong promotion. So the following list of tools and consultants emphasize agents who will be able to assist in the with savvy strategies in the face of profound changes to Website Analytics & SEO:

- Ahrefs [$99/month] has 4 tools for SEO measurements. Site Explorer provide organic search traffic charts and backlink tallies for websites; Site Audit provides per webpage SEO perfomance reults; Rank Tracker reports your sites ranking over time and vis-a-vis your competitors; Content Explorer discovers and analyzes top-performing content in your niche.
- backlinkoo provides SEO insights and consulting well ahead of the curve :
- LinkResearchTools -[399euros] offers tools for Link Building and Monitoring, Link Detoxing, SEO Advisory plus free Chrome & Firefox extensions for link scanning;
- Moz Pro [$79/month] has top rated keyword management, page optimization, and site audit tools;
- NeilPatel sits in the middle with lots of keyword analysis but also Stewide SEO audits;
- Searchmetrics [89euros/month] provides PPC, SERP, & Ranking Research, Competiro,r and SEO Visibility;
- SEMRush [$167/month] has over 40 tools covering keyword management, SEO/PPC/SMM reports, Content Marketing projects, historical data analsis, etc.
- SEOQuake [free]is a Chrome extension acting as a SEO Toolbox with SERP Overlay, Traffic +Backlinks+Ads reports, and SEO Audit.
The challenge for website owners and developers is how they adapt to profound changes in the rules on client tracking. Already, the SEO community has shifted away from classic pay for placement and they will find they have to adapt to the new rules of the SEO road.

Website Performance Measures

There is a strong consensus among Web Developers and SEO Specialists that your Website’s loading speed is a vital component of your website’s success – equal to brand appeal and clarity plus service messaging strategies. The slider summarizes the key speed measures: [cycloneslider id=”10025″] But as you might expect, the web demands for brand appeal and specalized SEO & service delivery have worked in the past ten years against overall website performance speeds. The problem is the growth in webpage size. – from 700KB/wepage in 2010 to 3500KB /webpage in 2020 a 500% increase, Offsetting the increase in webpage size has bee a number of web system factors like yhr increase in WiFi Internet speed by a factor of 2, faster PC and server system, plus improved browser and server software speeds. But the bottom line is that without careful website performance tuning, heavy and complex page loads will make webpage response time sluggish and slow. Radware tracks the performance of the top 100 eCommerce sites showing the trend to more complex, heavier webpages. The breakout of webpage load growth for these top 100 websites is foretells broader web trends. Here is the data from 2010 to 2020 and it is imposing:

Image usage doubled from 416KB/webpage to 861KB;
JavaScript usage tripled from 113KB/webpage to 369KB;
HTML dropped slightly from 34KB/webpage to 30KB;
CSS usage doubled from 25KB/webpage to 52KB
But Font usage ballooned to 105KB/webpage from 2KB in 2010;
And Video usage skyrocketed from less tan 22KB/webpage to 2735KB.

The huge growth in video usage was powered by the move from desktop to mobile platforms as primary web browsing transitioned from desktop to mobile devices. Httparchive.org also shows that Server Requests/webpage load rose from 58 in 2010 to 85 in 2018 but then dropped to 70 in 2020 as web developers worked religiously to curtail the time penalfty costs of roundtrip imposed by server requests.

Given the complexity, changing composition, and growing load of webpages, the question is how do you measure and then optimize website performance. Two approaches have come to the fore. First, there are broad Website Key Performance Indicators which tell how well your overall website is operating- like average web page speed and visitor bounce rate. Second, there are detailed webpage performance metrics that guide how to optimize your individual webpages. Let us examine Website KPIs as they help to identify your plans for overall website improvements – i.e shaping website optimizations. This follows optimization best practices where you fix the broad website issues then focus in on speed problems on individual webpages. 4 levels of Web KPIs are recommended by consultants :

Audience Measures delineate key indicators:
- real visitors vs bot scanners or hackers seeking illegal access;
- new vs returning visitors including frequency and duration of visits
- bounce rate – no.of pages visited, duration and page spread [related pages visited],etc.
Traffic Sources – origin of visitors including organic direct connect, referral cross links, marketing campaigns, paid ads, social media links. Obtaining this data often requires privacy invasive use of cookies and other access method
Measure Conversions – product/service scans, signups for news letters /bulletins, info downloads, order cart activity including buys or cancels, warranty/support requests, etc;
Website Overall measures of performance;
- track your website’s uptime and the operational error rate of your website apps;
- measure and record app response time profiles on a daily, weekly, and product cycle basis;
- do biannual assessment of web delivery costs versus conversions and sales.
- adjust offerings and delivery accordingly.

But gathering Web Analytic KPIs have become tarnished and a pall has been cast ovr the data due to their semi-legal status and sources. And given approaching antitturst poceedings, organizations should rely on KPIs based on DIY self-tracking and audited financial summaries.

Fortunately there are benign sources of consistent and broad Website KPI. For many companies, their audited monthly and quarterly financial reports provides the starting point for consistent analysis of website systems. For example, the KPI page from the free WP Statistics plugin provides clean website performance data stored locally[hence less privacy comcerns].
There is a small set of WordPress Stats plugins that promise to protect the privacy of visitors data which is collected and use in their website usage reports.

Google PageSpeed Insights is easy to use, good advice, but sprawling

A big advanatge of PageSpeed insights is that it is from Google so it has mobile as well as desktop results. But PageSpeed Insights is sprawling with links to other Google website measures like Google Webmaster Central and Lighthouse. Unlike other tools, users are hunting and clicking around for key data, charts, and recommendations:Although the intention is right, the implementation is awkward.

Pingdom is also free, easy to use, and is crammed with data results, charts and tips

The only thing missing from free Pingdom is mobile website performance results. But Pingdom allows users to specify where the test are done in the world and allows for easy repeat tests: Here we see the summary performance results [an impressive sub 1 second load time and only 33 page requests and a lean 1.34MB page load of the gallery aided by lazy loading of the images as users scroll down the page]. And immediately blow there are suggested improvements to the page.

But for developers there are the loading charts for all the components – this reveals DNSLT, TTFP, TTI and other critical metrics used in page optimization:
These Pingdom charts may be Greek to the average website owner, but they are vital to Web developers doing the webpage tunings.

WebPageTest is free, has most complete setup with timeline charts, and advice

WebPageTest is crammed with charts and easily accessed tips – just click on the measure boxes in the upper right; However, like Pingdom, WebPageTest lacks mobile display benchmarking.
This tool is really geared for CDN and international website testing. Users can pick up to simultaneous web test locations for a complete, worldwide picture of how well your website is performing Note how PicsofUSA fails most of the CDN tests because it is currently only target NortAmerican users. But given the Gtranslate plugin that mission may change – and MicroPageTest should provide the insights on how to optimize for an international audience.

GTmetrix is a freemium, easy to use tool with lots of tips, data, and timeline charts

GTmetrix free version provides data, timeline charts and advisories for webpage performance:
GTmetrix has tips and tutorial associated with every data result and chart. Each of the page load timings in the above screenshot has a timely tutorial. And GTmetrix Pro adds 3 major features to the program : 1)continuous following of chosen webpages; 2)tracking of more webpages from multiple locations in the world; 3)Developer API allows tracking different display sizes including mobile and tablet displays. The price of the Pro version stretches from $14.95/month to $149.50. Bu as this performance tuning video shows the need for the pro version is not required for most webpage optimization

Uptrends is a premium continuous website monitoring service costing $100 to $1000/year

Uptrends is a paid performance monitoring tool with constant daily monitoring from multiple world-wide locations and for mobile through a variety of device sizes.

Yellow Lab Tools is a free, easy to use tester of desktop, tablet and mobile displays

Yellow Lab Tools provides webpage results for desktop, tablet and mobile views but does not allow configuration of testing browser or locatiom. Nonetheless, Yellow Lab Tools does provide graphic results and tipsJust click on any metric reading and Yellow Lab pops a full page avisory of what actions might be taken. Its tabletand mobile advisories are valuable.

DareBoost is a freemium web pagetester with add-on services

DareBoost is another example like GTmetrix and UPTrends of programs that offer good webpage testing but have expanded their offerings to complete website performance monitoring. I like the graphic report details:It is easy to see the First Byte, Start Render and FullyLoaded timings . But even more important the number of requests and total weight of the webpage has remained very low after problems with both measures before adding lazy loading, media optimization, and script combination. With DareBoost Pro it is possible to add broader website performance monitoring.

Free webpage tools often have Pro versions that add overall website performance monitoring to their feature sets. So these tools are vital to website performance tuning. But for webpage tuning users have a vital set of tools to identify where a webpage is under-performing. The data, charts and advisories are essential for making the many complex optimizations . So now the problem is to identify the best webpage performance tuningsto fix any speed problem,

Website Database Performance Measures

Of all the website systems elements, the underlying datadase is the least observed or aapreciated. Partially this comes from the fact that data storage in speed and capacity often available almost as a surplus. But despite this abundance, many web systems have huge BiG Data requirements and fast response tim needs. So website owners should track their database performance.

Here are some of the database monitoring system goals;

Uptime monitoring as indicated by slow or stalled processes; runaway programs. or crashed apps;
Monitor changes to the database including any apps or objects added, dropped, or modified;
Query monitoring for isubstandard operations due to inefficient query plans, nonexistent indexes,clashing apps;
Tracking resource capacity issues due to unmatched diskspace to CPU, memory or task time;
Monitor database logs: and hitorical data as key to proactive monitoring, because they contain critical information about where and why systems are under-performing or crashing;

And here are three top end database monitoring tools that can deliver many of the above features:

SolarWinds Database Performance Analyzer (DPA)
SolarWinds DPA is suitable for SQL Server, Oracle, IBM DB2, SAP ASE , MySQL and many more database engines. It takes a unique approach to database performance monitoring, with a focus on response time and multidimensional performance analysis. This tool ranks database response time as the primary metric.
dbWatch dbWatch is a Microsoft SQL Server, Sybase, Postgres, MariaDB, MySQL, and Oracle database activity monitoring tool. It has full support for AlwaysOn and RAC clustering, with on-premises, hybrid, or cloud Azure SQL support, making it a truly cross-platform program.
Opsview Opsview specializes in cloud monitoring tools supporting Oracle, MySQL, InfluxDB, SQL Server, and PostgreSQL Databases. However, Opsview features extensions or addons for monitoring AWS DynamoDB, DB2, Exchange, MariaDB, LDAP, plus capabilities for tracking applications, cloud-based services, networks, servers, and PC clients.

The top end database monitoring tools are geared towards large multi-database and multi-server networked and/or cloud based websites .The tools cost thousands of dollars and require broad training and a range of skills to use them successfully. See the following reviews from Comparitech and DNSStuff for for more details on the trade-offs among the top end DB-Monitoring tools.

Small Business Database Tools

But for the millions of small business websites more appropriate tools are represented by WordPress which currently has 65% market share of the top 10 million CMS websites world wide. A number of SMB website tools like Shopify, Squarespace , Weebly and Wix supply Cloud environs that take care of backups, updates [but not performance tuning, SEO diversity,, external integrations etc] for their users. So we identify some of the top WordPress Database tools. Most are freemium with strong free versions which will meet many WordPress basic database needs with pro options for special rquirements.

Duplicator[freemium $79/year for 15 sites] scheduled backups, , site cloning and migration – WPE banDuplicator emphasizes its scheduled backups in the Pro edition as much as its migrate and clone capabilities Again, if you choose the Pro edition, it saves to a wide array of Cloud services are. The migrationand clone tool has search and replace feature in the pro edition.
All-In-One WP-Migration[freemium $79/year for 15 sites] allows both selective backups & migrations. Kin ban
All-in-one WP Migration is one of the easiest plugins to setup for both backups[choice of database and/or themes +plugins and/or special files. For migrations you will need the Pro edition
Updraft+ [freemium – $57/year for 10 site] Database or full site backup or migration. Kin ban.Updraft offers scheduled database or full website backups to server or remote storage options such as MyDrive, Dropbox, Google Drive, Rackspace Cloud and Amazon S3 web services and its cloud storage 3rdparty apps. Databases can be encrypted prior to backup, Also offers Pro app for full website migration & cloning.
Boldgrid Total Upkeep[freemium $30/year for unlimited sites] scheduled backups with secure connnections
BoldGrid Total Upkeep offers secure connection to SFTP, Amazon S3, or Googlle Drive for backups which can be database or selected files. Total UpKeep also offers migration features including search and replace option. For $60/year get Total Upkeep, BoldGrid Post & PageBuilder, Easy SEO, 15 Cloud WordPress sites, BoldGrid Total Cache with Speed Coach
WP-DB Manager [free] cleans and backup database with drop/empty and other SQL queries enabled. WPE ban
WP-Optimize[freemium $59/year for 5 sites] compresses database and images, caches WP objects. KIN, WPE bansCleans database of selected trash, post/page revisions, ping & trackbacks, spam comments, and defragments MySql table. Schedules clean up scans and auto-compresses new Media Lirary image files after full library compression. Offers caching services with device specific and exclde list rule & triggers browser caching when allowed.
Participants Database [freemium]allows user to create their own forms and associated database tables

Query Monitor [free] developers fixed queries into all aspects of WordPress database
Query Monitor is the developer tools panel for WordPress. It enables debugging of database queries, PHP errors, hooks and actions, block editor blocks, enqueued scripts and stylesheets, HTTP API calls, and more.
Optimizing DB after Erasing Revisions [free] is a ‘One Click’ WordPress Database Cleaner / Optimizer Kin ban
The plugin deletes selected post/page/CPT revision,s spam comments, pimgbacks/trackbacks. ,trash, expired transients, and unused tags. This can be followed by a database optimization.
ARI Adminer[free]is a phpadmin-like MySQL tables manager. WPE banThis plugin is a delight for developers because they can see any and all of the MySQL tables used by the WP Core , theme, and plugins. Be careful though, misplaced editing of fields and/or tables can cripple your website.
wpDataTables
[freemium $59/year/1 site]plugin used
to create tables
& table charts from Excel,
csv

In general these database tools are geared for backend tasks like backup, security, and performance t. The enterprise tools are also geared towards monitoring multi-server networks while tracing changing operational demands. In contrast, the Website SEO & Analytics plus Website Performance tools are are geared to frontend concerns.

Summary

All of the tools and measures reviewed here are really designed to cope with the rapid changes and ever increasing complexity of operating on the Web. So like what is happening in Web Analytics expect profound shifts on how things are done on the Web.