Python结合TinyDB如何获取最后插入的数据行？

Great question! Grabbing every single record just to pull the last one is such a waste of resources, especially as your TinyDB grows over time. Let me walk you through a couple of far better solutions:

1. Use TinyDB's Auto-Incrementing doc_id (Most Efficient) #

Every time you insert a document into TinyDB, it automatically assigns a unique, incrementing doc_id to it. That means the last inserted document will always have the largest doc_id in the database.

The fastest way to fetch it is by using TinyDB's internal _last_id property — this directly holds the value of the most recently assigned doc_id, so you don't have to iterate over any records at all:

# Get the last inserted document in O(1) time
last_row = db.get(doc_id=db._last_id)

Quick note: While _last_id is an internal attribute, it's been stable across all recent TinyDB versions. If you want to avoid relying on internal properties for extra safety, you can find the maximum doc_id with a lightweight iteration (still way better than loading all records):

from tinydb import Query

Item = Query()
# Find the highest doc_id by iterating only over document IDs
max_doc_id = max(doc.doc_id for doc in db)
last_row = db.get(Item.doc_id == max_doc_id)

2. Add a Timestamp on Insert (For Flexible Scenarios) #

If you ever need more control (like if you might manually modify doc_ids later, or need to track creation time for other queries), you can add a created_at timestamp to each document when inserting it. Then you can sort by this timestamp to get the latest entry:

from datetime import datetime

# Insert data with a creation timestamp
new_entry = {
    "your_field": "your_value",
    "created_at": datetime.now().isoformat()
}
db.insert(new_entry)

# Fetch the latest entry by sorting timestamps in reverse order
last_row = db.all(sorted_by=lambda x: x["created_at"], reverse=True)[0]

This approach is less efficient than using doc_id (since it still sorts all records), but it's useful if you need timestamp-based tracking for other parts of your app.

Final Recommendation #

Stick with the first method using db._last_id — it's the fastest, simplest, and most resource-efficient way to get the last inserted record without loading your entire database into memory.

内容的提问来源于stack exchange，提问作者TheDragoner