Sign in

I work as a Senior Backend Developer in ad software aka (adTech). Naturally I deal with an immense amount of data. I will share how I increased performance of ClickHouse using Material Views and datatypes.

The Problem: I had a large query that would take up to 1 minute to complete. If a user had to wait one minute for data to load they’re not ever coming back.

The Solution: Created Material Views for each table and only inserted columns that were needed for the query. With Material Views I decreased that time down to under 3 seconds.

What it…


How to build a web server in Go. We’re going to build a very simple api to demonstrate how easy it is to implement it in Golang. I would say most NodeJS developers are familiar with ExpressJS so we will use that framework style that we all know and love.

If you want to setup live-reload similar to nodemon part 1

Here is all the code we need to setup the Api to have the ExpressJS type router functionality and a Post Method.

First create your directory and enter into it. go mod init is similar to npm init -(…


Here's what I'm trying to get set up in this quick tutorial.

Sharing my experience switching from NodeJS to Golang. I spent a bit of time trying to get my workflow setup the way I had it with NodeJS. Here are the steps I went through getting a proper workflow set up for Golang development.

Installing

I use HomeBrew for MacOS. HomeBrew is a package manager like npm for NodeJS. I highly recommend it and will be using it for this example.

brew install go

Start a new project

We are going to create a hello world example to show how to get projects started.

mkdir hello
cd hello
go mod init example.com/hello

Here we create new…


As of today flutters homepage says that you need a developer account in order to deploy to an iOS device. Today I'm going show you how to deploy to an iOS device without paying for developer account.

First create a basic flutter app. Open up the terminal. I personally use iTerm2 (Its Awesome & Open Source) copy and paste the command into the terminal.

flutter create ios_deploy

cd into the the project directory.

cd ios_deploy/

In the Terminal: Run this Xcode command inside the flutter project. This is going to open up Xcode. …


So it took way too long to set up a working system using Docker and TeamCity. TeamCity is basically the same thing as Jenkins. Although Jenkins has been having a lot of issues with their update center lately so I decided to try something new.

So if you go to the official website you'll see TeamCity and multiple ways to install it. I highly recommend you install it with Docker. We will be installing TeamCity on Ubuntu using Docker.

Official Teamcity site.
https://www.jetbrains.com/teamcity/

You will need Docker installed on your Ubuntu system.

The next up we need to create a…


How to insert batch contacts into Postman for ELFO A2P

Make sure your URL is: http://localhost:1337/api/lead-list/import

In post man I uploaded my 100 number .txt file


Recently my team and I were discussing ways to speed up code reviews. Thats when Postman pop into my mind. With expected return values agreed upon, it’s much easier to test if api’s are working as they should. So when the senior dev needs to do code review he just needs to go through the checklist.

Lets get right into it. I need to test my backend api without using the ui.


I was working on a project that used nodeJS, ReactJS, MySQL and MongoDB. This project wasn’t using docker. So I decided to implement it and dockerize everything into separate containers. The reason to do this is to set up a standardize developer environment for the team. Clearly running the project on different OS’s you're going to have issues arise. Furthermore, theres a lot of wasted time in setting up the developer environment.

Docker compose to the rescue

With docker-compose.yml we can virtually have an entire dev environment setup with a single command: docker-compose up --build

Git clone the repo then git checkout

git clone https://github.com/ottokafka/docker_nodejs_mongodb.git
git…


So I was working on a project that required me to automatically import data into my MongoDB Docker container. A lot of the tutorials online didn’t work for me or were overly complicated. So I decided to make a very simplistic solution that works.

So my project consists of a NodeJS server and MongoDB to hold the data. I want my MongoDB to auto initialize data on container startup.

Make sure you have docker installed.

SOURCE CODE: git clone && git checkout

git clone https://github.com/ottokafka/docker_nodejs_mongodb.git && git checkout mongodb_auto_import

docker-compose.yml

NodeJS Server

const express = require('express');
const app = express();
const mongoose = require('mongoose');
const PORT = 4000;//…

I had a project recently were they were using NodeJS, MongoDB and MySQL as their tech stack. The problem was that the developers were using different OS’s for development which brought a non standard developer environment. So the solution was everyone use Docker.

SOURCE CODE:

git clone https://github.com/ottokafka/docker_nodejs_mongodb.git
git checkout mySQL_Mongodb_NodeJS

We need to create a docker-compose.yml

docker-compose.yml

NodeJS Server

Below we dont use localhost to connect to our databases we use the names we gave in the docker-compose file

const express = require('express');
const app = express();
const mongoose = require('mongoose');
const mysql = require('mysql');
const PORT = 4000;// USE…

Kafka

“Genius” is 1% inspiration and 99% perspiration. Accordingly, a ‘genius’ is often merely a talented person who has done all of his homework — T.E.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store