Download the PHP package martin-georgiev/postgresql-for-doctrine without Composer

On this page you can find all versions of the php package martin-georgiev/postgresql-for-doctrine. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of martin-georgiev/postgresql-for-doctrine

Informations about the package postgresql-for-doctrine

PostgreSQL for Doctrine

Enhances Doctrine with PostgreSQL-specific features and functions. Supports PostgreSQL 9.4+ and PHP 8.2+.

Coverage Status Latest Stable Version Total Downloads

## Quick Start ## 🚀 Features Highlight ### Data Types - **Array Types** - Integer arrays (`int[]`, `smallint[]`, `bigint[]`) - Float arrays (`real[]`, `double precision[]`) - Text arrays (`text[]`) - Boolean arrays (`bool[]`) - JSONB arrays (`jsonb[]`) - **Binary Types** - Raw binary data (`bytea`, `bytea[]`) - **Bit String Types** - Fixed-length bit strings (`bit`, `bit[]`) - Variable-length bit strings (`bit varying`, `bit varying[]`) - **JSON Types** - Native JSONB support - JSON field operations - JSON construction and manipulation - **Network Types** - IP addresses (`inet`, `inet[]`) - Network CIDR notation (`cidr`, `cidr[]`) - MAC addresses (`macaddr`, `macaddr[]`, `macaddr8`, `macaddr8[]`) - **Geometric Types** - Box (`box`, `box[]`) - Circle (`circle`, `circle[]`) - Line (`line`, `line[]`) - Line segment (`lseg`, `lseg[]`) - Path (`path`, `path[]`) - Point (`point`, `point[]`) - Polygon (`polygon`, `polygon[]`) - PostGIS Geometry (`geometry`, `geometry[]`) - PostGIS Geography (`geography`, `geography[]`) - **Range Types** - Date and time ranges (`daterange`, `daterange[]`, `tsrange`, `tsrange[]`, `tstzrange`, `tstzrange[]`) - Numeric ranges (`numrange`, `numrange[]`, `int4range`, `int4range[]`, `int8range`, `int8range[]`) - Multiranges (`datemultirange`, `datemultirange[]`, `int4multirange`, `int4multirange[]`, `int8multirange`, `int8multirange[]`, `nummultirange`, `nummultirange[]`, `tsmultirange`, `tsmultirange[]`, `tstzmultirange`, `tstzmultirange[]`) - **Date and Time Types** - Arrays (`date[]`, `timestamp[]`, `timestamptz[]`) - Time durations with `DateInterval` support (`interval`, `interval[]`) - String-represented time with timezone (`timetz`, `timetz[]`) - **Text Search Types** - Full-text search document (`tsvector`, `tsvector[]`) - Full-text search query (`tsquery`, `tsquery[]`) - **Case-Insensitive Text Types** (requires [citext](https://www.postgresql.org/docs/18/citext.html) extension) - Case-insensitive text (`citext`, `citext[]`) - **ULID Types** (requires [pgx_ulid](https://github.com/pksunkara/pgx_ulid) extension) - Sortable, timestamp-prefixed identifiers (`ulid`, `ulid[]`) - **Key-Value Types** (requires [hstore](https://www.postgresql.org/docs/18/hstore.html) extension) - Key-value store (`hstore`, `hstore[]`) - **Monetary Types** - Currency amounts (`money`, `money[]`) - **XML Types** - Native XML document storage (`xml`, `xml[]`) - **Hierarchical Types** - Label-tree data (`ltree`, `ltree[]`) - **Vector Types** (requires [pgvector](https://github.com/pgvector/pgvector) extension) - Fixed-dimension float vector (`vector`) - Half-precision float vector (`halfvec`) - Sparse vector (`sparsevec`) - **Enum Types** - User-defined PostgreSQL enum types [via `Enum` base class](docs/ENUM-TYPE.md) - **Composite Types** - User-defined PostgreSQL composite (row) types [via `Composite` base class](docs/COMPOSITE-TYPE.md) - Access fields from [user-defined composite types](https://www.postgresql.org/docs/17/rowtypes.html) via `COMPOSITE_FIELD()` function ### PostgreSQL Operators - **Array Operations** - Contains (`@>`) - Is contained by (`<@`) - Overlaps (`&&`) - Array aggregation with ordering - **JSON Operations** - Field access (`->`, `->>`) - Path operations (`#>`, `#>>`) - JSON containment and existence operators - **Range Operations** - Containment checks (in PHP value objects and for DQL queries with `@>` and `<@`) - Overlaps (`&&`) - **PostGIS Spatial Operations** - Bounding box relationships (`<<`, `>>`, `&<`, `&>`, `|&>`, `&<|`, `<<|`, `|>>`) - Spatial containment (`@`, `~`) - Distance calculations (`<->`, `<#>`, `<<->>`, `<<#>>`, `|=|`) - N-dimensional operations (`&&&`) ### Functions - **Text Search** - Full text search (`to_tsvector`, `to_tsquery`) - Pattern matching (`ilike`, `similar to`) - Regular expressions - String manipulation (`ascii`, `btrim`, `char_length`, `chr`, `decode`, `encode`, `initcap`, `lpad`, `ltrim`, `octet_length`, `quote_ident`, `quote_literal`, `quote_nullable`, `rpad`, `rtrim`, `strpos`, `translate`) - Trigram similarity (`similarity`, `word_similarity`, `strict_word_similarity`) (requires [pg_trgm](https://www.postgresql.org/docs/18/pgtrgm.html) extension) - **Hashing & Checksum** (`md5`, `sha224`, `sha256`, `sha384`, `sha512`, `crc32`, `crc32c`, `reverse` for bytea) - **Array Functions** - Generic array aggregation and manipulation (`array_agg`, `array_append`, `array_prepend`, `array_remove`, `array_replace`, `array_shuffle`) - Array dimensions and length - Special aggregates (`any_value`) - **JSON Functions** - JSON construction (`json_build_object`, `jsonb_build_object`) - JSON manipulation and transformation - Row to JSON (`row_to_json`, `row`) - **Date Functions** - Current timestamp functions (`clock_timestamp`, `statement_timestamp`, `transaction_timestamp`) - Interval adjustment (`justify_days`, `justify_hours`, `justify_interval`) - **Aggregate Functions** - Aggregation with ordering and distinct (`array_agg`, `json_agg`, `jsonb_agg`) - Statistical aggregates (`bool_and`, `bool_or`, `every`, `bit_and`, `bit_or`, `bit_xor`, `stddev`, `stddev_pop`, `var_pop`, `variance`, `corr`, `covar_pop`, `covar_samp`) - Special aggregates (`any_value`, `xmlagg`) - **Hstore Functions** (requires [hstore](https://www.postgresql.org/docs/18/hstore.html) extension) - Key and value extraction (`akeys`, `avals`, `skeys`, `svals`) - Key inspection (`defined`) - Key deletion (`delete`) - JSON conversion (`hstore_to_json`, `hstore_to_json_loose`) - **XML Functions** - XML aggregation, construction, manipulation, validation (`xmlagg`, `xmlcomment`, `xmlconcat`, `xml_is_well_formed`) - XPath querying (`xpath`, `xpath_exists`) - **Mathematical/Arithmetic Functions** - Trigonometric functions (`sin`, `cos`, `tan`, `asin`, `acos`, `atan`, degree variants) - Hyperbolic functions (`sinh`, `cosh`, `tanh`, `asinh`, `acosh`, `atanh`) - Number theory functions (`gcd`, `lcm`, `factorial`, `div`) - Statistical functions (`erf`, `erfc`, `random_normal`) - **Range Functions** - **Utility Functions** - Type casting (`cast`) - Data formatting (`to_char`, `to_number`) - UUID generation and inspection (`uuidv4`, `uuidv7`, `uuid_extract_timestamp`, `uuid_extract_version`) - **Vector Distance Functions** Full documentation: - [Available Types](docs/AVAILABLE-TYPES.md) - [Value Objects for Range Types](docs/RANGE-TYPES.md) - [PostgreSQL ltree Types](docs/LTREE-TYPE.md) - [Infinity Values](docs/INFINITY.md) - [Available Functions and Operators](docs/AVAILABLE-FUNCTIONS-AND-OPERATORS.md) - Overview and cross-references - [Array and JSON Functions](docs/ARRAY-AND-JSON-FUNCTIONS.md) - [PostGIS Spatial Functions](docs/SPATIAL-FUNCTIONS-AND-OPERATORS.md) - [Text and Pattern Functions](docs/TEXT-AND-PATTERN-FUNCTIONS.md) - [Date and Range Functions](docs/DATE-AND-RANGE-FUNCTIONS.md) - [Mathematical Functions](docs/MATHEMATICAL-FUNCTIONS.md) - [Utility Functions](docs/UTILITY-FUNCTIONS.md) - [XML Functions](docs/XML-FUNCTIONS.md) - [Network Address Functions](docs/NETWORK-FUNCTIONS.md) - [Common Use Cases and Examples](docs/USE-CASES-AND-EXAMPLES.md) - [Spatial Types](docs/SPATIAL-TYPES.md) - [Geometry Arrays](docs/GEOMETRY-ARRAYS.md) ## 📦 Installation ## 🔧 Integration Guides - [Integrating with Symfony](docs/INTEGRATING-WITH-SYMFONY.md) - [Integrating with Laravel](docs/INTEGRATING-WITH-LARAVEL.md) - [Integrating with Doctrine](docs/INTEGRATING-WITH-DOCTRINE.md) ## 💡 Usage Examples See our [Common Use Cases and Examples](docs/USE-CASES-AND-EXAMPLES.md) for detailed code samples. ## 🧪 Testing ### Unit Tests ### PostgreSQL Integration Tests We also provide integration tests that run against a real PostgreSQL database with PostGIS: See [tests/Integration/README.md](tests/Integration/README.md) for more details. ## ⭐ Support the Project ### 💖 GitHub Sponsors If you find this package useful for your projects, please consider [sponsoring the development via GitHub Sponsors](https://github.com/sponsors/martin-georgiev). Your support helps maintain this package, create new features, and improve documentation. Benefits of sponsoring: - Priority support for issues and feature requests - Direct access to the maintainer - Help sustain open-source development ### Other Ways to Help - Star the repository - [Report issues](https://github.com/martin-georgiev/postgresql-for-doctrine/issues) - [Contribute](docs/CONTRIBUTING.md) with code or documentation - Share the project with others ## 📝 License This package is licensed under the MIT License. See the [LICENSE](LICENSE) file for details. ## ⚡️ Powered by JetBrains

All versions of postgresql-for-doctrine with dependencies

PHP Build Version
Package Version
Requires php Version ^8.2 <8.6
ext-ctype Version *
ext-json Version *
ext-mbstring Version *
doctrine/dbal Version ~2.10||~3.0||~4.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package martin-georgiev/postgresql-for-doctrine contains the following files

Loading the files please wait ...