Tinydb 简明教程

TinyDB - Introduction

What is TinyDB?

用纯 Python 编程语言编写的 TinyDB 是一个轻量级文档数据库，没有外部依赖关系。它提供了易于使用的简单 API。我们无需任何配置即可将 TinyDB 数据库用于小型项目应用。

TinyDB, written in pure Python programming language, is a small and lightweight document-orineted database with no external dependencies. It provides simple APIs that makes it easy to use. We can use TinyDB database for small project applications without any configuration.

TinyDB 模块作为 Python 程序的第三方模块提供，可用于存储、检索和修改 JSON 格式的数据。

TinyDB module, available as a third-party module for Python programs, can be used to store, retereive, and modify the data in JSON format.

Features of TinyDB

TinyDB 是一个干净且操作起来轻松的数据库，可操作多种格式的文档。它具有以下特性。

TinyDB is a clean and hustle-free database to operate several formats of documents. It has the following features.

  1. Really tiny − TinyDB database is truly tiny in nature with only 1800 lines of code and 1600 lines tests.

  2. Easy to use − TinyDB is easy to use because of its simple and clean APIs.

  3. Document oriented − In TinyDB, we can store any document. The document will be represented as dict.

  4. Independent − The TinyDB database is independent of any external server and external dependencies from PyPI.

  5. Compatible with Python 3.6 or latest − TinyDB is tested and compatible with Python 3.6 and latest. It also works fine with PyPY3.

  6. Extensible − TinDB is easily extensible either by writing new storages or by modifying the behaviour of storages.

Advantages of TinyDB

TinyDB 为学生、用户和开发人员提供了许多好处。

TinyDB provide various benefits for students, users, and developers.

  1. TinyDB is open-sourced database aand it does not require any external configirations.

  2. It is quite easy-to-use, and the user can effortlessly handle documents.

  3. It automatically stores documents in the database.

  4. TinyDB is ideal in case of personal projects where we need to install some data.

  5. It is suitable for small applications that would be blown away by large databases like SQL or an external DB server.

  6. It uses a simple command line and query to operate data.

  7. There is 100% test coverage i.e., no explanation needed.

Limitatations of TinyDB

如果您需要以下内容，TinyDB 不是您项目的正确选择 −

TinyDB will not be the right choice for your project if you need to −

  1. create indexes for tables,

  2. manage relationships between tables,

  3. use an HTTP server, or

  4. access from multiple processors.

Comparison with Other Databases

下表重点介绍了 TinyDB 与 MySQL 和 Oracle 数据库的不同之处 −

The following table highlights how TinyDB is different from MySQL and Oracle databases −

Comparison Basis

MySQL

Oracle

TinyDB

Configurations

Several Configurations

Several Configurations

Less Configurations, lightweight database

Complicated

Yes

Yes

No, easy-to-use and hustle-free

Affordable

No

No

Affordable than other databases

Manageable

Big database, hence difficult to manage

Big database, hence difficult to manage

Small and manageable