/[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, 8 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, 5 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, 7 months ago) by dpavlin
support for multiple quotes

Revision 85 - Directory Listing
Modified Sat Feb 3 17:13:07 2007 UTC (15 years, 10 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, 10 months ago) by dpavlin
added indexes

Revision 83 - Directory Listing
Modified Wed Jan 17 22:30:14 2007 UTC (15 years, 10 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 (16 years 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, 4 months 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, 4 months 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, 4 months 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, 4 months ago) by dpavlin
delete just existing triggers

Revision 77 - Directory Listing
Modified Tue Aug 8 11:01:00 2006 UTC (16 years, 4 months 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, 4 months ago) by dpavlin
re-generate documentation on cvs target

Revision 75 - Directory Listing
Modified Mon Aug 7 23:22:29 2006 UTC (16 years, 4 months 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, 4 months ago) by dpavlin
turn debug off

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

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

Revision 71 - Directory Listing
Modified Mon Aug 7 22:07:49 2006 UTC (16 years, 4 months 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, 4 months 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, 4 months 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, 4 months 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, 4 months 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, 4 months 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, 4 months 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, 4 months 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, 4 months 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, 4 months 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, 4 months 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, 5 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, 6 months ago) by dpavlin
begin tutorial

Revision 58 - Directory Listing
Modified Thu May 25 17:50:13 2006 UTC (16 years, 6 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, 7 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, 7 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, 7 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, 7 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, 7 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, 7 months ago) by dpavlin
create node if needed

Revision 51 - Directory Listing
Modified Tue May 9 22:55:42 2006 UTC (16 years, 7 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, 7 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 (17 years, 1 month 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 (17 years, 1 month ago) by dpavlin
moved argument offsets into #define(s)


Revision 47 - Directory Listing
Modified Sun Sep 11 21:44:56 2005 UTC (17 years, 3 months 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, 3 months ago) by dpavlin
drop and re-create trivia node


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


Revision 44 - Directory Listing
Modified Sat Sep 10 22:51:03 2005 UTC (17 years, 3 months 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, 3 months ago) by dpavlin
few more changes to documentation


Revision 42 - Directory Listing
Modified Sat Sep 10 21:48:46 2005 UTC (17 years, 3 months 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, 3 months ago) by dpavlin
added node API


Revision 40 - Directory Listing
Modified Sat Sep 10 18:51:13 2005 UTC (17 years, 3 months 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, 5 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, 5 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, 5 months ago) by dpavlin
misc cleanups


Revision 36 - Directory Listing
Modified Thu Jul 7 17:21:50 2005 UTC (17 years, 5 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, 5 months ago) by dpavlin
added sync()


Revision 34 - Directory Listing
Modified Wed Jul 6 16:44:46 2005 UTC (17 years, 5 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, 5 months ago) by dpavlin
converted documentation to pod


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


Revision 31 - Directory Listing
Modified Wed Jul 6 14:47:56 2005 UTC (17 years, 5 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, 5 months ago) by dpavlin
small cleanup


Revision 29 - Directory Listing
Modified Wed Jul 6 11:47:56 2005 UTC (17 years, 5 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, 5 months ago) by dpavlin
cvs target for pgfoundry


Revision 27 - Directory Listing
Modified Thu Jun 30 20:01:36 2005 UTC (17 years, 5 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, 6 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, 6 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, 6 months ago) by dpavlin
fix path to index


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


Revision 22 - Directory Listing
Modified Thu May 26 20:16:34 2005 UTC (17 years, 6 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, 6 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, 6 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, 6 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, 6 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, 6 months ago) by dpavlin
added year to index data


Revision 16 - Directory Listing
Modified Thu May 26 00:16:48 2005 UTC (17 years, 6 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 months ago) by dpavlin
more work on testing framework


Revision 6 - Directory Listing
Modified Fri May 20 21:29:39 2005 UTC (17 years, 6 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, 6 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, 6 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, 6 months ago) by dpavlin
added limit and offset


Revision 2 - Directory Listing
Modified Fri May 20 13:00:46 2005 UTC (17 years, 6 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, 6 months ago) by dpavlin
initial import of API between Estraier and PostgreSQL


  ViewVC Help
Powered by ViewVC 1.1.26