SQL: Add C-based "vndbid" type and use it for image IDs

I had already rambled on the current composite type solution in
583ae868dfd3c882a8d2dd40b5d5ed099170c1c2 and I had already explored a
few alternatives. This was the one alternative I hadn't yet explored
because I wasn't sure the operational complexity was going to be worth
it, but after seeing how bad PostgreSQL was at optimizing queries with
composite types, I figured I might as well just go with this approach.

It improves performance of some queries by a *lot* (especially the image
selection query) and it's pretty elegant and convenient to work with.
Only downside is the complexity of compiling, installing and maintaining
a vndbid.so library for PostgreSQL.

1 files changed, 1 insertions, 1 deletions

diff --git a/util/vndb.pl b/util/vndb.pl
index b7aedb27..d926a04e 100755
--- a/util/vndb.pl
+++ b/util/vndb.pl
@@ -39,7 +39,7 @@ tuwf->{elmgen} = $ARGV[0] && $ARGV[0] eq 'elmgen';
 
 
 sub _path {
-    my($t, $id) = $_[1] =~ /\(([a-z]+),([0-9]+)\)/;
+    my($t, $id) = $_[1] =~ /([a-z]+)([0-9]+)/;
     $t = 'st' if $t eq 'sf' && $_[2];
     sprintf '%s/%s/%02d/%d.jpg', $_[0], $t, $id%100, $id;
 }