Skip to content

Latest commit

 

History

History
156 lines (99 loc) · 5.42 KB

PostgreSQL.md

File metadata and controls

156 lines (99 loc) · 5.42 KB

PostgreSQL

PostgreSQL most useful extensions

Search for "postgres" at Github

Backup

Barman: disaster recovery for business critical PostgreSQL databases

Heroku's WAL-E

GraphQL

Graphile (Javascript, Node.js)

Hasura (Haskell)

Graphile vs Hasura?

PostGraphile is written in JavaScript which is more approachable than Hasura’s Haskell …

PostgREST (Haskell) is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations

Prisma, successor of Graphcool

OLAP

Basic OLAP Support in PostgreSQL 9.5

Ruby, Rails

Rails on PostgreSQL weblog

activerecord-postgresql-arrays

  • PostgreSQL array awareness for ActiveRecord

activerecord-postgres-hstore: Goodbye serialize, hello hstore. Speed up hashes in the database

activerecord-postgres-hstore-core

activerecord-postgres-uuid adds support for the 128 bit UUID column type to ActiveRecord

dagnabit is an ActiveRecord plugin for directed acyclic graphs. It stores directed acyclic graphs as an adjacency list, using recursive common table expressions to perform fast reachability queries

enum_type — enumerated types in ActiveRecord

has_metadata_column reduce table width and migration overhead by moving non-indexed columns to a separate metadata column

hierarchy lets you use LTREE-utilizing hierarchies in ActiveRecord

partitioned: PostgreSQL database table partitioning support for Rails

pg_comment adds PostgreSQL comment support to Rails migrations

pg_search builds ActiveRecord named scopes that take advantage of PostgreSQL's full text search

postgresql-cursor is an extension to the ActiveRecord PostgreSQLAdapter for very large result sets. It provides a cursor open/fetch/close interface to access data without loading all rows into memory, and instead loads the result rows in “chunks” (default of 10.000 rows), buffers them, and returns the rows one at a time.

postgres_ext adds support for missing PostgreSQL data types to ActiveRecord: Arrays, CIDR, INET, MACADDR, UUID

queue_classic is a worker queue for Ruby applications that uses unbelievably awesome features in PostgreSQL

silent-postgres silences PostgreSQL connection adapter verbose output

switcheroo: ActiveRecord migration library to speed up schema changes for large PostgreSQL tables

transaction_retry retries database transaction on deadlock and transaction serialization errors

PostgreSQL as a document store for schemaless data

Graph

AgensGraph, GitHub, © Apache-2.0

Hstore

activerecord-postgres-hstore

hstore_flags stores boolean flags in a PostgreSQL hstore field

multilang-hstore is a small library for translating database values for Rails 3 and PostgreSQL hstore

JSON

…

The JSON and JSONB column types and PLV8

Time-Series

TimescaleDB, GitHub, © Apache-2.0

XML

…

Full Text Search

…

Local Check for Plagiarism

Effective similarity search in PostgreSQL using smlar which calculates similarity of arrays for PostgreSQL 9.1+

git clone git://sigaev.ru/smlar

or ssdeep_psql

The Homebrew formular for PLV8 at will/homebrew could be a blueprint for my smlar formular (Formula Cookbook).