summaryrefslogtreecommitdiff
path: root/README
AgeCommit message (Collapse)AuthorFilesLines
2018-06-03Add development DB dump, remove old devdb, convert README to markdownYorhel1-133/+0
2018-02-08Store d+ pages in the DB as versioned entries + use markdownYorhel1-0/+1
This touches a bunch of things: - Adds a new first-class database entry type - Removes the d+.+.+ BBCode link syntax, adds a new d+#+ and d+#+.+ link syntax (references have been updated where possible) - Adds a new dependency on Text::MultiMarkdown
2018-02-04Add "development database" for quick setup & testing purposesYorhel1-0/+19
+ a bit of tooling to make it work. The database was contributed by tigershark, with a few minor additions by me.
2017-12-29Experimenting with PostgreSQL 10: "UNENCRYPTED" keyword has been removedYorhel1-3/+3
2017-12-09Add vndb-dev-server.pl, an autoreloading http serverYorhel1-1/+1
2017-12-09Add Docker configYorhel1-1/+17
2017-12-06Add instructions for running VNDB as standalone web serverYorhel1-24/+6
2017-11-25Remove broken SQL functions from Makefile + add install instructionsYorhel1-12/+52
2016-09-18Suppress silly Perl 5.22 warnings about extra sprintf argsYorhel1-2/+2
2016-01-17Use Tie::IxHash for some global.pl listsYorhel1-13/+8
This removes the reliance on sort() to provide meaningful ordering (the keys aren't always good for ordering) and removes the 'order' hack used for (vn|prod)_relations.
2015-08-17jsgen: Support external command for JS compression (like uglifyjs)Yorhel1-0/+1
Tends to compress a bit better than JavaScript::Minifier::JS. But is also a lot slower, so not really useful when devving. Stats for en.js: raw gzip uglifyjs 68199 19446 JS::Minifier::XS 79862 21624 Uncompressed 107662 28663 On an unrelated note, I like how jQuery boasts about being "Only 32kB minified and gzipped.". That's quite a bit more than all of VNDB's Javascript combined. For a damn library.
2015-08-10js: Move generated variables into global VARS structureYorhel1-0/+2
This removes one source of namespace polution, and makes it more clear which code is using the variables.
2015-05-11Generate icons.png and associated CSS automaticallyYorhel1-0/+4
It became a bit of a hassle to keep updating that file manually in Gimp. This script performs surprisingly well for our set of icons.
2015-04-28README: Requirements updatesYorhel1-8/+7
I'm not sure which postgres version is the minimum, but I'm sure most recent update scripts use 9.3 features. Main site runs on 9.4 at the moment.
2014-10-15Let's call this 2.232.23Yorhel1-0/+2
2014-10-15Auth: Use a proper CSPRNG for generating salt and tokensYorhel1-0/+1
2013-01-05Don't use Multi for processing screenshotsYorhel1-2/+0
TODO: Get rid of the 'processing' flag and all the async loading of screenshot data in the screenshot uploader.
2013-01-05Don't use Multi for processing VN cover imagesYorhel1-0/+1
I used to do this to avoid loading Image::Magick in each TUWF process, decreasing memory usage, and lowering the blocking time by avoiding too much processing. Memory isn't much of a problem nowadays, and processing images is fast enough, too, so this complexity isn't necessary anymore. (Character images and screenshots pending)
2013-01-04Added daily-generated JSON dump of the tag informationYorhel1-0/+3
This isn't documented yet.
2012-07-24README & d7 updatesYorhel1-3/+3
2011-05-01Switched back to Algorithm::Diff::XSYorhel1-1/+1
Algorithm::Diff::Fast suddenly disappeared for some reason...
2011-02-08Uploaded some design/implementation notes I had lying aroundYorhel1-0/+5
Used to be private, with the sole purpose of getting a good overview of things for myself, but I guess these may also be useful to others.
2011-01-27Multi::RG: Use TUWF::XML instead of XML::WriterYorhel1-1/+0
This removes the last dependency on XML::Writer.
2011-01-27Multi::Feed: Use TUWF::XML instead of XML::WriterYorhel1-2/+0
2011-01-25TUWF: Initial convert from YAWF to TUWFYorhel1-3/+2
There may still be some bugs present and I've only converted the points where TUWF is incompatible with YAWF. The new TUWF features are not in use yet, I'll do that later on. Note that, in order to run the new code, TUWF must be installed on your system. The configuration for the TransAdmin plugin has also changed. Other than that there shouldn't be any issues.
2010-12-09Write VNDBUtil::uri_escape() and removed dependency on URI::EscapeYorhel1-1/+0
Its functionality is too simpel to require it as a special dependency, seriously.
2010-11-21Implemented the server side of the new release filter selectorYorhel1-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-14SQL: Added WHEN clause to all TRIGGERs for which it was usefulYorhel1-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-13Multi::Feed: Added Atom feedsYorhel1-2/+4
TODO: add links to these feeds from the site
2010-11-11Replaced Algorithm::Diff::XS with Algorithm::Diff::FastYorhel1-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-02Updated README to reflect the removal of the sitemapYorhel1-3/+0
2009-11-29SQL: Rewrote tag_vn_calc() to use a WITH RECURSIVE .. SELECT queryYorhel1-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-04API: Initial commit of the W.I.P. public APIYorhel1-0/+2
d11 does not fully reflect what has been implemented, and things are likely to change.
2009-10-07JS: Moved script.js to data/ and added jsgen.pl to process itYorhel1-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-07skingen: Used CSS::Minifier::XS instead of my crappy regexesYorhel1-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-25Use inline SVG for relation graphsYorhel1-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-21Added README fileYorhel1-0/+59
Wanted to have a place to document the dependencies, mostly for myself.