The Sqlite3 database of the whole Tang Dynasty

: http://pan.baidu.com/s/1b2mE54

Quantangshi.db is the Sqlite3 database, including 2 tables.

Index Table:
The volume column (integer, primary key) represents the volume number, from 1 to 900 for a total of 900 volumes.
The comment column (string) indicates the volume name, such as "Li Bai", and the volume name will appear duplicated.

Poem Table:
ID column (integer, primary key) in this database ordinal, from 1 to 42986. ID has been sorted by volume, sequence, 1th of the 1th, the ID is 1, and the last one of the last volume is 42986.
The volume column (integer, indexed) belongs to the first volume.
Sequence column (integer, indexed) in the ordinal of this volume, starting with a value of 1.
Title column (string, indexed) poem name
Author column (string, indexed) author
Text column (string) contents

Note:
The database has been compressed by a vacuum command.

File Size: 15.4 MB
md5:8a18d363f3a89e3954a6414ce3512f6d
sha1:d02a414a7b135cf059eaaa8118debe39ab94a354

Data Source:
http://www16.zzu.edu.cn/qts/(Zhengzhou University website)
The poetry of Tang Dynasty, a total of 2,529 poets, 43,430 poems, a total of 900 volumes.

The Sqlite3 database of the whole Tang Dynasty