tilo/backend/data/README.md, 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. 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). 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. 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 Update README line breaks 2022-05-07T01:09:03+00:00 Terry Truong terry06890@gmail.com 2022-05-07T01:09:03+00:00 urn:sha1:ad82c9dc1eb35036c4078b9cd36ae0924e1ff0d2 Fix typo in data entry code 2022-05-06T13:32:02+00:00 Terry Truong terry06890@gmail.com 2022-05-06T13:32:02+00:00 urn:sha1:5f8c7e12b6978e50850b434efbdf4062a4284979 Add db table info to data/README.md 2022-05-05T02:48:25+00:00 Terry Truong terry06890@gmail.com 2022-05-05T02:48:25+00:00 urn:sha1:975638afe73b3aec4617987800fc6871e6134469 Add scripts for obtaining/sending/displaying wikipedia descriptions 2022-05-03T15:17:06+00:00 Terry Truong terry06890@gmail.com 2022-05-03T15:17:06+00:00 urn:sha1:90a5e15bb824b84e5bb60337d6a57a1394090dc6 Add backend/data/enwiki/ directory containing scripts and instructive READMEs. Adjust some other scripts to generate 'eol_ids' sqlite table separate from 'names'. Make server respond to /data/desc requests, and have client TileInfo component display response data. Also adjust .gitignore entries to be root-relative.