GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → agroal → Pgagroal

agroal / Pgagroal

Licence: bsd-3-clause
High-performance connection pool for PostgreSQL

Programming Languages

c
50402 projects - #5 most used programming language

Labels

postgresqlhigh-performancepool

Projects that are alternatives of or similar to Pgagroal

Asyncpg
A fast PostgreSQL Database Client Library for Python/asyncio.
Stars: ✭ 5,216 (+1340.88%)
Mutual labels:  postgresql, high-performance
Libcopp
cross-platform coroutine library in c++
Stars: ✭ 398 (+9.94%)
Mutual labels:  pool, high-performance
Smartsql
SmartSql = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics
Stars: ✭ 775 (+114.09%)
Mutual labels:  postgresql, high-performance
agroal
The natural database connection pool
Stars: ✭ 92 (-74.59%)
Mutual labels:  high-performance, pool
Servicestack.ormlite
Fast, Simple, Typed ORM for .NET
Stars: ✭ 1,532 (+323.2%)
Mutual labels:  postgresql, high-performance
Stormpot
A fast object pool for the JVM
Stars: ✭ 267 (-26.24%)
Mutual labels:  pool, high-performance
Bloom Filter Scala
Bloom filter for Scala, the fastest for JVM
Stars: ✭ 333 (-8.01%)
Mutual labels:  high-performance
Dbngin
DB Engine
Stars: ✭ 344 (-4.97%)
Mutual labels:  postgresql
Mojito
An easy-to-use Elixir HTTP client, built on the low-level Mint library.
Stars: ✭ 333 (-8.01%)
Mutual labels:  pool
Devilbox
A modern Docker LAMP stack and MEAN stack for local development
Stars: ✭ 3,598 (+893.92%)
Mutual labels:  postgresql
Numpy Stl
Simple library to make working with STL files (and 3D objects in general) fast and easy.
Stars: ✭ 356 (-1.66%)
Mutual labels:  high-performance
Postgres
PostgreSQL driver for Deno
Stars: ✭ 352 (-2.76%)
Mutual labels:  postgresql
Sqlsmith
A random SQL query generator
Stars: ✭ 343 (-5.25%)
Mutual labels:  postgresql
Pgcat
Enhanced PostgreSQL logical replication
Stars: ✭ 335 (-7.46%)
Mutual labels:  postgresql
Windterm
A quicker and better cross-platform SSH/Sftp/Shell/Telnet/Serial client.
Stars: ✭ 345 (-4.7%)
Mutual labels:  high-performance
Pg Amqp Bridge
Send messages to RabbitMQ from PostgreSQL
Stars: ✭ 334 (-7.73%)
Mutual labels:  postgresql
Gramework
Fast and Reliable Golang Web Framework
Stars: ✭ 354 (-2.21%)
Mutual labels:  high-performance
Postgresql Monitoring
Queries to monitor postgresql
Stars: ✭ 331 (-8.56%)
Mutual labels:  postgresql
Kore
Kore (https://kore.io) is an easy to use web application platform for writing scalable web APIs in C. Its main goals are security, scalability and allowing rapid development and deployment of such APIs.
Stars: ✭ 3,477 (+860.5%)
Mutual labels:  high-performance
Pg Listen
📡 PostgreSQL LISTEN & NOTIFY for node.js that finally works.
Stars: ✭ 348 (-3.87%)
Mutual labels:  postgresql
View All Similar Projects ➔

pgagroal

pgagroal is a high-performance protocol-native connection pool for PostgreSQL.

Pronounced: p-g-a-gro-al, named after Agroal in Portugal.

Features

  • High performance
  • Connection pool
  • Limit connections for users and databases
  • Prefill support
  • Remove idle connections
  • Perform connection validation
  • Enable / disable database access
  • Graceful / fast shutdown
  • Prometheus support
  • Remote management
  • Authentication query support
  • Failover support
  • Transport Layer Security (TLS) v1.2+ support
  • Daemon mode
  • User vault

See Getting Started on how to get started with pgagroal.

See Configuration on how to configure pgagroal.

See Performance for a performance run.

Overview

pgagroal makes use of

  • Process model
  • Shared memory model across processes
  • libev for fast network interactions
  • Atomic operations are used to keep track of state
  • The PostgreSQL native protocol v3 for its communication

pgagroal will work with any PostgreSQL compliant driver, for example pgjdbc, Npgsql and pq.

See Architecture for the architecture of pgagroal.

Tested platforms

Compiling the source

pgagroal requires

dnf install gcc cmake make libev libev-devel openssl openssl-devel systemd systemd-devel python3-docutils

Alternative clang 8+ can be used.

Release build

The following commands will install pgagroal in the /usr/local hierarchy and run the default configuration.

git clone https://github.com/agroal/pgagroal.git
cd pgagroal
mkdir build
cd build
cmake -DCMAKE_INSTALL_PREFIX=/usr/local ..
make
sudo make install
/usr/local/bin/pgagroal -c /usr/local/etc/pgagroal/pgagroal.conf -a /usr/local/etc/pgagroal/pgagroal_hba.conf

See RPM for how to build a RPM of pgagroal.

Debug build

The following commands will create a DEBUG version of pgagroal.

git clone https://github.com/agroal/pgagroal.git
cd pgagroal
mkdir build
cd build
cmake -DCMAKE_BUILD_TYPE=Debug ..
make
cd src
cp ../../doc/etc/*.conf .
./pgagroal -c pgagroal.conf -a pgagroal_hba.conf

Remember to set the log_level configuration option to debug5.

Contributing

Contributions to pgagroal are managed on GitHub.com

Contributions are most welcome !

Please, consult our Code of Conduct policies for interacting in our community.

Consider giving the project a star on GitHub if you find it useful. And, feel free to follow the project on Twitter as well.

License

BSD-3-Clause

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].