[sqlite] Segmentation faults when calling sqlite3_step

2015-06-30 Thread Leroy Klompenhouwer
Eric, We don't use text or blob fields only double, int and int64 types. Can we assume that all the other binds besides the text and blob are directly copied? Leroy -Oorspronkelijk bericht- Van: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglis

[sqlite] Question about getting size of stored data

2015-06-30 Thread Jean Chevalier
Today, Michael asked: > > I tried the following, but it returns different sizes every time. But my test data is the same so I think it should have the same size. > ... > Can you help me to get the size of 1 row? Is it possible? > Hi Michael, Have you read all about the SQLite Database File Form

[sqlite] Question about getting size of stored data

2015-06-30 Thread Simon Slavin
On 30 Jun 2015, at 1:44pm, m.g.001 wrote: > I tried the following, but it returns different sizes every time. But my > test data is the same so I think it should have the same size. What do you mean by "my test data is the same" ? Are you saying you have a table with two rows which have ident

[sqlite] Segmentation faults when calling sqlite3_step

2015-06-30 Thread Leroy Klompenhouwer
We are experiencing random segmentation faults when calling the function sqlite3_step(). We use prepared statements in a transaction to insert records in the database. We have the following setup: - SQLite3.8.9 - Linux 32bit - Armv6 - SDCard with ext3 to store the database ? Can anyone expla

[sqlite] Question about getting size of stored data

2015-06-30 Thread m.g.001
Hello, I am new to this mailinglist. I think I have to send my question here. My Name is Michael and I come from Germany. At the moment I develope a few android apps for my study. Is it possbile to get the size of one stored row inside my sqlite database? I tried the following, but it return

[sqlite] Segmentation faults when calling sqlite3_step

2015-06-30 Thread Eric Hill
If you are calling sqlite3_bind_ to bind parameters, what are you passing as the last parameter? Try SQLITE_TRANSIENT to force SQLite to make a copy of the value right away. Maybe currently you have values going out of scope before step is called. Eric From

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-30 Thread da...@andl.org
It's usually pretty safe to ignore what the law has to say about copyright, because by the time that matters you would have to be dealing with lawyers. That's not the problem. What you seriously want to avoid is doing things that attract the attention of lawyers, because they have a habit of makin

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-30 Thread Stephen Chrzanowski
There are a few posts in this mailing list that have people putting up public domain database structures, with data, for different things to track. Google search also has come up with a few out there as well, but, you really got to nail down the query as just searching for "Public domain database"

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-30 Thread Paul Sanderson
The WhatsApp db is encrypted (using encrypt7 IIRC) - there are sources on the web that show how to get around this - but it's not trivial. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-For

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-30 Thread Simon Slavin
On 30 Jun 2015, at 4:47am, Darko Volaric wrote: > If it's being used for teaching it can also be fair use: ( from > http://www.teachingcopyright.org/handout/fair-use-faq ) > > "the court found that the biographer's use was fair, in part because the > biographer's purpose was to educate and info