PreProgrammer > Articles by: Preprogrammer
Author Archive: Preprogrammer
Preprogrammer
December 26, 2018
Data visualization is simply the understanding of data or its presentation in a visual context. It helps the relevant parties understand what has been presented visually so that they have the right information to make informed decisions. Data visualization helps one to understand concepts that could be very difficult in…
Read more
Preprogrammer
April 27, 2017
SQL Datatypes Data types specify the type of data for a particular column.If a column called “LastName” is going to hold names, then that particular column should have a “varchar” (variable-length character) data type.The most common data types: SQL Datatypes – Numeric INT -A normal-sized integer that can be signed…
Read more
Preprogrammer
April 18, 2017
SQL Reference JOIN, UNION, SET Operations. This article is all about those. Custom Names SELECT ct.ID, ct.Name, ord.Name, ord.Amount FROM customers AS ct, orders AS ord WHERE ct.ID=ord.Customer_ID ORDER BY ct.ID; Types of Join The following are the types of JOIN that can be used in MySQL: – INNER JOIN…
Read more
C Programming, Java, Java Programing, PHP, Programming, SQL
Inner, left join, right join, SET Operations, SQL Reference JOIN, UNION
Preprogrammer
April 18, 2017
WordPress website transferring from remote to local machine, it is a necessary when it comes to backups or testing. This tutorial is all about WordPress website transferring from remote to local machine. Before we starting, we need the backups of Database, Website folder ((Normally, everything inside public-html folder of the…
Read more
Preprogrammer
April 17, 2017
Installing Composer on Debian. Composer is a dependency management tool used in PHP, to easily manage resources. Composer can install or update libraries, that you are using in your projects. Minimum Requirements : Debian 6, 7 or 8 PHP (including php-cli) Curl (use command sudo apt-get install curl, to install…
Read more
Preprogrammer
April 13, 2017
VestaCP Creating Packages, adding Users. In VestaCP you can as many as packages you want.Users too. So, For creating one package there are some minimum requirements. The following package is with minimum requirements. You can expand or shrink these with as per your requirements. Step 1 : Adding a new…
Read more
Preprogrammer
April 13, 2017
Vestacp Hosting Control Panel Setup. Many of you don’t know how to do Vestacp Hosting Control Panel Setup. So, here it is for those, who have a system with a terminal and ssh access only. # ——————————————– # Vestcp Setup – Debian 8 # ——————————————– > sudo apt-get update >…
Read more
Preprogrammer
April 13, 2017
Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’ on Intellij is an error shows due to driver files missing. To resolve an issue like this follow the following procedure. How to add the JDBC library using Intellij: Steps 1.) Goto View -> Tool Windows -> Database. 2.) Now, Select a database and…
Read more
Preprogrammer
March 22, 2017
IntelliJ vs Eclipse Keymap Action IntelliJ IDEA Eclipse Open any file quickly Ctrl + Shift + N Ctrl + Shift + R Find a type or class Ctrl + N Ctrl + Shift + T Show all the members of current type Ctrl + F12 Ctrl + O Jump to…
Read more
Preprogrammer
March 17, 2017
Debian Linux Mint F.lux error quick fix. Sometimes, F.lux will not automatically start in your Debian systems. It also, happened to me. So, what i did was manually setting the f.lux configuration and adding it to the startup program. xflux must be installed on your system. To test this, open…
Read more
Preprogrammer
March 17, 2017
How to solve, Classic error: Unable to update index for central|http://repo1.maven.org/maven2. Sometimes Eclipse failed to index the repository due to errors/configurations. In such scenarios, even if you try to search in the repositories, it will fail due to the non indexed repo.To fix these kind of problems, try the following….
Read more
Preprogrammer
December 9, 2016
Laravel Admin Dashboard Released on ExtensionsValley.com. This latest Laravel Admin Dashboard is built on Genetelella based free bootstrap admin template.This Laravel Admin Dashboard is extremely furnished and unlike other bulky loaded templates, it’s fast, clean and comfortable. In fact, they are not just providing this as a Laravel Admin Dashboard…
Read more
Preprogrammer
December 9, 2016
LaFlux – Extremely Customizable Laravel Admin Dashboard. It has been a very long time, we have been using Laravel. All these time Laravel has been proved that, it is the best framework for Web Applications and having tons and tons of features.The re is no competition for Larvel now, It’s…
Read more
Preprogrammer
December 3, 2016
Xiaomi MI3 Manual flashing of partitions one by one. It can happen sometime, you lost your phone in the middle of nowhere and the flashing softwares, CWM recovery or Twrp recovery, what ever you are sing not working.May be some thing you are doing wrong or it’s just not working….
Read more
Preprogrammer
September 17, 2016
Linux – Important Facts About Filenames. These article is about Important Facts About Filenames, while you are in a Linux system. Linux – Important Facts About Filenames 1. Filenames that begin with a period character are hidden. This only means that ls will not list them unless you say ls…
Read more