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

Edco Wallet

Database performance, CloudReport 2020

The transition to the cloud is in full swing. Private, public, hybrid, IaaS, PaaS, DbaaS; the cloud has countless forms and applications. But which cloud provider and which machines match best with your environment, and especially with your database? CockroachLabs - the company behind CockroachDB - recently published their annual Cloud Report. They have conducted an extensive and thorough benchmark with the three most well-known cloud providers: AWS, Azure and GCP. The benchmark is about a database instance on a cloud server and not DbaaS. In this blog Edco Wallet shares a summary of the Cloud Report 2020.

More about Cloudreport 2020

Thomas Spoelstra

DBA - Old but Gold vs DbaaS

We wrote earlier that there is nothing wrong with managing databases in a somewhat older environment. But there is also nothing wrong with more mature database administrators. Thomas Spoelstra - yes, the guy from the man cave - is one of those. He knows better than anyone how to set up a database as efficiently as possible, because 'before' there simply wasn't any more disk space or memory. Now that we are massively switching to the cloud, with all its space and possibilities for scaling up, those efficiency skills no longer seem that important. Until the costs get out of hand. Then you need someone who can assess and fine-tune the content of the data model to reduce your cloud costs. So someone like Thomas...

More about DBaaS

Martijn Wallet

Determine better indexing and partitioning with hypopg

I ran into the challenge to determine the best partitioning key on an Amazon RDS Postgres database. Normal approach would be to start a project trying to implement this on a development environment. But in most cases, like during a QuickScan, the customer expects an educated guess in as little time as possible. It concerns running production environments where you would rather not release all kinds of scripts and analysis tooling to avoid disrupting the primary process. Which then also takes up unnecessary extra time.

More about HypoPG

Martijn Wallet

Native PostgreSQL or Supported PostgreSQL

One of the most popular open source databases is PostgreSQL, in 2018 even declared DBMS of the Year. In this blog Martijn Wallet shares the most important advantages of using Supported PostgreSQL such as EDB Postgres Platform as compared to native PostgreSQL.

read more

Dimitri Choustov

Get your database fit and healthy again

At OptimaData we are regularly asked to investigate disappointing performance of database environments (such as SQL Server, MySQL or PostgreSQL). Due to all possible variations and combinations in environments, there is not one specific or directly identifiable cause for such a performance issue. In this blog Dimitri Choustov explains how to get your database fit and healthy again.

Read more about HealthChecks

Pieter Groenendijk

Look after the customer with the much-needed extra vitamin A(ttention)

Because of the coronavirus, we're all working remotely all of a sudden. In order to be able to work remotely there are sufficient tools available. But to work well and enjoyably from a distance and to really make contact with colleagues, employees and customers, some extra attention is needed. We are very happy with co-creative entrepreneurship. Pieter Groenendijk, our staffing and recruitment specialist, explains in this blog what we mean by this and why we care about the extra bit of vitamin A (attention).

Read more about vitamin A

Roland van Veen

Nothing wrong with experienced databases

There is nothing wrong with the management of databases in somewhat older environments. On the contrary, these are applications that keep a lot of companies afloat. But there are a number of things you need to pay attention to. Roland van Veen, OptimaData DBA and Database Reliability Engineer, explains in this blog what those things are.

More about legacy databases

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

Via the link "read more database blogs" you will find our blog section. Blogs about databases, open source DBMS like PostgreSQL, MySQL, MariaDB, CochroachDB. Great stories how to and also general stuff about data and management.

read more database blogs

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

Via the link "read more database blogs" you will find our blog section. Blogs about databases, open source DBMS like PostgreSQL, MySQL, MariaDB, CochroachDB. Great stories how to and also general stuff about data and management.

read more database blogs

Via the link "read more database blogs" you will find our blog section. Blogs about databases, open source DBMS like PostgreSQL, MySQL, MariaDB, CochroachDB. Great stories how to and also general stuff about data and management.

read more database blogs

Via the link "read more database blogs" you will find our blog section. Blogs about databases, open source DBMS like PostgreSQL, MySQL, MariaDB, CochroachDB. Great stories how to and also general stuff about data and management.

read more database blogs

Via the link "read more database blogs" you will find our blog section. Blogs about databases, open source DBMS like PostgreSQL, MySQL, MariaDB, CochroachDB. Great stories how to and also general stuff about data and management.

read more database blogs

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