Sirius Blog: You ask, we answer!

  • Oracle to CockroachDB Migration - Part 1

     

    Continuing our series on RDBMS migrations, this post will demo a schema migration from Oracle to CockroachDB.

    CockroachDB is an Open Source, scalable, distributed RDBMS.

    This post will focus on installing and configuring a CockroachDB cluster. For this demo we will run a small 3-node docker cluster.

    Read more

  • System_Stats - a great new extension from EDB

    A quick post on an excellent new extension from EDB - system_stats, PostgreSQL views into system processes, memory, cpu, disk - highly recommended. this test was run against an PostgreSQL 11.4 instance

    You can find the installation instructions on GitHub here

    You can now find out anything you need to know about your systems right within PostgreSQL

     

    Read more

  • What is ERP?

    A Quick intro for the SME as to what ERP is, and why might it be useful for a growing business. A guest post from Sirius partner uzERP, experts in Open Source ERP for the Enterprise.

    Introduction

    There are many essential processes involved in running any organisation, no matter its size....

    Read more

  • PostgreSQL: New features in Version 13 - Index Deduplication

    With the second beta release of PostgreSQL 13, we now have first sight of the full range of new features the PostgreSQL and Open Source world is getting excited about! Naturally, Sirius engineers are getting deep into them, and we'd like to share these exciting new features with you!

    Today’s post will examine one of the new features of PostgreSQL 13 – B-tree index de-duplication.

    Read more

  • Microsoft SQL Server to PostgreSQL Migration using Pgloader

     

    To continue our migration series, today’s post will focus on pgloader. Pgloader is another Open Source data migration utility for PostgreSQL from MySQL and SQL Server. Today’s demo will migrate a sample database (StackOverflow) from MS SQL Server 2019 to Postgresql v10.

    StackOverflow contains the following tables

    Read more