2007-07-13 10:12:54 dpavlin r87
/trunk/README.pod: added IMDB download link for test database (trivia)
2007-04-18 15:55:47 dpavlin r86
/trunk/data/indexer.pl: support for multiple quotes
2007-02-03 17:13:07 dpavlin r85
/trunk/pgest.c: add PG_MODULE_MAGIC for PostgreSQL 8.2
2007-01-18 11:02:57 dpavlin r84
/trunk/data/trivia.sql: added indexes
2007-01-17 22:30:14 dpavlin r83
/trunk/data/indexer.pl, /trunk/data/convert.pl, /trunk/data/trivia.sql, /trunk/data/Makefile, /trunk/data/trivia, /trunk/data/db.pl, /trunk/data/parse_trivia.pm: restructure IMDB trivia parser, added db target to create trivia database in PostgreSQL
2006-11-26 21:21:46 dpavlin r82
/trunk/bin/pgest-index.pl: don't add to full-text index primary keys with names beginning with _
2006-08-09 17:25:31 dpavlin r81
/trunk/README.pod: finished see also, with note about queryies
2006-08-08 12:15:55 dpavlin r80
/trunk/pgest.c: bugfix: offset implementation didn't return all records
2006-08-08 11:42:01 dpavlin r79
/trunk/pgest.c: update trigger now uses est_node_edit_doc (as it should)
2006-08-08 11:40:09 dpavlin r78
/trunk/bin/pgest-index.pl: delete just existing triggers
2006-08-08 11:01:00 dpavlin r77
/trunk/bin/pgest-index.pl: try unique index if primary key doesn't exits
2006-08-07 23:24:54 dpavlin r76
/trunk/Makefile: re-generate documentation on cvs target
2006-08-07 23:22:29 dpavlin r75
/trunk/Makefile, /trunk/README.pod, /trunk/Tutorial.pod: minor modificaton to cross-link documentation and actually transfer all of it to pgfoundry.org
2006-08-07 22:53:46 dpavlin r74
/trunk/bin/pgest-index.pl: turn debug off
2006-08-07 22:47:41 dpavlin r73
/trunk/pgest.c: hush size_t warning
2006-08-07 22:44:21 dpavlin r72
/trunk/pgest.c: hush compiler warning
2006-08-07 22:07:49 dpavlin r71
/trunk/Tutorial.pod: tutorial is very short, thanks to helper script :-)
2006-08-07 21:08:41 dpavlin r70
/trunk/bin/pgest-index.pl: finish (hopefully) documentation. perldoc pgsql-index.pl is now really useful :-)
2006-08-07 17:30:56 dpavlin r69
/trunk/bin/pgest-index.pl: single-line progress bar (if it fits), only thing going to STDOUT is example SQL query (so it can be redirected to file)
2006-08-07 17:05:07 dpavlin r68
/trunk/bin/pgest-index.pl: 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
2006-08-07 16:38:24 dpavlin r67
/trunk/bin/pgest-index.pl: added chunk of documentation and ability to --create or --drop indexes
2006-08-07 14:56:08 dpavlin r66
/trunk/bin/pgest-index.pl: 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)
2006-08-07 14:47:00 dpavlin r65
/trunk/bin/pgest-index.pl: print example SQL search query at end
2006-08-07 14:32:21 dpavlin r64
/trunk/README.pod: improved documentation, now this project is full-text index for PostgreSQL and not just search function :-)
2006-08-07 14:30:55 dpavlin r63
/trunk/bin/pgest-index.pl: drop triggers at beginning, work inside transaction, create pgest and pgest_trigger functions
2006-08-07 13:24:49 dpavlin r62
/trunk/bin, /trunk/bin/pgest-index.pl: script to create pgest index on PostgreSQL database (modification of dbi-indexer.pl from Search::Estraier distribution)
2006-08-07 11:14:52 dpavlin r61
/trunk/pgest.sql, /trunk/pgest.c: added pgest_trigger function which allows updateable indexes
2006-07-11 14:11:42 dpavlin r60
/trunk/README.pod: make it in sync with relity
2006-05-25 18:46:49 dpavlin r59
/trunk/Makefile, /trunk/README.pod, /trunk/data/indexer.pl, /trunk/Tutorial.pod: begin tutorial
2006-05-25 17:50:13 dpavlin r58
/trunk/test.sql: example how to return hints (which require de-normalized schema)
2006-05-11 16:19:38 dpavlin r57
/trunk/test.sql, /trunk/pgest.c: initial implementation of hints using (fake) atribute names in form HINTS.something (e.g. HITS.HIT or HINTS.WORDNUM...)
2006-05-11 15:52:50 dpavlin r56
/trunk/Makefile, /trunk/test.sql, /trunk/pgest.c: fix multiple attributes delimited with {{!}}, fix warnings
2006-05-11 11:43:36 dpavlin r55
/trunk/Makefile: 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)
2006-05-11 10:19:46 dpavlin r54
/trunk/test.sql, /trunk/README.pod: updated documentation and example for convert
2006-05-11 10:18:32 dpavlin r53
/trunk/data/Makefile: script now creates index on it's own
2006-05-11 10:18:08 dpavlin r52
/trunk/data/indexer.pl: create node if needed
2006-05-09 22:55:42 dpavlin r51
/trunk/test.sql, /trunk/README.pod, /trunk/pgest.c, /trunk/t/pgest.t: depriciated usage of direct access to index. use node API and estmaster instead.
2006-04-14 16:17:19 dpavlin r50
/trunk/data/indexer.pl, /trunk/data/Makefile: remove direct database creation and use node API always via Search::Estraier
2005-10-29 18:54:40 dpavlin r49
/trunk/test.sql, /trunk/README.pod, /trunk/pgest.sql, /trunk/pgest.c, /trunk/t/pgest.t: added depth to node API version of pgest, note that you have to use modified perl wrapper with node API
2005-10-20 16:24:26 dpavlin r48
/trunk/pgest.c: moved argument offsets into #define(s)
2005-09-11 21:44:56 dpavlin r47
/trunk/pgest.c: few more check to keep PostgreSQL from segfaulting in case of errors
2005-09-11 21:44:11 dpavlin r46
/trunk/data/Makefile: drop and re-create trivia node
2005-09-10 23:08:47 dpavlin r45
/trunk/t/pgest.t: test node API version of pgest
2005-09-10 22:51:03 dpavlin r44
/trunk/pgest.c: check if search failed and report status
2005-09-10 22:33:36 dpavlin r43
/trunk/README.pod: few more changes to documentation
2005-09-10 21:48:46 dpavlin r42
/trunk/README.pod: updated documentation to reflect two different ways to call pgest with example
2005-09-10 20:35:09 dpavlin r41
/trunk/test.sql, /trunk/pgest.sql, /trunk/data/indexer.pl, /trunk/pgest.c: added node API
2005-09-10 18:51:13 dpavlin r40
/trunk/test.sql, /trunk/pgest.c: add support for multiple attributes delimited by {{!}}
2005-07-08 15:26:04 dpavlin r39
/trunk/pgest.c: removed misleading INFO message (hint: it's not a bug)
2005-07-08 12:47:49 dpavlin r38
/trunk/pgest.c: added est_cond_set_max to return just minumum needed resutls from Hyper Estraier
2005-07-07 17:24:22 dpavlin r37
/trunk/Makefile, /trunk/test.sql: misc cleanups
2005-07-07 17:21:50 dpavlin r36
/trunk/Makefile: nicer dependency, doesn't recompile pgest.so if not needed
2005-07-07 14:18:49 dpavlin r35
/trunk/data/indexer.pl: added sync()
2005-07-06 16:44:46 dpavlin r34
/trunk/Makefile: update project home page with documentation
2005-07-06 16:35:51 dpavlin r33
/trunk/README, /trunk/Makefile, /trunk/README.pod: converted documentation to pod
2005-07-06 15:15:04 dpavlin r32
/trunk/t/pgest.t: test ordering
2005-07-06 14:47:56 dpavlin r31
/trunk/test.sql, /trunk/pgest.sql, /trunk/pgest.c, /trunk/t/pgest.t: 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
2005-07-06 14:34:10 dpavlin r30
/trunk/data/indexer.pl: small cleanup
2005-07-06 11:47:56 dpavlin r29
/trunk/README, /trunk/data/indexer.pl, /trunk/data/Makefile: added indexer.pl written using perl Hyper Estraier bindings
2005-07-01 12:50:53 dpavlin r28
/trunk/Makefile: cvs target for pgfoundry
2005-06-30 20:01:36 dpavlin r27
/trunk/pgest.c: fix for compilation on PostgreSQL 8.0
2005-05-29 19:32:28 dpavlin r26
/trunk/misc/bench.pl, /trunk/misc/bench.txt: rewrite benchmark to use just new function, add bits of documentation
2005-05-27 21:06:01 dpavlin r25
/trunk/test.sql, /trunk/pgest.sql, /trunk/pgest.c, /trunk/misc/bench.pl, /trunk/t/pgest.t, /trunk/misc/bench.txt, /trunk/estseek/estseek.conf, /trunk/misc: removed obsolete implementeation without attribute specification which was also slower according to benchmarks.
2005-05-27 12:13:28 dpavlin r24
/trunk/test.sql: fix path to index
2005-05-26 20:22:44 dpavlin r23
/trunk/README, /trunk/Makefile, /trunk/test.sql: added small snippet of documentation
2005-05-26 20:16:34 dpavlin r22
/trunk/t/pgest.t: test new function instead of old one
2005-05-26 19:43:56 dpavlin r21
/trunk/data/convert.pl: Generate dumps of used years, titles and quotes. Some parsing fixes
2005-05-26 19:42:36 dpavlin r20
/trunk/pgest.c: moved all debug output to DEBUG1 instead of INFO, fixed compilation warning
2005-05-26 17:56:53 dpavlin r19
/trunk/test.sql, /trunk/pgest.sql, /trunk/pgest.c: 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);
2005-05-26 14:07:04 dpavlin r18
/trunk/estseek/estseek.tmpl, /trunk/estseek, /trunk/estseek/estseek.cgi, /trunk/estseek/estseek.top, /trunk/estseek/estseek.conf: simple estseek configuration for testing searches
2005-05-26 13:57:32 dpavlin r17
/trunk/test.sql, /trunk/data/convert.pl: added year to index data
2005-05-26 00:16:48 dpavlin r16
/trunk/data/convert.pl, /trunk/pgest.c: added size of each trivia to index (and back to output)
2005-05-26 00:15:57 dpavlin r15
/trunk/Makefile: add html target to re-generate ChangeLog.html
2005-05-26 00:06:10 dpavlin r14
/trunk/pgest.c, /trunk/t/pgest.t: tests and fix for limit and offset bug introduced with null handling
2005-05-26 00:05:33 dpavlin r13
/trunk/test.sql: example how to find references to Blade Runner in other movies :-)
2005-05-25 23:38:37 dpavlin r12
/trunk/test.sql, /trunk/pgest.sql, /trunk/pgest.c, /trunk/t/pgest.t: added NULL handling for optional arguments
2005-05-25 23:28:15 dpavlin r11
/trunk/data/Makefile: decrease memory usage to 64Mb (useful when running from tmpfs)
2005-05-25 23:27:35 dpavlin r10
/trunk/data/convert.pl: add title rank to 3, small fix in index generation
2005-05-22 21:18:11 dpavlin r9
/trunk/pgest.c, /trunk/t/pgest.t: support query in which only attribute is specified
2005-05-20 22:09:16 dpavlin r8
/trunk/t/pgest.t, /trunk/data: tests, some of which fail (which is whole point of having tests, I guess)
2005-05-20 22:01:19 dpavlin r7
/trunk/Makefile, /trunk/test.sql,
/trunk/t/limit_offset.sh, /trunk/data/convert.pl, /trunk/pgest.c, /trunk/data/Makefile: more work on testing framework
2005-05-20 21:29:39 dpavlin r6
/trunk/Makefile, /trunk/data/convert.pl, /trunk/data/Makefile, /trunk/data: make test database from IMDB's trivia
2005-05-20 19:44:09 dpavlin r5
/trunk/test.sql, /trunk/pgest.sql, /trunk/pgest.c: added attribute to function, fixed warnings, fixed limit and offset
2005-05-20 18:45:01 dpavlin r4
/trunk/pgest.c: bugfix: return null for 0 sized attributes
2005-05-20 16:11:38 dpavlin r3
/trunk/test.sql, /trunk/t/limit_offset.sh, /trunk/pgest.sql, /trunk/t, /trunk/pgest.c: added limit and offset
2005-05-20 13:00:46 dpavlin r2
/trunk, /trunk/pgest.c: changed debug level, ignore some files
2005-05-20 12:19:05 dpavlin r1
/trunk/Makefile, /trunk/test.sql, /trunk, /trunk/pgest.sql, /trunk/pgest.c: initial import of API between Estraier and PostgreSQL