Registry / database / sequelize-postgres-papandreou

sequelize-postgres-papandreou

library7.0.0-alpha.44-patch8jsnpmunverified

A PostgreSQL dialect adapter for Sequelize, specifically version 7.0.0-alpha.44-patch8 of a community fork (papandreou) that patches Sequelize's built-in Postgres support. This package is part of the Sequelize ORM ecosystem and provides the database-specific layer for connecting to PostgreSQL databases. It aims to address bugs or missing features in the official Sequelize PostgreSQL dialect, particularly for alpha releases. The fork sees active but irregular patches. Key differentiators: offers fixes for edge cases in Sequelize 7 alpha that may not yet be merged upstream. However, users should prefer the official @sequelize/postgres package for production use or upgrade to Sequelize 7 stable when released. Release cadence is patch-focused, tied to Sequelize alpha updates.

database

npm install sequelize-postgres-papandreou

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · SEQUELIZE-POSTGRES

sequelize-postgres-papandreou

databasejavascriptv7.0.0-alpha.44-patch8

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

Sequelize

✓ import { Sequelize } from 'sequelize';

✗ const Sequelize = require('sequelize');

Sequelize is a named export. In TypeScript, use named import (ESM only).

default export

✓ import pgDialect from 'sequelize-postgres-papandreou';

✗ import { pgDialect } from 'sequelize-postgres-papandreou';

The package exports a default dialect class. Do not use named import.

type import (TypeScript)

✓ import type { Dialect } from 'sequelize'; import pgDialect from 'sequelize-postgres-papandreou';

✗ import pgDialect from 'sequelize-postgres-papandreou' with ({ dialect: pgDialect });

Use type import for Dialect from sequelize, then pass the default export as dialect option.

Initializes Sequelize with the Papandreou PostgreSQL dialect, authenticates, and closes connection.

import { Sequelize } from 'sequelize'; import pgDialect from 'sequelize-postgres-papandreou'; const sequelize = new Sequelize({ dialect: pgDialect, host: 'localhost', port: 5432, database: process.env.DB_NAME ?? 'test', username: process.env.DB_USER ?? 'postgres', password: process.env.DB_PASS ?? '', }); async function test() { try { await sequelize.authenticate(); console.log('Connection has been established successfully.'); } catch (error) { console.error('Unable to connect to the database:', error); } finally { await sequelize.close(); } } test();

Debug

Known issues

deprecatedUse @sequelize/postgres instead for production; this fork is for Sequelize 7 alpha and may be abandoned.

fix

Migrate to '@sequelize/postgres' when using Sequelize 7 stable.

affects: >=7.0.0-alpha.0

gotchaImporting the dialect as a named export (e.g., import { pgDialect }) will fail; it is a default export.

fix

Use default import: import pgDialect from 'sequelize-postgres-papandreou';

affects: >=7.0.0-alpha.0

breakingSequelize 7 is alpha; this dialect may have incomplete feature support compared to sequelize@6.

fix

Check the official Sequelize migration guide before upgrading from v6.

affects: >=7.0.0-alpha.0

Errors

Common errors & fixes

Error: Dialect needs to be supplied, as sqlite!

Incorrect import or missing customization; this error occurs when Sequelize cannot find the dialect module.

fix

Ensure you import the dialect correctly: import pgDialect from 'sequelize-postgres-papandreou'; and pass it in the options: dialect: pgDialect

TypeError: PG_DIALECT is not a constructor

Using ESM default import with require-style pattern, or importing named export that does not exist.

fix

Use default import: import pgDialect from 'sequelize-postgres-papandreou';

SequelizeConnectionError: connect ECONNREFUSED

PostgreSQL server not running or connection parameters incorrect.

fix

Verify host, port, and that the database service is running. Check environment variables.

Upgrade

Version history

7.0.0-alpha.44-patch8latest on npm

Audit

Dependencies

sequelizerequiredCore ORM; this dialect is a plugin for Sequelize 7.

Agent activity

9 hits · last 30 days

node