[sqlite] canonical new u1db and sqlite

[sqlite-us...@h-rd.org]

Hi,

Canonical ha released a first prototype of u1db, a sqlite based  
document db which is syncable.  Somehow this reminds me of a  
combination of the fossil db model and unql and unqlspec.  Is there a  
relation between the projects?


thanks,



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] status of unqlspec / sqlite

[sqlite-us...@h-rd.org]

Hi,

some time ago Richard was involved in http://www.unqlspec.org/ .  Is  
that still going on?  I am quite interested in a backend for sqlite.


thanks,

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Virtual Tables and tcl / apsw

[sqlite-us...@h-rd.org]

Hi,

I have some questions on virtual tables and tcl compared to perl and  
python/apsw.


As I understand you can build your own virtual table implementation  
with apsw (and also with perl).  Is this also possible with tclsqlite?

Any pointers greatly appreciated, I could not find it in the docs.

A bit related is a question on the vfs.  apsw allows to implement a  
vfs.  Is this also possible with tcl?


thanks,


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] uuid generation in sqlite

[sqlite-us...@h-rd.org]

Hi,

I have put together a simple uuid generation method in sqlite:

  select '{' || hex( randomblob(4)) || '-' || hex( randomblob(2))
 || '-' || '4' || substr( hex( randomblob(2)), 2) || '-'
 || substr('AB89', 1 + (abs(random()) % 4) , 1)  ||
 substr(hex(randomblob(2)), 2) || '-' || hex(randomblob(6)) || '}';

It's based on the description for v.4 uuid's in wikipedia
https://secure.wikimedia.org/wikipedia/en/wiki/Uuid .

But I am thinking there may be a better (or another) method to do this  
in sqlite, without the need to use something external?

thanks

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users