#postgresql

[ follow ]
Medium
2 months 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
3 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 ]
#prisma
Marcin Wanago Blog - JavaScript, both frontend and backend
3 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 ]
Marcin Wanago Blog - JavaScript, both frontend and backend
5 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 ]
Marcin Wanago Blog - JavaScript, both frontend and backend
3 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 ]
Marcin Wanago Blog - JavaScript, both frontend and backend
5 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 ]
moreprisma
#scala
Medium
4 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 ]
Medium
6 months ago
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. [ more ]
Medium
4 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 ]
Medium
6 months ago
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. [ more ]
morescala
Marcin Wanago Blog - JavaScript, both frontend and backend
5 months ago
JavaScript

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. [ more ]
#PostgreSQL
InfoQ
6 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
6 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 ]
InfoQ
6 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
6 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 ]
morePostgreSQL
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
7 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 ]
Lightbend
3 weeks ago
Scala

The database is the bottleneck! | @lightbend

Akka 24.05 achieves high throughput with PostgreSQL by sharding write requests [ more ]
Testdriven
3 weeks ago
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. [ more ]
#data-integrity
Marcin Wanago Blog - JavaScript, both frontend and backend
1 week ago
Data science

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). [ more ]
Marcin Wanago Blog - JavaScript, both frontend and backend
2 weeks ago
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 ]
Marcin Wanago Blog - JavaScript, both frontend and backend
1 week ago
Data science

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). [ more ]
Marcin Wanago Blog - JavaScript, both frontend and backend
2 weeks ago
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 ]
moredata-integrity
[ Load more ]