#PostgreSQL

[ follow ]
#postgresql
Medium
1 month ago
JavaScript

Enabling Full-Text Search with Slick-pg

Developers can utilize tminglei's Slick PostgreSQL Extensions for PostgreSQL full-text search in Scala Slick projects. [ more ]
CodeProject
2 months ago
DevOps

C# .NET Core Event Source with Martendb

MartenDB enables CRUD operations effortlessly
MartenDB showcases powerful Event Sourcing capabilities [ more ]
GitHub
2 months ago
JavaScript

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. [ more ]
Marcin Wanago Blog - JavaScript, both frontend and backend
2 months ago
JavaScript

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. [ more ]
Medium
3 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. [ more ]
Marcin Wanago Blog - JavaScript, both frontend and backend
4 months ago
JavaScript

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. [ more ]
morepostgresql
InfoQ
5 months ago
DevOps

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. [ more ]
Marcin Wanago Blog - JavaScript, both frontend and backend
5 months ago
JavaScript

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. [ more ]
LogRocket Blog
6 months ago
React

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. [ more ]
InfoQ
6 months ago
Artificial intelligence

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