#postgresql
#postgresql

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

JavaScript

API with NestJS #174. Multiple PostgreSQL schemas with Drizzle ORM

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

fromHackernoon

Ruby on Rails

Want Everyone Out of the Database? Here's How the Pros Do It | HackerNoon

Single-user mode is essential for performing critical database tasks without conflicts.

Transitioning back to multi-user mode is crucial after maintenance to restore normal operations.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

Miscellaneous

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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

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

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

JavaScript

API with NestJS #174. Multiple PostgreSQL schemas with Drizzle ORM

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

fromHackernoon

Ruby on Rails

Want Everyone Out of the Database? Here's How the Pros Do It | HackerNoon

Single-user mode is essential for performing critical database tasks without conflicts.

Transitioning back to multi-user mode is crucial after maintenance to restore normal operations.

Miscellaneous

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.

more#database-management

fromLogRocket Blog

1 week ago

Data science

Use TypeScript instead of Python for ETL pipelines - LogRocket Blog

Building an ETL pipeline in TypeScript enhances type safety and maintainability while processing data from various sources.

fromAmazon Web Services

3 weeks ago

Java

Converting embedded SQL in Java applications with Amazon Q Developer | Amazon Web Services

Automating SQL code conversion streamlines database migration efforts and mitigates risks of errors and downtime.

fromThe Hacker News

4 weeks ago

Over 1,500 PostgreSQL Servers Compromised in Fileless Cryptocurrency Mining Campaign

Ongoing campaign targets exposed PostgreSQL instances to deploy cryptocurrency miners via weak credentials and advanced evasion techniques.

Privacy professionals

fromresund Startups

1 month ago

London startup

Foo Cafe: Back once again with amazing tech events

The Spring Event at Foo Café aims to foster community and learning among tech enthusiasts with a diverse lineup of educational presentations.

#nosql

Business intelligence

Microsoft builds open source document database on PostgreSQL

Microsoft has launched a fully open-source document database platform built on PostgreSQL, providing a no-cost, schema-less solution for developers.

fromInfoWorld

JavaScript

Microsoft's new DocumentDB rethinks NoSQL on PostgreSQL

Open-source DocumentDB offers an alternative to MongoDB.

Azure Cosmos DB vCore introduces a predictable pricing model.

The new DocumentDB built on PostgreSQL provides a NoSQL environment.

Migration between Cosmos DB versions requires complete data transfer.

Miscellaneous

Microsoft bolsters PostgreSQL with NoSQL-like extensions

Microsoft's open-source PostgreSQL extensions blur the lines between relational and non-relational databases, particularly targeting MongoDB.

The introduction of Binary JSON and MongoDB-compatible commands showcases a shift in database technology.

Document databases are increasingly integrating features of relational databases.

Business intelligence

Microsoft builds open source document database on PostgreSQL

Microsoft has launched a fully open-source document database platform built on PostgreSQL, providing a no-cost, schema-less solution for developers.

fromInfoWorld

JavaScript

Microsoft's new DocumentDB rethinks NoSQL on PostgreSQL

Open-source DocumentDB offers an alternative to MongoDB.

Azure Cosmos DB vCore introduces a predictable pricing model.

The new DocumentDB built on PostgreSQL provides a NoSQL environment.

Migration between Cosmos DB versions requires complete data transfer.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

Miscellaneous

Microsoft bolsters PostgreSQL with NoSQL-like extensions

Microsoft's open-source PostgreSQL extensions blur the lines between relational and non-relational databases, particularly targeting MongoDB.

The introduction of Binary JSON and MongoDB-compatible commands showcases a shift in database technology.

Document databases are increasingly integrating features of relational databases.

more#nosql

#postgis

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

API with NestJS #183. Distance and radius in PostgreSQL with Drizzle ORM

PostgreSQL's PostGIS extension offers robust geographical data handling, essential for calculating distances and identifying locations using defined coordinate systems.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

API with NestJS #185. Operations with PostGIS Polygons in PostgreSQL and Drizzle

PostGIS allows various operations on polygons in PostgreSQL, integrated through raw SQL queries and Drizzle ORM.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

API with NestJS #184. Storing PostGIS Polygons in PostgreSQL with Drizzle ORM

PostGIS enables the storage and representation of polygons in PostgreSQL, highlighting geographical data management.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

API with NestJS #183. Distance and radius in PostgreSQL with Drizzle ORM

PostgreSQL's PostGIS extension offers robust geographical data handling, essential for calculating distances and identifying locations using defined coordinate systems.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

API with NestJS #185. Operations with PostGIS Polygons in PostgreSQL and Drizzle

PostGIS allows various operations on polygons in PostgreSQL, integrated through raw SQL queries and Drizzle ORM.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

API with NestJS #184. Storing PostGIS Polygons in PostgreSQL with Drizzle ORM

PostGIS enables the storage and representation of polygons in PostgreSQL, highlighting geographical data management.

more#postgis

fromMarcin Wanago Blog - JavaScript, both frontend and backend

API with NestJS #181. Prepared statements in PostgreSQL with Drizzle ORM

Using prepared statements improves query execution efficiency in PostgreSQL.

Prepared statements are session-specific, meaning they don't persist beyond the current session.

JavaScript

#nestjs

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

JavaScript

API with NestJS #180. Organizing Drizzle ORM schema with PostgreSQL

A good file structure from the start simplifies application maintenance as it scales.

fromDEV Community

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

Introducing Turborepo NestJS + Qwik City Boilerplate

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

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

JavaScript

API with NestJS #180. Organizing Drizzle ORM schema with PostgreSQL

A good file structure from the start simplifies application maintenance as it scales.

fromDEV Community

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

Introducing Turborepo NestJS + Qwik City Boilerplate

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

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

more#nestjs

#drizzle-orm

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

API with NestJS #178. Storing files inside of a PostgreSQL database with Drizzle

PostgreSQL's bytea column can store binary data, but Drizzle ORM requires custom definitions to handle it properly.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

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.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

JavaScript

API with NestJS #178. Storing files inside of a PostgreSQL database with Drizzle

PostgreSQL's bytea column can store binary data, but Drizzle ORM requires custom definitions to handle it properly.

JavaScript

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.

more#drizzle-orm

fromhackernoon.com

fromMarcin Wanago Blog - JavaScript, both frontend and backend

Deliverability

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.

fromSitePoint Forums | Web Development & Design Community

JavaScript

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

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

fromHackernoon

1 year ago

JavaScript

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.

JavaScript

Failing to connect Commento with PostgreSQL

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

fromZDNET

Business intelligence

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.

fromCodeProject

JavaScript

PostgreSQL: Write-Ahead Logging (WAL)

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

fromMarcin Wanago Blog - JavaScript, both frontend and backend

Business intelligence

Microsoft backs open source PostgreSQL analytics extension

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

JavaScript

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.

fromLogRocket Blog

JavaScript

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.

fromInfoQ

9 months ago

DevOps

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.

fromTestdriven

Python

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.

fromAlvinalexander

fromApp Developer Magazine

JavaScript

Java JDBC connection string examples

Example JDBC connection strings for popular databases.

fromMarcin Wanago Blog - JavaScript, both frontend and backend

Business intelligence

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.