When talking about databases, most people think of relational databases in a form of tables. There are some popular relational databases like MySql, SQLite and PostgreSQL. The last one is an open-source Relational Database Management System, which has more than 15 years of development and one of the most advanced RDBMS. Its SQL implementation strongly conforms to the ANSI-SQL standard. PostgreSQL is also fully ACID compliant and supports Foreign Keys, Joins, Views, Triggers, and Stored Procedures (in multiple languages). In this post we will look at the features of PostgreSQL. (more…)
What is Docker?
Docker consists of the two main parts the Docker Engine and the Docker Hub. The Docker Engine is the core of Docker and you can think of it in terms of a container ship. Each application represents one container on this ship and the ship is our virtual machine. Docker groups several applications together and runs them as a single application. To distribute your built application, docker provides the Docker Hub service where you can upload and publish your application. Docker Hub is also the place, where you can find other projects you might want to use for yourself. (more…)
Welcome back in the database land. Today we will examine another one of the document based databases. The first questions is: What is different between Mongo and Couch? Well, a lot. Even though they use the same way of storing data, JSON structures, both are more like cousins than siblings. CouchDB is sometimes also called the – Database made of the internet. We will soon see, what it means. (more…)