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 download and install MySQL on Mac OS X?
Submitted by Webmaster on Wednesday May 23, 2012
MySQL is the most popular open source database management system. It allows you to quickly download and install and run a powerful database system on almost any platform available including Linux, Windows, and Mac OS X etc...(Read more)
Category:
Database Management Systems > MySQL > Installation
Tags:
MySQL DATE_FORMAT function and ORDER BY
Submitted by Webmaster on Monday December 12, 2011
An interesting scenario that I came across today was the fact that if you use the same alias as the column name in a formatted string (using DATE_FORMAT) and you also use same alias in ORDER BY or GROUP BY clause then MySQL uses the string output of DATE_FORMAT to sort records rather than the actual date column...(Read more)
Category:
Database Management Systems > MySQL > Tips and Tricks
Tags:
MySQL Query Cache not necessarily a bad thing
Submitted by Webmaster on Monday October 03, 2011
After reading about the query cache mutex contention, scalability issues on multi-cores, and several people recommending disabling query cache on multi-core machines. I decided to give it a try and disable it to improve performance and since I was also seeing a lot of "freeing items" states for my queries (mysql works on query cache for part of the time query is in that state)...(Read more)
Category:
Database Management Systems > MySQL > Tips and Tricks
Tags:
Download all Aspersa MySQL tools/scripts through a single command
Submitted by Webmaster on Wednesday August 10, 2011
According to Aspersa's user manual, "Aspersa is a collection of open-source system utilities primarily designed to ease the work of Percona consultants. This manual is the primary documentation for Aspersa tools. Please contribute your improvements."..(Read more)
Category:
Database Management Systems > MySQL > Tools
Tags:
Download all maatkit scripts through a single command
Submitted by Webmaster on Wednesday August 10, 2011
According to maatkit home page, Maatkit is a toolkit for users, developers, and administrators of open-source databases. It is high-quality, formally tested software that is well documented and has an active open-source developer community...(Read more)
Category:
Database Management Systems > MySQL > Tools
Tags:
How to make class diagrams using Composition?
Submitted by Webmaster on Wednesday July 13, 2011
Before we move on to making class diagram for this problem lets discuss what is composition relation and how we use it, composition has a solid black diamond symbol...(Read more)
Category:
Miscellaneous > UML > Resources
Tags:
How to make use case diagram using Generalization in UML
Submitted by Webmaster on Wednesday July 13, 2011
Purpose of this tutorial is to give you understanding of how to use generalization, include and extend relationships when making use case diagrams...(Read more)
Category:
Miscellaneous > UML > Resources
Tags:
How to work with Association classes in UML - Part2?
Submitted by Shahbaz on Friday July 08, 2011
Alright, like i said we will discuss a different scenario in this tutorial to further clarify the concept of association classes so here is the scenario...(Read more)
Category:
Miscellaneous > UML > Resources
Tags:
How to work with Association classes in UML - Part1?
Submitted by Shahbaz on Thursday July 07, 2011
Unified Modeling Language (UML) is a standardized general-purpose modeling language in the field of object-oriented software engineering. The standard is managed, and was created by, the Object Management Group...(Read more)
Category:
Miscellaneous > UML > Resources
Tags:
MySQL error while dropping databases
Submitted by Shahryar on Thursday January 06, 2011
A few months back I was trying to drop some unnecessary test and archived databases from MySQL servers and while dropping a database I got the following error message...(Read more)
Category:
Database Management Systems > MySQL > Administration
