The WordPress.com developer docs provide under Studio> FAQs the section on “How can I manage the Studio site’s SQLite database?“. It lists the details of how to use SQLite tools with your Studio Site. I found them sufficient as they remove all barriers to be successful.
The database of each Studio site is located in the folder wp-content/database as a hidden file .ht.sqlite`.
Two ways are recommended for managing the SQLite database files on your computer: SQLite3 or SQLiteStudio
sqlite3
sqlite3 is a command line tool and comes preinstalled on a Mac.
sqlite3 wp-content/database/.ht.sqliteAlthough I am a fan of command line tools, for database handling I like to have a GUI and as my typing skills are not the best.
The screenshot shows you a list of usage hints after you invoke sql3lite .ht.sqlite from within the database folder of your Studio site and type “.help”.
SQLiteStudio
After a download of SQLiteStudio you might get a warning from Apple that it can’t verify the file, so it won’t open the installer. If that’s the case, got to your Settings > Security screen and scroll to section where it lists which file it blocked. You can click on Open Anyway to continue with the installation.
After I successfully installed it, I opened it and with a drag and drop of the file /wp-content/database/.ht.sqlite in the left sidebar, I was able to connect the SQLite Studio with the database from Studio.
In below video you see me clicking through some of the screens, to open a table, look at the data, or the structure, and then hover over some of the buttons. I also found the SQL editor I can use to create queries on the raw data.
Leave a Reply