+
+

Related Products

  • AdRem NetCrunch
    158 Ratings
    Visit Website
  • DbVisualizer
    583 Ratings
    Visit Website
  • Google Cloud SQL
    553 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,017 Ratings
    Visit Website
  • Windocks
    7 Ratings
    Visit Website
  • ZenTreasury
    9 Ratings
    Visit Website
  • New Relic
    2,923 Ratings
    Visit Website
  • EazyStock
    65 Ratings
    Visit Website
  • RaimaDB
    12 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
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

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
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version
Free Trial

Pricing

$8 per month
Free Version
Free Trial

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
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

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
Autodiscovery
Capacity Planning
Dashboard
Dependency Tracking
Historical Trend Analysis
Multitenancy
Notifications / Alerts
Performance Monitoring
Permissions / Access Controls
Predictive Analytics
Prioritization
Query Analysis
Resource Optimization
Troubleshooting

Application Performance Monitoring (APM) Features

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

Database Features

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

Database Backup Features

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

DevOps Features

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

NoSQL Database Features

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

Relational Database Features

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

Integrations

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

Integrations

MySQL
PostgreSQL
Akamai Cloud
Amazon Web Services (AWS)
DataGrip
DigitalOcean
Google Cloud Platform
Greenplum
MariaDB
Microsoft Azure
MongoDB
Opsgenie
Oracle Cloud Infrastructure
Oracle Database
PagerDuty
Redis
Slack
VMware Cloud
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