Age | Commit message (Collapse) | Author | Files | Lines |
|
The previous statement was optimized for PostgreSQL 8.3 and took only about a
second, but after the update to 8.4 it took about 10 times longer due to a
different execution plan being generated. This slightly reworded statement
generates a more efficient plan on 8.4.
|
|
avg_rating should be the average rating of all VNs, not the global average
vote.
|
|
Sorting from least to most popular VN make sense now, you won't have to
wade through those entries without any vote at all.
|
|
They still have influence on the average number of votes per VN and the
overall average vote, but this isn't significant. (at least, not at the
moment)
|
|
Was a good idea after all...
|
|
It's even realtime! To my surprise this calculation isn't very heavy, or
PostgreSQL is just extremely fast. The GetVN query on /v/all takes 100ms
in the worst case (instead of the usual 30-60ms). Can always cache this
later on.
|
|
|
|
|
|
|
|
I'm planning to add some more stuff to this makefile later, like
starting/stopping Multi and performing updates.
|
|
The changes.rev column should be correct in the first place, and in the
(most likely) impossible condition that it isn't, the update_rev()
function is more likely to make things worse.
|
|
|
|
|
|
|
|
TODO:
- document the relations
- emit a relgraph notify when needed
|
|
As the same table can easily be used to store producer relation graphs
as well.
|
|
This doesn't mean the relations are final, though...
|
|
Again, mostly copied from the VN relation editor...
|
|
The current list of relations isn't final yet, may be changed later on.
Quite a bit of this code has been copied from the VN relations... need
to find a way to use prober code reuse here.
TODO:
- Nice relation editor interface
- Display relations in revision browser
- Display relations on producer pages
- Generate relation graphs
- Sync update_2.8.sql into dump.sql
|
|
|
|
|
|
|
|
This is a very important column in a very important table, I hope I
didn't forget to update a piece of code somewhere...
|
|
Instead of displaying the total number of threads. Posts are marked as
read when the thread is opened.
|
|
They aren't displayed on the site yet, though.
|
|
|
|
Removed the 'SET default_with_oids', as the minimum required PostgreSQL
version (8.3) has OIDS disables by default already. Also uncommented the
CREATE LANGUAGE, plpgsql is a "trusted language" and as such doesn't
need superuser priveleges to create anymore.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Should be converted to enums at some point... integers don't do the
trick here.
|
|
|
|
|
|
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.
|
|
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.
|
|
Even though the LangFile module is rather low-level, writing this script
was pretty easy.
|
|
Again, two separate but related things.
|
|
OK, these are actually two separate things: to make the relations
translatable they didn't necessarily have to be stored as enum, and I
could've also converted them to enum but not have it translatable.
Nevertheless, it was easier to just do both at the same time.
Also note how I used the string "$____vnrel_<rel>____$" as identifier in
the relation graphs while I could have used something a lot shorter
("$<rel>$" would have been fine, for example). This is done so that
graphviz can make some space for those relations - the long identifier
gives a slightly more realistic representation of the actual length of
the relation titles.
|
|
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.
|
|
This was *supposed* to be done in
ce6d43aed955effe136f1ce3682828d2d43109cb
|
|
|
|
Things are looking good so far.
|
|
|
|
You can ignore the entries in lang.txt, those are simply for testing
purposes.
|
|
|
|
|
|
threads_posts.edited allows NULL values.
|