PHPNews

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


LaraconEU 2016 – Overview

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 …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Friday August 26, 2016


How I became a Data Engineer

A reminiscence of a personal timeline of events; please, excuse minor errors and/or let me know if my memory has shuffled things around a bit. My first job was at a company that had their own CRM and they wanted a web version of some parts of the system. At that time, I only had “experience” with ASP and Microsoft …

Continue reading »

Written by Gabriela D'Ávila - - Aggregated on Saturday July 23, 2016