Fabian fdnklg

How to setup a serverless rest api and connect it it with a mongodb on ec2 instance.

1. Setup an EC2 instance with terraform

Clone the Terraform example repo and follow the explained steps to get it running.

Be sure to open all necessary ports in your security groups used by the instance to make it available to the public.

1. Setup serverless on an aws with node.js

Follow the Tutorial to config serverless on your machine.

How to setup a geocoder api on your local computer

Setup docker on your local machine and install Docker desktop
Clone the nominitim-docker v3.0.0 repo:

git clone https://github.com/mediagis/nominatim-docker/tree/master/3.0

Modify the Dockerfile and set your url to PBF

How to setup a docker container on an aws elastic beanstalk environment as a single node container

prepare a docker image which runs locally. (You can find a docker image of the routing service here)
setup aws account and create organization with required roles
- elasticloadbalancing
- aws-elasticbeanstalk-service-role
Install EB-CLI (Command line interface) and AWS CLI

brew install awscli

If you’re interested to execute a script more often at a specific time you might be interested to setup a cron job. Now I want to briefly summarise the most basic how to about setting up a cronjob for a node script on a linux web server.

What is cron?

Cron is a service that executes scripts at a given time. Each cron job is following this syntax:

* * * * * auszuführender Befehl
┬ ┬ ┬ ┬ ┬
│ │ │ │ │
│ │ │ │ └──── weekday (0-7, Sonntag ist 0 oder 7)

How to request your rest API in a paginated way with parallel promises

In your API backend count all documents included in your mongodb and create a handler function for it. A detailed view about the API code can be found here.

db.collection.find({ you db query here }).count()

In the frontend split your requests in smaller bits of requests and while following this design pattern:

How to handle a sqlite database

A list a basic tutorials which helped to accomplish basic transformations of a sqlite db

Basic commands and more of them
Export as a csv

	<!DOCTYPE html>
	<html>
	<head>
	<style>

	svg {
	display: block;
	margin: 0 auto;
	}