pg conf intro presentation - postgresql wiki · sql query -11 1.c builds 21 1 te website revews...

14
Egger Apps Jakob Egger [email protected] Postico Postgres.app

Upload: others

Post on 14-Jul-2020

0 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

Egger Apps

Jakob Egger [email protected]

PosticoPostgres.app

Page 2: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

Who we are

“Egger Apps” was founded in 2011

We are currently 3 developers:Jakob, Chris and Martin

We're based in Linz, Austria

Page 3: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

PosticoPostgres.app

Open Source Mac App

PostgreSQL server

10000 downloads/month 4000 downloads/month

PostgreSQL client

Commercial Mac App

https://postgresapp.com https://eggerapps.at/postico/

Page 4: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

Postgres.app

Simple to use (trivial installation, no configuration necessary)

Powerful and convenient (run multiple servers simultaneously)

Comes with PostGIS and plv8

Page 5: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!
Page 6: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!
Page 7: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

Postico

Modern & friendly PostgreSQL client

Data Entry

Table Schema Authoring

SQL Query Editor

Page 8: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

Postico is a modern, friendly database client

Page 9: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

Postico is great for reporting and data entry

Page 10: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

The structure editor is a popular feature among web and application developers

Page 11: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

Postico is used increasingly for data science and analytics.

Page 12: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

Target Audience

Web and application developers

Data Scientists

Students & PostgreSQL newcomers

Page 13: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

One tool, one job

Postico is not a tool for everyone; it has specific use cases, and is best used together with other tools.

Page 14: PG Conf Intro Presentation - PostgreSQL wiki · SQL Query -11 1.c builds 21 1 te website revews countrv Connected. reviewer ratina ttle 5 Excellent and very usefu S utility 3 go ahead!

URL handlers

Please support postgres: URLs!

In Postgres.app, double clicking a database connects to it using psql or Postico.

We'd love to support other apps!