Tech-Today
Recently, we've use hstore data type in our database because of its key, value pair functionality and here's how I install hstore in my ubuntu 12.04:
1.) execute in terminal
2.) execute in the database/schema where you wanted to use hstore datatype:
- How To Install Mysql In Ubuntu 16.04
The following commands allow us to install a MySQL server on Ubuntu 16.04, create a database, user and table. And finally, tune the server. # install mysql sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server sudo mysql_secure_installation...
- Install And Configure Mariadb On Ubuntu
I. Installation In your terminal execute the following commands: sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 sudo add-apt-repository 'deb [arch=amd64] http://mirror.zol.co.zw/mariadb/repo/10.3/ubuntu...
- Database
MSSQLMSSQL equivalent of DESC in MYSQLPostgresqlChange postgresql's postgres passwordHow to install hstore in postgresql 9.1JDBC provider setting in java for postgresql, mysql and oracleHow to alter the sequence value in postgresqlOracleHow to change...
- How To Install Apache2 Php5 And Mysql5 In Ubuntu 12.04
These are the set of scripts I executed in ubuntu to install the ff: 1.) apache2 2.) php5 3.) mysql5 >sudo apt-get install apache2 //installs in /etc/apache2 >sudo apt-get install php5 //installs in /etc/php5 >sudo apt-get install libapache2-mod-php5...
- How To Dual Boot Windows 7 And Ubuntu 12.04 On Lenovo G480
Finally after trying out several configurations that didn't work I am now able to successfully boot a Windows 7 and Ubuntu 12.04 OS on a Lenove G480 laptop. First here's what didn't work: 1.) easyBCD doesn't work, Windows 7 will just...
Tech-Today
How to install hstore in postgresql 9.1
Recently, we've use hstore data type in our database because of its key, value pair functionality and here's how I install hstore in my ubuntu 12.04:
1.) execute in terminal
>sudo apt-get update
>sudo apt-get install postgresql-contrib-9.1
2.) execute in the database/schema where you wanted to use hstore datatype:
>create extension hstore;
- How To Install Mysql In Ubuntu 16.04
The following commands allow us to install a MySQL server on Ubuntu 16.04, create a database, user and table. And finally, tune the server. # install mysql sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server sudo mysql_secure_installation...
- Install And Configure Mariadb On Ubuntu
I. Installation In your terminal execute the following commands: sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 sudo add-apt-repository 'deb [arch=amd64] http://mirror.zol.co.zw/mariadb/repo/10.3/ubuntu...
- Database
MSSQLMSSQL equivalent of DESC in MYSQLPostgresqlChange postgresql's postgres passwordHow to install hstore in postgresql 9.1JDBC provider setting in java for postgresql, mysql and oracleHow to alter the sequence value in postgresqlOracleHow to change...
- How To Install Apache2 Php5 And Mysql5 In Ubuntu 12.04
These are the set of scripts I executed in ubuntu to install the ff: 1.) apache2 2.) php5 3.) mysql5 >sudo apt-get install apache2 //installs in /etc/apache2 >sudo apt-get install php5 //installs in /etc/php5 >sudo apt-get install libapache2-mod-php5...
- How To Dual Boot Windows 7 And Ubuntu 12.04 On Lenovo G480
Finally after trying out several configurations that didn't work I am now able to successfully boot a Windows 7 and Ubuntu 12.04 OS on a Lenove G480 laptop. First here's what didn't work: 1.) easyBCD doesn't work, Windows 7 will just...