* .sqlite和* .db文件有什么区别? [英] What is the difference between *.sqlite and *.db file?

问题描述

*.sqlite和*.db文件之间有什么区别?

What is the difference between a *.sqlite and a *.db file?

推荐答案

您可以根据需要命名SQLite数据库.内容不是由文件结尾决定的，而是由每个SQLite开头的字节顺序确定的. 3)文件:

You can name your SQLite database whatever you want. The content is not determined by the file ending but by a sequence of bytes which start every SQLite (3) file:

0x53 0x51 0x4c 0x69 0x74 0x65 0x20 0x66 0x6f 0x72 0x6d 0x61 0x74 0x20 0x33 0x00

是ASCII的

• SQLite format 3

换句话说，它可能是相同的数据库内容.没有什么区别，只要创建者没有在其中放入其他字节即可.

In other words, it could be the same database content. There is no difference, as long as the creator did not put other bytes in it.

如果要查看它是否是SQLite 3数据库，请在hexeditor中打开该文件，然后查找上面的字节，或者直接使用SQLite驱动程序将其打开.

If you want to see if it is a SQLite 3 database, open the file in a hexeditor and look for the byte above or simply open it with the SQLite driver.

这篇关于* .sqlite和* .db文件有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！