{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 冷血范 的问题《Full text search with embedded DB in Delphi》','https://www.manongdao.com/q-1230265.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
We are creating an open source Twitter client and are looking for an embedded DB with the smallest footprint possible that works with Delphi and that lends itself well to full text search (I know that doesn't go with small footprint very well). Ideally it should be free or open source too (demanding I know).
I am leaning toward SQLite, but I have not used it before and don't know if it supports full text search, or how well it works with Delphi. I've used DBISAM before and it is embedded with full text search, but not free. Firebird is another option we considered.
There might be a combination that makes this work. What would you use, and how does it rate for 1) Footprint, 2) Full text search, 3) Free/Open source.
UPDATE: Thanks to everyone for your suggestions. So many good choices to choose from.
I've had a lot of success using DiSQLite. It has FTS support and a ton of other features. They have a Free version and a Professional version. I believe the Free version does FTS as well. I've tried many of the SQLite implementations for Delphi and this is the best one I've seen. It compiles straight into your application so there are no external DLLs.
I've looked at a lot of the free libraries out there for embedded databases in Delphi and many are not supported anymore, never got released, or only work in Delphi5.
Sqlite is pretty much single user/single connection only. Doing an update locks the entire database. You deal with this by setting a timeout value for other connections to wait (default is no timeout). Multi-user access can become very slow and/or give frequent timeout depending on what value you use.
I have used the Asqlite components from http://www.aducom.com/. Free and Open source. Doesn't currently support d2009 by the looks, but it is under development. There are a number of other component sets as well but I haven't used any other.
You can add full text searching to any delphi app using Rubicon (now under new management at http://www.href.com/rubicon). However this is not free :(