#postgresql

[ follow ]
#data-types

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

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

API with NestJS #147. The data types to store money with PostgreSQL and Prisma

Avoid using floating-point numbers for storing monetary values due to potential errors.
Binary representation of integer numbers simplifies storing integers efficiently in computers.

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

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

API with NestJS #147. The data types to store money with PostgreSQL and Prisma

Avoid using floating-point numbers for storing monetary values due to potential errors.
Binary representation of integer numbers simplifies storing integers efficiently in computers.
moredata-types

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.
#performance-optimization

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.

An Overview of PostgreSQL indexing | HackerNoon

Effective index management in PostgreSQL 16 is key to optimizing database performance as data volumes increase.

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.

An Overview of PostgreSQL indexing | HackerNoon

Effective index management in PostgreSQL 16 is key to optimizing database performance as data volumes increase.
moreperformance-optimization

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.
#database-management

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 #169. Unique IDs with UUIDs using Drizzle ORM and PostgreSQL

UUIDs offer a robust method for generating unique identifiers, addressing the need for uniqueness in databases.

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 #169. Unique IDs with UUIDs using Drizzle ORM and PostgreSQL

UUIDs offer a robust method for generating unique identifiers, addressing the need for uniqueness in databases.
moredatabase-management
#drizzle-orm

API with NestJS #170. Polymorphic associations with PostgreSQL and Drizzle ORM

Polymorphic associations optimize database design by allowing a single comment table to relate to multiple types of content without redundancy.

API with NestJS #165. Time intervals with the Drizzle ORM and PostgreSQL

Flexible time intervals can be defined in PostgreSQL, validated through custom validators, and effectively managed using Drizzle ORM.

API with NestJS #163. Full-text search with the Drizzle ORM and PostgreSQL

Full-text search in PostgreSQL enables rapid and relevant document searches with Drizzle ORM and NestJS implementation.

API with NestJS #160. Using views with the Drizzle ORM and PostgreSQL

PostgreSQL offers views and materialized views to simplify complex SQL queries by creating virtual tables that can be stored in the database for performance optimization.

API with NestJS #170. Polymorphic associations with PostgreSQL and Drizzle ORM

Polymorphic associations optimize database design by allowing a single comment table to relate to multiple types of content without redundancy.

API with NestJS #165. Time intervals with the Drizzle ORM and PostgreSQL

Flexible time intervals can be defined in PostgreSQL, validated through custom validators, and effectively managed using Drizzle ORM.

API with NestJS #163. Full-text search with the Drizzle ORM and PostgreSQL

Full-text search in PostgreSQL enables rapid and relevant document searches with Drizzle ORM and NestJS implementation.

API with NestJS #160. Using views with the Drizzle ORM and PostgreSQL

PostgreSQL offers views and materialized views to simplify complex SQL queries by creating virtual tables that can be stored in the database for performance optimization.
moredrizzle-orm

Failing to connect Commento with PostgreSQL

Commento can be self-hosted with PostgreSQL to avoid monthly fees, allowing blog comments integration with Hugo sites.
#open-source
from Developer Tech News
1 month ago
Business intelligence

PostgreSQL 17 delivers a leap forward for open-source databases

PostgreSQL 17 introduces major performance improvements and new features, enhancing both scalability and developer experience in database management.

Microsoft backs open source PostgreSQL analytics extension

An open source project aims to enhance PostgreSQL's analytics capabilities by integrating the DuckDB analytics engine.

PostgreSQL 17 delivers a leap forward for open-source databases

PostgreSQL 17 introduces major performance improvements and new features, enhancing both scalability and developer experience in database management.

Microsoft backs open source PostgreSQL analytics extension

An open source project aims to enhance PostgreSQL's analytics capabilities by integrating the DuckDB analytics engine.
moreopen-source

PostgreSQL 17 packs big performance and feature enhancements

PostgreSQL 17 introduces native incremental backups, advanced SQL/JSON support, improved transaction handling, and enhanced logical replication, positioning it as a top database solution.

PostgreSQL: Write-Ahead Logging (WAL)

WAL is essential for database integrity, allowing for recovery and consistency through pre-logging changes.
#mongodb

MongoDB dunks on PostgreSQL after Q2 success

MongoDB claims to be gaining market share against PostgreSQL by addressing limitations in scalability and flexibility for applications like Fanatics Betting & Gaming.

API with NestJS #157. Handling JSON data with PostgreSQL and the Drizzle ORM

PostgreSQL offers structured data handling, while MongoDB suits flexible data with varying attributes. PostgreSQL supports storing and querying loosely structured JSON data using JSON columns effectively.

MongoDB dunks on PostgreSQL after Q2 success

MongoDB claims to be gaining market share against PostgreSQL by addressing limitations in scalability and flexibility for applications like Fanatics Betting & Gaming.

API with NestJS #157. Handling JSON data with PostgreSQL and the Drizzle ORM

PostgreSQL offers structured data handling, while MongoDB suits flexible data with varying attributes. PostgreSQL supports storing and querying loosely structured JSON data using JSON columns effectively.
moremongodb
#nestjs

Introducing Turborepo NestJS + Qwik City Boilerplate

This boilerplate combines NestJS, Qwik City, and PostgreSQL with a strong emphasis on TypeScript and modern development practices.

API with NestJS #152. SQL constraints with the Drizzle ORM

Constraints in SQL databases such as not-null, unique, and primary key play vital roles in maintaining data integrity.

Introducing Turborepo NestJS + Qwik City Boilerplate

This boilerplate combines NestJS, Qwik City, and PostgreSQL with a strong emphasis on TypeScript and modern development practices.

API with NestJS #152. SQL constraints with the Drizzle ORM

Constraints in SQL databases such as not-null, unique, and primary key play vital roles in maintaining data integrity.
morenestjs

API with NestJS #162. Identity columns with the Drizzle ORM and PostgreSQL

The PostgreSQL community now recommends using identity columns over serial types for defining primary keys.

Supabase adoption guide: Overview, examples, and alternatives - LogRocket Blog

Supabase is a game-changing backend service for frontend developers, streamlining workflows and enhancing user experience.

Google Introduces Free Trial for AlloyDB PostgreSQL Database

Google offers a free trial for AlloyDB, a high-performance managed PostgreSQL-compatible database service with advanced features for various use cases.

API with NestJS #159. Date and time with PostgreSQL and the Drizzle ORM

Storing date and time correctly is critical. PostgreSQL uses ISO 8601 format. Time zones are managed without automatic conversion. Choosing the appropriate column type is essential.

Enabling Full-Text Search with Slick-pg

Developers can utilize tminglei's Slick PostgreSQL Extensions for PostgreSQL full-text search in Scala Slick projects.

C# .NET Core Event Source with Martendb

MartenDB enables CRUD operations effortlessly
MartenDB showcases powerful Event Sourcing capabilities

GitHub - evoluteur/evolutility-server-node: Model-driven REST APIs for CRUD and more, written in Javascript, using Node.js, Express, and PostgreSQL.

Evolutility-Server-Node offers generic REST APIs for CRUD operations and simple charts on objects with varied structures.
Evolutility-Server-Node requires Node.js, Express, PostgreSQL, and PG-Promise as dependencies for operation.
#scala
from Medium
8 months ago
Scala

Building a Secure User Registration Service with Email Verification in Scala and http4s

Ensuring a secure and seamless user registration process is important for online platforms.
This article discusses the use of Scala, http4s, Slick, Redis, and PostgreSQL to create a robust web service for user registrations.

Using TestContainers in Scala with Spark for real unit testing

TestContainers is a technology that allows you to spin up docker containers programmatically for testing purposes.
This article provides a step-by-step guide on how to set up a Scala project using SBT and write a test that reads from a PostgreSQL database created through TestContainers using Spark.

Building a Secure User Registration Service with Email Verification in Scala and http4s

Ensuring a secure and seamless user registration process is important for online platforms.
This article discusses the use of Scala, http4s, Slick, Redis, and PostgreSQL to create a robust web service for user registrations.

Using TestContainers in Scala with Spark for real unit testing

TestContainers is a technology that allows you to spin up docker containers programmatically for testing purposes.
This article provides a step-by-step guide on how to set up a Scala project using SBT and write a test that reads from a PostgreSQL database created through TestContainers using Spark.
morescala

Select API with NestJS #141. Getting distinct records with Prisma and PostgreSQL

PostgreSQL provides ways to filter query results and remove duplicate rows.
Prisma can be configured to use native database features to filter duplicates in memory.

API with NestJS #140. Using multiple PostgreSQL schemas with Prisma

Schemas in PostgreSQL act as namespaces within the database and are containers for objects like tables and indexes.
By default, when creating a table without specifying the schema, PostgreSQL attaches it to the public schema.
#PostgreSQL

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.

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.
morePostgreSQL

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.

The database is the bottleneck! | @lightbend

Akka 24.05 achieves high throughput with PostgreSQL by sharding write requests

Approximate Counting in Django and Postgres

Django's paginator relies on slow SELECT COUNT(*) query. Approaches include approximating row count and custom paginator for faster loading.

Java JDBC connection string examples

Example JDBC connection strings for popular databases.

Open source extensions from Timescale| ScopeTrader

Timescale introduces pgvectorscale and pgai open-source extensions to enhance PostgreSQL for AI applications, competing with specialized vector databases like Pinecone at a lower cost.

API with NestJS #153. SQL transactions with the Drizzle ORM

Ensuring data integrity is a key role for developers, and SQL databases provide tools for consistency. Transactions in SQL maintain atomicity, consistency, isolation, and durability (ACID properties).
[ Load more ]