Re: [sqlite] Sync SQLite with smartphones?

2010-10-03 Thread Gilles Ganault
On Sun, 3 Oct 2010 17:07:04 +0100, Simon Slavin wrote: >There are several tools around to synchronise specific databases, >and they depend on knowing how those specific databases work > and what the data means. But devising a general synch tool that > would be useful for every database is far mor

Re: [sqlite] SQLite working with C++'s iostream

2010-10-03 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/03/2010 10:03 AM, Pierre Krieger wrote: > For example a stream which handles a simple ROT-13 "encryption" can > be written in ten minutes (if you know the internals of the iostream library) My Python wrapper has this functionality as an example

Re: [sqlite] SQLite working with C++'s iostream

2010-10-03 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/03/2010 09:31 AM, Pierre Krieger wrote: > Anyway I don't think about using this code in a real program for the > moment, I just made it because of my love for modularity and because it > looked like a nice idea It is a good idea and the use case

Re: [sqlite] SQLite working with C++'s iostream

2010-10-03 Thread Pierre Krieger
> That's going to be problematic, because almost all of SQLite's usage > of underlying I/O is block-style, not stream-style, more akin to > accessing elements in a persistent byte array (with other practical > matters added on, of course) than to reading and writing streams. > You'd probably be bet

Re: [sqlite] SQLite working with C++'s iostream

2010-10-03 Thread Drake Wilson
Quoth Pierre Krieger , on 2010-10-03 18:31:41 +0200: > But the main reason why I would use streams is for other things like > reading data from a socket or decrypting a file on-the-fly for example > (these are just ideas) That's going to be problematic, because almost all of SQLite's usage of und

Re: [sqlite] SQLite working with C++'s iostream

2010-10-03 Thread Pierre Krieger
Thanks for answering > You claim that documentation is missing.  Specifically what was not > documented? Well I was referring to the online documentation (sqlite.org/c3ref/vfs.html and sqlite.org/c3ref/io_methods.html) which don't explain the effects, possible return codes, etc. of some of the f

Re: [sqlite] Sync SQLite with smartphones?

2010-10-03 Thread Simon Slavin
On 3 Oct 2010, at 11:50am, Gilles Ganault wrote: > I was wondering if someone came up with a tool to sync an SQLite > database with smartphones (Blackberry, iPhone, Android, etc.)? Synching two copies of a database is extremely complicated. If you treat the entire database as a file, and just

Re: [sqlite] SQLite working with C++'s iostream

2010-10-03 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/03/2010 12:25 AM, Pierre KRIEGER wrote: > I made my own implementation You claim that documentation is missing. Specifically what was not documented? BTW for SQLITE_GET_LOCKPROXYFILE just Google "sqlite SQLITE_GET_LOCKPROXYFILE". You should

Re: [sqlite] TestFixture 3.7.2 - Some WAL tests fail on QNX OS

2010-10-03 Thread Raj, Praveen
Hi, Yes the files sizes of "test.db", "test.db-wal" and "test.db-shm" are 1024, 4333512 and 65536 bytes respectively as specified below. Most of the test scripts are failing when the -shm file size grows from 32kb to 64kb (though the "test.db-wal" file size varies for different test scripts). B

Re: [sqlite] EXTERNAL:Re: FTS Question

2010-10-03 Thread Black, Michael (IS)
OK...that make sense...so i hook up my own tokenizerthen how do I allow the hyphen to really mean hyphen and not "NOT". I would've expected "play-off" to be ok and "play -off" to be the NOT operator. Is there some reason why whitespace isn't being taken into account to determine the meani

[sqlite] Atomic commit assumptions regarding underlying writes

2010-10-03 Thread Drake Wilson
Here's two parts of the doc on atomic commit behavior in SQLite, from http://sqlite.org/atomiccommit.html as retrieved on 2010-10-03. Section 2.0, "Hardware Assumptions", states: | SQLite does not assume that a sector write is atomic. However, it does | assume that a sector write is linear. By "li

[sqlite] Sync SQLite with smartphones?

2010-10-03 Thread Gilles Ganault
Hello I was wondering if someone came up with a tool to sync an SQLite database with smartphones (Blackberry, iPhone, Android, etc.)? I've read about SyncML and OpenSync, but they seem to be still under development. Thank you. ___ sqlite-users mailing

[sqlite] SQLite working with C++'s iostream

2010-10-03 Thread Pierre KRIEGER
Hi, Two days ago I asked a question on stackoverflow.com about how to make SQLite interface with C++'s streams Here is the link: http://stackoverflow.com/questions/3839158/using-sqlite-with-stdiostream Since nobody answered, I made my own implementation (you can see its source code on the same p