PostgreSQL Install PostgreSQL client 30 Mar 202230 Mar 2022 To install via apt: sudo apt-get install postgresql-client To connect to a server (azure example): psql -h myhost.postgres.database.azure.com -d postgres -U username
PostgreSQL Install pgAdmin (docker) 30 Mar 202230 Mar 2022 Install The easiest way to install and use pgAdmin for development is via docker. It is available to docker hub so installation is very fast and easy docker pull dpage/pgadmin4…
C/C++… Profiling C/C++ with gprof 13 Dec 202113 Dec 2021 We will use the following flags: -g for debugging information-pg for profiling information Add the -g -pg flags to the compiler (either gcc or g++): gcc -g -pg -o my_executable…
Administration… PHP toolcase 29 Nov 20218 Mar 2022 Getting information Display installed versions To list the installed versions and select the default version you can use the command: sudo update-alternatives --config php Display installed modules This will display…
PHP… Install PHP 8.0 for laravel 29 Nov 20211 Feb 2022 Basics In order to install recent versions of PHP you have to add a repository to your system. Ondrej Sury maintains that repository which is why in most tutorials you…
Administration… Apache Toolcase 28 Nov 202125 Jan 2022 Install Install apache2 via APT sudo apt install apache2 Manage Apache service You can view status, start, stop and restart the service: sudo service apache2 status sudo service apache2 start…
Administration… SSH Toolcase 28 Nov 202125 Jan 2022 Here is a small lists of frequent operations you may want to do regarding your SSH keys Create a SSH key pair On default directory The following command will create…
Administration… Apache virtual hosts example 28 Nov 202128 Nov 2021 Overview To setup virtual hosts on Apache the standard procedure is the following: First, create the directories of the document root for each siteIn the directory /etc/apache2/sites-available, create a configuration…
Docker… Run docker as nonroot 22 Nov 202129 Mar 2022 Prerequisites Before you proceed, make sure docker is installed and it is running properly. Steps to run docker as non-root In order to run docker as normal user you should…
install… Prepare your computer to write Spring boot code 1 Aug 20213 Aug 2021 Important note: The following instructions are for the Technologies of Internet applications course of DIT (ΤΕΔ) for Spring Boot. The instructions could be used by those who will follow either…
Libraries… Prepare your computer for OPENGL/GLAD programming (C++) 17 Feb 202120 Feb 2021 This is a tutorial based on the technologies required for the related courses of graphics.di.uoa.gr (x64, windows setup): CMAKE OPENGL 3.3GLFWGLADASSIMPSOILfreetypeirrKlangVS Studio community (latest version) Summary of what you are…
Books… OpenMP little book 5 Oct 20205 Oct 2020 OpenMP little book is a simple introductory e-book available only online. You can find it at the link below: https://nanxiao.gitbooks.io/openmp-little-book
Libraries… Install mpiP 4 Oct 20204 Oct 2020 First install MPI if it is not already installed. Then: Step 1 - Install GNU binutils sudo apt install binutils-dev Step 2 - Download and decompress the mpiP library Download…
How-To… How to count lines of source code 13 Jul 2020 Install cloc: sudo apt install cloc And then run the command: cloc .
Install… Prepare your computer for for machine learning (Python) 26 Dec 201918 Jan 2022 Summary of what you are going to install: pythonnumpypandasscipyscikit-learnkerastensorflowipythonmatplotlibseaborn Step 1 - Update apt if needed: sudo apt update Step 2 - Install prerequisites: sudo apt install build-essential sudo apt-get…
Troubleshoot… List all installed versions 25 Oct 201925 Oct 2019 You could use update-alternatives: sudo update-alternatives --config java
MySQL… Timezone error 5 Oct 20196 Jan 2021 In older drivers timezone has to be defined explicitly. Change the connection string as shown below: jdbc:mysql://localhost/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
MySQL… Root account cannot connect 5 Oct 20196 Jan 2021 This is actually a good restriction. As a general thumb of rule, you should not use the root account for the applications. Although not recommended, you can allow root user…
MySQL… Hash function conflict 5 Oct 20196 Jan 2021 Reset the password using the following commands: sudo mysql -u root -p ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
Core Install valgrind 26 Aug 20191 Aug 2020 Installation via apt: sudo apt install valgrind On how to use valgrind for debugging read this article.
Core… Install C/C++ core 26 Aug 20191 Aug 2020 Installation via apt: sudo apt update sudo apt install build-essential It is highly recommended that you install valgrind for debugging and memory leak detection and that you install an IDE.…
install… Prepare your computer to write Java EE 8 REST code (jersey) 21 Jul 20191 Aug 2020 Important note: The following instructions are for the Technologies of Internet applications course of DIT (ΤΕΔ) for Java EE 8. The instructions could be used by those who will follow…
Applications… Install Apache Tomcat 21 Jul 201917 Feb 2021 It can be quite complex to setup Apache Tomcat. Before doing so, you could consider other alternative options: If you are going to use Spring Boot you can just use…
IDE… Install Netbeans IDE 21 Jul 20191 Aug 2020 First, you should install Java. As a general thumb of rule, the JDK 1.8 version is the most used and the most stable JDK you could use. Read more at…
install… Install and manage JDK 2 Jul 20191 Aug 2021 List installed configurations update-java-alternatives -l Select default configurations update-alternatives --config java Install open-jdk 8 sudo apt install openjdk-8-jdk You may install any specific version with the following command (replace X…
MySQL… Install Mysql and mysql-workbench [apt] 2 Jul 20198 Mar 2022 To install latest MySQL to Ubuntu perform the following steps: 1) Download and add the repositories Download the repositories from the official download page manually. Install them. 2) Update the…
C/C++… Use valgrind to debug C/C++ applications 14 Mar 201913 Dec 2021 To compile the program use the following flags: -g3-O0 (optional) To execute the program once you have compiled it: ./valgrind program For extensive testing you could also use the following…
Install… Install ipython with autoload 1 Nov 20182 Oct 2019 1. Install ipython: pip install ipython 2. Create a default profile: ipython profile create 3. Edit profile at: ~/.ipython/profile_default/ipython_config.py and add (or uncomment) the following lines: c.InteractiveShellApp.exec_lines = [] c.InteractiveShellApp.exec_lines.append('%load_ext…
Libraries… Install MPI 19 Sep 20181 Aug 2020 Installation via apt: sudo apt update sudo apt install build-essential sudo apt install mpich sudo apt install libmpich-dev Here are the steps: Step 1 - Update the repository sudo apt…
Pascal… Install lazarus IDE 12 Aug 20181 Feb 2022 Summary of what you are going to install: Lazarus IDEanchordocking design package for a dockable GUI 1) Install Lazarus IDE At first try to download it from the standard APT…
install… Prepare your computer to write Java EE 8 code 9 Jul 20186 Oct 2019 Important note: The following instructions are for the Technologies of Internet applications course of DIT (ΤΕΔ) for Java EE 8. The instructions could be used by those who will follow…
install… Prepare your computer to write Sunspot code 7 Jul 20186 Oct 2019 Note: These instructions are mainly for students of DIT (UoA). Summary of what you are going to install to your computer: virtualbox virtualbox extensions You will install the following software inside…
Install… Install bottle 31 May 201816 May 2022 Summary of what you are going to install: pythonpipbottle Install python, pip and bottle via apt: sudo apt update sudo apt install python3.6 sudo apt -y install python3-pip sudo pip3…
How-To… Hints for debugging simple TCP applications 29 May 20182 Oct 2019 Summary of what you are going to install: ncatcurl Summary of the commands: sudo apt install ncat sudo apt install curl echo "hello world" > /dev/tcp/localhost/11111 echo "hello world" |…
Books… Murach’s Java Servlets and JSP 1 Apr 201822 Jul 2019 Murach's Java Servlets and JSP The best book for Servlets and JSP. Progressive difficulty and a lots of a examples.
Tools… Online Problem solver 6 Feb 20182 Oct 2019 The online solver is a mini application that comprises of a set of mini web services that solve well known problems in computer science (at bachelor level) that are frequently…
Exercises… Operation of a court with semaphores 3 Dec 20172 Oct 2019 Write a set of programs that simulate the operation of a court in a specific case scenario. Synchronization between the processes should be achieved with POSIX or System-V semaphores Resources:…
Exercises… Image Converter in NetPBM Format 3 Dec 20172 Oct 2019 Write a converter or a web application that can convert image files between any NetPBM format (support at least P1, P2, P3, P4, P5, P6 formats). Files to use as…
Administration… IPCS Toolcase 9 Nov 201728 Nov 2021 View all segments and semaphore arrays $ ipcs -s -m View details of a memory segment $ ipcs -m -i <id> View details of a semaphore array $ ipcs -s…
install… Prepare your computer to write MIPS code 7 Nov 20176 Oct 2019 Summary of what you are going to install: QtSpim Notepad++ Although you may use Linux or MAC OS as an operating system for your development computer, as a beginner it…
Install… Install XV6 Operating system 6 Nov 201727 Aug 2019 Summary of what you are going to install: qemuxv6 Summary of the commands: sudo apt update sudo apt install qemu git clone git://github.com/mit-pdos/xv6-public.git make make qemu-nox Here are the steps:…
install… Install ACM Java task force library in 64bit (Windows) 5 Nov 20172 Oct 2019 Prerequisites: Install java Summary of what you are going to install: acm library on 64 bit operating system At first you should download the acm.jar from this page. If you…
How-To… Upload files with SCP 5 Nov 201725 Mar 2020 Prerequisites: scp (pre-installed on most Linux distributions) Let's say your student ID is sdiABCDEFG and lets say you have to upload your assignment to the following address: /home/users/kXX/projectN/sdiABCDEFG/ Here are…
Libraries… Install LAPACKE 4 Nov 20171 Aug 2020 Prerequisites: C/C++ compiler (install link) Summary of what you are going to install: BLASLapackLapacke Summary of the commands: sudo apt update sudo apt install liblapack3 sudo apt install liblapack-dev sudo…
Books… Data Structures and Algorithm Analysis in C++ 4 Nov 20172 Oct 2019 Data Structures and Algorithm Analysis in C++, International Edition A little bit overpriced but an excellent read. Lots of examples using modern C++. The book covers almost any data structure…
Administration… MQTT Toolcase 4 Nov 201719 Dec 2021 Install Install Mosquitto sudo apt install mosquitto Install Mosquitto clients Useful for testing. sudo apt install mosquitto-clients Configuration file This file is usually placed at: /etc/mosquitto/mosquitto.conf Baseline configuration # Place…
Books… Design Patterns – Heads first 1 Nov 20172 Oct 2019 Head First Design Patterns - A brain friendly guide The best book for Design patterns. It is not difficult to read and It uses many illustrations which is very good…
Books… Design Patterns 1 Nov 20172 Oct 2019 Design patterns : elements of reusable object-oriented software A great book for design patterns, but it is advanced and hard to read. It is recommended as a follow up once…
Tools Linux installation script 18 Oct 20172 Oct 2019 If you use Linux, you may find useful the online Linux installation script builder. The script builder reads the data via REST and generates a table from which you can…
Tools Makefile generator 18 Oct 20172 Oct 2019 If you are writing code in C/C++ you may find useful the online makefile generator which is available as a part of the online problem solver. Please note the following:…
Books… Absolute C++ 1 Oct 20172 Oct 2019 Absolute C++, Global Edition Continue reading "Absolute C++"
Books… C++ Primer 1 Oct 20172 Oct 2019 C++ Primer C++ Primer is one of the best books to start with if you are interested in learning C++, and the first that I would recommend for a beginner.…
Books… Effective Java 1 Oct 20172 Oct 2019 Effective Java This is not a beginner's book. But it is one of the most important intermediate level books you are ever going to read. Seriously. It contains many tips…
Books… C Programming: A Modern Approach 1 Oct 20172 Oct 2019 C Programming: A Modern Approach C Programming: A Modern approach is one of the best books to start with, and the first one I recommend for C. It goes back…
How-To Computer maintenance and stability 4 Sep 20171 Aug 2021 Do not install software that advertises that it will speed up your computer or that it will magically repair and clean up your hard drive. Most of those programs do…
Install… Prepare your computer to write Python code 20 Aug 20171 Aug 2021 Summary of what you are going to install: pythonpycharm Here are the steps: 1) Update the repository (?) sudo apt update 2) Install python (?) In many linux distributions you…
install… Prepare your computer to write Java code 20 Aug 20176 Mar 2020 Summary of what you are going to install: Java JDKJava IDE Although you may use Windows or MAC OS as an operating system for your development computer, as a beginner…
Install… Prepare your computer to write C/C++ code 19 Aug 20171 Aug 2021 Summary of what you are going to install via apt: build-essential (including gcc/g++ etc)Open JDKC/C++ IDE (netbeans)valgrind Here are the steps: 1) Update the repository (?) sudo apt update 2)…