PHPackages silverstripe/postgresql - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. silverstripe/postgresql ActiveSilverstripe-vendormodule[Database & ORM](/categories/database) silverstripe/postgresql ======================= SilverStripe now has tentative support for PostgreSQL ('Postgres') 3.0.0(2y ago)16258.1k↑50%33[6 issues](https://github.com/silverstripe/silverstripe-postgresql/issues)[2 PRs](https://github.com/silverstripe/silverstripe-postgresql/pulls)2BSD-3-ClausePHPCI passing Since Nov 9Pushed 1y ago13 watchersCompare [ Source](https://github.com/silverstripe/silverstripe-postgresql)[ Packagist](https://packagist.org/packages/silverstripe/postgresql)[ RSS](/packages/silverstripe-postgresql/feed)WikiDiscussions 3 Synced 1mo ago READMEChangelog (10)Dependencies (4)Versions (25)Used By (2) PostgreSQL Module Module ======================== [](#postgresql-module-module) [![CI](https://github.com/silverstripe/silverstripe-postgresql/actions/workflows/ci.yml/badge.svg)](https://github.com/silverstripe/silverstripe-postgresql/actions/workflows/ci.yml) Installation ------------ [](#installation) ``` composer require silverstripe/postgresql ``` Configuration ------------- [](#configuration) ### Environment file [](#environment-file) Add the following settings to your `.env` file: ``` SS_DATABASE_CLASS=PostgreSQLDatabase SS_DATABASE_USERNAME= SS_DATABASE_PASSWORD= ``` See [environment variables](https://docs.silverstripe.org/en/getting_started/environment_management) for more details. Note that a database will automatically be created via `dev/build`. ### Through the installer [](#through-the-installer) Open the installer by browsing to install.php, e.g. Select PostgreSQL in the database list and enter your database details Usage Overview -------------- [](#usage-overview) See [docs/en](docs/en/README.md) for more information about configuring the module. Known issues ------------ [](#known-issues) All column and table names must be double-quoted. PostgreSQL automatically lower-cases columns, and your queries will fail if you don't. Collations have known issues when installed on Alpine, MacOS X and BSD derivatives (see [PostgreSQL FAQ](https://wiki.postgresql.org/wiki/FAQ#Why_do_my_strings_sort_incorrectly.3F)). We do not support such installations, although they still may work correctly for you. As a workaround for PostgreSQL 10+ you could manually switch to ICU collations (e.g. und-x-icu). There are no known workarounds for PostgreSQL <10. Ts\_vector columns are not automatically detected by the built-in search filters. That means if you're doing a search through the CMS on a ModelAdmin object, it will use LIKE queries which are very slow. If you're writing your own front-end search system, you can specify the columns to use for search purposes, and you get the full benefits of T-Search. If you are using unsupported modules, there may be instances of MySQL-specific SQL queries which will need to be made database-agnostic where possible. ### Health Score 45 — FairBetter than 93% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity42 Moderate usage in the ecosystem Community37 Small or concentrated contributor base Maturity73 Established project with proven stability Bus Factor3 3 contributors hold 50%+ of commits How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~185 days Recently: every ~94 days Total 24 Last Release 677d ago Major Versions 1.2.0 → 2.0.0-alpha12016-10-26 1.x-dev → 2.0.12017-12-07 2.3.3 → 3.0.0-beta12023-03-02 ### Community Maintainers ![](https://avatars.githubusercontent.com/u/654636?v=4)[Aaron Carlino](/maintainers/unclecheese)[@unclecheese](https://github.com/unclecheese) ![](https://www.gravatar.com/avatar/b0cba8b534e20e6ab4fff555a97b237a18436ebca1446fc0b29c8a8b504038b9?d=identicon)[GuySartorelli](/maintainers/GuySartorelli) ![](https://avatars.githubusercontent.com/u/111025?v=4)[Ingo Schommer](/maintainers/chillu)[@chillu](https://github.com/chillu) ![](https://www.gravatar.com/avatar/a25bc04c5720a36869d5a39c6449dde7eb43e19b7c8e666d5f632d6a9ab440b1?d=identicon)[emteknetnz](/maintainers/emteknetnz) ![](https://www.gravatar.com/avatar/afbb3dcc9ef29c1a6eedd6addcae5fce9ab1271915a85a4c349301b71237368d?d=identicon)[silverstripe-machine01](/maintainers/silverstripe-machine01) ![](https://www.gravatar.com/avatar/be6648e60fbab6f70bfc34dd8c14259562d28a47510a934ea9c01fe98633f3c2?d=identicon)[sminnee](/maintainers/sminnee) ![](https://avatars.githubusercontent.com/u/1168676?v=4)[Maxime Rainville](/maintainers/maxime-rainville)[@maxime-rainville](https://github.com/maxime-rainville) --- Top Contributors [![geoff-silverstripe](https://avatars.githubusercontent.com/u/318115?v=4)](https://github.com/geoff-silverstripe "geoff-silverstripe (53 commits)")[![chillu](https://avatars.githubusercontent.com/u/111025?v=4)](https://github.com/chillu "chillu (32 commits)")[![dhensby](https://avatars.githubusercontent.com/u/563596?v=4)](https://github.com/dhensby "dhensby (32 commits)")[![emteknetnz](https://avatars.githubusercontent.com/u/4809037?v=4)](https://github.com/emteknetnz "emteknetnz (24 commits)")[![GuySartorelli](https://avatars.githubusercontent.com/u/36352093?v=4)](https://github.com/GuySartorelli "GuySartorelli (11 commits)")[![lozcalver](https://avatars.githubusercontent.com/u/1655548?v=4)](https://github.com/lozcalver "lozcalver (9 commits)")[![robbieaverill](https://avatars.githubusercontent.com/u/5170590?v=4)](https://github.com/robbieaverill "robbieaverill (8 commits)")[![simonwelsh](https://avatars.githubusercontent.com/u/125915?v=4)](https://github.com/simonwelsh "simonwelsh (8 commits)")[![tractorcow](https://avatars.githubusercontent.com/u/936064?v=4)](https://github.com/tractorcow "tractorcow (6 commits)")[![sminnee](https://avatars.githubusercontent.com/u/59968?v=4)](https://github.com/sminnee "sminnee (4 commits)")[![halkyon](https://avatars.githubusercontent.com/u/138450?v=4)](https://github.com/halkyon "halkyon (4 commits)")[![sabina-talipova](https://avatars.githubusercontent.com/u/87288324?v=4)](https://github.com/sabina-talipova "sabina-talipova (3 commits)")[![ScopeyNZ](https://avatars.githubusercontent.com/u/3260989?v=4)](https://github.com/ScopeyNZ "ScopeyNZ (3 commits)")[![phalkunz](https://avatars.githubusercontent.com/u/318116?v=4)](https://github.com/phalkunz "phalkunz (3 commits)")[![RantyDave](https://avatars.githubusercontent.com/u/4230547?v=4)](https://github.com/RantyDave "RantyDave (2 commits)")[![torleif](https://avatars.githubusercontent.com/u/67215?v=4)](https://github.com/torleif "torleif (2 commits)")[![wilr](https://avatars.githubusercontent.com/u/101629?v=4)](https://github.com/wilr "wilr (1 commits)")[![devimust](https://avatars.githubusercontent.com/u/12205479?v=4)](https://github.com/devimust "devimust (1 commits)")[![dnsl48](https://avatars.githubusercontent.com/u/9313746?v=4)](https://github.com/dnsl48 "dnsl48 (1 commits)")[![flamerohr](https://avatars.githubusercontent.com/u/1064889?v=4)](https://github.com/flamerohr "flamerohr (1 commits)") --- Tags databasepostgresqlsilverstripe ### Code Quality TestsPHPUnit Code StylePHP\_CodeSniffer ### Embed Badge ![Health badge](/badges/silverstripe-postgresql/health.svg) ``` [![Health](https://phpackages.com/badges/silverstripe-postgresql/health.svg)](https://phpackages.com/packages/silverstripe-postgresql) ``` ### Alternatives [silverstripe/mssql Adds MSSQL support to SilverStripe 157.8k1](/packages/silverstripe-mssql)[brettt89/silverstripe-garbage-collector SilverStripe Garbage Collector module 109.6k](/packages/brettt89-silverstripe-garbage-collector) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)