License is one of the fields of the datasource table. When adding new entries, one will want to choose a license from that table. Finding the right license using pure SQL works, but not very well. One problematic example:
Using SQL ILIKE, no entry is found for "%Creative Commons Attribution Share-Alike 4.0%". However, there is an entry "Creative Commons Attribution Share Alike 4.0 International" in the database. It is not found because of the hyphen in the query string.
Contributions to making license querying smarter are very welcome! In fact, we may want to make querying smarter not just for licenses but for all of the tables.
License is one of the fields of the datasource table. When adding new entries, one will want to choose a license from that table. Finding the right license using pure SQL works, but not very well. One problematic example:
Using SQL ILIKE, no entry is found for "%Creative Commons Attribution Share-Alike 4.0%". However, there is an entry "Creative Commons Attribution Share Alike 4.0 International" in the database. It is not found because of the hyphen in the query string.
Contributions to making license querying smarter are very welcome! In fact, we may want to make querying smarter not just for licenses but for all of the tables.