Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Description

EMS SQL Management Studio for PostgreSQL offers a comprehensive suite for the administration and development of PostgreSQL databases. This all-in-one workbench equips users with essential tools for a variety of tasks, including managing databases and their components, designing databases, performing migrations, and building queries, as well as facilitating data import and export, comparing databases, and executing service tasks. Users can efficiently access and manage all databases and their associated objects through a streamlined console that features an intuitive interface. The software allows for the creation and modification of server and database objects, while enabling users to set required properties and examine detailed information using advanced visual editors. Additionally, with the Compare databases feature, users can automatically transfer structural changes from development environments to production databases. Users can also generate ER diagrams for newly constructed databases, facilitating expedited deployment. Setting up database maintenance tasks is made simple with advanced options, allowing SQL Studio to execute them on a regular schedule, ensuring optimal performance and reliability. This tool not only enhances productivity but also streamlines database management processes significantly.

Description

When PostgreSQL serves as the foundation of your enterprise and is a key data source, PeerDB offers an efficient, straightforward, and economical solution for replicating data from PostgreSQL to data warehouses, queues, and storage systems. It is engineered to function seamlessly at any scale and is specifically adapted for various data repositories. By utilizing replication messages sourced from the PostgreSQL replication slot, PeerDB adeptly replays schema updates while providing alerts for slot growth and active connections. It also includes native support for PostgreSQL toast columns and large JSONB columns, making it particularly advantageous for IoT applications. The platform features an optimized query architecture aimed at minimizing warehouse expenditures, which is especially beneficial for users of Snowflake and BigQuery. Additionally, it accommodates partitioned tables through both publication mechanisms. PeerDB ensures rapid and reliable initial data loads via transaction snapshotting and CTID scanning techniques. With features such as high availability, in-place upgrades, autoscaling, advanced logging, comprehensive metrics, and monitoring dashboards, as well as burstable instance types, it is also well-suited for development environments. Overall, PeerDB stands out as a versatile tool that effectively meets the diverse needs of modern data management.

API Access

Has API No 

API Access

Has API No 

Screenshots View All

Screenshots View All

Integrations

PostgreSQL Yes 
Apache Kafka No 
Azure Event Hubs No 
ClickHouse No 
GitHub No 
Google Cloud BigQuery No 
IBM Db2 Yes 
InterBase Yes 
MariaDB Yes 
MySQL Yes 
Oracle Database Yes 
PubSub+ Platform No 
SQL Server Yes 
Snowflake No 

Integrations

PostgreSQL Yes 
Apache Kafka Yes 
Azure Event Hubs Yes 
ClickHouse Yes 
GitHub Yes 
Google Cloud BigQuery Yes 
IBM Db2 No 
InterBase No 
MariaDB No 
MySQL No 
Oracle Database No 
PubSub+ Platform Yes 
SQL Server No 
Snowflake Yes 

Pricing Details

$260 one-time payment
Free Trial Yes 
Free Version No 

Pricing Details

$250 per month
Free Trial Yes 
Free Version No 

Deployment

Web-Based Yes 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows No 
Mac No 
Linux No 
Chromebook No 

Deployment

Web-Based Yes 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows No 
Mac No 
Linux No 
Chromebook No 

Customer Support

Business Hours Yes 
Live Rep (24/7) No 
Online Support Yes 

Customer Support

Business Hours No 
Live Rep (24/7) Yes 
Online Support Yes 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) No 
In Person No 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) Yes 
In Person No 

Vendor Details

Company Name

EMS Software

Founded

1986

Country

United States

Website

www.sqlmanager.net/products/postgresql/studio

Vendor Details

Company Name

PeerDB

Country

United States

Website

www.peerdb.io

Product Features

Database

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

Product Features

Data Replication

Asynchronous Data Replication No 
Automated Data Retention No 
Continuous Replication No 
Cross-Platform Replication No 
Dashboard No 
Instant Failover No 
Orchestration No 
Remote Database Replication No 
Reporting / Analytics No 
Simulation / Testing No 
Synchronous Data Replication No 

Database

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

Alternatives

Alternatives

Database X-Ray Reviews

Database X-Ray

Murray Hill Technologies
AlloyDB Reviews

AlloyDB

Google
SQLGate Reviews

SQLGate

CHEQUER
DBeaver Community Reviews

DBeaver Community

DBeaver Corp.