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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
videos
Advanced Python
January 03, 2011
Understanding Python (easy)
December 29, 2010
MariaDB, the Backward Compatible Br
December 26, 2010
most popular
- How to check MySQL version number?
- How to make use case diagram using Generalization in UML
- How to download, compile, and install CMake on Linux
- Installing OpenSSL on Ubuntu Linux
- Starting Apache Web Server at every Reboot
most discussed
- How to download, compile, and install CMake on Linux
- How to download and install Bison (GNU Parser Generator) on Ubuntu Linux
- Download, configure, compile, and install MySQL 5.5 from source code on Linux
- Installing OpenSSL on Ubuntu Linux
- Installing m4 Macro Processor on Ubuntu Linux
popular searches
- free download for mysql database server 5.1.5
- bison
- gearman
- install cairo
- php
- install mysql
- java
- laptop
- linux
- mysql
- mysql initialization
- source code
- mysql mysql
- tools
- ubuntu
archives
| 2012 | - | - | - | - | may | jun |
| - | - | - | - | - | - | |
| 2011 | jan | - | mar | - | - | - |
| jul | aug | - | oct | - | dec | |
| 2010 | jan | - | mar | apr | - | - |
| - | aug | sep | oct | nov | dec | |
| 2009 | jan | feb | mar | apr | may | jun |
| jul | aug | sep | oct | nov | dec | |
| 2008 | jan | - | - | - | - | - |
| - | - | - | - | nov | dec | |
| 2007 | - | - | - | - | - | - |
| - | - | sep | - | - | dec |
subscribe
tags cloud
