This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
Log of /trunk
Directory Listing
Revision
88 -
Directory Listing
Modified
Sun Mar 16 20:55:56 2008 UTC
(16 years ago)
by
dpavlin
better error message when run without arguments
Revision
87 -
Directory Listing
Modified
Fri Jul 13 10:12:54 2007 UTC
(16 years, 8 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
(16 years, 11 months ago)
by
dpavlin
support for multiple quotes
Revision
85 -
Directory Listing
Modified
Sat Feb 3 17:13:07 2007 UTC
(17 years, 1 month ago)
by
dpavlin
add PG_MODULE_MAGIC for PostgreSQL 8.2
Revision
84 -
Directory Listing
Modified
Thu Jan 18 11:02:57 2007 UTC
(17 years, 2 months ago)
by
dpavlin
added indexes
Revision
83 -
Directory Listing
Modified
Wed Jan 17 22:30:14 2007 UTC
(17 years, 2 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
(17 years, 4 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
(17 years, 7 months ago)
by
dpavlin
finished see also, with note about queryies
Revision
80 -
Directory Listing
Modified
Tue Aug 8 12:15:55 2006 UTC
(17 years, 7 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
(17 years, 7 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
(17 years, 7 months ago)
by
dpavlin
delete just existing triggers
Revision
77 -
Directory Listing
Modified
Tue Aug 8 11:01:00 2006 UTC
(17 years, 7 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
(17 years, 7 months ago)
by
dpavlin
re-generate documentation on cvs target
Revision
75 -
Directory Listing
Modified
Mon Aug 7 23:22:29 2006 UTC
(17 years, 7 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
(17 years, 7 months ago)
by
dpavlin
turn debug off
Revision
73 -
Directory Listing
Modified
Mon Aug 7 22:47:41 2006 UTC
(17 years, 7 months ago)
by
dpavlin
hush size_t warning
Revision
72 -
Directory Listing
Modified
Mon Aug 7 22:44:21 2006 UTC
(17 years, 7 months ago)
by
dpavlin
hush compiler warning
Revision
71 -
Directory Listing
Modified
Mon Aug 7 22:07:49 2006 UTC
(17 years, 7 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
(17 years, 7 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
(17 years, 7 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
(17 years, 7 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
(17 years, 7 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
(17 years, 7 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
(17 years, 7 months ago)
by
dpavlin
print example SQL search query at end
Revision
64 -
Directory Listing
Modified
Mon Aug 7 14:32:21 2006 UTC
(17 years, 7 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
(17 years, 7 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
(17 years, 7 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
(17 years, 7 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
(17 years, 8 months ago)
by
dpavlin
make it in sync with relity
Revision
59 -
Directory Listing
Modified
Thu May 25 18:46:49 2006 UTC
(17 years, 10 months ago)
by
dpavlin
begin tutorial
Revision
58 -
Directory Listing
Modified
Thu May 25 17:50:13 2006 UTC
(17 years, 10 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
(17 years, 10 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
(17 years, 10 months ago)
by
dpavlin
fix multiple attributes delimited with {{!}}, fix warnings
Revision
55 -
Directory Listing
Modified
Thu May 11 11:43:36 2006 UTC
(17 years, 10 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
(17 years, 10 months ago)
by
dpavlin
updated documentation and example for convert
Revision
53 -
Directory Listing
Modified
Thu May 11 10:18:32 2006 UTC
(17 years, 10 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
(17 years, 10 months ago)
by
dpavlin
create node if needed
Revision
51 -
Directory Listing
Modified
Tue May 9 22:55:42 2006 UTC
(17 years, 10 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
(17 years, 11 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
(18 years, 5 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
(18 years, 5 months ago)
by
dpavlin
moved argument offsets into #define(s)
Revision
47 -
Directory Listing
Modified
Sun Sep 11 21:44:56 2005 UTC
(18 years, 6 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
(18 years, 6 months ago)
by
dpavlin
drop and re-create trivia node
Revision
45 -
Directory Listing
Modified
Sat Sep 10 23:08:47 2005 UTC
(18 years, 6 months ago)
by
dpavlin
test node API version of pgest
Revision
44 -
Directory Listing
Modified
Sat Sep 10 22:51:03 2005 UTC
(18 years, 6 months ago)
by
dpavlin
check if search failed and report status
Revision
43 -
Directory Listing
Modified
Sat Sep 10 22:33:36 2005 UTC
(18 years, 6 months ago)
by
dpavlin
few more changes to documentation
Revision
42 -
Directory Listing
Modified
Sat Sep 10 21:48:46 2005 UTC
(18 years, 6 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
(18 years, 6 months ago)
by
dpavlin
added node API
Revision
40 -
Directory Listing
Modified
Sat Sep 10 18:51:13 2005 UTC
(18 years, 6 months ago)
by
dpavlin
add support for multiple attributes delimited by {{!}}
Revision
39 -
Directory Listing
Modified
Fri Jul 8 15:26:04 2005 UTC
(18 years, 8 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
(18 years, 8 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
(18 years, 8 months ago)
by
dpavlin
misc cleanups
Revision
36 -
Directory Listing
Modified
Thu Jul 7 17:21:50 2005 UTC
(18 years, 8 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
(18 years, 8 months ago)
by
dpavlin
added sync()
Revision
34 -
Directory Listing
Modified
Wed Jul 6 16:44:46 2005 UTC
(18 years, 8 months ago)
by
dpavlin
update project home page with documentation
Revision
33 -
Directory Listing
Modified
Wed Jul 6 16:35:51 2005 UTC
(18 years, 8 months ago)
by
dpavlin
converted documentation to pod
Revision
32 -
Directory Listing
Modified
Wed Jul 6 15:15:04 2005 UTC
(18 years, 8 months ago)
by
dpavlin
test ordering
Revision
31 -
Directory Listing
Modified
Wed Jul 6 14:47:56 2005 UTC
(18 years, 8 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
(18 years, 8 months ago)
by
dpavlin
small cleanup
Revision
29 -
Directory Listing
Modified
Wed Jul 6 11:47:56 2005 UTC
(18 years, 8 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
(18 years, 9 months ago)
by
dpavlin
cvs target for pgfoundry
Revision
27 -
Directory Listing
Modified
Thu Jun 30 20:01:36 2005 UTC
(18 years, 9 months ago)
by
dpavlin
fix for compilation on PostgreSQL 8.0
Revision
26 -
Directory Listing
Modified
Sun May 29 19:32:28 2005 UTC
(18 years, 10 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
(18 years, 10 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
(18 years, 10 months ago)
by
dpavlin
fix path to index
Revision
23 -
Directory Listing
Modified
Thu May 26 20:22:44 2005 UTC
(18 years, 10 months ago)
by
dpavlin
added small snippet of documentation
Revision
22 -
Directory Listing
Modified
Thu May 26 20:16:34 2005 UTC
(18 years, 10 months ago)
by
dpavlin
test new function instead of old one
Revision
21 -
Directory Listing
Modified
Thu May 26 19:43:56 2005 UTC
(18 years, 10 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
(18 years, 10 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
(18 years, 10 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
(18 years, 10 months ago)
by
dpavlin
simple estseek configuration for testing searches
Revision
17 -
Directory Listing
Modified
Thu May 26 13:57:32 2005 UTC
(18 years, 10 months ago)
by
dpavlin
added year to index data
Revision
16 -
Directory Listing
Modified
Thu May 26 00:16:48 2005 UTC
(18 years, 10 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
(18 years, 10 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
(18 years, 10 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
(18 years, 10 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
(18 years, 10 months ago)
by
dpavlin
added NULL handling for optional arguments
Revision
11 -
Directory Listing
Modified
Wed May 25 23:28:15 2005 UTC
(18 years, 10 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
(18 years, 10 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
(18 years, 10 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
(18 years, 10 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
(18 years, 10 months ago)
by
dpavlin
more work on testing framework
Revision
6 -
Directory Listing
Modified
Fri May 20 21:29:39 2005 UTC
(18 years, 10 months ago)
by
dpavlin
make test database from IMDB's trivia
Revision
5 -
Directory Listing
Modified
Fri May 20 19:44:09 2005 UTC
(18 years, 10 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
(18 years, 10 months ago)
by
dpavlin
bugfix: return null for 0 sized attributes
Revision
3 -
Directory Listing
Modified
Fri May 20 16:11:38 2005 UTC
(18 years, 10 months ago)
by
dpavlin
added limit and offset
Revision
2 -
Directory Listing
Modified
Fri May 20 13:00:46 2005 UTC
(18 years, 10 months ago)
by
dpavlin
changed debug level, ignore some files
Revision
1 -
Directory Listing
Added
Fri May 20 12:19:05 2005 UTC
(18 years, 10 months ago)
by
dpavlin
initial import of API between Estraier and PostgreSQL