[sqlite] ABI report

On 2/25/2016 7:28 PM, Stephen Chrzanowski wrote: > What does ABI stand for? https://en.wikipedia.org/wiki/Application_binary_interface -- Igor Tandetnik

[sqlite] ABI report

What does ABI stand for? API I'm assuming Application Programming Interface (As per the site content). On Thu, Feb 25, 2016 at 10:23 AM, Richard Hipp wrote: > On 2/25/16, Ponomarenko Andrey wrote: > > Hello, > > > > I've started to maintain ABI report for the SQLite library here: > >

[sqlite] Crash when running complex FT5 queries

On 02/25/2016 03:04 AM, Gergely Lukacsy (glukacsy) wrote: > Hi, > > > > We run into a reproducible crash on FTS5 search when searching something > complex such as: > > > > "(word1* word2* word3*) OR word1* OR word2* OR word3*" > > > > It might be that we are doing something wrong, but any insight

[sqlite] ABI report

Hello, I've started to maintain ABI report for the SQLite library here: http://abi-laboratory.pro/tracker/timeline/sqlite/ Seems that backward binary compatibility of the library is perfect. This makes life of the Linux maintainers easier. Great result! Thank you.

[sqlite] Why skip invoking busy handlerwhilepBt->inTransaction!=TRANS_NONE

No. I don?t mean [SQLite] will invoke the busy-handler. I mean I can modify the source code here and let it invoke busy-handler in WAL. Because it will not result in a deadlock in WAL. So can I do this? ???:Dan Kennedydanielk1977 at gmail.com ???:sqlite-userssqlite-users at

[sqlite] Why skip invoking busy handler whilepBt->inTransaction!=TRANS_NONE

On 02/25/2016 09:53 AM, sanhua.zh wrote: > So can this be understood as, if I run my code in WAL, I can invoke busy > handler even it in TRAN_READ? No. The busy-handler is not invoked when trying to upgrade from a read to a write transaction. Regardless of journal mode. Dan. > > > >

[sqlite] How to modify page_size

hi,all How could I modify the page_size of the Data base? I use the following method, but could not change the page_size. nRet = sqlite3_exec(m_pDB, "PRAGMA page_size=8192;", 0,0,); Why? best regards. Jim Wang.

[sqlite] Encrypt the SQL query

Hi, In my C++ program, I will invoke SQLite to execute SQL queries. But these queries are just stored as normal string constants in C++ so it is easy to be decoded via reverse engineering method. Does SQLite provide a good way to encrypt the SQL query strings while does not affect the performance

[sqlite] Why is a separate journal file needed ?

On Wed, 24 Feb 2016 12:53:48 + Simon Slavin wrote: > In case you're new to this group, please understand that I'm > experienced with SQLite and I understand how it works and how it uses > journal files. > > Can someone explain to me -- or point at a web page which does -- why > a separate

[sqlite] Why skip invoking busy handler whilepBt->inTransaction!=TRANS_NONE

So can this be understood as, if I run my code in WAL, I can invoke busy handler even it in TRAN_READ? ???:Dan Kennedydanielk1977 at gmail.com ???:sqlite-userssqlite-users at mailinglists.sqlite.org :2016?2?24?(??)?23:52 ??:Re: [sqlite] Why skip invoking busy handler

[sqlite] Can SQLite be used from DLL

Hi, I'm trying to design/make a program where I will use SQLite from the DLL. What I mean is I will establish a connection inside a DLL but disconnect from the database in my main application. It turns out that doing so I am getting the crash when I try to disconnect from the database file.

[sqlite] Order by multiple columns

Hi, Thank you. In that case, if I create an index for (F1, F2, F3), then the next time when I invoke SELECT statement like this: SELECT * FROM MyTable ORDER BY F1, F2, F3; Then SQLite will utilize the index automatically, is that correct? If I use SELECT * FROM MyTable ORDER BY F1, F2; Then

[sqlite] ABI report

On 2/25/16, Ponomarenko Andrey wrote: > Hello, > > I've started to maintain ABI report for the SQLite library here: > http://abi-laboratory.pro/tracker/timeline/sqlite/ Thank you for doing this. I think this is very important for the community. I also think it is important that it is being

[sqlite] bubble-generator.tcl usage question

Hello, this is directed at Dr. Richard Hipp, I think. Starting with an "I think" as I'm assuming you are the original author, Richard. I can't quite figure out if the bubble diagram generator, bubble-generator.tcl is available for modification and redistribution. I've created some COBOL

[sqlite] How to modify page_size

On 2016/02/25 9:40 AM, Jim Wang wrote: > hi,all > How could I modify the page_size of the Data base? I use the following > method, but could not change the page_size. >nRet = sqlite3_exec(m_pDB, "PRAGMA page_size=8192;", 0,0,); > Why? Because the Pragma specifies the ideal,

[sqlite] How to enabled PRAGMA options in c++ app ?

Thank you very much, i was spending hours of trying to make it work and yes it works fine :) Maby you could update your Documentation in the first lines of PRAGMA documents for such unknowldged like me :/ cause this PRAGMA is a bit confusing in some cases for newbies Thank you in advance Simon

[sqlite] How to modify page_size

Jim Wang wrote: > How could I modify the page_size of the Data base? The documentation says: | The page_size pragma will only cause an immediate change in the page | size if it is issued while the database is still empty, prior to the | first

[sqlite] How to modify page_size

Works as advertised. A database in WAL mode does not allow the page size to be changed. -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Yongil Jang Gesendet: Donnerstag, 25. Februar

[sqlite] Encrypt the SQL query

admin at shuling.net wrote: > In my C++ program, I will invoke SQLite to execute SQL queries. But these > queries are just stored as normal string constants in C++ so it is easy to > be decoded via reverse engineering method. How could _any_ obfuscation not be decoded with reverse engineering?

[sqlite] Encrypt the SQL query

On 25 Feb 2016, at 6:01am, wrote: > Does SQLite provide a good way to > encrypt the SQL query strings while does not affect the performance when > executing the queries? The source code for SQLite is available. There's no way to prevent a hacker reverse-engineering whatever calls you make

[sqlite] How to modify page_size

AFAIK, WAL mode is used and database is not empty, VACUUM operation doesn't change page size. But, I'm not sure about latest version of SQLite. :) 2016? 2? 25? (?) 16:50, R Smith ?? ??: > > > On 2016/02/25 9:40 AM, Jim Wang wrote: > > hi,all > > How could I modify the page_size of the

[sqlite] bubble-generator.tcl usage question

On 2/25/16, btiffin wrote: > > I can't quite figure out if the bubble diagram generator, > bubble-generator.tcl is available for modification and redistribution. I am happy that you found the bubble-generator.tcl script useful. Feel free to reuse it for whatever you want. No attribution

[sqlite] How to modify page_size

Short answer: you can't. It would require rebuilding every single page of the database. Exception 1: If the database is empty, the pragma will set the page size. Exception 2: If your database is not empty and you run VACUUM (which rebuilds every page of the database anyway) immediately after

[sqlite] Very minor documentation bug

https://www.sqlite.org/c3ref/vfs.html New fields may be appended in figure versions -> New fields may be appended in *future* versions

[sqlite] SQLite replicator, live backup, server thing

This looks interesting. It allows you to set up multiple computers on the internet to keep copies of a database in synch. Changes in one are promulgated to them all. As a side effect

[sqlite] Order by multiple columns

On 25 Feb 2016, at 2:31am, admin at shuling.net wrote: > Thank you. You're welcome. > In that case, if I create an index for (F1, F2, F3), then the > next time when I invoke SELECT statement like this: > > SELECT * FROM MyTable ORDER BY F1, F2, F3; > > Then SQLite will utilize the index

[sqlite] Sqlite is secure with MD5?

Hello, I am using sqlite3-3.11.0, i See sqlite is using MD5 hash algorithm to generate MD5 checksums for TCL interface. Since MD5 is broken for purposes of security, How can i replace MD5 with any other hash algorithm (sha-2) to keep it secure from malicious attacker? Or Is there a way to

[sqlite] How to enabled PRAGMA options in c++ app ?

On 25 Feb 2016, at 12:01am, a a wrote: > PRAGMA secure_delete = true; SQLite's PRAGMA commands should be executed as if they were SQL commands. They are not C or C++ code. In other words you can take whatever program structure you would use to execute CREATE TABLE MyTable (a, b) and use

[sqlite] How to enabled PRAGMA options in c++ app ?

Hi to all, I am new to sqlite and c++ also. I have download the latest source code of amalgamation from sqlite.org and i added the two files of the four into my app (sqlite3.h and sqlite3.c) I have manage to connect use and run anything i liked within my app with sqlite3 and its very easy