OptimaData is a full-service, multi-platform data(base) service provider

Craig Healey

How to run Postgres on Docker part 3

In a previous post I deployed a PostgreSQL database in a container from a standard image. Now I’m going to look at deploying a PostgreSQL cluster. Well, kind of. PostgreSQL uses the term cluster to refer to “a collection of databases managed by a single PostgreSQL server instance”. I’m using it in the more general sense, to refer to High Availability.

read more

Craig Healey

How to run Postgres on Docker (part 2)

In my previous blog post, I quickly ran through how to set up postgreSQL inside a Docker container, up to the point where you could administer the database with psql or pgAdmin. What I didn’t do was explain how any of it worked. If you’re trying to anything even slightly different, or if you encounter errors running it as I outlined, then you’re going to need to know what all of those commands actually do. In this blogpost i will explain some Docker basics.

Read more

Craig Healey

How to run Postgres on Docker (part 1)

As a multi-platform DBA, I spend a lot of time learning about the latest features available on a variety of open-source and proprietary databases. I usually use VirtualBox images to create my sandbox databases, but they can take up quite a bit a disk space and resources. Especially if I’m playing around with things like database clustering solutions, when I need multiple databases running together. So the other day, I thought about using Docker containers.

read more

Gerard Zuidweg

Open Source DBMS Feel free to choose but choose wisely

Open Source Database Management Systems are on the rise. Not only among newtech companies, but now also in banks, government departments and multinationals. Recent research among CIOs has shown that more than 60 percent want to drastically reduce licensing costs. Opting for more open source software helps, if well-considered choices are made. The most important points to consider are shown below.

Points to consider Open Source DBMS

Edco Wallet

The OptimaData top 8 database events in 2019

Numerous international and national events, conferences, congresses and symposia will take place in 2019 on open source database platforms. Because of the wide range and often limited time and resources, it can be difficult to determine what you will or will not visit. We are therefore happy to give you a hand with this overview of the 8 most important and interesting database events in 2019. We are of course present at these conferences and we hope to meet you there too!

See the Top 8 Open Source DBMS Events

Martijn Wallet

PostgreSQL 12 is taking shape; these are the most important new features

Each year there a new version of PostgreSQL is released. That’s the moment in which many new features and improvements become available for all users. During the last PostgreSQL meetup in Amsterdam, Devrim Gündüz, major contributor and passionate PostgreSQL consultant, explained the upcoming release of PostgreSQL 12. In this blog we list the most important changes in PostgreSQL 12 for everyone who does not closely follows all the commits in Github or who did’nt have the opportunity to visit the PostgreSQL Usergroup NL meetup.

More about PostgreSQL 12

Edco Wallet

Will Open Source be sunk by its own success?

In addition to the well-known databases such as Oracle, MySQL or MS SQL, Open Source databases are developing at lightning speed. In fact, they’re developing so quickly that more and more companies will be using open source databases such as PostgreSQL or MongoDB in their IT infrastructure, and an increasing number of IT brokerage and recruitment agencies will start working with open source professionals. On one hand, that is a nice compliment for the Open Source Community, but on the other, there is also a danger: market forces threaten to undermine the principle of Open Source.

Read more