我找到了
GUID generation routine with python.
运行代码给我以下结果.
- 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？
除了占用32个字节而不是16个字节之外,在sqlite中将GUID存储为文本有什么问题？
