search

CentreForDigitalHumanities / idioms

Database of Dutch Dialect Idioms
https://dutchdialectidioms.uu.nl/
Other
0 stars 0 forks source link

Adjust conversion to SQLite #14

Closed ar-jan closed 1 year ago

ar-jan commented 2 years ago

Various tables and columns appear to be empty or unused for our needs. Carry over only the required data.

jgonggrijp commented 2 years ago

@ar-jan Could you elaborate a bit? In the hypothetical situation that I need to step in, for example because of illness, I would need more information in order to understand what needs to be done.

ar-jan commented 2 years ago

Good point. The story is:

I started building the app by converting the entire MySQL database to SQLite (excluding views), and re-creating the output of the old app by adding the relevant queries. It turns out that there are various tables that aren't used, and in the tables that are used there are many columns that are empty or whose contents weren't exposed publically. This is probably in part for features that were still in development, or that were built but eventually not used by the project.

The quick option is to just use the entire database and not expose the unused structures, but should we want to later open source not only the code but maybe also the database itself, it would be better to create a cleaned up version.

ar-jan commented 2 years ago

Practically, this could be done by running another conversion that only includes tables/columns that are used in the app's code.

ar-jan commented 1 year ago

Done.