News Articles SQL

SQL Beginner Friendly Cheatsheet

1. Retrieving/Selecting Data – The SELECT statement is used to select data from a database. SELECT column_name FROM table_name; for eg – SELECT StudentName FROM Student; 2. Selecting All Records/Columns of Data – The Asterisk(*) is used to select all records. SELECT * FROM table_name; for eg – SELECT * FROM Student; 3. Selecting Distinct […]

5 ways to implement case-insensitive search in SQLite with full Unicode support

Recently I needed a case-insensitive search in SQLite to check if an item with the same name already exists in one of my projects – listOK. At first, it looked like a simple task, but upon deeper dive, it turned out to be easy, but not simple at all, with many twists and turns. Built-in […]

Supabase Vs Firebase Pricing and When To Use Which

Supabase Vs Firebase Pricing and When To Use Which Supabase recently appeared on the scene as an attempt to be an open source alternative to Firebase. It’s a great product and I’ve used it in many projects already. I’ve written about it here and here. The main difference between Supabase vs Firebase is that Supabase […]

End-To-End Type Safety: What, Why and How

A difficult challenge developers often face is creating and managing types across the entirety of their software stack in a way that allows for quick and easy error and change detection. Without a proper system in place, simple changes to your database’s schema, your API layer’s definition of an object, or even your web client’s […]

Fill in missing Date ranges using MySQL

I’m always trying different programming exercises in order to learn and grow as a Developer. One of my favorite learning exercises is… Continue reading on Level Up Coding » Source: Level Up Coding

Getting Started with YugabyteDB and Docker

When developing modern applications, it is important to maintain dev/prod parity (that is, keep development, staging, and production as similar as possible). This should also extend to the local development environment. Containerization makes it easy to achieve consistency across all environments, even with more complicated components such as databases. YugabyteDB is a cloud-native, distributed SQL […]

Interview Questions of the SQL

What is a trigger? : Trigger is a database object which will automatically invoke or execute when a specific event occur in the database. The most common type of triggers are DML triggers, DDL triggers and Database triggers And this trigger can be invoke before the operation or after the operation. If the function include […]

Determine the First and Last Day of a Month with MySQL

Working with date values is part of every developer’s job. It seems like we are always looking for or filtering some data by date or a… Continue reading on Level Up Coding » Source: Level Up Coding

SQL Basics (Zero to Hero)- Part 01

SQL – Structured Query Language A table is a collection of related data entries and it consists of columns and rows. Eg: SELECT * FROM Customers; –> It will retrieve all records data from customer table. Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL […]

Using Materialize and Redpanda to Analyze Raspberry Pi Temperature Data

Introduction This is a self-contained demo using Materialize to process data IoT devices data directly from a PostgreSQL server. The demo builds up on the How to build AdonisJS API to store your Raspberry Pi Temperature tutorial. The data is generated by a Raspberry Pi temperature mock service simulating 50 devices reporting to an AdonisJS […]

JDBC Tutorial Part 2: Running SQL Queries

In Part 2 of this tutorial series, you’ll learn how to execute SELECT, INSERT, UPDATE, and DELETE statements against an SQL database using JDBC. These actions are known as CRUD operations (Create, Read, Update, Delete), which form most of the functionality in an application. Note: We’ll continue where the previous step of the tutorial left […]

SQL vs NoSQL Database – A Complete Comparison

There are two main categories of database in use in the development world today, commonly referred to as SQL and NoSQL. In this article, we will compare an SQL vs. NoSQL database based on their pros and cons. SQL, or Structured Query Language, is the universally known query language for relational databases. SQL databases make […]

Import database to docker with terminal

Hey, this is Mohammad Hassani 😃 if you are developing with Linux and wanna import database to docker with terminal you can use this tutorial… It’s just 4 steps 1) copy database to _data folder: first of all you should copy your .sql file to var/lib/docker/volumes/blog_blogmysql/_data in terminal: cp DATABASE.sql var/lib/docker/volumes/blog_blogmysql/_data // Replace DATABASE to […]

Como a SQL lida com valores NULL

Durante meus estudos direcionado para questões de projeto e implementação de banco de dados, encontrei algo bastante interessante e que seria legal compartilhar. A SQL tem diversas regras e abordagem para lidar com valores NULL e que se dividem da seguinte forma: Valor desconhecido (existe, mas não é conhecido); A data de nascimento de uma […]

Optimistic or Pessimistic locking for Token Buckets Rate limiting in PostgreSQL

In a Part 2 of this series I defined a function to get tokens for API call rate limiting. I’ve run it in watch 0.01 loops in 8 sessions to show concurrent access for the same user. With PostgreSQL, the guarantee that reads and writes happen on the same state is enforced by pessimistic locking: […]

How I created a mini ORM with python?

Introduction When you code in a Django web framework, we all know that you won’t directly work with databases. There is an ORM (Object relational mapping) who will interact with database using migration and SQL operation. So, I want in this tutorial to show you how to implement an ORM manager from scratch. Object–relational mapping (ORM) […]

Database character sets and collations explained – why utf8 is not UTF-8

Table Of Contents Character sets and collations explained Charater sets: The tale of □�💩 Why utf8 in MySQL is not UTF-8 Collations: How to sort things What about performance? Conclusion The relationship between character sets and collations always seemed pretty vague to me, let alone the possible impact on performance. So if you are like […]

What are the top 9 SQL Queries for freshers?

In general, query is a request for something. But in the world of programming query means retrieving data from the database with commands that are preset. i.e. SELECT, INSERET, SUM, WHERE etc. Furthermore, if you wish to explore more about the SQL, DBMS you can visit the page below. SQL Queries are asked directly in […]

Sitemap | Terms | Privacy | Cookies | Advertising

Senior Software Developer

Creator of @LzoMedia I am a backend software developer based in London who likes beautiful code and has an adherence to standards & love's open-source.