#PostgreSQL

[ follow ]
#postgresql

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.

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

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.

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.

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.

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.

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

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.

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.

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

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.

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.

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