

- Welcome to Geeksww.com
categories
Database Management Systems
- MS SQL Server
- MySQL
- Oracle Berkeley DB
Libraries
- Apache Portable Runtime
- Apache Portable Runtime Utility
- Flex
- Freetds
- Libiconv
- Libmcrypt
- Libmhash
- Libpng
- Libxml
- Libxslt
- m4
- Neon (webdav)
- OpenSSL
- zLib
Miscellaneous
- Bison
- Byacc
- UML
- Varnish Cache
Operating Systems
- Linux
- MacOS X
- MS Windows
Servers
- Apache Web Server
- Internet Information Services
- Node.js
- vsftpd FTP Server
Tools
- Development
- Security
Web Development
- AJAX
- Javascript
- PHP
- Python
tags cloud
How to set default values for MySQL JSON columns
Submitted by Shahryar on Monday May 11, 2020
MySQL has been making huge progress on the JSON/NoSQL front as well ie. supporting many of the JSON access and manipulation features and operations. In this how-to tutorial, I am going to show you how to add a new JSON column with default value in an existing MySQL table using the ALTER TABLE statement. And, how to create a new table using CREATE TABLE with JSON column along with its default value...(Read more)
Category:
Database Management Systems > MySQL > Administration
Tags:
How to delete rows in table when PK is referenced in another table
Submitted by Webmaster on Monday May 09, 2016
Before data insertion, updates, deletes etc, database management systems that support foreign keys (like MySQL) make sure you do not introduce any inconsistencies. So, you need to make sure you're not leaving orphan records behind in child tables...(Read more)
Category:
Database Management Systems > MySQL > Tips and Tricks
Tags:
Unique primary keys(PKs) for MySQL using Redis
Submitted by Webmaster on Thursday April 21, 2016
MySQL provides an auto increment feature (AUTO_INCREMENT attribute) that can be used to generate unique identities for new rows/records. However, this may become a problem when you are writing to more than one MySQL databases and merging them, since all of them will be generating their own unique keys...(Read more)
Category:
Database Management Systems > MySQL > Tips and Tricks
Tags:
How to rename MySQL DB by moving tables
Submitted by Webmaster on Thursday April 21, 2016
RENAME DATABASE statement was removed from MySQL because it was found to be dangerous. However, MySQL still supports the RENAME TABLE command...(Read more)
Category:
Database Management Systems > MySQL > Administration
Tags:
How to compile and install Varnish-cache on Linux
Submitted by Webmaster on Wednesday July 01, 2015
I used Ubuntu 12.04 LTS on Amazon EC2 to download, compile, and install Varnish cache. As of this writing, you can find the latest stable release at https://www.varnish-cache.org/releases..(Read more)
Category:
Miscellaneous > Varnish Cache > Installation
Tags:
How to setup node.js/express.js, compass, bootstrap project
Submitted by Webmaster on Monday June 22, 2015
In this tutorial, I will explain how to initialize and configure a Node.js+Express.js, Compass (CSS framework), and Bootstrap (front end UI framework) project. Please note that the tutorial expects all programs already installed and installation instructions will not be provided in this tutorial. However, it should be easy to find out how to install each program...(Read more)
Category:
Servers > Node.js > Configuration
Tags:
Bundle, validate, compress javascript files
Submitted by Webmaster on Saturday June 20, 2015
Due to a number of javascript files and libraries I had included in my project (and custom code written myself), I realized that I should do something to minimize the number of HTTP requests to server by bundling up source files somehow. I used simple OS shell commands to do so on a Mac OSX but instructions should work fine on Linux (with or without some adjustments)...(Read more)
Category:
Web Development > Javascript > Tips and Tricks
Tags:
Removing lines with strings from text files on Linux/Mac OS X
Submitted by Webmaster on Friday May 01, 2015
I used this technique to remove strings from bash history file containing passwords and other sensitive data on a Mac OS X shell...(Read more)
Category:
Operating Systems > MacOS X > Tips and Tricks
Tags:
How to set innodb_flush_log_at_timeout in MySQL 5.6?
Submitted by Webmaster on Monday September 15, 2014
A setting that isn't used much but could be used more is innodb_flush_log_at_timeout, which controls how often InnoDB does an fsync from the OS buffer to disk. Here's how it interacts with innodb_flush_log_at_trx_commit...(Read more)
Category:
Database Management Systems > MySQL > Administration
Tags:
How to setup quick, passwordless login using SSH?
Submitted by Webmaster on Thursday May 01, 2014
There are two parts to this tutorial. In the first one, I am going to show how to login to a remote server without using a password (when you normally do need a password to login). Secondly, I am also going to show you how to setup SSH on your local machine so that you can use short aliases to connect to remote machines. I have successfully used these techniques on Linux and Mac OS X for the past year or so...(Read more)
Category:
Tools > Security > Tips and Tricks