#postgresql

[ follow ]
#database-technology

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.

PostgreSQL becomes developers' choice for AI and real-time apps

PostgreSQL is increasingly favored among developers for AI-related applications due to its flexibility, reliability, and robust extensibility.

Microsoft backs open source PostgreSQL analytics extension

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

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.

PostgreSQL becomes developers' choice for AI and real-time apps

PostgreSQL is increasingly favored among developers for AI-related applications due to its flexibility, reliability, and robust extensibility.

Microsoft backs open source PostgreSQL analytics extension

An open source project aims to enhance PostgreSQL's analytics capabilities by integrating the DuckDB analytics engine.
moredatabase-technology
#web-development

You Don't Need a Lot of Code to Build a Web File Manager

Efficient file uploads and downloads can be achieved in web applications with minimal coding, using PostgreSQL and Gliimly.

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

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

You Don't Need a Lot of Code to Build a Web File Manager

Efficient file uploads and downloads can be achieved in web applications with minimal coding, using PostgreSQL and Gliimly.

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

Floating-point representation is unreliable for storing monetary values due to potential inaccuracies.
moreweb-development
#drizzle-orm

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 #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 #179. Pattern matching search with Drizzle ORM and PostgreSQL

Pattern matching in SQL is essential for efficient text searching in web applications using Drizzle ORM, PostgreSQL, and NestJS.

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 #174. Multiple PostgreSQL schemas with Drizzle ORM

PostgreSQL schemas help organize database objects, allowing for better management and control.

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 #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 #179. Pattern matching search with Drizzle ORM and PostgreSQL

Pattern matching in SQL is essential for efficient text searching in web applications using Drizzle ORM, PostgreSQL, and NestJS.

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 #174. Multiple PostgreSQL schemas with Drizzle ORM

PostgreSQL schemas help organize database objects, allowing for better management and control.
moredrizzle-orm

How to Build SaaS Multi-Tenant Applications: Multi-Tenant SaaS in 200 Lines of Code

SaaS application can be built in about 200 lines of code using PostgreSQL and Gliimly.
#database-management

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.

Timescale Bolsters AI-Ready PostgreSQL with pgai Vectorizer

Timescale's pgai Vectorizer enables seamless AI integration within PostgreSQL, streamlining workflows and enhancing vector embeddings 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 #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.

Timescale Bolsters AI-Ready PostgreSQL with pgai Vectorizer

Timescale's pgai Vectorizer enables seamless AI integration within PostgreSQL, streamlining workflows and enhancing vector embeddings 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.
moredatabase-management

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.

Failing to connect Commento with PostgreSQL

Commento can be self-hosted with PostgreSQL to avoid monthly fees, allowing blog comments integration with Hugo sites.

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.

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.
#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.
#prisma

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.

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

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.
moreprisma
#scala

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.

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

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

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.

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

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.
#sql-databases

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

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.

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

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.
moresql-databases

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.
[ Load more ]