Databases | Chris' Laboratory

MongoDB Node.js

13/03/202029/08/2020

Node.js + MongoDB RESTful API Boilerplate

Github: https://github.com/chrisleekr/nodejs-mongodb-api-boilerplate This is a sample project that I followed the tutorial Build Node.js RESTful APIs in 10 Minutes written by Olatunde Garuba. How to start $...

Frameworks MySQL PHP

29/03/201929/08/2020

[PHP+MySQL] 간단한 카카오 i 오픈빌더 챗봇 만들기 (Kakao i Open Builder)

카카오 i 오픈빌더 (Kakao i Open Builder)를 이용한 플러스 친구 챗봇 (PHP + MySQL) 백엔드 프로젝트 이 프로젝트는 샘플 테스트용으로 카카오톡 플러스 친구 챗봇을 구현하기...

Frameworks MySQL Server

22/08/201629/08/2020

Vagrant MySQL Master-Slave Replication

Vagrant MySQL Master-Slave Replication Source Repo: https://github.com/chrisleekr/vagrant-mysql-master-slave-replication Vagrantfile to spin up MySQL Master-Slave replication with persistent data storage Note: This project is created for just practice....

MS-SQL

29/12/2014

MS SQL Express 2012 Installation Error – No room is available to display rows

Environments Mac 10.10 Parallels Desktop 9 Windows 7 Issue & Solutions When I try to install MS SQL Express 2012, the installer shows an error...

Frameworks MySQL PHP

23/09/201429/08/2020

Sample XAMPP MySql my.ini Fast Performance

Only use in local test MySQL. # Example MySQL config file for large systems. # # This is for a large system with memory =...

Django MySQL

09/05/201429/08/2020

EnvironmentError: mysql_config not found

I am using Mac OS X 10.9, MAMP 1.9 (MySQL 5.1.44), Python 2.7.5. Got this error when I change database configuration in settings.py. I felt...

Frameworks MySQL Server

13/03/201429/08/2020

VPS – Apache & MySQL Performance Tuning

Apache 1. Open/Create /var/www/vhosts/{hostname}/conf/vhosts.conf 2. Add oradjust below code KeepAlive On MaxKeepAliveRequests 29 KeepAliveTimeout 15 3. Copy to make backup of apache configuration # cp...

Codeigniter MongoDB

15/08/201215/08/2012

MongoDB Library for Codeigniter

Codeigniter MongoDB Library Reference & Download: https://github.com/alexbilbie/codeigniter-mongodb-library/tree/v2 Using with CodeIgniter: Add the file Mongo_db.php to your /application/libraries folder. Add the file mongodb.php to your /application/config...

MongoDB

15/08/201215/08/2012

MongoDB PHP extension for MAMP in Mac OS X

The command 'pecl' in MAMP dos not work; therefore, it requires to download pre-complied PHP extensions from https://github.com/mongodb/mongo-php-driver/downloads Open php.ini and add below code [code]extension=mongo.so[/code]...

MySQL

13/12/201029/08/2020

A script to change all tables and fields to the utf-8-bin collation in MYSQL

A script to change all tables and fields to the utf-8-bin collation in MYSQL (This article is from http://stackoverflow.com/questions/105572/a-script-to-change-all-tables-and-fields-to-the-utf-8-bin-collation-in-mysql) <?php set_time_limit(0); function MysqlError() {...