ElectricSQL Sync

ElectricSQL Sync 1.7.11 is an open-source, self-hosted PostgreSQL synchronization service designed for delivering real-time data from PostgreSQL databases to modern applications through a centralized sync API. It provides developers, system administrators, IT teams, and organizations with a flexible solution for synchronizing application data while retaining control over their database infrastructure and deployment environment.

Key Features of ElectricSQL Sync:

• Self-hosted PostgreSQL synchronization service accessible through HTTP-based APIs.
• Provides real-time synchronization between PostgreSQL databases and application clients.
• Supports partial data synchronization through the ElectricSQL Shape API.
• Uses PostgreSQL logical replication to monitor and synchronize database changes.
• Provides an HTTP-based API for requesting and consuming synchronized database data.
• Supports Docker-based deployment for simplified installation and management.
• Provides a lightweight synchronization layer suitable for cloud servers, virtual machines, and on-premises infrastructure.
• Helps developers build modern and local-first applications with continuously synchronized PostgreSQL data.
• Self-hosted deployment gives users greater control over synchronization services, database connectivity, and application infrastructure.
• Suitable for developers, system administrators, IT teams, organizations, and businesses requiring PostgreSQL data synchronization.

ElectricSQL Sync Usage:

 
$ sudo su 
$ cd /opt/electricsql 
 
Check ElectricSQL Sync service: 
sudo docker compose ps 
 
Check ElectricSQL Sync version:
sudo docker logs electric 2>&1 | grep -m1 "Starting ElectricSQL"
 
Check ElectricSQL Sync image:
sudo docker inspect electric --format '{{.Config.Image}}'
 
Check ElectricSQL Sync API: 
curl -i "http://YOUR_SERVER_IP:5133/v1/shape?table=test&offset=now&secret=YOUR_ELECTRIC_SECRET" 
 
Access the ElectricSQL Sync API: 
http://YOUR_SERVER_IP:5133/v1/shape?table=test&offset=now&secret=YOUR_ELECTRIC_SECRET 
 
  

Disclaimer:
ElectricSQL Sync is an open-source project maintained by its developers and community contributors and is not affiliated with or endorsed by Microsoft Azure or any other cloud provider. Users are responsible for configuring network access, authentication, security settings, firewall rules, application dependencies, licensing requirements, data retention policies, backup procedures, and user access controls when deploying and using ElectricSQL Sync in a cloud environment.