Tropeçando 71

PG Phriday: Displaced Durability

Há tabelas que possuem dados com os quais você não se importa de perdê-los. São situações de dados transientes, como áreas de dados passageiros, tabelas temporárias persistentes, tabelas com dados crus de importação. Por quê não aproveitar o fato do PostgreSQL oferecer a opção de ser UNLOGGED? Ainda mais porque pode-se evitar usar recursos do servidor desnecessariamente.

Check your pg_dump compression levels

Ao realizar backups do banco PostgreSQL, há muitas situações em que encontramos uma sobrecarga inesperada e o nível de compressão escolhido para fazer o backup pode ter ação direta sobre isso. Como a compressão nem sempre é tão importante, não esquecer este detalhe pode poupar incômodos desnecessários em operações de backup que não as rotineiras.

How to install an Opensource VPN Server on Linux

Instalação de VPN própria para assegurar o controle do tráfego em conexões.

Filtrando e validando dados no PHP com filter_var()

Entrada de dados é uma característica de quase a totalidade dos sistema ou sites. É indispensável, para segurança dos dados, filtrar esta entrada a fim de evitar invasões, roubo de dados ou inconsistência. No PHP, aprenda a fazer isso usando filter_var().

FFmpeg no Ubuntu: veja como instalar esse pacote no 14.04/14.10 via repositório

Trabalhando com logs no PostgreSQL

Dicas de configurações de log em servidores PostgreSQL. As informações contidas em logs são essenciais em muitos problemas e importantes para a saúde da aplicação e do sistema de banco de dados.

Codility – PermMissingElem

I scored 100% in #php on @Codility!
https://codility.com/demo/take-sample-test/perm_missing_elem/

Training ticket

Session
ID: trainingWEF9F8-YEU
Time limit: 120 min.

Status: closed
Created on: 2016-01-17 03:25 UTC
Started on: 2016-01-17 03:25 UTC
Finished on: 2016-01-17 03:40 UTC

Training ticket (real finishing time)

Session
ID: trainingCSVQV7-4KF
Time limit: 120 min.

Status: closed
Created on: 2016-01-17 04:29 UTC
Started on: 2016-01-17 04:29 UTC
Finished on: 2016-01-17 04:30 UTC

Tropeçando 70

Estressando CPU, memória RAM e disco rígido com stress-ng no Ubuntu

Um programa para realizar teste de estresse em recursos do computador. Com isso, será possível conhecer melhor os limites da máquina.

Developer’s Guide to Open Source Licenses

Building REST API for Legacy PHP Projects

PostgreSQL 9.4 streaming replication over SSL with Replication Slots

Export to xls using angularjs

TopTal

I have recently come across a new platform called TopTal, which is basically a search engine of professionals in the tech field based upon their skill set and expertise. Its objective is to match projects with freelance professionals across the globe based upon the projects specific needs, barriers and/or unique application that must be considered (i.e., bioinformatics, health care, statistics, query accessibility, etc…). From the perspective of the consumer this enables a more accurate delineation of the project skills needed and the appropriate professionals that meet the qualifications for the entire aggregate of skills needed for effective completion of the project. This platform also provides freelance tech professionals an ability to advertise their skill set to the more discerning tech field employers who have more specialized or focused needs.

In an era, where the consumer is beginning to realize that all computer technicians are not the same – the mismatch of skills on project teams is a consistent hindrance of efficiency and timelines. In reality, the well-oiled team matches skills like a symphony with one note completing the other in a harmony of efficiency. However, the harsh reality for employers, but is no surprise to tech professionals, is that the ideal team for one project is not necessarily the ideal team for the next. Often projects present different objectives and barriers with new or different perspectives needing to be considered to always find the most innovative solution possible – which in reality forces the need for different frames of references looking at it from new ways – with each project a different problem.

Personally, I am excited to wave in the possibility for more efficient project teams that bring together an eclectic group of professionals to solve a specific problem. In fact, it reminds me of the scene in Apollo 13 when they dump a bag full of mismatched odds and ends in front of a group of the best minds and give them the instructions… “solve it”. I’ve been working on freelance projects alongside my full time job because of one reason… it keeps me sharp. Freelance makes you think outside the box, takes from the skills that may seem mundane in my 9-5 job to another level of problem solving, it makes me see the holes and weaknesses and forces me to find and stretch my problem solving skills for the perfect fit… in a nutshell, I practice my art.

Rafa

Rafael Araujo is a computer technician specializing in databases, modeling and high availability architecture and back-end environments prepared for high traffic and/or high concurrency. Works with PHP, Java, Shell Script, HTML5, JavaScript, AngularJS, jQuery, PostgreSQL, MySQL, MSSQL, Oracle, PL/PGSQL, PL/SQL.