github.com
How can it be used effectively?Use database replication. From your main website to your local instance. This way you have your articles instantly on your local server.
If you have dynamic IP at your home you might want to use a DDNS service.
I can suggest you this Ludicrousdb for replication.
GitHub - stuttter/ludicrousdb: LudicrousDB is an advanced database interface for WordPress that supports replication, failover, load balancing, & partitioning
LudicrousDB is an advanced database interface for WordPress that supports replication, failover, load balancing, & partitioning - stuttter/ludicrousdb
A way to quickly send data from your live WordPress site to your local setup without using plugins is to manually export the live site's database and import it into your local setup.
import os
# Export live site's database
os.system("mysqldump -u {user} -p{password} {database} > live_site_db.sql")
# Import exported database into local setup
os.system("mysql -u {user} -p{password} {database} < live_site_db.sql")
# Replace live site's URL with local site's URL
os.system("sed -i 's/{live_site_url}/{local_site_url}/g' {database}")
# Update wp-config.php file with correct database information
from wpconfig import WPConfig
config = WPConfig(path='path/to/wp-config.php')
config.set_db_name('{database}')
config.set_db_user('{user}')
config.set_db_password('{password}')
config.save()mysqldump, mysql, sed and python libraries os, wpconfig installed on your machine before running the script.
