I Need to Learn About Databases

I have reached the point in my programming journey where I want to build apps that pull from a vast collection of data – but so far, I only know how to work with JSON, and not very well, at that.

I have heard of CSV, of MySQL, ProgestreSQL, and the browser database storage system IndexDB(?). Each seems to have its own history and use cases, so I am not sure which one would be best for me.

Here is what I want:

  • A way to store data privately
  • A data management system that is fast, efficient, and scalable
  • A data management system that supports both hierarchical and tag-based organization simultaneously
  • A system that has as few security vulnerabilities and dependencies as possible
  • A system that runs efficiently enough to support flexible data querying and visualization
  • A system that prioritizes maintainability

I am not sure if I am asking too much. I am going to continue hacking away at mastering JSON and JS array methods. However, I sense that I will need to get into MySQL and IndexedDB soon.

I will continue to post about my learning process. Stay tuned! If you have any suggestions or helpful tips, please drop them in the comments!

Leave a Reply

Your email address will not be published. Required fields are marked *