tilo/backend/data, branch load-some-outside-overflow Tilo: Interactive Tree of Life https://terryt.dev/cgit/tilo/atom?h=load-some-outside-overflow 2022-05-15T06:43:22+00:00 Converted nodes+r_nodes tables into nodes+edges+r_nodes+r_edges 2022-05-15T06:43:22+00:00 Terry Truong terry06890@gmail.com 2022-05-14T14:46:39+00:00 urn:sha1:a4673571570816a06d4188169fc00dada79ec0a3 Conversion avoids encoding node children as JSON strings, and allows for easier querying of edge data. Adjusted server to use new format. Also added some table indexes for common operations. Add desc-resolution special-case for root node 2022-05-14T11:20:15+00:00 Terry Truong terry06890@gmail.com 2022-05-14T10:37:29+00:00 urn:sha1:9a647b3fe26b9928c254003446b96e9ea0ea70e1 Supplement DBpedia descs with enwiki's 2022-05-14T10:13:38+00:00 Terry Truong terry06890@gmail.com 2022-05-14T10:13:35+00:00 urn:sha1:36d3d535b646e65f4b38e8097ce0b74b784520ba Use DBpedia data for node descriptions 2022-05-14T09:39:10+00:00 Terry Truong terry06890@gmail.com 2022-05-14T09:30:43+00:00 urn:sha1:c97acf8852e2017fd4776d65069f707121405f43 Add backend/data/dbpedia/ directory containing scripts and README for obtaining DBpedia data, storing it into a db, converting/adding description data to data.db, and for resolving tol-node DBpedia-node association conflicts (via DBpedia relations, manual listing, etc). Resulted in less (about 3/4 as many) descriptions as with using enwiki, but with notably less mis-associations (eg: node Thor is described as a shrimp instead of a god). Adjust reviewImgs.py to remove EXIF orientation data 2022-05-12T13:21:52+00:00 Terry Truong terry06890@gmail.com 2022-05-12T13:21:52+00:00 urn:sha1:670b17f94d17514ea679261669978dbc7077bef8 Commit reduced-tree name-list data 2022-05-11T14:15:35+00:00 Terry Truong terry06890@gmail.com 2022-05-11T14:15:35+00:00 urn:sha1:d67dd368322edcbcb921a138d0a327f726f4012d Add reduced-tree data generation+serving+querying+setting 2022-05-11T14:10:12+00:00 Terry Truong terry06890@gmail.com 2022-05-11T14:10:12+00:00 urn:sha1:e1ef2bf3387769de4edc4a7ec1a6d38c5a21c5e7 Add genReducedTreeData.py, which generates a reduced_nodes table. Adjust server to serve that data for queries with a tree=reduced query param. Adjust client to query for that data depending on a useReducedTree variable. Add a SettingsPane setting to change that useReducedTree variable. Do minor code cleanup 2022-05-11T02:43:38+00:00 Terry Truong terry06890@gmail.com 2022-05-11T02:43:38+00:00 urn:sha1:4872ce9c22cc3c7024075f66409efdaf8860e9b8 Use prefix-search with ranking-by-length 2022-05-11T01:44:14+00:00 Terry Truong terry06890@gmail.com 2022-05-10T09:52:47+00:00 urn:sha1:6c61612564b9a30f747207c43729c3e7e8cbf0d3 Add quotes around displayed alt-names 2022-05-10T05:40:58+00:00 Terry Truong terry06890@gmail.com 2022-05-10T05:40:58+00:00 urn:sha1:3d895370a608d4f51726b74e2560dcf5f4ec43a8