PureBasic Forums - English

As I found out, the version of SQLITE included in PB4.41 is not very new and, very important for my needs, doesn't contain FTS3 fulltext search.

In the past I used an own wrapper, but since PB offers UseSQLiteDatabase() function (and more...) I would like to use the integrated functions instead of my own wrapper. Coding would become much more easy...
But: How can I replace the PB integrated SQLite by an other one (f.e. my own compiled DLL)? Is there a file anywhere that I could replace simply by my own compilation? Or is there a workaround to open my own DLL including FTS3, but using later on PB integrated commands like GetDatabaseString without the need of using an own wrapper?

Hints and tricks are welcome!


Bye, Ingo

Well, if you have written a procedure to execute a FTS3, I don't see how that would stop you from working with the same DB using PB's native calls also. There does not seem the need for a wrapper dll (for one function), but if there is, it could be a "light" one that only includes the additional functionality you need and you would still control the basics via PB.......

IdeasVacuum wrote:Well, if you have written a procedure to execute a FTS3, I don't see how that would stop you from working with the same DB using PB's native calls also........

That's a misunderstanding: I don't execute FTS3, but I have SQLITE.DLL with additional compiled FTS3 function.
If you get the SQLITE source from SQLITE webspace, you can activate and deactivate a switch in compiler options "FTS3 on/off".
Unfortunately standard SQLITE is compiled without integrated FTS3 and also PB integrated SQLITE is compiled without FTS3.

My question was: How can I remove the PB integrated SQLITE and replace with my compiled SQLITE+FTS3 version.

Of course, it's clear that FTS3 could be used with PB integrated calls, because FTS3 is used also with standard SQL commands. The problem now is the integration into PB.

Otherwise I have to use my own wrapper again - it's possible, but I would like to prevent using own procedures as long as the "twin brother" is already available native in PB.

Thanks for answering!

I was aware of the FTS module of SQLite. I enabled it for the next beta.