Pirobits
Blog
@bypirob
Blog
MySQL: ENUM Datatype
4/24/2024
·
1 min
Today I discovered that MySQL has a data type which is an ENUM. It allows you to define up to 2^16 or 65536 different values. The peculiarity is that you can define a set of values such as “status” => “pending”, “wip”, “done”, and MySQL itself converts them into values 1, 2, 3... Important: the values start at 1 and not 0. Note that it can have either a DEFAULT value or it can be NULL and in this case, if it is not defined, the field value will be NULL.
Learn about product creation and software development
I will send you a summary of pirobits content, as well as links or news I find interesting.
Subscribe
How to make presentations with Reveal.js (HTML, JS and CSS)
YouTube
4/22/2024
·
4 min
Looking for the best tool to create presentations, I'll tell you why I chose Reveal.js over other tools like PowerPoint.
My working setup: adding acoustic treatment
4/16/2024
·
3 min
One of the things I have always done is to progressively improve my setup. In the last few months I have improved the quality with which I record videos: both image and sound. And don't think that you need a lot of money for this: my equipment for recording videos is very cheap and I'm happy with the result.
Solving Sudokus with backtracking in Python
YouTube
4/15/2024
·
5 min
Sudokus is something that has always caught my attention and, when I learnt about backtracking during my degree in computer engineering, in the artificial intelligence subjects, I came up with the idea of solving sudokus using this method.
My first "viral" video
4/12/2024
·
2 min
A few months ago I decided to upload a video every week to YouTube that would allow me to explore some topic in depth, and give it a different format than a written post. I do this mainly because I like to talk about the problems I am solving, because I am sure I can provide knowledge to other people, just as I learn from others who share their experiences.
Install JetBrains Mono Font and Customize Visual Studio Code
4/9/2024
·
2 min
One of the things I really enjoy is changing the theme of the applications I work with; it gives them a fresh look that is always welcome from time to time.
Next.js: The good, the bad, and everything you need to know
YouTube
4/8/2024
·
7 min
NextJS is a technology that is widely used nowadays for web development. Personally, I quite like it and have used it in multiple projects. After several years of using both React and NextJS, I want to tell you about the good, the bad, the advantages, and the problems I have encountered while creating products.
Siguiente página