-
SQL Joins
How to perform a simple join between two database tables
-
SQL, how to delete data and tables
How to delete data from a SQL database table, and how to delete the table
-
SQL, how to update a table structure
How to update a SQL database table structure
-
SQL, how to update data
How to update data stored in a SQL database table
-
SQL, Unique and Primary keys
How to create unique and primary keys in a SQL database
-
SQL, Handling empty cells
How to handle null data in a SQL database
-
SQL, how to use SELECT
How to get data from a SQL database table
-
SQL, adding data to a table
How to insert data in a SQL database table
-
SQL, creating a table
How to create a table in a SQL database
-
Let vs Const in JavaScript
Let or const? Which one should you use?
-
Setting up a project to build a JavaScript game with Phaser
Setup a modern project and get started building a JavaScript HTML5 game using Phaser 3
-
What is a GB-second?
Find out what is a GB-second in the AWS terminology
-
What is a JavaScript Frontend Framework?
A little introduction to frontend frameworks
-
Incrementing multiple folders numbers at once using Node.js
How I solved a little folders management problem
-
An introduction to REST APIs
What is a REST API from the point of view of a creator of a REST API and from the point of view of a consumer
-
The Node Core Modules
A list of the core modules provided by Node.js
-
My plan for being hired as a Go developer. In 2017
I know, it's 2020. But I was reading my notes on a plan I had in 2017.
-
The UDP Protocol
A high level overview of the User Datagram Protocol
-
The TCP Protocol
A high level overview of the Transfer Control Protocol
-
DNS, Domain Name System
A high level overview of what is DNS and how it works
-
How to get query string values in JavaScript
Accessing and modifying query string values using URLSearchParam
-
How to reload the browser window when you save a file
A quick and simple approach
-
How to remove duplicates from a JavaScript array
Given an array, how can you remove duplicate values in it?
-
How to remove all the node_modules folders content
Save space by dropping your old Node modules
-
The Developer’s Dilemma
Deciding between using an existing service or platform, and building your own
-
How to convert an Array to a String in JavaScript
How to generate a string out of an array in JavaScript
-
On being a generalist
You have a choice. You can be a specialist, or a generalist. Which route should you choose?
-
What is a magic number in programming?
In some tutorials, books, or videos, you might have seen the term magic number. What is that?
-
The Arduino MKR WiFi 1010
An overview of this great IoT electronics board from Arduino
-
How to make sure the Raspberry Pi has always the same IP address
A step by step guide to configuring a router to assign a static DHCP IP address in your LAN to the Raspberry Pi
-
How to connect to a Raspberry Pi using a Mac
A step by step guide to connect to a Raspberry Pi using Rapbian via VNC
-
List of keywords and reserved words in JavaScript
A simple reference to all the keywords and reserved words in JavaScript
-
How to open VS Code from the command line
A simple guide to installing the VS Code command line tools
-
The C Preprocessor
How to use the C Preprocessor
-
C Header Files
How to use C Header Files to separate a program into multiple files
-
C Structures
An introduction to C Structures
-
C Enumerated Types
An introduction to C Enumerated Types
-
The typedef keyword in C
An introduction to the typedef keyword in C
-
C Global Variables
An introduction to C Global Variables
-
Static variables in C
How to work with static variables in C
-
Can you nest functions in C?
Find out if you can nest functions in C, or not!
-
Scope of variables in C
Learn what scope is, and how it works in C
-
How to access the command line parameters in C
Learn how to access the command line parameters in C
-
C conversion specifiers and modifiers
A handy reference to C conversion specifiers and modifiers
-
How to print the percentage character using `printf()` in C
Learn how to print the percentage character using `printf()` in C
-
How to check a character value in C
Learn how to check a character value in C
-
How to solve the implicitly declaring library function warning in C
Learn how to solve the implicitly declaring library function warning in C
-
How to return a string from a C function
Learn how to return a string from a C function
-
Double quotes vs single quotes in C
How to work with quotes in C
-
Basic I/O concepts in C
How to perform input/output using printf and scanf in C
-
How to use NULL in C
A brief guide at null pointers in C
-
Introduction to C Functions
An introduction to C Functions
-
Booleans in C
An introduction to how to use booleans in C
-
Looping through an array with C
How to loop through an array with C
-
Introduction to C Pointers
An introduction to C Pointers
-
How to find the length of a string in C
A practical tutorial on how to find the length of a string in C
-
Introduction to C Strings
An introduction to C Strings
-
How to determine the length of an array in C
How to determine the length of an array in C
-
Introduction to C Arrays
An introduction to C Arrays
-
How to work with loops in C
An introduction to C for, while and do-while loops
-
C Conditionals
An introduction to C Conditionals: if/else and switch
-
C Operators
An introduction to C Operators and Operator precedence
-
C Constants
An introduction to dealing with constants in C
-
C Variables and types
An introduction to dealing with variables in C, and the basic types
-
Introduction to the C Programming Language
Get started with C, a fundamental programming language
-
Dealing with the fire
The fire is awesome when it’s there, otherwise it would be impossible for me to do creative and productive work without burning out. What's the fire?
-
I wrote 1 blog post every day for 2 years. Here's 5 things I learned about SEO
5 SEO lessons learned by writing 1 blog post every day for 2 years
-
Milli Micro Nano Pico
With electronics and time measurements, you will find those terms used often: milli, micro, nano, pico. What do they mean?
-
Non-printable ASCII characters list
A table containing all the non-printable ASCII characters
-
Printable ASCII characters list
A table containing all the printable ASCII characters
-
The Arduino Programming Language
How can you write programs for your Arduino board? Arduino, natively, supports a language that we call the Arduino Programming Language, or Arduino Language.
-
The Arduino Uno WiFi rev 2 board
The Arduino Uno is a microcontroller board. It is currently the reference version of Arduino, and the latest version of an official Arduino device is the Arduino Uno WiFi rev 2.
-
The Arduino Uno rev 3 board
This is the reference Arduino version for prototyping, as lots and lots of tutorials use this version of Arduino as their reference board.
-
An introduction to Arduino
An overview of the Arduino electronics platform
-
Coding is an art
Coding is an art, a creative craft, a joyful thing
-
How to block distractions using uBlock Origin
A trick I learned to block distractions using uBlock Origin
-
How to send the authorization header using Axios
Learn how to send the authorization header using Axios
-
How to fix the xcrun invalid active developer path error in macOS
Quickly solve this annoying problem with the command line
-
MySQL User Permissions
A quick introduction at User Permissions in a MySQL Database
-
SQLite User Permissions
A quick introduction to user permissions in SQLite
-
Converting Numbers from Decimal to Binary
How to quickly convert a number expressed in the Decimal Number System to the Binary Number System
-
The Binary Number System
Introduction to the Binary Number System
-
Write what you don't know
Some thoughts on writing about things you don't know (yet)
-
The GPL License
A quick overview of the GPL License
-
The Decimal Number System
Introduction to the Decimal Number System
-
Finite State Machines
A quick overview of what State Machines are, with simple examples
-
Postgres vs MySQL, a comparison
A quick comparison between PostgreSQL and MySQL
-
How to start a blog using Hugo
A detailed tutorial to start a new blog using Hugo from zero to deployment
-
Creating a user on MySQL
A quick step by step guide at how to create a user on MySQL
-
How to install MySQL on macOS
Step by step instructions to install MySQL on macOS using Homebrew
-
How to list tables in the current database using Postgres
A quick explanation of how to list tables in the current database inside the `psql` tool in PostgreSQL, or using SQL
-
How to list all databases using Postgres
A quick explanation of how to list all databases inside the `psql` tool in PostgreSQL, or using SQL
-
How to switch database using Postgres
A quick explanation of how to switch between databases inside the `psql` tool in PostgreSQL
-
How to list all users in Postgres
Find out how to get a list of all the users present in a Postgres database, and their permissions
-
This decade in JavaScript
Looking back at the last decade in JavaScript / Web, it's been a wild ride.
-
Postgres User Permissions
In this tutorial I will explain how to managing users and permissions in Postgres.
-
Introduction to Postgres
A high level overview of the PostgreSQL database
-
How to install SQLite on macOS
In this tutorial I want to explain what you need to do to install SQLite.
-
A practical guide to Homebrew
An introduction to the popular Homebrew package manager
-
Do you always need a database for your app?
Some thoughts on the need of a database. Maybe you need it, maybe not.