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
- Dart
- Javascript
- PHP
- Python
tags cloud
Tutorials
How to write a function that generates random string in Javascript?
Submitted by Webmaster on Monday January 09, 2023
To write a function that generates a random string in JavaScript, you can use the following code:..(Read more)
Category:
Web Development > Javascript > Tips and Tricks
Tags:
Which frontend framework should i learn?
Submitted by Webmaster on Monday January 09, 2023
There are many frontend frameworks to choose from, and the best one for you will depend on your goals, experience level, and personal preferences...(Read more)
Category:
Web Development > Javascript > Resources
Tags:
The server requested authentication method unknown to the client [phpmyadmin]
Submitted by Webmaster on Monday January 09, 2023
It looks like you are trying to connect to a MySQL server using phpMyAdmin and you are encountering an error message saying that the server requested an authentication method unknown to the client...(Read more)
Category:
Database Management Systems > MySQL > Administration
Tags:
setfacl: command not found
Submitted by Webmaster on Monday January 09, 2023
The `setfacl` command stands for "set file access control list" and is used to set or modify the access control list (ACL) of a file or directory on a filesystem that supports ACLs. An ACL is a list of permissions that determine who can access a file or directory and how they can access it...(Read more)
Category:
Operating Systems > Linux > Tools
Tags:
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
