vndb - Source code of VNDB.org

Age	Commit message (Collapse)	Author	Files	Lines
2010-11-21	Implemented the server side of the new release filter selector	Yorhel	1	-1/+1
	There's no validation of the filter string yet, and somehow I don't feel like adding that; it's a lot of code and there's nothing to protect - the values are inserted using parameters into a SELECT query, the worst thing that could happen is the user receiving a 500. Also, I've started using the perl '//=' operator, which was added in 5.10. This removes support for older perls.
2010-11-14	SQL: Added WHEN clause to all TRIGGERs for which it was useful	Yorhel	1	-1/+1
	This effectively removes compatibility with all PostgreSQL versions below 9.0. The use of the WHEN clause has two major advantages: 1. Performance: Trigger functions aren't executed when they don't need to. 2. Easier and more general trigger functions; as some of the logic has been placed in the trigger definitions now.
2010-11-13	Multi::Feed: Added Atom feeds	Yorhel	1	-2/+4
	TODO: add links to these feeds from the site
2010-11-11	Replaced Algorithm::Diff::XS with Algorithm::Diff::Fast	Yorhel	1	-1/+1
	This module is cleaner, faster and has less dependencies. (didn't exist yet at the time I first implemented the revision diffs)
2010-11-02	Updated README to reflect the removal of the sitemap	Yorhel	1	-3/+0

2009-11-29	SQL: Rewrote tag_vn_calc() to use a WITH RECURSIVE .. SELECT query	Yorhel	1	-1/+1
	This is more efficient, and doesn't require the tag_tree() or tag_vn_childs() stored procedures. Does require PostgreSQL 8.4+
2009-11-04	API: Initial commit of the W.I.P. public API	Yorhel	1	-0/+2
	d11 does not fully reflect what has been implemented, and things are likely to change.
2009-10-07	JS: Moved script.js to data/ and added jsgen.pl to process it	Yorhel	1	-0/+3
	While this 'processing' is currently limited to minifying the file if JavaScript::Minifier::XS is available, this change would make it a lot easier to make the strings in the JS code translatable.
2009-10-07	skingen: Used CSS::Minifier::XS instead of my crappy regexes	Yorhel	1	-0/+4
	The minified and gzipped CSS file is now 0.7kB smaller than the non-minified but gzipped CSS file. That's significant enough on ~5kB.
2009-09-25	Use inline SVG for relation graphs	Yorhel	1	-1/+3
	The graphs are now stored in the DB in SVG format, the static/rg/ directory can be removed (not used anymore). SVG data is stored using the xml data type, so now I can say for sure you'd need at least PostgreSQL 8.3. This feature still needs some tweaking, though. Current state isn't perfect.
2009-09-21	Added README file	Yorhel	1	-0/+59
	Wanted to have a place to document the dependencies, mostly for myself.