goldytech

Architecture Decision Record (ADR)

Title

Use PostgreSQL as the primary database

Status

Accepted

Context

We need a reliable and scalable database solution for our web application. Currently, we are using a lightweight SQLite database, which is not suitable for production due to its limitations in concurrency and scalability.

goldytech

var pool = ArrayPool<Employee>.Shared;
            var employeeRecords = pool.Rent(100000);
            var pipeLinesTest = new WithPipeLines();

            try
            {
                await pipeLinesTest.ProcessFileAsync(_filePath, employeeRecords);
            }
            finally
            {

goldytech

#nullable enable
using System;
using System.Buffers;
using System.IO;
using System.IO.Pipelines;
using System.Text;
using System.Threading.Tasks;

namespace FileIO
{

goldytech

using System;
using System.Linq;
using System.Threading.Tasks;
using Marvin.Cache.Headers;
using Marvin.Cache.Headers.Interfaces;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Options;

namespace Peddle.ApiGateway.MiddlewareComponents
{

goldytech

"use strict";

const { ServiceBroker } = require("moleculer");
const { ValidationError } = require("moleculer").Errors;
const TestService = require("../../../services/greeter.service");

describe("Test 'greeter' service", () => {
	let broker = new ServiceBroker({ logger: false });
	broker.createService(TestService);

goldytech

"use strict";


const db = require("../database");

/**
 * @typedef {import('moleculer').Context} Context Moleculer's Context
 */

module.exports = {

goldytech

"use strict";

const db = require("../database");
const jwt = require("jsonwebtoken");
const { MoleculerClientError } = require("moleculer").Errors;
const User = db.User;
const {isEmptyObject, compareHash,APP_EVENTS } = require("../util");
const { Op } = require("sequelize");

/**

goldytech

public enum StatusCategory
    {
        Request,
        InSignature,
        InAuthoring,
        InEffect,
        Terminated,
        Expired
    }

goldytech

 private static bool IsHrManagerByPropertyPattern(object employee)
  {
      return employee is Emp e && e is { IsManager: true, Department: {Name: "Human Resources" } };
  }

goldytech

 var employee = new Employee
                {
                    Id = 1,
                    Department = new Department {Id = 1, Name = "Human Resources"},
                    Name = "John Doe",
                    IsManager = true
                },