WebStat analyser/src/schema.sql, branch webstat-0.4WebStat web site access analyserhttps://git.randomdan.homeip.net/repo/webstat/atom?h=webstat-0.42026-04-17T23:53:11ZSwap 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:04acfa679fd846ac829ded5562093b3766c85154Attempt to save uninsertable log lines to the entities table2026-01-17T20:33:37ZDan Goodliffedan@randomdan.homeip.net2026-01-17T19:40:47Zurn:sha1:34051da2f27ffa40d0b6d20ae891a497fe73bfe5
If that fails, we still park them as before, such as when the DB is
unavailable. Those which are saved as entities require investigation why
they couldn't be saved, much like UnparsableLines.
pg_format schema.sql and sql/*.sql2026-01-17T20:33:37ZDan Goodliffedan@randomdan.homeip.net2026-01-17T18:33:56Zurn:sha1:9f1dfacb0f236da5f0413ac20e3376388df7d798
No changes.
Add access_log_view2025-10-15T22:21:50ZDan Goodliffedan@randomdan.homeip.net2025-10-15T22:21:50Zurn:sha1:b4b57337e69f1ee0b816369ed6b7d657ee11da8c
A pre-joined with entities view showing all the original data along with
ids; ideal for human readable stuff.
Add PROPFIND to http_verb list2025-10-09T13:21:30ZDan Goodliffedan.goodliffe@octal.co.uk2025-10-09T13:21:30Zurn:sha1:bc05a99df780313ba3cc298323e98beaa5b0ba54Switch to PostgreSQL's oid type for entity ids2025-09-29T23:51:54ZDan Goodliffedan@randomdan.homeip.net2025-09-29T23:51:54Zurn:sha1:edfaf671d016f675a3a3b87d58d615a92e84148b
oid is an "unsigned 4 byte integer", which matches our crc32 approach
perfectly, and is half the storage cost of bigint.