How to Delete Multiple Entries That Match a Given Regex in FaunaDB

This blog post should be a quick one. 

Long story short, I have a database in Fauna that contains loads upon loads of URLs. And for a reason I shall not disclose—though you are welcome to playfully speculate—I had to delete quite a few URLs from this database.

Here’s the problem: Fauna’s documentation sucks has room for improvement.

So allow me to spare you the half-hour it took me to figure out how to delete multiple entries from a database in Fauna. 

Really all you have to do is

1. Grab your `secret`, the name of your table, and your regex and plop them into the script below.

2. Profit.

I highly recommend printing the results first before deleting anything just to be sure that `results` contains the entries you indeed wish to delete. But beyond that, there’s not much else to do. The script below honestly boils down to initializing fauna and running a for-loop that deletes the entries that match the regex.

If you use fauna, I hope you found this helpful! I know I sure did. I’m currently keeping this script in my back pocket for a rainy day.