Amir Muhammad Hakim mramirid

Running Kafka Brokers on Docker Containers

How to Run

Docker Compose A

This config uses Docker images created by wurstmeister.

Retrieve the IPv4 address of the host machine and assign it to the environment variable HOST_IP.

Creating Indexes During Table Creation

We can add an index to a table right when creating that table - like this:

CREATE TABLE <table_name> (
    ... column definitions,
    INDEX <index_name> (<column>)
);

Updating & Removing SQL Foreign Key Constraints

Besides adding foreign key constraints at creation time (i.e. when using CREATE TABLE), we can also add such constraints after a table has been created with help of ALTER TABLE. We can also remove foreign key constraints from an existing table.

Adding Foreign Key Constraints Via `ALTER TABLE`

MySQL & PostgreSQL

ALTER TABLE <table_name>

Enabling MongoDB Replication

Stop Mongod Service/Daemon/Process.
Find & open the mongod.conf.
- Windows: <MongoDB-Server-Bin-Path>/mongod.conf
- Linux: /etc/mongod.conf
Add the following to the File:

	import { PG_UNIQUE_VIOLATION } from '@drdgvhbh/postgres-error-codes';
	import {
	ArgumentsHost,
	Catch,
	ConflictException,
	HttpException,
	InternalServerErrorException,
	} from '@nestjs/common';
	import { BaseExceptionFilter } from '@nestjs/core';
	import { QueryFailedError } from 'typeorm';

	import { useId } from "react";
	import { formatIDR } from "utils/format";

	export default function TopUpCategories(props: { className: string }) {
	return (
	<section className={props.className}>
	<h2 className="text-lg fw-medium color-palette-1 mb-14">
	Top Up Categories
	</h2>

	import tweepy
	import csv

	# input your credentials here
	consumer_key = ''
	consumer_secret = ''
	access_token = ''
	access_token_secret = ''

	auth = tweepy.OAuthHandler(consumer_key, consumer_secret)

	import twitter, re, datetime, pandas as pd

	class Twitter_Miner():
	request_limit = 20
	api = False
	data = []

	twitter_keys = {
	'consumer_key': '',
	'consumer_secret': '',

	// JavaScript Code Snippet
	// Convert integer to Rupiah & vice versa
	// https://gist.github.com/845309
	//
	// Copyright 2011-2012, Faisalman
	// Licensed under The MIT License
	// http://www.opensource.org/licenses/mit-license

	/**
	* Convert a number to a string of its equivalent in rupiah

	/**
	* Calculate the height of an image based on its aspect ratio and width
	* @param {number} width
	* @param {number} ratioWidth
	* @param {number} ratioHeight
	* @returns the calculated height
	*/
	function getHeight(width, ratioWidth, ratioHeight) {
	const ratio = width / ratioWidth;
	const height = ratio * ratioHeight;