FTS3 or FTS4 in SQLite

Everything else that doesn't fall into one of the other PB categories.
giammy
User
User
Posts: 16
Joined: Wed Aug 03, 2011 10:43 am

FTS3 or FTS4 in SQLite

Post by 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
Addict
Addict
Posts: 1675
Joined: Sun Dec 12, 2010 12:36 am
Location: Somewhere in the midwest
Contact:

Re: FTS3 or FTS4 in SQLite

Post by 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
User
User
Posts: 16
Joined: Wed Aug 03, 2011 10:43 am

Re: FTS3 or FTS4 in SQLite

Post by giammy »

Zach wrote: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
Addict
Addict
Posts: 1675
Joined: Sun Dec 12, 2010 12:36 am
Location: Somewhere in the midwest
Contact:

Re: FTS3 or FTS4 in SQLite

Post by 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
Addict
Addict
Posts: 1885
Joined: Wed Feb 17, 2010 12:00 am

Re: FTS3 or FTS4 in SQLite

Post by 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
Enthusiast
Enthusiast
Posts: 113
Joined: Sun Jul 29, 2012 2:51 pm

Re: FTS3 or FTS4 in SQLite

Post by karmacomposer »

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

Mike
jassing
Addict
Addict
Posts: 1885
Joined: Wed Feb 17, 2010 12:00 am

Re: FTS3 or FTS4 in SQLite

Post by jassing »

karmacomposer wrote: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.
Post Reply