Re: [sqlite] Generic indexes on FTS3 table

On Fri, Dec 4, 2009 at 6:44 PM, Pavel Ivanov wrote: >> (2) Is there a way to create FTS virtual table that only holds the >> fulltext index and not the data itself? (This way I'd able to solve >> the problem by creating a separate FTS3 table and hooking triggers on >> r/w

Re: [sqlite] how to use sqlite3 in win DDK?

Hello Mw, I've done some Windows kernel work some years ago. I think you're going to have to build your own disk IO and file locking modules because standard windows API's don't work in the kernel level. I think you might be better off leaving the DB up in user space and just let the driver

Re: [sqlite] Add IMMEDIATE/EXCLUSIVE support to SAVEPOINT?

On Dec 4, 2009, at 9:45 PM, Nikolaus Rath wrote: > > Has it ever been discussed (or for good reason never been > considered) to > extent the SAVEPOINT command with respect to its behavior if there > is no > enclosing transaction? > http://www.sqlite.org/lang_savepoint.html "When a

[sqlite] Add IMMEDIATE/EXCLUSIVE support to SAVEPOINT?

Hello, Has it ever been discussed (or for good reason never been considered) to extent the SAVEPOINT command with respect to its behavior if there is no enclosing transaction? At the moment I am manually keeping track of enclosing transactions and then switch dynamically between "SAVEPOINT" and

[sqlite] The point of BEGIN DEFERRED

Hello, If I understand the documentation right, the following SQL snippet can cause deadlocks when running multi-threaded, because both threads can acquire and hold the SHARED lock at the same time, but then no thread can get the EXCLUSIVE lock anymore (note that the SELECT and INSERT are meant

[sqlite] Cache size tuning

Does SQLite provide any tools to help the developer tune the database cache size? Thanks, - Richard Klein ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Multiples natural left joins problem

> You have not specified your version, but I can repeat your > difficulties when using version 3.6.19 and 3.6.20 > I am using version 3.6.16 > You can get 'correct' results if you modify your query to > SELECT movies.id, title, files, icon_modified, icon_width > FROM ( movies natural left

Re: [sqlite] Generic indexes on FTS3 table

> (2) Is there a way to create FTS virtual table that only holds the > fulltext index and not the data itself? (This way I'd able to solve > the problem by creating a separate FTS3 table and hooking triggers on > r/w queries). Can you exclude text fields from your table, put it into separate FTS

[sqlite] Generic indexes on FTS3 table

Hi all, I'd like to add a fulltext index to a complex table. The table already has couple of indeces built on top of it. I created a virtual FTS3 table with identical schema and inserted all the data there. As one cannot create indexes on top of virtual tables, most of the queries the table was

Re: [sqlite] The next release of SQLite....

Gidday Tim, >I will look further into this approach: > > select sqlite3_load_extension('mylibrary', 'entrypoint'); > >to see if Adobe's security permits it. However, the Adobe FlashBuilder >database application developer must confront this uncertainty: Adobe has >been unresponsive to questions

[sqlite] how to use sqlite3 in win DDK?

sqlite3.lib was made by VC++;and already added to the sources file. TARGETLIBS=sqlite3.lib code: #include #include #include void database() { sqlite3 *db; sqlite3_open("c:\\test.db",); DbgPrint("hello,on it\n"); } NTSTATUS DriverEntry(PDRIVER_OBJECT pDriverObj,PUNICODE_STRING

Re: [sqlite] sqlite help requested to support this requirement

On Fri, Dec 4, 2009 at 8:01 AM, Pronab Ganguly wrote: > Thanks a lot for all help suggestion.Let me know if you have any experience > on file parsing using sqlite. .. SQLite doesn't do any "file parsing." You have to do the file parsing, and then stick the v -- Puneet

Re: [sqlite] Multiples natural left joins problem

2009/12/4 Yuzem : > >> What query are you trying with the above tables, and how do the >> results differ from what you expect? >> > This is the query: > SELECT movies.id,title,files,icon_modified,icon_width > FROM (movies natural left join files) natural left join

Re: [sqlite] The next release of SQLite....

Adobe has security "sandbox" requirements, so I would not want to disparage them for their decisions, though I do wish they would be more forthcoming with information. Regards Tim Romano Jean-Christophe Deschamps wrote: >>> Does Adobe actually filter out statements similar to: >>> >>>select

Re: [sqlite] The next release of SQLite....

Thanks very much for pointing this out, Jean-Christophe. Yes, glob is exactly what I wanted. I will look further into this approach: select sqlite3_load_extension('mylibrary', 'entrypoint'); to see if Adobe's security permits it. However, the Adobe FlashBuilder database application

Re: [sqlite] sqlite help requested to support this requirement

You don't need any file parsing with SQLite and SQLite is not a file-parsing utility. SQLite is a database engine. It creates file of its own format and parses it without user noticing it. All you have to do is issue necessary SQL commands to work with your database. You definitely need to read

Re: [sqlite] Multiples natural left joins problem

> What query are you trying with the above tables, and how do the > results differ from what you expect? > This is the query: SELECT movies.id,title,files,icon_modified,icon_width FROM (movies natural left join files) natural left join icons_movies LIMIT 25 ; The difference with your last

Re: [sqlite] sqlite help requested to support this requirement

Thanks a lot for all help suggestion.Let me know if you have any experience on file parsing using sqlite. -P On Fri, Dec 4, 2009 at 6:15 PM, Pavel Ivanov wrote: > > SQLite is an implementation of SQL. SQL is used to store information in > a way that allows you to look

Re: [sqlite] sqlite help requested to support this requirement

> SQLite is an implementation of SQL. SQL is used to store information in a > way that allows you to look things up more quickly than searching a flat > file. If you can search for data your flat files fast enough to make your > software work acceptably, you do not need SQL and your project

Re: [sqlite] sqlite help requested to support this requirement

On 4 Dec 2009, at 11:50am, Pronab Ganguly wrote: > I am newbie to sqlite.Would like to is sqlite is better than flat file > parsing? > > We have platform specific files of different formats to be read so our > code is complex and difficult for maintenance considering support for > newer

Re: [sqlite] sqlite3 is blocked by transaction when wanting to close the sqlite3 *

Never use signal handlers to call sqlite3_* functions. Your handler can be called while another sqlite3_* call is in process but sqlite3_* functions are not re-entrant, so such code will lead to any kind of bizarre behavior (including any sort of segmentation fault). Use your signal handler to set

[sqlite] sqlite help requested to support this requirement

Hi All, I am newbie to sqlite.Would like to is sqlite is better than flat file parsing? We have platform specific files of different formats to be read so our code is complex and difficult for maintenance considering support for newer platforms and backward compatibility. We are planning for a

Re: [sqlite] sqlite3 is blocked by transaction when wanting to close the sqlite3 *

Thank you I do the job as you say, but the problem is still here. There are several processes who write the database. And the place is not same each time that the problem happens. How could I know the reason exactly? PS: I used the signal to close the connection to database. Just like:

Re: [sqlite] "foreign key mismatch" error

Original Message > On Dec 4, 2009, at 12:31 PM, Paul Shaffer wrote: > >> Below are 3 tables. When I delete a row in Item with related rows in >> Item_attribute I get the dreaded "foreign key mismatch" error. I've >> read >> through the documentation and don't see what I'm

Re: [sqlite] sqlite3 is blocked by transaction when wanting to close the sqlite3 *

I do the job as you say, but the problem is still here. There are several processes who write the database. And the place is not same each time that the problem happens. How could I know the reason exactly? PS: I used the signal to close the connection to database. Just like: int main () {

Re: [sqlite] The next release of SQLite....

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Artur Reilin wrote: > Is somewhere a list of which sites of the documentation has changed? It > would be a little difficult to search for differences. Documentation is kept in a separate fossil repository than the SQLite source. You can see the