backend.im/realtimechatapiwithmediasupport-t50lz6

Automated Action a0aec8bfae Configure application to use PostgreSQL instead of SQLite

- Updated package.json to use PostgreSQL dependencies (pg, @types/pg)
- Removed SQLite dependency
- Updated TypeORM configuration for PostgreSQL connection
- Modified database entities to use PostgreSQL-compatible column types (jsonb, timestamp)
- Created comprehensive database migration script for initial schema
- Updated environment configuration with PostgreSQL variables
- Updated README with PostgreSQL setup instructions and database migration steps
- Ensured storage directories are properly configured

🤖 Generated with BackendIM

Co-Authored-By: Claude <noreply@anthropic.com>

2025-06-21 17:46:30 +00:00

1.5 KiB

Raw Permalink Blame History

postgres-date

Postgres date output parser

This package parses date/time outputs from Postgres into Javascript Date objects. Its goal is to match Postgres behavior and preserve data accuracy.

If you find a case where a valid Postgres output results in incorrect parsing (including loss of precision), please create a pull request and provide a failing test.

Supported Postgres Versions: >= 9.6

All prior versions of Postgres are likely compatible but not officially supported.

Install

$ npm install --save postgres-date

Usage

var parse = require('postgres-date')
parse('2011-01-23 22:15:51Z')
// => 2011-01-23T22:15:51.000Z

API

`parse(isoDate)` -> `date`

isoDate

Required
Type: string

A date string from Postgres.

Releases

The following semantic versioning increments will be used for changes:

Major: Removal of support for Node.js versions or Postgres versions (not expected)
Minor: Unused, since Postgres returns dates in standard ISO 8601 format
Patch: Any fix for parsing behavior

1.5 KiB Raw Permalink Blame History