Dismiss Notice

REGISTRATION IS AFTER ADMIN ACTIVATION

DONATIONS WITH PAYPAL CLICK TO BUTTON

1 MONTH VIP - 5$; 3 MONTHS VIP - 10$; 6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$

DONATIONS WITH Bitcoin Address:3NRs3CK3fhXifrNYxHEZKpETDd9vNLMsMD

Dismiss Notice
The registration is approved by the Administrator. It takes about 1 day to approve your registration
Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

Full Text TXT Search In Delphi (+FireDac +SQLite)

Discussion in 'DF Member Programs and Projects' started by N0body, Dec 13, 2013.

  1. N0body
    Online

    N0bodyN0body is a Verified Member DelphiFan Administrator Staff Member DF Staff

    [​IMG]



    Finally, the sample project for my full text search implementation in Delphi is ready. The idea involves providing a user of my application the ability to do full text (Google like) searches on a set of documents by searching inside document content. For the task, I’ve selected SQLite for the database and FireDac for the database connectivity and operations.


    For the sake of simplicity and the proof-of-concept approach this sample program is really simple: it will index all TXT files under some directory (including sub directories) and allow to do simple “match” type full text search queries. Certainly, in my real world application, the task is more complex and involves non-TXT files, some Windows service application and alike … but for the start, if you are up to implementing full text search, this sample project should give you a kick-start.


    [glow=red,2,300]Download[/glow]
     
  2. vader
    Offline

    vader Guest

    Sounds very interesting. But is it working on any text file, like forms, includes? Or just module sources (*.pas)? I like the feature in GExperts to search inside forms. Does your software has this ability?
     
  3. sadcox66
    Offline

    sadcox66 DF Junior

    Please Look at Sphinx. I use it to search in mediawiki.
    It runs in the background as a service and will categorize files. Easy to interface with PHP. Also should be with Delphi. Can get results from command line.
    You can search .txt, .pdf also databases

    http://en.wikipedia.org/wiki/Sphinx_(search_engine)
    http://sphinxsearch.com/forum/search.html?q=delphi&f=1&order=weight
    http://www.mediawiki.org/wiki/Extension:SphinxSearch
    http://sphinxsearch.com/downloads/release/
    http://www.openlogic.com/wazi/bid/239175/Search-beyond-MySQL-with-Sphinx


    Some people use Solr but I have no experience.
     

Share This Page

Laws
Our website, law, laws, copyright and aims to be respectful of individual rights. Our site, as defined in the law of 5651 serves as a provider of space. According to the law, contrary to the law of site management has no obligation to monitor content. Therefore, our site has adopted the principle of fit and remove. Works are subject to copyright laws and is shared in a manner that violated their legal rights, or professional associations, rights holders who, adsdelphi@gmail.com I can reach us at e-mail address. Complaints considered to be infringing on the examination of the content will be removed from our site.
Donate Help To Us and Be VIP
DONATIONS WITH PAYPAL CLICK TO BUTTON
6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$
Social Block