Overview This blog post is a summary of the following talk on YouTube, credits to the presenter. What is SQLite? SQLite is a widely used, serverless, and self-contained database engine known for its simplicity, speed, and reliability. Its key features contribute to its popularity and versatility across various applications. Ease of Use and Deployment Performance … Read more
Overview This blog post summarizes key insights from a webinar, “Tuning Tips to Maximize Postgres Performance,” hosted by EDB. The webinar, featuring Dave Page, VP and Chief Architect of Database Infrastructure, and Devrim Gundus, an EDB consultant, offers a deep dive into optimizing Postgres performance, from hardware considerations to query tuning techniques. If you prefer … Read more
Overview I woke up on Saturday morning expecting a normal day where I worked on my side project ukata.io. However, life is unexpected. I opened one of my content on the *production* site and found an error in the front end. None of my courses are accessible! This is the log in the backend: I’m … Read more
Overview Subquery is a powerful SQL tool. It enables users to do things that are not possible using common statements. Here are some common use cases of subqueries: In this post, I will show you how to use subqueries to get the data you need from your tables. Let’s get started. A Simple (and useless) … Read more
Overview Now you have your data populated (if you haven’t, please go back to the previous post) to complete the setup. In this post, I’m going to show you various way to query your data using the SELECT command. When using in combination with other clauses (such as WHERE, LIMIT), you can get exactly what … Read more
Introduction PostgreSQL provides a variety of built-in aggregation functions that allow you to calculate values such as count, sum, average, minimum, and maximum values for a set of rows. In this post, I’m going to walk you through the basic to advance aggregation functions. Let’s get started Basic Aggregation Functions You can use aggregation functions … Read more