230624 – New Data Structures

Crazy... But Chill 😎

Along the lines of continuous improvement, I've been looking at ways of improving the UX by implementing new data structures to reduce the number of trips required to the database. Here's the latest awesome release by the team at Chill Music Lab for us to enjoy while we see what I mean 🙂

22-06-26-03

MOOVPAD Relational Databases

Using lookup tables in databases to link information together is normal practice, as far as I can tell from my (limited) learnings of modern database design. I say my learning is limited because I've only really been looking into the science behind it for a relatively short period. But I've also managed to learn a fair bit, and I think I've found another way to improve the database design for MOOVPAD apps.

While this may actually be standard practice for most database engineers (although I'm not sure), my plan is to save data in concatenated strings and then deal with these once the data is retrieved, breaking them down into their constituent parts. I don't expect this approach to be a new thing in any way, but it is new to my thinking and should hopefully save the need for too many trips back to the database.

Hope you have a great day, and I'm looking forward to catching up again soon with more progress 🙂

Stay awesome,

EMH

22-08-12-01

HOW MOOVPAD IS BEING BUILT

For the overview of how MOOVPAD apps are being developed, the reasoning behind particular decisions during development, policies, links to the science and research at the core of MOOVPAD, and more in relation to all the technical things, please see the link to the left.

This will be an ongoing work in progress, and will always be linked to the bottom of each upcoming Blog post.

I AM #LAME7