PostgreSQL common problems and solutions

PostgreSQL is the world’s most advanced SQL open source database. It contains comparable enterprise class features such as full ACID compliance and Multi-Version Concurrency Control for supporting high concurrent loads. And it supports standards such as ANSI SQL and SQL/MED (including foreign data wrappers for Oracle, MySQL, MongoDB and many others) and yet is highly extensible with support for over 12 procedural languages, GIN and GIST Indexes, Spatial data support, and multiple NoSQL like features for document (JSON) or key-value based applications.

Continue reading

MySQL GUI Tools: Top 5

Selecting the specific one among the MySQL GUI Tools is a primary concern for MySQL database administrators. MySQL which is a relational database management system is very popular now a days. And it is adopted by many technology giants. The main advantage of MySQL database is that it is free and it is open source.

Continue reading

MongoDB Tutorial: Install MongoDB on CentOS 6

MongoDB is a NoSQL database intended for storing large amounts of data in document-oriented storage with dynamic schemas. NoSQL refers to a database with a data model other than the tabular format used in relational databases such as MySQL, PostgreSQL, and Microsoft SQL. The features include: full index support, replication, high availability, and auto-sharding. This is the first MongoDB tutorial on JSTricks.

Continue reading