Fully featured Repository Pattern with Typescript and native PostgreSQL driver

1. repository-pattern-example

   1 1 5 0.0 TypeScript

   

   All source code can be found here. Also for fans of functional programming, which I am, I prepared my own version in folders/files with the prefix fp.

2. Sevalla

   sevalla.com featured

   Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!

   

3. node-pg-migrate

   2 4 1,394 9.4 TypeScript

   Node.js database migration management for PostgreSQL

   

   Why PG? For the clarity of the article to a large circle of developers, the entire explanation will be built by PostgreSQL and PG package. And in a real project, the database schema will change over time, and in order to be able to perform migrations, we will use Node PG migrate.

4. fastify

   3 127 34,457 9.6 JavaScript

   Fast and low overhead web framework, for Node.js

   

   I suggest to start explain how it is work in real project from main.ts file. For routing I like to use fastify. But for example we will use architecture with repositories > handlers layers. For real project you need to use repositories > services > handlers layers for easier code maintainability in future. All repository calls need to be proxied by services, no direct calls repositories in handlers must not be.

5. PostgreSQL

   4 59 12,849 9.0 JavaScript

   PostgreSQL client for node.js.

   

   Why PG? For the clarity of the article to a large circle of developers, the entire explanation will be built by PostgreSQL and PG package. And in a real project, the database schema will change over time, and in order to be able to perform migrations, we will use Node PG migrate.

6. Apache HBase

   5 12 5,376 9.6 Java

   Apache HBase

   

   For this type of systems PostgreSQL not best solution, and for a number of reasons like lack of replication out of the box. And we strictly must not have «Vendor lock», and therefore also did not take modern SQL databases like Amazon Aurora. And end of the ends the choice was made in favor Cassandra, for this article where we will talking about low-lever implementation of Repository Pattern it is not important, in your case it can be any unpopular database like HBase for example.

7. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

Suggest a related project