Tutorials Index Page 17
How to write IF...THEN in an SQL query? (sql server)
In this tutorial we are going to explain how to wirte an IF...THEN statement with SQL Server. We use the sql standard CASE and also explain the IIF statement.
Analysis of travel salesman problem
Travel salesman problem (TSP) is a very well know computer science problem which is really easy to understand but it's a NP-hard problem. The problem is about finding te shortest possible route that visits each city and returns to the origin. Here we analyze the problem and variants of it.
JavaScript Tips for Better Development
How to improve as a javascript developer. If you are an intermediate programmer and stuck at your level try to read this article and study the ideas here with more details.
Clone All Repos from Git Server
Check this tutorial to learn how to clone all git repos for gitolite, bitbucket or gitlab. We are going to show you bash code to clone all repositories of your username.
Reliable reverse ssh tunnel that avoids connection lost
Have you ever use SSH tunnel from work to avoid firewalls? If yes, you probably lost ssh connection which casues to lose the connection to your server or machine. To solve this issue we use autossh with will reconnect on conneciton lost, check this tutorial to use it as a reverse ssh tunnel
How to Use Golang with PostgreSQL - Complete Guide
Learn how to connect Golang to PostgreSQL, perform CRUD operations, use prepared statements, and handle transactions with the pq driver.
How to check if a string contains a specific word in PHP?
We explain different ways to search for a string inside a variable with php. Many approaches are used.
Linux: Search Text in Files with grep/ack/ag
Have you ever struggle to use the command *find* in linux and it doesn't work as expected? Here we explain the proper way of finding text in multiple files. We also show you the fastest tool to search in git repositories.
How to check out a remote Git branch?
To checkout a remote branch you need first to do git fetch. Check this tutorial to learn with more details how to checkout remote branch with git.