Installing Presto for Mac

Presto is a “Distributed SQL Query Engine for Big Data” that gives you the ability to join across data stores! tada

Server

The easiest way to install Presto is with Homebrew.

brew install presto

Next, add a connector. Here’s the list of available ones.

For PostgreSQL, create /usr/local/Cellar/presto/0.150/libexec/etc/catalog/mydb.properties with:

connector.name=postgresql
connection-url=jdbc:postgresql://localhost:5432/mydbname
connection-user=myuser
connection-password=mysecret

And start the server with:

presto-server run

Client

Presto comes with a CLI

presto --catalog mydb --schema public

And run:

SHOW TABLES;

Try one of your tables with:

SELECT * FROM mytable;

There are also clients in many different languages you can use.

rabbit tophat sparkles

Published August 4, 2016 · Tweet


You might also enjoy

Why and How to Keep Your Decryption Keys Off Web Servers

Argon2 with Devise

Hybrid Cryptography on Rails


All code examples are public domain.
Use them however you’d like (licensed under CC0).