/[pgestraier]/trunk
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Log of /trunk

View Directory Listing Directory Listing


Sticky Revision:

Revision 88 - Directory Listing
Modified Sun Mar 16 20:55:56 2008 UTC (14 years, 6 months ago) by dpavlin
better error message when run without arguments

Revision 87 - Directory Listing
Modified Fri Jul 13 10:12:54 2007 UTC (15 years, 2 months ago) by dpavlin
added IMDB download link for test database (trivia)

Revision 86 - Directory Listing
Modified Wed Apr 18 15:55:47 2007 UTC (15 years, 5 months ago) by dpavlin
support for multiple quotes

Revision 85 - Directory Listing
Modified Sat Feb 3 17:13:07 2007 UTC (15 years, 7 months ago) by dpavlin
add PG_MODULE_MAGIC for PostgreSQL 8.2

Revision 84 - Directory Listing
Modified Thu Jan 18 11:02:57 2007 UTC (15 years, 8 months ago) by dpavlin
added indexes

Revision 83 - Directory Listing
Modified Wed Jan 17 22:30:14 2007 UTC (15 years, 8 months ago) by dpavlin
restructure IMDB trivia parser, added db target to create
trivia database in PostgreSQL

Revision 82 - Directory Listing
Modified Sun Nov 26 21:21:46 2006 UTC (15 years, 10 months ago) by dpavlin
don't add to full-text index primary keys with names beginning with _

Revision 81 - Directory Listing
Modified Wed Aug 9 17:25:31 2006 UTC (16 years, 1 month ago) by dpavlin
finished see also, with note about queryies

Revision 80 - Directory Listing
Modified Tue Aug 8 12:15:55 2006 UTC (16 years, 1 month ago) by dpavlin
bugfix: offset implementation didn't return all records

Revision 79 - Directory Listing
Modified Tue Aug 8 11:42:01 2006 UTC (16 years, 1 month ago) by dpavlin
update trigger now uses est_node_edit_doc (as it should)

Revision 78 - Directory Listing
Modified Tue Aug 8 11:40:09 2006 UTC (16 years, 1 month ago) by dpavlin
delete just existing triggers

Revision 77 - Directory Listing
Modified Tue Aug 8 11:01:00 2006 UTC (16 years, 1 month ago) by dpavlin
try unique index if primary key doesn't exits

Revision 76 - Directory Listing
Modified Mon Aug 7 23:24:54 2006 UTC (16 years, 1 month ago) by dpavlin
re-generate documentation on cvs target

Revision 75 - Directory Listing
Modified Mon Aug 7 23:22:29 2006 UTC (16 years, 1 month ago) by dpavlin
minor modificaton to cross-link documentation and actually transfer all of
it to pgfoundry.org

Revision 74 - Directory Listing
Modified Mon Aug 7 22:53:46 2006 UTC (16 years, 1 month ago) by dpavlin
turn debug off

Revision 73 - Directory Listing
Modified Mon Aug 7 22:47:41 2006 UTC (16 years, 1 month ago) by dpavlin
hush size_t warning

Revision 72 - Directory Listing
Modified Mon Aug 7 22:44:21 2006 UTC (16 years, 1 month ago) by dpavlin
hush compiler warning

Revision 71 - Directory Listing
Modified Mon Aug 7 22:07:49 2006 UTC (16 years, 1 month ago) by dpavlin
tutorial is very short, thanks to helper script :-)

Revision 70 - Directory Listing
Modified Mon Aug 7 21:08:41 2006 UTC (16 years, 1 month ago) by dpavlin
finish (hopefully) documentation. perldoc pgsql-index.pl is now really
useful :-)

Revision 69 - Directory Listing
Modified Mon Aug 7 17:30:56 2006 UTC (16 years, 1 month ago) by dpavlin
single-line progress bar (if it fits), only thing going to STDOUT is example SQL query
(so it can be redirected to file)

Revision 68 - Directory Listing
Modified Mon Aug 7 17:05:07 2006 UTC (16 years, 1 month ago) by dpavlin
auto-discover primary key (if it's single column and sutable), auto-generate SQL
select * from table which is *NOT OPTIMAL* if you are not going to search all
columns in your table

Revision 67 - Directory Listing
Modified Mon Aug 7 16:38:24 2006 UTC (16 years, 1 month ago) by dpavlin
added chunk of documentation and ability to --create or --drop indexes

Revision 66 - Directory Listing
Modified Mon Aug 7 14:56:08 2006 UTC (16 years, 1 month ago) by dpavlin
don't change encoding when inserting in HyperEstraier (since pgest_trigger doesn't do that).
This might mean that Hyper Estraier web UI won't have correct encoding if your database
isn't in UTF-8 encoding (which might get fixed, but that would require all
functions to have encoding parametar which is, IMHO, overkill)

Revision 65 - Directory Listing
Modified Mon Aug 7 14:47:00 2006 UTC (16 years, 1 month ago) by dpavlin
print example SQL search query at end

Revision 64 - Directory Listing
Modified Mon Aug 7 14:32:21 2006 UTC (16 years, 1 month ago) by dpavlin
improved documentation, now this project is full-text index for PostgreSQL and not just
search function :-)

Revision 63 - Directory Listing
Modified Mon Aug 7 14:30:55 2006 UTC (16 years, 1 month ago) by dpavlin
drop triggers at beginning, work inside transaction, create pgest and pgest_trigger functions

Revision 62 - Directory Listing
Modified Mon Aug 7 13:24:49 2006 UTC (16 years, 1 month ago) by dpavlin
script to create pgest index on PostgreSQL database (modification of dbi-indexer.pl from
Search::Estraier distribution)

Revision 61 - Directory Listing
Modified Mon Aug 7 11:14:52 2006 UTC (16 years, 1 month ago) by dpavlin
added pgest_trigger function which allows updateable indexes

Revision 60 - Directory Listing
Modified Tue Jul 11 14:11:42 2006 UTC (16 years, 2 months ago) by dpavlin
make it in sync with relity

Revision 59 - Directory Listing
Modified Thu May 25 18:46:49 2006 UTC (16 years, 4 months ago) by dpavlin
begin tutorial

Revision 58 - Directory Listing
Modified Thu May 25 17:50:13 2006 UTC (16 years, 4 months ago) by dpavlin
example how to return hints (which require de-normalized schema)

Revision 57 - Directory Listing
Modified Thu May 11 16:19:38 2006 UTC (16 years, 4 months ago) by dpavlin
initial implementation of hints using (fake) atribute names in form HINTS.something
(e.g. HITS.HIT or HINTS.WORDNUM...)

Revision 56 - Directory Listing
Modified Thu May 11 15:52:50 2006 UTC (16 years, 4 months ago) by dpavlin
fix multiple attributes delimited with {{!}}, fix warnings

Revision 55 - Directory Listing
Modified Thu May 11 11:43:36 2006 UTC (16 years, 4 months ago) by dpavlin
use pkg-config hyperestraier if estconfig is not found (this should help on Debian installations
with Hyper Estraier installed from package... you will also need libestraier-dev)

Revision 54 - Directory Listing
Modified Thu May 11 10:19:46 2006 UTC (16 years, 4 months ago) by dpavlin
updated documentation and example for convert

Revision 53 - Directory Listing
Modified Thu May 11 10:18:32 2006 UTC (16 years, 4 months ago) by dpavlin
script now creates index on it's own

Revision 52 - Directory Listing
Modified Thu May 11 10:18:08 2006 UTC (16 years, 4 months ago) by dpavlin
create node if needed

Revision 51 - Directory Listing
Modified Tue May 9 22:55:42 2006 UTC (16 years, 4 months ago) by dpavlin
depriciated usage of direct access to index. use node API and estmaster
instead.


Revision 50 - Directory Listing
Modified Fri Apr 14 16:17:19 2006 UTC (16 years, 5 months ago) by dpavlin
remove direct database creation and use node API always via Search::Estraier


Revision 49 - Directory Listing
Modified Sat Oct 29 18:54:40 2005 UTC (16 years, 11 months ago) by dpavlin
added depth to node API version of pgest, note that you have to use modified
perl wrapper with node API


Revision 48 - Directory Listing
Modified Thu Oct 20 16:24:26 2005 UTC (16 years, 11 months ago) by dpavlin
moved argument offsets into #define(s)


Revision 47 - Directory Listing
Modified Sun Sep 11 21:44:56 2005 UTC (17 years ago) by dpavlin
few more check to keep PostgreSQL from segfaulting in case of errors


Revision 46 - Directory Listing
Modified Sun Sep 11 21:44:11 2005 UTC (17 years ago) by dpavlin
drop and re-create trivia node


Revision 45 - Directory Listing
Modified Sat Sep 10 23:08:47 2005 UTC (17 years ago) by dpavlin
test node API version of pgest


Revision 44 - Directory Listing
Modified Sat Sep 10 22:51:03 2005 UTC (17 years ago) by dpavlin
check if search failed and report status


Revision 43 - Directory Listing
Modified Sat Sep 10 22:33:36 2005 UTC (17 years ago) by dpavlin
few more changes to documentation


Revision 42 - Directory Listing
Modified Sat Sep 10 21:48:46 2005 UTC (17 years ago) by dpavlin
updated documentation to reflect two different ways to call pgest with example


Revision 41 - Directory Listing
Modified Sat Sep 10 20:35:09 2005 UTC (17 years ago) by dpavlin
added node API


Revision 40 - Directory Listing
Modified Sat Sep 10 18:51:13 2005 UTC (17 years ago) by dpavlin
add support for multiple attributes delimited by {{!}}


Revision 39 - Directory Listing
Modified Fri Jul 8 15:26:04 2005 UTC (17 years, 2 months ago) by dpavlin
removed misleading INFO message (hint: it's not a bug)


Revision 38 - Directory Listing
Modified Fri Jul 8 12:47:49 2005 UTC (17 years, 2 months ago) by dpavlin
added est_cond_set_max to return just minumum needed resutls from Hyper Estraier


Revision 37 - Directory Listing
Modified Thu Jul 7 17:24:22 2005 UTC (17 years, 2 months ago) by dpavlin
misc cleanups


Revision 36 - Directory Listing
Modified Thu Jul 7 17:21:50 2005 UTC (17 years, 2 months ago) by dpavlin
nicer dependency, doesn't recompile pgest.so if not needed


Revision 35 - Directory Listing
Modified Thu Jul 7 14:18:49 2005 UTC (17 years, 2 months ago) by dpavlin
added sync()


Revision 34 - Directory Listing
Modified Wed Jul 6 16:44:46 2005 UTC (17 years, 2 months ago) by dpavlin
update project home page with documentation


Revision 33 - Directory Listing
Modified Wed Jul 6 16:35:51 2005 UTC (17 years, 2 months ago) by dpavlin
converted documentation to pod


Revision 32 - Directory Listing
Modified Wed Jul 6 15:15:04 2005 UTC (17 years, 2 months ago) by dpavlin
test ordering


Revision 31 - Directory Listing
Modified Wed Jul 6 14:47:56 2005 UTC (17 years, 2 months ago) by dpavlin
added results order (see test.sql for example) to function arguments,
fixed limit (it really returns limit rows, and not limit - offset :-\),
added est_cond_delete(cond) so that we don't leek memory


Revision 30 - Directory Listing
Modified Wed Jul 6 14:34:10 2005 UTC (17 years, 2 months ago) by dpavlin
small cleanup


Revision 29 - Directory Listing
Modified Wed Jul 6 11:47:56 2005 UTC (17 years, 2 months ago) by dpavlin
added indexer.pl written using perl Hyper Estraier bindings


Revision 28 - Directory Listing
Modified Fri Jul 1 12:50:53 2005 UTC (17 years, 3 months ago) by dpavlin
cvs target for pgfoundry


Revision 27 - Directory Listing
Modified Thu Jun 30 20:01:36 2005 UTC (17 years, 3 months ago) by dpavlin
fix for compilation on PostgreSQL 8.0


Revision 26 - Directory Listing
Modified Sun May 29 19:32:28 2005 UTC (17 years, 4 months ago) by dpavlin
rewrite benchmark to use just new function, add bits of documentation


Revision 25 - Directory Listing
Modified Fri May 27 21:06:01 2005 UTC (17 years, 4 months ago) by dpavlin
removed obsolete implementeation without attribute specification which was
also slower according to benchmarks.


Revision 24 - Directory Listing
Modified Fri May 27 12:13:28 2005 UTC (17 years, 4 months ago) by dpavlin
fix path to index


Revision 23 - Directory Listing
Modified Thu May 26 20:22:44 2005 UTC (17 years, 4 months ago) by dpavlin
added small snippet of documentation


Revision 22 - Directory Listing
Modified Thu May 26 20:16:34 2005 UTC (17 years, 4 months ago) by dpavlin
test new function instead of old one


Revision 21 - Directory Listing
Modified Thu May 26 19:43:56 2005 UTC (17 years, 4 months ago) by dpavlin
Generate dumps of used years, titles and quotes. Some parsing fixes


Revision 20 - Directory Listing
Modified Thu May 26 19:42:36 2005 UTC (17 years, 4 months ago) by dpavlin
moved all debug output to DEBUG1 instead of INFO, fixed compilation warning


Revision 19 - Directory Listing
Modified Thu May 26 17:56:53 2005 UTC (17 years, 4 months ago) by dpavlin
Created new function which allows users to specify attributes which should
be returned like this:

select * from pgest('/index/path', 'query', '@title ISTRINC foo', limit, offset, {'@id','@title','@size'}) as (id text, title text, size text);


Revision 18 - Directory Listing
Modified Thu May 26 14:07:04 2005 UTC (17 years, 4 months ago) by dpavlin
simple estseek configuration for testing searches


Revision 17 - Directory Listing
Modified Thu May 26 13:57:32 2005 UTC (17 years, 4 months ago) by dpavlin
added year to index data


Revision 16 - Directory Listing
Modified Thu May 26 00:16:48 2005 UTC (17 years, 4 months ago) by dpavlin
added size of each trivia to index (and back to output)


Revision 15 - Directory Listing
Modified Thu May 26 00:15:57 2005 UTC (17 years, 4 months ago) by dpavlin
add html target to re-generate ChangeLog.html


Revision 14 - Directory Listing
Modified Thu May 26 00:06:10 2005 UTC (17 years, 4 months ago) by dpavlin
tests and fix for limit and offset bug introduced with null handling


Revision 13 - Directory Listing
Modified Thu May 26 00:05:33 2005 UTC (17 years, 4 months ago) by dpavlin
example how to find references to Blade Runner in other movies :-)


Revision 12 - Directory Listing
Modified Wed May 25 23:38:37 2005 UTC (17 years, 4 months ago) by dpavlin
added NULL handling for optional arguments


Revision 11 - Directory Listing
Modified Wed May 25 23:28:15 2005 UTC (17 years, 4 months ago) by dpavlin
decrease memory usage to 64Mb (useful when running from tmpfs)


Revision 10 - Directory Listing
Modified Wed May 25 23:27:35 2005 UTC (17 years, 4 months ago) by dpavlin
add title rank to 3, small fix in index generation


Revision 9 - Directory Listing
Modified Sun May 22 21:18:11 2005 UTC (17 years, 4 months ago) by dpavlin
support query in which only attribute is specified


Revision 8 - Directory Listing
Modified Fri May 20 22:09:16 2005 UTC (17 years, 4 months ago) by dpavlin
tests, some of which fail (which is whole point of having tests, I guess)


Revision 7 - Directory Listing
Modified Fri May 20 22:01:19 2005 UTC (17 years, 4 months ago) by dpavlin
more work on testing framework


Revision 6 - Directory Listing
Modified Fri May 20 21:29:39 2005 UTC (17 years, 4 months ago) by dpavlin
make test database from IMDB's trivia


Revision 5 - Directory Listing
Modified Fri May 20 19:44:09 2005 UTC (17 years, 4 months ago) by dpavlin
added attribute to function, fixed warnings, fixed limit and offset


Revision 4 - Directory Listing
Modified Fri May 20 18:45:01 2005 UTC (17 years, 4 months ago) by dpavlin
bugfix: return null for 0 sized attributes


Revision 3 - Directory Listing
Modified Fri May 20 16:11:38 2005 UTC (17 years, 4 months ago) by dpavlin
added limit and offset


Revision 2 - Directory Listing
Modified Fri May 20 13:00:46 2005 UTC (17 years, 4 months ago) by dpavlin
changed debug level, ignore some files


Revision 1 - Directory Listing
Added Fri May 20 12:19:05 2005 UTC (17 years, 4 months ago) by dpavlin
initial import of API between Estraier and PostgreSQL


  ViewVC Help
Powered by ViewVC 1.1.26