I use this to manage temporary data quite a bit – for example, server logs of a chat, where you only want to keep the X most recent – after every write, or as a scheduled task, I delete all but the last 10. Here’s a query to do that simply (obviously you could use SELECT or UPDATE instead of DELETE… the principal is the same):