PHPNews

How to use MySQL 8.0.4 with a GUI

If you want to have a look on what is about to come in the new version of the popular database and is used to Syntax Highlighting you don’t need to be chained to the Terminal. Some of you may use tools like MySQL Workbench or  Sequel Pro (as of the release of this post both tools had the following error occurring…

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Thursday February 22, 2018


Congress, who is? – A Civic Tech project

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…

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Tuesday November 28, 2017


MySQL 8.0: Preview @ PHPWorld

These are the slides for my MySQL 8.0 Preview: What is coming ? At PHPWorld 2017. Abstract: 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 …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Wednesday November 15, 2017


Playing with Ruby modules: prepend

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 …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Monday July 31, 2017


I don’t know Ops, and that may be OK

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 …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Friday February 17, 2017


Understanding Generated Columns

The Theory 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 …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Monday October 17, 2016


Roles on MySQL 8.0

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 …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Thursday September 15, 2016


MySQL 8.0 (dev): what to look for

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: Roles Although password expiration was implemente…

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Wednesday September 14, 2016


Varchar fields on MySQL 5.7

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) …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Thursday September 8, 2016