Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here are a few resources for you to consider:</p> <ul> <li><a href="http://www.firebirdsql.org/index.php?op=files&amp;id=sphinx" rel="nofollow noreferrer">Sphinx</a> very powerful and popular free open source full-text search engine. </li> <li><a href="http://www.textolution.com/ftsib.asp" rel="nofollow noreferrer">Textolution</a> Fulltext search for Interbase and Firebird.</li> <li><a href="http://www.ibobjects.com/ibofts.html" rel="nofollow noreferrer">IBObjects</a> Full Text Search ("Fuzzy Search") module, a fully working module that can be used to set up your search indexes or as a model for your own custom implementation. </li> <li><a href="http://www.href.com/rubicon:2062282706" rel="nofollow noreferrer">Rubicon</a> is a Delphi add-on that lets you put full text search capabilities into your applications. </li> <li><a href="http://www.codeproject.com/KB/database/FulltextFirebird.aspx" rel="nofollow noreferrer">Fulltext Search for Firebird SQL By Dan Letecky</a> on CodeProject using DotLucene full-text search engine.</li> <li><a href="http://sourceforge.net/projects/mutis" rel="nofollow noreferrer">Mutis</a> is a Delphi port of the Lucene Search Engine. Provide a flexible API for index, catalog and search text-based information with great performance. Excelent for implement custom search engines, researching, text retrieval, data mining and more.</li> </ul> <p>There is a <a href="http://www.red-soft.biz/en" rel="nofollow noreferrer">fork of Firebird</a> code made by a company called Red Soft. It's licensed under the same license as Firebird, so you can take a look at their version which can support full-text searches using Lucene engine via JavaVM interfaces.</p> <p>You can also read a paper titled "<a href="http://www.ibphoenix.com/downloads/FirebirdConf2006/TECH-TPZ303-R/TECH-TPZ303-R.zip" rel="nofollow noreferrer">Full text search in Firebird without a full text search engine</a>" by Bjoern Reimer and Dirk Baumeister, presented at 4th Firebird Conference.</p>
    singulars
    1. This table or related slice is empty.
    1. POFull Text Search with Firebird and Delphi
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMark Rotteveel
    1. USJim McKeeth
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POFull Text Search with Firebird and Delphi
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COGreat list, Jim!
      singulars
      1. PO
      1. USgabr
    2. COThanks Jim. I've looked at most of them, but never found Mutis. I'm downloading now. BTW, are you using FTS in your Twitter project? If so, which did you choose?
      singulars
      1. PO
      1. USnorgepaul
    3. COWe are currently planning to use DISQLite3, but the client has been on hold. Delphi Live! and then family in town. Things are quieting down and now I have crunch time at work.
      singulars
      1. PO
      1. USJim McKeeth
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload