FTS3 or FTS4 in SQLite

[giammy]

I use PB 4.51 and the version of SQLITE included in PB4.51 doesn't contain FTS3 or FTS4 fulltext search.

I need for SQLite fulltext search cross-platform

In this topic http://www.purebasic.fr/english/viewtop ... hilit=fts3 Fred said he would include this feature as soon as possible....anyone has news?

suggestions?

thank you in advance for your help

[Zach]

You have to use a wrapper with FTS3/4 enabled DLL. We had a similar discussion about getting an up to date SQLite in 4.60, but Fred indicated he still has not had time to do it. Fred said integrating SQLite into PB requires them to do modifications, so we still have no newer SQLite I guess until Fred or Freak can find the time.

Don't worry, you're not the only one who is a bit frustrated about it.

[giammy]

You have to use a wrapper with FTS3/4 enabled DLL. We had a similar discussion about getting an up to date SQLite in 4.60, but Fred indicated he still has not had time to do it. Fred said integrating SQLite into PB requires them to do modifications, so we still have no newer SQLite I guess until Fred or Freak can find the time.

Don't worry, you're not the only one who is a bit frustrated about it.

thanks a lot, can you suggest me an example of wrapper code?

[Zach]

I've never written one, personally.

I have very little knowledge of this. I think this is best left to someone else.
If you do a forum search you may find older wrappers you can base your own work off, though.

[jassing]

I have an sqlite3.lib that you can replace the PB one and get fulltext search ability -- so far, I haven't noticed any issues.

[karmacomposer]

Can I create a MySQL database app with PureBasic? I ask here since SQLite is pretty close.

Mike

[jassing]

Can I create a MySQL database app with PureBasic? I ask here since SQLite is pretty close.

Not directly like with SQLite but sure, you can connect up to a server & create a database.