aboutsummaryrefslogtreecommitdiffstats
path: root/makedb.ml (follow)
Commit message (Collapse)AuthorAgeFilesLines
* store NULL when an element's discovery year is "Ancient"Gravatar Peter McGoron 2021-08-131-0/+1
| | | | | | | | The only elements that do not have a discovery year are those that have been known for about as long as we have historical records. It is highly unlikely that we will discover a new element that will not have a definite year of discovery, so NULL can be used to refer to elements so old nobody knows who discovered it first.
* Use lowercase for all element names and symbolsGravatar Peter McGoron 2021-08-131-5/+6
| | | | | | | The matching algorithm will work better when all names are normalized. For instance, a search of "iorn" will not list "iron" in the first three matches, but a search of "Iorn" will have "iron" as the first match.
* makedb: fix "searchtable" being refered to its old name "cache"Gravatar Peter McGoron 2021-08-131-1/+1
|
* makedb: split newlines for each value and parameterGravatar Peter McGoron 2021-08-131-14/+50
|
* change 'cache' to 'searchtable' in databaseGravatar Peter McGoron 2021-08-101-4/+4
|
* makedb: properly add cacheGravatar Peter McGoron 2021-08-081-9/+10
|
* makedb: make cached automatonGravatar Peter McGoron 2021-08-081-7/+37
|
* makedb: finalize stmtGravatar Peter McGoron 2021-08-081-2/+4
|
* makedb: add cache tableGravatar Peter McGoron 2021-08-081-1/+5
|
* use sqlite to store tableGravatar Peter McGoron 2021-08-081-0/+52