Emre Sebat emresebat

Update: 2023/11/30 Bruce Momjian's take on things: https://momjian.us/main/blogs/pgblog/2023.html#November_22_2023

Given a table...

CREATE TABLE foo (
  id SERIAL PRIMARY KEY,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  ...
);

nginx 403 Forbidden Error hosting in User Home Directory

resources

runtime environment

Better local require() paths for Node.js

Problem

When the directory structure of your Node.js application (not library!) has some depth, you end up with a lot of annoying relative paths in your require calls like:

const Article = require('../../../../app/models/article');

Those suck for maintenance and they're ugly.

Possible solutions

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.

$/
  artifacts/
  build/
  docs/
  lib/
  packages/
  samples/
  src/
 tests/

	#!/bin/bash
	#
	# The reason of creating this script is that Endpoint Security VPN installs it's own application firewall kext cpfw.kext
	# which prevents for example PPTP connections from this computer, which is not appropriate if you need subj connection just
	# from time to time
	#
	# Usage: ./checkpoint.sh
	#
	# The script checks if Enpoint Security VPN is running. If it is, then it shuts it down, if it is not, it fires it up.
	# Or, make an Automator action and paste the script.

	git rebase --interactive HEAD~2

	# we are going to squash c into b
	pick b76d157 b
	pick a931ac7 c

	# squash c into b
	pick b76d157 b
	s a931ac7 c

	CREATE EXTENSION tablefunc;

	CREATE TABLE sales(year int, month int, qty int);
	INSERT INTO sales VALUES(2007, 1, 1000);
	INSERT INTO sales VALUES(2007, 2, 1500);
	INSERT INTO sales VALUES(2007, 7, 500);
	INSERT INTO sales VALUES(2007, 11, 1500);
	INSERT INTO sales VALUES(2007, 12, 2000);
	INSERT INTO sales VALUES(2008, 1, 1000);
	INSERT INTO sales VALUES(2009, 5, 2500);

	var app = angular.module('admin', ['ng-admin']),
	hook = new Hook.Client({...});

	var headerNav, pageWrapper, restangular;

	if (hook.auth.currentUser && hook.auth.currentUser.role != 'admin') {
	hook.auth.logout();
	}

	function hideMenu() {

	/*

	Small ng-admin config showing how to inject a Login controller when
	a 401 error is returned by the server.

	*/
	(function () {
	"use strict";

	var app = angular.module('myApp', [