[sqlite] ANN: SQLite PHP Generator 15.12 released

Hi! SQL Maestro Group announces the release of SQLite PHP Generator 15.12, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your SQLite database. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demo:

[sqlite] Problem with accumulating decimal values

> I was taught "Round [only] before printing.". These days it would be > something like "Round [only] before your API returns to the calling > program. Those are not the same. Round only before printing (whether to the screen or to a printer). In other words, rounding is a way to make things

[sqlite] Missing documentation about BLOB encoding conversions

> says: >> To cast a BLOB value to TEXT, the sequence of bytes that make up the >> BLOB is interpreted as text encoded using the database encoding. > > (The database encoding must be set when the DB file is created.) Thank you! That's the

[sqlite] compile configure

hi,all When I compile the sqlite3 source, will I select difference parameter effect the performance of the sqlite funtion such as speed?

[sqlite] batch or one by one?

Testing shows that sqlite3_get_table is faster than sqlite3_prepare_v2 and sqlite3_step together. In fact. At 2015-12-17 14:48:18, "Igor Tandetnik" wrote: >On 12/16/2015 11:24 PM, ??? wrote: >> There is an interesting phenomenon.As you know, SQLite can retrieve >> records by batch or

[sqlite] SQLite take lower performance while using shared cache on iOS/Mac

I try to use shared cache to optimize my code. Sincesqlite3_enable_shared_cache is deprecated on iOS/Mac, I usesqlite3_open_v2 withSQLITE_OPEN_SHAREDCACHE flag to open shared cache mode. 4 threads select is running in my code, while each thread has its own sqlite connection and do the same

[sqlite] Missing documentation about BLOB encoding conversions

Michael Kaufmann wrote: >>> It seems that BLOBs are converted from UTF-8 to UTF-16 when >>> sqlite3_column_text16() is called. > > The sequence of calls is: > > 1. sqlite3_step() > 2. sqlite3_column_text16() says: > To cast a BLOB value to TEXT,

[sqlite] Missing documentation about BLOB encoding conversions

The sequence of calls is: 1. sqlite3_step() 2. sqlite3_column_text16() 3. sqlite3_column_bytes() Please see the attached example program. Regards, Michael > What is the exact sequence of calls? > > If you call sqlite3_column_text() on a blob value, the new type will > be text and a

[sqlite] Problem with accumulating decimal values

On 17 Dec 2015, at 4:22am, R Smith wrote: > it was a seemingly too-convoluted detour for simply saying: "Don't store > rounded numbers. Round only the results." I was taught "Round [only] before printing.". These days it would be something like "Round [only] before your API returns to the

[sqlite] batch or one by one?

On 17 Dec 2015, at 4:24am, ??? <2004wqg2008 at 163.com> wrote: > 1.Retrieve by batch such as sqlite3_get_table. As the documentation says, please do not use sqlite3_get_table(). It was written a long time ago and better calls are now available. "This is a legacy interface that is

[sqlite] batch or one by one?

hi,all There is an interesting phenomenon.As you know, SQLite can retrieve records by batch or one by one. 1.Retrieve by batch such as sqlite3_get_table. 2.Retrieve one by one such as sqlite3_prepare_v2 and sqlite3_step together. Using the above two methods to retrieve

[sqlite] SQLite take lower performance while using shared cache on iOS/Mac

Using a shared cache will result in lower memory usage and may result in lower IO, but it isn't likely to speed up your program since it also requires more locks to guarantee safety between competing database connections. SQLite on Apple's platforms is built with SQLITE_THREADSAFE=2, so under

[sqlite] Missing documentation about BLOB encoding conversions

Hi, I expected that BLOB data is returned unchanged by sqlite3_column_blob(), sqlite3_column_text() and sqlite3_column_text16(). The documentation at https://www.sqlite.org/c3ref/column_blob.html says: "Type conversions and pointer invalidations might occur in the following cases: ... The

[sqlite] Missing documentation about BLOB encoding conversions

What is the exact sequence of calls? If you call sqlite3_column_text() on a blob value, the new type will be text and a subsequent call to sqlite_column_text16() must by definition perform transcoding. -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] batch or one by one?

On Thu, Dec 17, 2015 at 8:04 AM, ??? <2004wqg2008 at 163.com> wrote: > Testing shows that sqlite3_get_table is faster than sqlite3_prepare_v2 and > sqlite3_step together. In fact. > > And uses, on average, much more memory, as it stores all rows for the query results in the result table. If your

[sqlite] Problem with accumulating decimal values

On 2015/12/17 3:26 AM, James K. Lowden wrote: >> Calculated errors are fine because we can at any time revisit the >> calculation procedures, we can refine and perhaps opt for more >> significant digits - but we can ALWAYS guarantee the accuracy-level >> of the calculated result. However,

[sqlite] batch or one by one?

On 12/17/2015 2:04 AM, ??? wrote: > Testing shows that sqlite3_get_table is faster than sqlite3_prepare_v2 and > sqlite3_step together. In fact. You must be doing something wrong in your test harness. You are likely measuring something other than actual SQLite performance. Show your code. --

[sqlite] batch or one by one?

On 12/16/2015 11:24 PM, ??? wrote: > There is an interesting phenomenon.As you know, SQLite can retrieve > records by batch or one by one. > 1.Retrieve by batch such as sqlite3_get_table. > 2.Retrieve one by one such as sqlite3_prepare_v2 and sqlite3_step > together. If you