[sqlite] Does a search on an external content FTS table use the index of the underlying content?

Let's say I have a table Data_content(term TEXT UNIQUE) which has an indexed column 'term'. I then create an FTS4 table using CREATE VIRTUAL TABLE Data USING fts4 (content="Data_content", term); If I later search using SELECT * FROM Data WHERE term IN (...), does it use the indexes generated in D

[sqlite] problem about output html in c++

sqlite3 -html -header t9_engine.db "select id,partnumber,pic,pcs from engine where id>7;" >> mm.html the pic result is "c:\abc.jpg"... but I wanna the result is "" how to do? maybe use sqlite3_step, but I don't know how to realize. thank you! ___ s

Re: [sqlite] Strategies for checking the version of a database?

On Sep 18, 2012, at 1:05 PM, Marcus Ilgner wrote: >> Considering this, and according to your experience, what's the best >> sqlite-friendly way to check for the version of a database schema? >> > > You could use the user_version pragma (don't use schema_version) to > store this information. >

Re: [sqlite] SQLLite Question regarding instances and files

Thanks for the Reply Adam and no I had not concidered your alternative.  But I have considered the issues of perfomance, unexpected loss of connection, multiple connections to one database file as well as the overhead of creating a new database everytime a new test is to be run.  I think cons of

Re: [sqlite] SQLLite Question regarding instances and files

Good day, You are treating the database files as test log files, correct? If you are wanting a PC to execute a program that accesses an sqlite database file on a network, it is possible. If you read through previous discussions in this mail list archive you will find numerous warnings and challe

Re: [sqlite] sqliteman vs sqlite3 tcl package

On Tue, Sep 18, 2012 at 8:20 AM, Black, Michael (IS) wrote: > 2 things > > #1 Create indexes on testTable.deTestRecordId, dataXyTable.deTestRecordid, > and testTable.testName. > > #2 Do you really need the "LIKE" operator? That's going to scan the > entire table every time. If you can chang

Re: [sqlite] sqliteman vs sqlite3 tcl package

2 things #1 Create indexes on testTable.deTestRecordId, dataXyTable.deTestRecordid, and testTable.testName. #2 Do you really need the "LIKE" operator? That's going to scan the entire table every time. If you can change that to "=" you'll likely run a lot faster too. This shouild speed u

[sqlite] [ANN] ODB C++ ORM 2.1.0 released, improves SQLite support

Hi, I am pleased to announce the release of ODB 2.1.0. ODB is an open source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code. Maj

[sqlite] sqliteman vs sqlite3 tcl package

I have posted a question in the comp.lang.tcl group here and someone suggested that I post here as well. So here it goes... I am currently trying to use the tcl sqlite3 package to perform a database query. The datab

[sqlite] SQLLite Question regarding instances and files

My question is that I have a client who would like to be able to have a different database file for each group of data they are collecting (a test involving data acquisition). The database file would be saved to a network share that would occasionally get backed up by the network admin. The da

Re: [sqlite] Strategies for checking the version of a database?

On Tue, Sep 18, 2012 at 6:38 AM, Rui Maciel wrote: > Say there is an application that relies on sqlite for its database needs, > and that from a version onward it starts to use a different database > schema. When faced with this type of change, it is always nice to have a > way to infer if the a

Re: [sqlite] Strategies for checking the version of a database?

On Dienstag, 18. September 2012 12:38:17, Rui Maciel wrote: > Say there is an application that relies on sqlite for its database > needs, and that from a version onward it starts to use a different > database schema. When faced with this type of change, it is always > nice to have a way to infer i

[sqlite] Strategies for checking the version of a database?

Say there is an application that relies on sqlite for its database needs, and that from a version onward it starts to use a different database schema. When faced with this type of change, it is always nice to have a way to infer if the application's database corresponds to the old schema in or