I’m using React and NextJS to build out the UI and the frontend server for a personal project. I haven’t done any serious web development since college, and that was mostly using straight HTML/CSS and Javascript. There’s a lot I need to learn in order to be an effective web developer using the above frameworks. It took me 3 hours to get a graph to center on a page and respect the bounds of its parent container....
How to Avoid exposing the Backend API I’ve been learning how to use react and nextJS to build a frontend for one of my projects. I’m using Flask to build the API backend server that will provide the main functionality. I want to limit abuse of the API server and came across several options. Options CORS CORS is a mechanism that’s enforced by the browser to limit access to a server’s resources....
3 Podcasts I’ve been Listening to Podcasts have been around for a long time, but I’ve only started listening to podcasts around the end of 2021/early 2022. I don’t know why I had a bad image of them in my mind and resisted giving them a try. Turns out I was wrong, and podcasts have a variety of formats that aren’t just two guys talking to each other. I could’ve learned a lot while doing chores / driving around instead of listening to the same songs over and over again....
Here are things I would’ve found valuable when first starting out: 1. Version control (git) - beyond the basics As a Computer Student I learned and used git as part of my individual projects and group projects. But, that git knowledge was minimal. It consisted of how to check in code, commit, push to remote, resolve conflicts, create a branch, merge a branch. Working on longer term projects with a larger team required a different set of knowledge like:...
ProxySQL What is ProxySQL? ProxySQL is a performant proxy that offloads the load from the primary mysql db by multiplexing client connection, allowing slow read queries to be redirected to db replicas, and a bunch of other features. I’m going to be focusing on query redirection and the pitfalls I encountered getting it work. Query Redirection There are two main options when it comes to query redirection: Use a different proxysql port or user and have all queries coming from that port or user to use a specific hostgroup Use the query rules to redirect specific queries that match some condition The first option requires changing the application code to use the redirection port or the other user which requires an extra connection....