TinyDB – Upserting Data We discussed the update and insert queries, but sometimes, we a need a mix of both update and insert. In such cases, TinyDB provides a unique upsert query. This query helps us to insert and update data at a time as per the condition. It works in two ways − If […]
TinyDB – Retrieving Data After creating a database, we need to frequently retrieve the data from that database. Following are the ways by which we can reterive the data from a database − The len() Query With the help of this query, we can get the number of documents in a database. Its syntax is […]
TinyDB – Storage Types TinyDB has two types of storage: JSON and in-memory. TinyDB, by default, stores the data in JSON files. While creating a database, you need to specify the path where to store the JSON file on your computer. Storing Data in a JSON File First, let”s see how we can use a […]