#PostgreSQL

[ follow ]
#postgresql

API with NestJS #173. Storing money with Drizzle ORM and PostgreSQL

Floating-point representation is unreliable for storing monetary values due to potential inaccuracies.

Building an API with Go, PostgreSQL, Google Cloud and CockroachDB | HackerNoon

The article offers a practical guide for developers to build and deploy an API focused on materia fusion from Crisis Core: Final Fantasy VII.

PostgreSQL 17 Released with Improved Vacuum Process and Performance Gains

PostgreSQL 17 enhances performance with new memory management for vacuum operations and logical replication improvements.

API with NestJS #172. Database normalization with Drizzle ORM and PostgreSQL

Database normalization simplifies data management by eliminating redundancy through clear rules, enhancing efficiency in data retrieval.

Users remain on PostgreSQL 12 as end of life looms

PostgreSQL 12 will reach end of life soon; many users must prepare for upgrades to remain supported.

API with NestJS #171. Recursive relationships with Drizzle ORM and PostgreSQL

Recursive relationships enable hierarchical structures in database design, allowing entities to reference themselves.

API with NestJS #173. Storing money with Drizzle ORM and PostgreSQL

Floating-point representation is unreliable for storing monetary values due to potential inaccuracies.

Building an API with Go, PostgreSQL, Google Cloud and CockroachDB | HackerNoon

The article offers a practical guide for developers to build and deploy an API focused on materia fusion from Crisis Core: Final Fantasy VII.

PostgreSQL 17 Released with Improved Vacuum Process and Performance Gains

PostgreSQL 17 enhances performance with new memory management for vacuum operations and logical replication improvements.

API with NestJS #172. Database normalization with Drizzle ORM and PostgreSQL

Database normalization simplifies data management by eliminating redundancy through clear rules, enhancing efficiency in data retrieval.

Users remain on PostgreSQL 12 as end of life looms

PostgreSQL 12 will reach end of life soon; many users must prepare for upgrades to remain supported.

API with NestJS #171. Recursive relationships with Drizzle ORM and PostgreSQL

Recursive relationships enable hierarchical structures in database design, allowing entities to reference themselves.
morepostgresql

OCI Database: Oracle Embraces PostgreSQL

Oracle announces the general availability of OCI Database with PostgreSQL version 14.9, the first managed PostgreSQL service on Oracle Cloud.
The service offers advantages in terms of cost, performance, scale, availability, and durability, with a purpose-built shared-storage architecture and a custom user-mode DbOS filesystem.

API with NestJS #136. Raw SQL queries with Prisma and PostgreSQL range types

Prisma currently does not support range types in PostgreSQL, but PostgreSQL has built-in range types that can be used.
To use a range type in Prisma, you need to define the type in the schema and create a migration manually.

Using ElectricSQL to build a local-first application - LogRocket Blog

ElectricSQL is a sync layer between apps and PostgreSQL database, allowing for seamless data synchronization between local device and remote database.
ElectricSQL is currently in public alpha with limitations such as no support for SERIAL, SEQUENCE, and UNIQUE, and restrictions on primary and foreign keys.

Google AlloyDB Omni: PostgreSQL-Compatible Database for On-Premises and VMware Cloud Foundation

AlloyDB Omni, a downloadable version of the PostgreSQL-compatible database service AlloyDB, is now generally available on Google Cloud.
AlloyDB Omni is designed to run on-premises and offers support for generative AI, vector embeddings, and integrations with the Google Cloud AI ecosystem.
Google Cloud also announced the preview of the AlloyDB Omni Kubernetes operator, which simplifies database provisioning and observability in Kubernetes environments.
[ Load more ]