A lot of people ask me to teach them how to do query analysis and performance. The truth is: there isn’t a script to follow. The following paragraphs are a brain dump on what usually goes on my mind when I am debugging and analyzing.
Please comment on what you think I should focus on to cover here.
A while ago I had this idea for a project: To show how representatives voted, either for or against, on bills.
People elect representatives but often forget to follow what they are up to. I asked around: who is your representative? The most common response: I don’t know. If people don’t even know who their represent…
These are the slides for my MySQL 8.0 Preview: What is coming ? At PHPWorld 2017.
Yes, you read it correctly, we are jumping from 5.7 to 8.0 (that sounds familiar, doesn’t it?). The new version doesn’t only change the number but also changes how you write SQL. Recursive queries will allow you to …
I created a React package called react-usa-map
It displays the USA map with the states including DC / Hawaii / Alaska
It’s MIT license
Install instructions on The package section of this post.
I am working on a project which may or may not go much further. I am building a …
For the past couple months, I’ve been studying. As a side effect, my GitHub account was cluttered with code that is experimental. I didn’t exactly want to trash the experimental code. I wanted to keep my code but also not specifically keep it under my profile.
The solution I found was to create an organization and …
SQLite is really a good tool to set up quick proof of concepts and small applications; however it’s not the most robust solution on the market for working with relational databases. In the open source community two databases take the top of the list: PostgreSQL and MySQL .
I did a small project for my studies. …
Developers in general love when stuff works. Having a solution that can solve about 80% of your problems can leave time for you to deal with the other 20%.
But this post is not about Active Record vs. Data Mapper or any thing like it. Each one has its use case where it’s best applicable and it depends on you (or …
In the past month or so I’ve been learning Ruby, this is my first blog post about the language and my experiences learning it. I’d love to hear your feedback.
Ruby allows you to work with modules and mixins, giving characteristics to classes and instances that otherwise could only happen through inheritance. One …
Disclaimer : This post is aimed to you, the curious developer, sys-admin, technologist, whatever-title-you-use. DO NOT run the following lines on production. Not even in a stable environment, do this if you don’t care about the outcome of the current data.
If you want to keep up with the newest MySQL developer …
This post is a case study of a job I had to do in a legacy application, it doesn’t mean it will apply to you, but it might.
This is a table of contents:
Converting to a JSON array
1st step: remove the leading commas
2nd step: add brackets to the string
3rd step: …
I am a Software Engineer at heart. I started as such and worked with PHP for about 7 years, always correlating my work with data somehow until I got an opportunity and decided to follow my instincts and be a Data Engineer.
I didn’t turn a Data Engineer from one night to another. It was a process. I was lucky to have …
Prior to my talk at LaraconEU 2016 I was curious to know how much adoption for MySQL 5.7 was in within the community.
I tweeted this:
Pool, use twitter client to see it:
Which Version of MySQL do you use? SELECT @ VERSION ; RT for reach, please. — Gabriela D'Ávila (@gabidavila) August 23, 2016
This post will be updated as soon more information comes along.
This developer version wasn’t released yet, when it does, use at your own risk.
Oracle released the development version of MySQL 8.0.0-dmr on September 12th of 2016. Since then, the team have been working on the 8.0.1 development milestone. …
Generated Columns is a feature released on MySQL 5.7. They can be used during CREATE TABLE or ALTER TABLE statements. It is a way of storing data without actually sending it through the INSERT or UPDATE clauses in SQL. The database resolves what the data will be.
There are two types of …
This is a blogpost about MySQL 8.0.0, the content here could be subject to changes in the future since this is not a stable release .
This is a feature that will make life the many DevOps and DBAs easier. Believe it or not, a lot of people control access to the database by sharing the same username and …
This is an unstable release, please don’t use in production.
It was rumored that the new MySQL version would be 8 and not as 5.8 as a lot of people thought, and it appears the rumors were true.
Below are some of the features that caught my eye at first glance:
Although password expiration was implemente…
Disclaimer: this post takes into consideration that strict mode is enabled on the server
VARCHAR and CHAR are used to store strings. VARCHAR stores varying length and CHAR always use the same exact size no matter the size of the string. For example, CHAR(4) will always store 4 bytes, whereas VARCHAR(4) …
On the 15th of august, Cloudways published an interview with me. There we talk about databases and community, check it out:
Filed under: Article , Interview Tagged: cloudways , Interview
Last time I went to LaraconEU as in 2014 as speaker in the community track, it was my first international event ever speaking in english and I had jitters from it.
A lot a friends were made and it was nice to see all of them again this year.
What I also like about LaraconEU it is a Laravel conference that doesn’t …