Tips and tricks from engineers at the leading prediction cloud for B2C brands.
I calculated hashes of single-family home addresses in the United States: create table hashtest as ( select house_number_and_street, city, state, digest(upper(house_number_and_street || ',' || city || ',' || state), 'md5') as "md5", digest(upper(house_number_and_street || ',' || city || ','
Yesterday morning, I was confronted with a truly terrible error message from a Rust program I was developing: $ cage up --init ... Error: error getting the project's state from Docker ExpectedError("Object", "null") The first part of that error message comes from cage (our open source tool
This post is part of our PostgreSQL series. SQL cursors are a great way to stream data out of a database without loading it all into memory. Reading using a cursor Sequel has use_cursor: BATCH_SIZE = 1000 DB[:widgets]. select(:id, :name, :power). use_cursor(rows_per_fetch: BATCH_
Citus Cloud is the hosted Postgres that our app uses. We tried EnterpriseDB Postgres Plus Cloud and couldn't even get going; we used Amazon RDS for a year but migrated away about 6 months ago. Heroku Postgres wasn't bare-metal enough for us. 1. Log directly to Papertrail It's not a
This post is part of our rust series. The Rust compiler just saved me from a nasty threading bug. I was working on cage (our open source development tool for Docker apps with lots of microservices), and I decided to parallelize the routine that transformed docker-compose.yml files. This was
This post is part of our devops series. At Faraday, we rely heavily on microservices to analyze data, generate maps and make predictions. All our microservices run inside Docker containers, which makes it easy to run our code either locally or in the cloud. But if you've ever worked on