WebStat analyser/src/schema.sql, branch webstat-0.6WebStat web site access analyserhttp://git.randomdan.homeip.net/repo/webstat/atom?h=webstat-0.62026-05-18T23:53:27ZAdd index for uninsertable lines with no failure detail2026-05-18T23:53:27ZDan Goodliffedan@randomdan.homeip.net2026-05-18T23:53:27Zurn:sha1:cabd894779c2d2e453c8ed7771fdbd17c881bc2c
This index would be empty under normal conditions.
Be specific about values from entities table2026-05-09T23:41:56ZDan Goodliffedan@randomdan.homeip.net2026-05-09T23:41:56Zurn:sha1:5111c39ad9c1665347471da9fc1ae5737e37cde5
Fixes compatibility with PostgreSQL 18 which fails due to ambiguity.
Only call entity insert handler if detail is null2026-05-05T11:24:11ZDan Goodliffedan.goodliffe@octal.co.uk2026-05-05T11:24:11Zurn:sha1:200c3636b600ac2f997316612f1b1321112496cd
Improves handling of entity inserts where the entity already exists and
already has detail; does not call the onInsert handler. This avoids
repeatedly fetching UA detail every time the UA is first seen by a
process.
Add indexes on all entity references in access_log2026-04-26T15:14:50ZDan Goodliffedan@randomdan.homeip.net2026-04-26T15:14:50Zurn:sha1:ada3ab9f84dfa2df733d48d516476203a361ac63Add BRIN index to access_log.request_time and improve purge2026-04-23T09:11:13ZDan Goodliffedan.goodliffe@octal.co.uk2026-04-23T09:11:13Zurn:sha1:7c59f2b66284b5b561c5368a0c834640ae0e611e
Purge is now fully request_time based and not hacked around id ranges.
Swap int for integer in schema2026-04-17T23:53:11ZDan Goodliffedan@randomdan.homeip.net2026-04-17T23:53:11Zurn:sha1:fa6074eaf52be4254c17b74f20193aa96c940df8
Plays better with apgdiff
Replace use of crc32 for entity id2026-04-15T11:05:20ZDan Goodliffedan.goodliffe@octal.co.uk2026-04-15T11:03:21Zurn:sha1:5b2166496e5f3ff2c4276e0b5b28f109c70673d5
Entity value is MD5 hashed same as DB unique key, but the id itself is
now taken from the DB primary key which is sequence generated.
Replace unique constraint on entity value with index on hash2026-03-18T13:19:42ZDan Goodliffedan.goodliffe@octal.co.uk2026-03-18T13:19:42Zurn:sha1:076679d9f2b761a9e4892e399f1a16f141d85986
UNIQUE CONSTRAINT is limited to 2704 bytes, which prevents inserting
large values. Here we swap to a unique index on the MD5 hash of the
value. This should more than suffice given we already map to a 32bit for
the id and the index size is much much smaller.
Fix typo in access_log_view definition2026-03-18T10:25:09ZDan Goodliffedan.goodliffe@octal.co.uk2026-03-18T10:25:09Zurn:sha1:e247e81f649297784dc81e83b2e6d33d30f9f3ee
Replaces accidentally duplicated user_agent for correct content_type.
Process new field, content-type, in input stream2026-01-18T01:36:06ZDan Goodliffedan@randomdan.homeip.net2026-01-18T01:36:06Zurn:sha1:04acfa679fd846ac829ded5562093b3766c85154