Engineering

Our engineering is underpinned by principles that celebrate both the integrity of code and the ambition to innovate. This manifesto champions excellence, advocates for the adoption of cutting-edge technologies, and fosters an environment of continuous intellectual growth.

PostgreSQL setup

PostgreSQL database

PostgresSQL, or simply Postgres, is a relational database. It's the de facto standard for SQL databases, and is the preferred SQL database of Mashup Garage. • PostgreSQL wikipedia page (en.wikipedia.org): https://en.wikipedia.org/wiki/PostgreSQL

postgres credentials

Phoenix projects default to connecting to Postgres with the username `postgres` and password `postgres`. This isn't so easy to override, so let's just keep that as the default.

macOS setup

The easiest way to install PostgreSQL is through Homebrew.

**Install postgres:** In macOS, use Homebrew to install it.

# OSX only brew install postgres

**Start postgres:** Use homebrew/services to start Postgres. Optional but recommended.

# OSX only brew tap homebrew/services brew services start postgres

**Create a postgres user:** Use PostgreSQL's `createuser` to create a new user. Give it a password postgres.

$ createuser --superuser postgres -P Enter password for new role: Enter it again:

Linux/Windows (via Docker)

The preferred way to get PostgreSQL working on Linux is through Docker.

**Install Docker:** Create a file called docker-compose.yml in the root of your project:

version: '3' services: db: image: postgres ports: - '5432:5432' volumes: - 'pgdata:/var/lib/postgresql/data' environment: POSTGRES_PASSWORD: postgres volumes: pgdata:

**Run it:** Run it using docker-compose:

docker-compose up`
Next: Design Playbook

Connect.

Mashup Garage, a premier software development team, specialises in crafting exceptional products for startups and enterprises. With expertise in React, Elixir/Phoenix, and Ruby on Rails, we deliver solutions that meet your unique needs. Our mission is to bring value backed by decades of technical expertise and global co-founding experience.

What do you need help with?

Build a project

Build a team

Consult

Speak to someone

Expect a guaranteed response from us in 1-2 business days.

United Kingdom

London

Islington, London

+44 738 777 3405

LDN

Philippines

Manila

3F Topy IV Building, 3 Economia Road, Bagumbayan, Quezon City, 1110

+63 917 3084089

MNL