database

Tips on using LocalWP sandboxing

LocalWP, known as Local and formerly Local by Flywheel, is a free, user-friendly and popular sandbox hosting environment for developing WordPress sites. Local sandboxes run directly on your workstations and are generally isolated to each machine as opposed to being available on the Internet. They also bundle useful features for site installation, migration, database administration, […]
WordCamp LAX 2020 presentation

Video on database cleanup, prune legacy plugin and theme cruft to free-up resources
WordPress Santa Clarita presentation

I’m presenting on the topic Database Cleanup at two events coming up. Everyone’s invited! The first venue will be WordPress Santa Clarita Valley Meetup the evening of Tuesday Sep 15th 7:00pm over Zoom. The second venue will be taking place mid October and will be announced soon…
WooCommerce Los Angeles presentation

Join WooCommerce Los Angeles Meetup back at WeWork Santa Monica Broadway on Wednesday, June 5th at 6:30pm for a demonstration session on database cleaning.
Cleaning up your WooCommerce database

There’s lots you can do to improve database (DB) performance, but each change comes with risks. Always thoroughly test changes in a development environment first before making permanent database changes in production. Growth in data requires a growth in hosting to handle the scale of database size and queries. There’s only so much you can […]
Exporting and importing orders

I was recently tasked with migrating a legacy WooCommerce store into a newer environment and database. Here’s a couple of approaches you can consider if faced with a similar project – full database migration versus exports/imports.