geeksww tutorials tutorials

How to set default values for MySQL JSON columns

Submitted by Shahryar on 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.

Category:

Database Management Systems > MySQL > Administration

Tags:

mysql

How to delete rows in table when PK is referenced in another table

Submitted by Webmaster on 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.

Category:

Database Management Systems > MySQL > Tips and Tricks

Tags:

delete foreign insert integrity keys mysql referential

Unique primary keys(PKs) for MySQL using Redis

Submitted by Webmaster on 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.

Category:

Database Management Systems > MySQL > Tips and Tricks

Tags:

administration auto-increment incrby key mysql redis unique

How to rename MySQL DB by moving tables

Submitted by Webmaster on 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.

Category:

Database Management Systems > MySQL > Administration

Tags:

administration database mysql rename table

How to compile and install Varnish-cache on Linux

Submitted by Webmaster on 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

Category:

Miscellaneous > Varnish Cache > Installation

Tags:

cache http installation linux optimization performance proxy varnish web

How to setup node.js/express.js, compass, bootstrap project

Submitted by Webmaster on 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.

Category:

Servers > Node.js > Configuration

Tags:

bootstrap compass configuration css express.js installation javascript node.js project

Bundle, validate, compress javascript files

Submitted by Webmaster on 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).

Category:

Web Development > Javascript > Tips and Tricks

Tags:

bundle closure compress development google javascript merge minify web

Removing lines with strings from text files on Linux/Mac OS X

Submitted by Webmaster on 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.

Category:

Operating Systems > MacOS X > Tips and Tricks

Tags:

awk linux macosx sed string

How to set innodb_flush_log_at_timeout in MySQL 5.6?

Submitted by Webmaster on 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.

Category:

Database Management Systems > MySQL > Administration

Tags:

mysql performance tuning

How to setup quick, passwordless login using SSH?

Submitted by Webmaster on 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.

Category:

Tools > Security > Tips and Tricks

Tags:

config linux macosx passwordless security ssh

More Tutorials >>

subscribe for tutorials subscribe

Geeksww.com RSS Follow geeksww on Twitter

tags cloud tags cloud

business twitter development database microsoft windows php security software apple google fedora linux mobile new-release iphone facebook mysql opensource ubuntu