PostgreSQL Installation
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later. PostgreSQL…
Depth of an attribute in Document
Say my document is very huge & have multiple sub-documents & attributes (i.e, dotted notation with long depth) in it. And assume I don’t the schema design of my document, but I want to query on the db to count…
MongoDB Shard creation script
Below shell script will be useful to create a MongoDB’s sharded environment on a single sever/multiple servers depending on your requirement. Things to remember to execute below automated script. 1) We should have required privileges to the user on your…