Re: [sqlite] Coding standard

2019-12-12 Thread Arthur Blondel
I'm using amalgamation version 3.30.1. and check with CodeSonar Attached the Security issues. On Wed, Dec 11, 2019 at 4:57 PM Richard Hipp wrote: > On 12/11/19, Arthur Blondel wrote: > > Hello, > > Running the CERT coding standard > > <https://en.wikipedia.org/wik

[sqlite] Coding standard

2019-12-11 Thread Arthur Blondel
Hello, Running the CERT coding standard on the sqlite code I get up to 32000 warnings, most of them are security issues. Does anyone had this problem? The CERT standard is a must for my project and I wonder if there is a solution. Thanks

Re: [sqlite] Remove row to insert new one on a full database

2019-04-05 Thread Arthur Blondel
ove space in the database file. > If you're running out of disk space, it could be you need to vacuum your > database file. How large is the database? How much disk space do you have > left? > > > Thanks, > Chris > > On Fri, Apr 5, 2019 at 1:46 PM Arthur Blondel > wrote

Re: [sqlite] Remove row to insert new one on a full database

2019-04-05 Thread Arthur Blondel
output: 1. rc = 0 2. rc = 0 3. rc = 0 4. rc = 0 5. rc = 0 3959 - DB full 3960 - 109 rows was removed 4044 - 92 rows was removed 4128 - 86 rows was removed 4212 - 85 rows was removed 4296 - 85 rows was removed 4380 - 84 rows was removed 4464 - 84 rows was removed 4548 - 84 rows was removed

[sqlite] Remove row to insert new one on a full database

2019-04-04 Thread Arthur Blondel
Hello When I try to insert new data to a full SQLite database, I need to remove much more than really needed. I'm doing the following: while(1) { do { status = insert_1_row_to_db(); if (status == full) { remove_one_row_from_db(); } } while (status ==