Eyakub Eyakub

PgBouncer on one VPS: single and multiple projects

A guide for apps on FastAPI + SQLAlchemy 2 (async) + asyncpg sharing one PostgreSQL server on Ubuntu. It was written after putting a production app behind PgBouncer, and it includes the problems hit along the way.

1. What PgBouncer is, and why to use it

PostgreSQL runs one OS process per connection (~5–10 MB each). max_connections defaults to 100 for the whole server, and every app's connection pool counts against it. Ten Celery workers, each holding a SQLAlchemy pool, add up quickly. On a shared box, one app spiking means another app gets too many connections.

Free Learning Resources For Software Testers

An ongoing project to create a set of links to free online learning resources for new and experienced Software Testers (Click Readme.md to view).

Since computer science and IT university departments don't invariably offer dedicated software testing modules and resources are spread among various different providers linked to different methodologies, I created this project to help guide new testers into some sort of useful curriculum and collate some existing web-based resources into lists of links.

The rules I wish to implement are -

Content must be relevant to testers
Content must be informative and not overly "salesy"
Content must be free of charge

Flutter

A quick cheatsheet of useful snippet for Flutter

Widget

A widget is the basic type of controller in Flutter Material. There are two type of basic Widget we can extend our classes: StatefulWidget or StatelessWidget.

Stateful

StatefulWidget are all the widget that interally have a dynamic value that can change during usage. It can receive an input value in the constructor or reference to functions. You need to create two classes like:

Install Python 3.7.3

Python 3.7.4

  $ sudo apt update
  $ sudo apt install software-properties-common
  $ sudo add-apt-repository ppa:deadsnakes/ppa
  $ sudo apt install python3.7
  $ sudo apt-get install python3.7-venv
  $ python3.7 -V

Docker Commands, Help & Tips

Show commands & management commands

$ docker

Docker version info

VSCode Shortcuts

List of helpful shortcuts for faster coding

For mac, replace "Ctrl" with "cmd" and "Alt" with "option"

Official List of all commands

Windows
Mac

	server
	{
	# Listen
	listen 80;
	listen [::]:80;
	listen 443 ssl http2;
	listen [::]:443 ssl http2;

	# Directory & Server Naming
	server_name exapmle.com www.exapmle.com;

	<script>
	if ( window.history.replaceState ) {
	window.history.replaceState( null, null, window.location.href );
	}
	</script>

	## Steps for React native
	`
	- react-native init projectName
	- react-native run-android
	`