TypeScript icon, indicating that this package has built-in type declarations

1.4.1 • Public • Published


Contributor Covenant

A PostgreSQL store for the express-rate-limit middleware.


From the npm registry:

# Using npm
> npm install --save @acpr/rate-limit-postgresql
# Using yarn or pnpm
> yarn/pnpm add @acpr/rate-limit-postgresql


Functional examples for using rate-limit-postgresql are found in the following repository

let rateLimit = require('express-rate-limit')
let postgresStores = require('@acpr/rate-limit-postgresql')

let limiter = new RateLimit({
	store: new postgresStores.PostgresStore(
			user: 'postgres',
			password: 'postgres',
			host: 'localhost',
			database: 'rate-limit',
			port: 5432,
	windowMs: 15 * 60 * 1000, // 15 minutes
	max: 3, // Limit each IP to 3 requests per `window` (here, per 15 minutes)
		'Too many accounts created from this IP, please try again after 15 minutes',
	standardHeaders: 'draft-7', // Set `RateLimit` and `RateLimit-Policy`` headers
	legacyHeaders: false,

//  apply to all requests


This library is provided in ESM as well as CJS forms, and works with both Javascript and Typescript projects.

This package requires you to use Node 16 or above.

Import it in a CommonJS project (type: commonjs or no type field in package.json) as follows:

let postgresStores = require('@acpr/rate-limit-postgresql')

Import it in a ESM project (type: module in package.json) as follows:

import postgresStores from '@acpr/rate-limit-postgresql'


Types of Postgres Stores

There are two different types of Postgres Stores:

  1. PostgresStoreAggregatedIP (with the default PostgresStore constructor)- which aggregates the IP count in the table, as shown in the following table
key session_id count 1 3 1 1
  1. PostgresStoreIndividualIP - which stores the IP of each request in a separate row (as shown in the following table) and performs the aggregation at a separate step
id key session_id event_time
1 1 2023-09-13T07:40:09+00:00
2 1 2023-09-13T07:40:10+00:00
3 1 2023-09-13T07:40:11+00:00
4 1 2023-09-13T07:40:11+00:00

Note: The database uses UUID as a data type for IDs, the tables contain integers as IDs to keep illustration simple.


Both types of store take the same input in their constructor

  • config - The database configuration as specified in the node-postgres configuration.
  • prefix - The unique name of the session (persisted in the database). Used by the double-count check to avoid false-positives when a key is counted twice, but with different prefixes.


Project license is specified in the license file. Third party licenses are located in the third_party_licenses folder

Package Sidebar


npm i @acpr/rate-limit-postgresql

Weekly Downloads






Unpacked Size

42.8 kB

Total Files


Last publish


  • nfriedly
  • gamemaker1
  • acpr