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
-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
-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
> 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
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
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
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
-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
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
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
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
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
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
13 matches
Mail list logo