Published in Better Programming·Jan 23Member-onlyHow to Interact With PostgreSQL From Rust Using SQLxThe important things you need to know to get the job done — Setup Let’s first set up a local PostgreSQL so our application can interact with it. For simplicity, we will use Docker. docker run -p 5432:5432 --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres This command will set up a PostgreSQL database named “postgres” with the password “mysecretpassword.” …Rust Programming Language4 min readRust Programming Language4 min read
Published in Better Programming·Mar 9, 2022Member-onlyDatabase Replication: Benefits and Trade-OffsDesign better systems by understanding the trade-offs and benefits of database replication — Benefits Database replication is a database scale-out approach where the same data is replicated to multiple machines. That sounds wasteful, but it is not without justifiable benefits: High availability and performance improvement. High availability is achieved by having nodes with identical data. If one of the nodes fails, the system will…Programming6 min readProgramming6 min read
Published in Dev Genius·Jul 11, 2021The Software Testing SpectrumA better guideline for choosing your software testing strategy — One of the software engineering practices that I’m against is Software Test Pyramid. The recommendation is along the lines of “do have more isolated tests and fewer integration tests”: Write lots of small and fast unit tests. Write some more coarse-grained tests and very few high-level tests that test your…Software Engineering7 min readSoftware Engineering7 min read
Published in Towards Data Science·May 30, 20213 Data-Backed Ways To Significantly Speed Up Your MySQL Bulk InsertsSee what the data says about the best ways to optimize MySQL bulk inserts. — In Data Science projects, a common last step in the data pipeline is to persist the result into a database (e.g. MySQL). The result of this data pipeline is usually big, so optimizing the writes into the database is important to achieve the acceptable pipeline latency. I’ve benchmarked and analyzed…Database4 min readDatabase4 min read
Published in Better Programming·Mar 2, 2021Rendering Charts in Laravel ApplicationsThe easiest and quickest way to render charts in Laravel apps — People say that a picture is worth a thousand words. That couldn’t be truer for charts, which allow you to condense data into a meaningful message that one can easily digest. In this article, we will discuss how to render charts in a Laravel application. The approach that we will…Programming4 min readProgramming4 min read
Published in Better Programming·Nov 13, 2020Production-Grade Logging in Rust ApplicationsA strong application is a well-logged application — Your application is serving hundreds of customers per day. One day, some customers call you and complain that they are not able to proceed because of broken functionality. You then look into the database and see new data coming in just fine from other customers. …Programming10 min readProgramming10 min read
Published in Better Programming·Nov 3, 2020Structuring Rust Projects for TestabilityWrite better, more testable Rust — In this article, we will see how to structure a Rust project so that it’s easily testable. We will build a simple authentication module that is exposed via REST API while storing the data to PostgreSQL and Redis. We will use actix-web for handling the REST API part, sqlx for…Programming7 min readProgramming7 min read
Oct 3, 2020Using xdotool as a Tiling Window SolutionIn this post, I’d like to explain how I use xdotool to easily tile windows to my preferred layout on my 49" 5K monitor. The Problem I recently bought a 49" monitor with 5K resolution, which I intend to use mostly for productivity work. My previous monitor was a 27" with 1080p…Productivity5 min readProductivity5 min read
