Categoria: Tropeçando

  • Tropeçando 82

    docz It has never been so easy to document your things! usql A universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQL and non-relational databases! Agendando tarefas com o Cron para Node O Cron para Node é um pacote npm que nos permite fazer o agendamento […]

  • Tropeçando 81

    ACME Support in Apache HTTP Server Project We’re excited that support for getting and managing TLS certificates via the ACME protocol is coming to the Apache HTTP Server Project (httpd). ACME is the protocol used by Let’s Encrypt, and hopefully other Certificate Authorities in the future. We anticipate this feature will significantly aid the adoption […]

  • Tropeçando 80

    MVCC and VACUUM Experienced PostgreSQL users and developers rattle off the terms “MVCC” and “VACUUM” as if everyone should know what they are and how they work, but in fact many people don’t. This blog post is my attempt to explain what MVCC is and why PostgreSQL uses it, what VACUUM is and how it […]

  • Tropeçando 79

    Plan for the unexpected: install diagnostic tools on your PostgreSQL servers There’s a lot of information out there on how to configure PostgreSQL, on the importance of backups and testing them, etc. But what about the server you run PostgreSQL on? We tend to pay a lot less attention to tools that you won’t need […]

  • Tropeçando 78

    Replicação: o que mudou Detalhes das mudanças na replicação do PostgreSQL desde a versão 9.0 até a 9.6. What the hell are Generics and would I want them in PHP? So everyone is talking about this hip “new” kid on the block for PHP: Generics. The RFC is on the table and a lot of […]

  • Tropeçando 77

    How to Measure Execution Time in Node.js Design Pattern Workshop Recently on the pgsql-performance mailing list, a question popped up regarding Postgres RAM usage. In this instance Pietro wondered why Postgres wasn’t using more RAM, and why his process was taking so long. There were a few insightful replies, and they’re each interesting for reasons […]

  • Tropeçando 76

    Crie um proxy SOCKS em um servidor Linux com SSH para ignorar filtros de conteúdo O método mais rápido para melhorar o desempenho de qualquer Servidor de Aplicações Web PHP usando MySQL ou PostgreSQL Getting first and last values per group Every so often someone needs solution to getting first (or couple of first) values […]

  • Tropeçando 75

    Dply – Serviço permite criar um servidor Linux na nuvem que fica disponível por 2 horas gratuitamente Promise Anti-patterns Promises are very simple once you get your head around them, but there are a few gotchas that can leave you with your head scratching. Here are a few that got me. PG Phriday: Why Postgres […]

  • Tropeçando 73

    Tables and indexes vs. HDD and SSD Although in the future most database servers (particularly those handling OLTP-like workloads) will use a flash-based storage, we’re not there yet – flash storage is still considerably more expensive than traditional hard drives, and so many systems use a mix of SSD and HDD drives. pgBackRest 1.0 Released […]

  • Tropeçando 72

    A simple JSON difference function A function that would take two JSONB objects in PostgreSQL, and return how the left-hand side differs from the right-hand side. Deadlocks in PostgreSQL Compreenda os tipos de lock existentes no PostgreSQL, como ocorre um deadlock e pesquisar o causador do lock. PG Phriday: COPY and Alternative Import Methods Alternativa […]