path: root/.gitignore
diff options
authorYorhel <>2020-04-05 15:18:05 +0200
committerYorhel <>2020-04-05 15:18:27 +0200
commit6d767e48b63c30fd572cff1fdf73bb2e60574848 (patch)
treeb330f7f37b42293fad2579fb7788e2be5ca7ecb6 /.gitignore
parenta53e57953a9f4a9912c70901b3841fd30a80bd1d (diff)
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 library for PostgreSQL.
Diffstat (limited to '.gitignore')
1 files changed, 3 insertions, 0 deletions
diff --git a/.gitignore b/.gitignore
index c8f9e661..eda3cee9 100644
--- a/.gitignore
+++ b/.gitignore
@@ -29,3 +29,6 @@