Age | Commit message (Collapse) | Author | Files | Lines |
|
The code is a bit more complicated now, and it's not a lot faster, but
at least this helps a bit.
|
|
This is implemented by adding ihid (item hidden) and ilock (item
locked) columns to the changes table,
The (vn|release|producer).(hidden|locked) columns now work as a
cache, refering to the changes.(ihid|ilock) columns with
changes.id = (vn|release|producer).latest.
The cached columns are updated automatically each time a new revision is
inserted.
This is a pretty large change, bugs are quite likely.
|
|
|
|
Also added a little sanity checking on the edit_(vn|release) table,
and added a default value for releases_rev.released.
|
|
This will make it easier to do automated edits, either from cron jobs,
Multi, update scripts, or from within SQL triggers.
So far only the VN related functions have been defined/updated, trying
to edit/add releases or producers will not work at the moment.
The functions for editing or adding a new database entry have been
merged, as the procedure is rather similar.
util/dump.sql will be updated later on.
|
|
This column was used to differentiate between automated edits and user
edits, but that later changed to checking for changes.requester = 1.
The column has since never really been used, and due to a bug introduced
in VNDB 2.0, it has never been updated, either. Meaning it's not even
accurate for any database changes made after december 2008...
|
|
And also changed the way the item_table.latest column was updated: it is
now only updated after the revision insert has completed, making it
easier to write trigger functions in 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...
|
|
Performance improvement of ~15ms for all release and VN browse pages.
There are in total 20 known languages in the DB, and 12 of them are
actually used (i.e. a release in that language exists). Which means 8 of
the listed language filters won't produce any results (yet), but I'd say
that's an accaptable trade-off.
|
|
That was the last one. I hope I haven't forgotten to update anything.
|
|
The 'language' column in releases_rev has been replaced with a
releases_lang table. As this is quite a big change, there may still
be bugs floating around somewhere.
|
|
|
|
|
|
No idea why, but it looks like a mess :-(
|
|
DB/{Votes,VNList,WishList}.pm into ULists.pm
|
|
We're getting there...
|
|
Because I can't say no to a performance increase of 4 to 7ms
for -every- pageview!
Makes use of postgresql triggers and stored procedures.
|
|
go to Multi again
|
|
They pretty much all work the same anyway
|
|
History browser is now pretty much done
|
|
|
|
The query is starting to get pretty heavy, might want to cache a few
columns to get rid of all those table joins
|
|
Currently relies on the fact that Multi is the only one making the
automated edits
|
|
Doesn't work for r+ and v+ yet. Filter options pending...
|
|
...and those URL regexes are getting more and more complex >.>
|
|
|
|
...and I created yet another *::Misc module...
|