-
Notifications
You must be signed in to change notification settings - Fork 248
Content outline
Site sections (an architecture for organizing information as it is developed):
-
Installing
- Linux
- Windows
- MacOS
- Docker
-
Connecting
Basic instructions + tutorials for each key language & library See section: Languages & Framework/Library Platforms
-
Developing
-
Tooling
Introduces tools and configuration for Postgres-friendly development work on each key language & library See section: Languages & Framework/Library Platforms
Also a good home for guides on development-oriented usage of EDB-specific tooling.
-
Storing & Querying
SQL guides and tutorials
-
Modelling
Guides and HOWTOs cover common needs, considerations, and tasks required to accomodate them for:
- Normalization and denormalization
- Indexes
- Constraints
- ORMs and code-first modelling
- ETL
-
Security considerations during development
Tutorials illustrating PostgreSQL's security model, roles and permissions; guides for setting sensible defaults during development
-
Testing
Guides and HOWTOs for testing SQL, stored procedures, unit and integration testing against PostgreSQL
-
Debugging
Guides for debugging SQL behavior and performance, debugging stored procedures, extensions and PostgreSQL itself
-
Versioning / Migrating
Guides and HOWTOs for versioning queries and schemas, with examples for each key language & platform See section: Languages & Framework/Library Platforms
-
-
Tuning PostgreSQL
Guides and HOWTOs for planning, monitoring and optimizing systems
-
Securing PostgreSQL
Guides to auditing, designing and deploying security policies, identifying and managing roles, choosing and configuring identificaiton and authentication
-
High Availability (HA)
Guides for defining, planning, configuring and monitoring HA systems
-
Patching PostgreSQL
Guides for evaluating, planning, testing
-
Deploying at scale
Guides, tooling and examples for:
- Ansible
- Puppet
- Terraform
-
Disaster Recovery (DR)
Guides for preparation, planning and testing
Some tasks are primarily relevant to a subset of platforms: schema migrations are widely applicable, while mapping stored procedure results to objects is specific to ORM platforms. Identifying the root task is therefore essential to defining structure. This is not an exhaustive list, but following language+library platforms are among the most commonly-used when coupled with PostgreSQL.
(listed in rough order of priority based on usage):
- Java
- Hibernate
- JDBC
- Spring Data
- Python
- Django
- SQLAlchemy
- psycopg2
- Pandas
- JavaScript
- sequelize.js
- knex.js
- node-postgres
- Ruby
- Rails
- C#
- Npgsql
- Entity Framework (Core)
- PHP
- PDO
- Laravel
- Doctrine