Hello fellow programming enthusiast!

API Optimization So far, we’ve built a simple REST API that exposes basic stock ticker resources, including historical data, tickers, and technical indicators such as SMAs. Our database consists of roughly 25 million rows and has a size of around 2GB. Although the database isn’t exceptionally large, the table sizes are significant enough to warrant exploring database optimizations. Let’s examine our current API response times. Response Times Consider the following endpoint:...

The API In this project series, we’re going to build a REST API that exposes resources related to stocks. In this post, we’re going to precompute our technical SMA indicator for our clients to consume through our API. You may find the code in the following repository: https://git.thecodebranch.com/blog/finance-api/src/tag/setup-api So far, we’ve generated a database with roughly 25 million rows of fake ticker data representing stock data from the years 2000 - 2020....

Why Use a Command Line Parser? In the process of developing a project, especially one as dynamic and multifaceted as a financial API, we often find ourselves repeating certain tasks. These tasks might include rebuilding our database, recomputing technical indicators, or regenerating ticker data with updated parameters. Initially, it might seem practical to create individual scripts for each of these actions. However, this approach can quickly become cumbersome and inefficient, especially as the project grows....

The API In this project series, we’re going to build a REST API that exposes resources related to stocks. In this post, we’re going to precompute our technical SMA indicator for our clients to consume through our API. You may find the code in the following repository: https://git.thecodebranch.com/blog/finance-api/src/tag/add-indicators Do We Need to Precompute Data? Let’s say we had customers paying for our API. It would be in our best interest to keep the API as responsive and fast as possible....

What Are We Building? In this project series, we’re going to build a REST API that exposes resources related to stocks. In this post, we’re going to generate a set data of for the API, so that we have something to play with for the rest of the project. We’re going to generate data because I don’t have real data that I can give you, and secondly, learning how to generate fake data can help you test ideas and build projects....

Why Should We Use Git Branches? Git offers a powerful tool for organizing and managing code development: branching. But what exactly is branching, and why is it so vital for software development? What is Git Branching? A branch in Git is an isolated environment for changes separate from the main project. This isolation allows developers to work on features, fix bugs, and test new ideas without affecting the main codebase or disrupting other team members....

Behavioral Testing in Python It’s no secret that the software industry has a lot of opinionated people, considering all of the different technologies, languages, frameworks, methodologies… the list goes on and on. Every team that I’ve personally worked with has had different approaches to development and different viewpoints on their software development practices. Some believed in having a unit test for each piece of code written, some preferred behavioral tests, and others… well, didn’t test anything (I don’t recommend that approach!...

Look… I’m not a frontend developer. In fact, it’s not something that I really enjoy. Dealing with node, npm, yarn, massive dependency lists, html and css styling… the list goes on and on. For me, the appeal to Svelte is its ease-of-use and ease-of-deployment. Svelte has been by far, the easiest framework for me to play with and to get something accomplished quickly. I’m not saying that this is a good argument for Svelte, but for me personally, it has allowed me to overcome the learning curves of other frameworks with minimal effort....