Nico Audy nicoaudy

How to setup a Postgres replication with docker and docker-compose

How to use

To run you will need docker and docker-compose installed, and run the command docker-compose up on a folder within this file named docker-compose.yml(attached in this Gist)

How the PGAudit is enable, you will see the queries log and in which database is running which query, this is the main purpose of this Gist, along with have a database with replication working out of the box

To add user with just reading rights to access the database on slave replica

Laravel Horizon, redis-server, supervisord on Ubuntu server

Laravel 8.x, Horizon 5.x, Redis 6.x

Parepare application

Install and configure Laravel Horizon as instructed in docs
Make sure you can access the Horizon dashboard like - http://yourapp.com/horizon
For now it should show status as inactive on dashbaord

Install redis-server

Usage

Put SearchTrait.php in app directory. Then use SearchTrait in your model, like so

use App\SearchTrait;
use Illuminate\Database\Eloquent\Model;

class Article extends Model 
{

Node.js Deployment

Steps to deploy a Node.js app to DigitalOcean using PM2, NGINX as a reverse proxy and an SSL from LetsEncrypt

1. Sign up for Digital Ocean

If you use the referal link below, you get $10 free (1 or 2 months) https://m.do.co/c/5424d440c63a

2. Create a droplet and log in via ssh

I will be using the root user, but would suggest creating a new user

	let
	nixpkgs = fetchTarball "https://github.com/NixOS/nixpkgs/tarball/nixos-23.11";
	pkgs = import nixpkgs { config = { allowUnfree = true; }; overlays = []; };

	git = pkgs.git.overrideAttrs (oldAttrs: rec {
	version = "2.42.0";
	});

	podman = pkgs.podman.overrideAttrs (oldAttrs: rec {
	version = "4.7.2";

	// ignore_for_file: unnecessary_null_comparison

	import 'package:flutter/material.dart';
	import 'package:flutter/gestures.dart';

	class TouchableOpacity extends StatefulWidget {
	/// Creates a widget that uses Gesture Detector internally and works in the same way
	/// but fades the child when the user touches it.
	///
	/// By default the opacity of the child is animated to 0.2 when the user touches it,

	import 'package:flutter/material.dart';
	import 'theme.dart' as Theme;

	void main() {
	runApp(
	new MaterialApp(
	title: 'CompanyApp',
	color: Theme.CompanyColors.blue[500],
	theme: Theme.CompanyThemeData,
	home: new Scaffold(

	<?php

	namespace App\Console\Commands;

	use Illuminate\Console\Command;
	use Symfony\Component\Process\Process;
	use Symfony\Component\Process\Exception\ProcessFailedException;

	class BackUpDatabase extends Command
	{

	" hide hidden chars
	:set nolist

	" show hidden characters in Vim
	:set list

	" settings for hidden chars
	" what particular chars they are displayed with
	:set lcs=tab:▒░,trail:▓,nbsp:░
	" or