我发现了python的GUID生成例程.
运行代码给我以下结果.
GUID: 00000129e0e72d9b2aab3c1500ac001000e90001 Time: Sat, 17 Jul 2010 09:55:33 (millis: 0.787) IP: 172.16.233.1 Counter: 715865109
此代码的注释具有以下消息.
### GUIDs make wonderful database keys. They require no access to the ### database (to get the max index number), they are extremely unique, and they sort ### automatically by time. GUIDs prevent key clashes when merging ### two databases together, combining data, or generating keys in distributed ### systems.
这适用于SQLite吗?据我所知,SQLite中的INTEGER类型是8字节,并且有8字节,因此无法以十进制值存储值0x00000129e0e72d9b2aab3c1500ac001000e90001或101362835865894089778560972572099193929729.
有没有办法在SQLite全局获取唯一ID?
mattmc3.. 12
除了占用32个字节而不是16个字节之外,在SQLite中将GUID存储为文本有什么问题?
除了占用32个字节而不是16个字节之外,在SQLite中将GUID存储为文本有什么问题?
好文章,以帮助您做出决定....
主键:ID与GUID:
http://www.codinghorror.com/blog/2007/03/primary-keys-ids-versus-guids.html