+
+

Related Products

  • AdRem NetCrunch
    165 Ratings
    Visit Website
  • DbVisualizer
    593 Ratings
    Visit Website
  • Google Cloud SQL
    554 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • ZenTreasury
    9 Ratings
    Visit Website
  • EazyStock
    65 Ratings
    Visit Website
  • New Relic
    2,941 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • MikMak
    85 Ratings
    Visit Website
  • LeaseAccounting.app
    Visit Website

About

PawSQL integrates the best practices of query optimization in database industry, provides advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries. Based on the professional PawSQL optimization engine (used by more than 10,000 database practitioners around the world), it provides rich SQL optimization suggestions and intelligent index recommendations. PawSQL provides a comprehensive and balanced audit rule set for multiple databases such as MySQL, PostgreSQL, openGauss, Oracle, etc., providing enterprises with a consistent audit experience no matter how diverse their database environment is. Rule-based SQL review, covering potential correctness and performance optimization issues. Rich rewrite optimization, recommending semantically equivalent but more efficient SQL queries. Cost-based verification ensures that new solutions based on SQL rewrite and index recommendation have better performance. Intelligent index recommendation.

About

ScaleGrid is a fully managed Database-as-a-Service (DBaaS) platform that helps you automate your time-consuming database administration tasks both in the cloud and on-premises. Easily provision, monitor, backup and scale your open source databases with high availability, advanced security, full superuser and SSH access, query analysis, and troubleshooting support to improve the performance of your deployments. Supported databases include: - MySQL - PostgreSQL - Redis™ - MongoDB® database - Greenplum™ (coming soon) The ScaleGrid platform supports both public and private clouds, including AWS, Azure, Google Cloud Platform (GCP), DigitalOcean, Linode, Oracle Cloud Infrastructure (OCI), VMware and OpenStack. Used by thousands of developers, startups, and enterprise customers including Atlassian, Meteor, and Accenture, ScaleGrid handles all your database operations at any scale so you can focus on your application performance.

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Individuals looking for query optimization in database industry, advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries

Audience

Database Administrators (DBA), Developers, DevOps Engineers

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

Support

Phone Support Not Supported
24/7 Live Support Supported
Online Supported

API

Offers API Supported

API

Offers API Not Supported

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version Supported
Free Trial Not Supported

Pricing

$8 per month
Free Version Not Supported
Free Trial Supported

Reviews/Ratings

Overall 5.0 / 5
ease 5.0 / 5
features 5.0 / 5
design 4.0 / 5
support 3.0 / 5

Reviews/Ratings

Overall 5.0 / 5
ease 4.7 / 5
features 4.3 / 5
design 4.7 / 5
support 4.3 / 5

Pros & Cons from Real Users

Pros

  • 1. Comprehensive Database Support: PawSQL supports a variety of database systems, including MySQL, PostgreSQL, OpenGauss, and more, providing a consistent auditing experience across diverse database environments 2. Advanced Parsing Capabilities: PawSQL demonstrates excellent parsing abilities, capable of handling all tested SQL statements without issues 3. High-Accuracy Warnings: PawSQL provides SQL warnings or tips with high precision, focusing not only on the correctness of SQL statements but also offering performance optimization rules and potential correctness issues 4. Optimization Suggestions: PawSQL offers query rewrite optimization and intelligent index recommendations, helping developers and DBAs solve SQL performance issues in a one-stop manner 5. Performance Verification: PawSQL provides a What-If performance verification feature, offering an analyze option to obtain the actual parsing and execution cost of SQL, avoiding the shortcomings of MySQL's explain for intermediate result tables and providing more accurate cost estimation

Cons

  • PawSQL doesn't support SQL Server yet, and little support for HIVE SQL.

Pros & Cons from Real Users

Pros

  • Setup is a breeze. Easily add firewall rules Easily add or remove users. Fast support and possibility to bring your own aws cloud etc when you are really scaling etc.
  • So simple to setup and manage our databases. We've luckily not had to use the automated failover in production, but tested it rigorously before deploying. It couldn't be easier to manage and setup. The alert system is amazing as well.
  • I am a scientist who has no formal training in computer science or databases. I needed to create a MySQL database to store a large amount of training data for a machine learning project. I found AWS to be overly complicated and overpowered for my needs. ScaleGrid offered an affordable solution with a web interface and very responsive support. I highly recommend them.

Cons

  • - it's a bit costly for minimum plan being 10$ It is costly for starters but if you are about to scale it makes sense to use it.
  • I honestly don't have a single con for moving to ScaleGrid. It was so simple.
  • It would be helpful to have a bit more documentation about how to manage backups, get more disk space, and use the web console. It is all probably self-evident to database gurus, but for non-experts like me, documentation would be very helpful.

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Training

Documentation Supported
Webinars Supported
Live Online Supported
In Person Supported

Company Information

PawSQL
Founded: 2024
China
www.pawsql.com

Company Information

ScaleGrid
Founded: 2012
United States
scalegrid.io

Alternatives

Alternatives

ClusterControl

ClusterControl

Severalnines
SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

Categories

Categories

Database Monitoring Features

Anomaly Detection Supported
Autodiscovery Supported
Capacity Planning Supported
Dashboard Supported
Dependency Tracking Supported
Historical Trend Analysis Supported
Multitenancy Supported
Notifications / Alerts Supported
Performance Monitoring Supported
Permissions / Access Controls Supported
Predictive Analytics Supported
Prioritization Supported
Query Analysis Supported
Resource Optimization Supported
Troubleshooting Supported

Application Performance Monitoring (APM) Features

Baseline Manager Not Supported
Diagnostic Tools Supported
Full Transaction Diagnostics Not Supported
Performance Control Supported
Resource Management Supported
Root-Cause Diagnosis Supported
Server Performance Supported
Trace Individual Transactions Not Supported

Database Features

Backup and Recovery Supported
Creation / Development Supported
Data Migration Supported
Data Replication Supported
Data Search Supported
Data Security Supported
Database Conversion Supported
Mobile Access Supported
Monitoring Supported
NOSQL Supported
Performance Analysis Supported
Queries Supported
Relational Interface Supported
Virtualization Supported

Database Backup Features

Automatic Backup Supported
Backup Locations Supported
Backup Scope Settings Supported
Differential Backup Supported
Filegroup Backup Supported
Full Backup Supported
Incremental Backup Supported
Manual Backup Supported
Multiple Backups Supported

DevOps Features

Approval Workflow Not Supported
Dashboard Supported
KPIs Supported
Policy Management Not Supported
Portfolio Management Not Supported
Prioritization Not Supported
Release Management Not Supported
Timeline Management Not Supported
Troubleshooting Reports Supported

NoSQL Database Features

Auto-sharding Supported
Automatic Database Replication Supported
Data Model Flexibility Supported
Deployment Flexibility Supported
Dynamic Schemas Supported
Integrated Caching Supported
Multi-Model Supported
Performance Management Supported
Security Management Supported

Relational Database Features

ACID Compliance Supported
Data Failure Recovery Supported
Multi-Platform Supported
Referential Integrity Not Supported
SQL DDL Support Supported
SQL DML Support Not Supported
System Catalog Not Supported
Unicode Support Not Supported

Integrations

MySQL Supported
PostgreSQL Supported
Akamai Cloud Not Supported
Amazon Web Services (AWS) Not Supported
DataGrip Supported
DigitalOcean Not Supported
Google Cloud Platform Not Supported
Greenplum Not Supported
MariaDB Supported
Microsoft Azure Not Supported
MongoDB Not Supported
Opsgenie Not Supported
Oracle Cloud Infrastructure Not Supported
Oracle Database Supported
PagerDuty Not Supported
Redis Not Supported
Slack Not Supported
VMware Cloud Not Supported

Integrations

MySQL Supported
PostgreSQL Supported
Akamai Cloud Supported
Amazon Web Services (AWS) Supported
DataGrip Not Supported
DigitalOcean Supported
Google Cloud Platform Supported
Greenplum Supported
MariaDB Not Supported
Microsoft Azure Supported
MongoDB Supported
Opsgenie Supported
Oracle Cloud Infrastructure Supported
Oracle Database Not Supported
PagerDuty Supported
Redis Supported
Slack Supported
VMware Cloud Supported
Claim PawSQL and update features and information
Claim PawSQL and update features and information
Claim ScaleGrid and update features and information
Claim ScaleGrid and update features and information