Planet Ingres

June 27, 2022

Nikos Vaggalis - AGE - The Open Source PostgreSQL Extension For Graph Database Functionality

Apache AGE, "A Graph Extension" was recently announced as an Apache Software Foundation Top-Level Project (TLP). What is the importance of that?The project was originally developed in 2019 as an extension to AgensGraph (Bitnine Global's multi-model database fork of PostgreSQL) and it entered the Apache Incubator in April 2020. The Apache Incubator is the primary entry path for projects and

by Nikos Vaggalis ( at June 27, 2022 05:12 PM

June 24, 2022

Nikos Vaggalis - GitHub Skills - A Better Way to Learn Git and GitHub

GitHub has just launched Github Skills, a new learning platformthat replaces the current Learning Labs. This is a change for the better.Git and GitHub have something for everyone, beginners and pros alike. The trouble is that in order to master it you have to go through a steep learning curve where there's always something new to learn even when you thought you knew it all. For example, you just

by Nikos Vaggalis ( at June 24, 2022 06:28 PM

June 16, 2022

Nikos Vaggalis - New Database Drivers for Oracle and PostgreSQL Released

The PostgreSQL JDBC Team team has announced the release 42.4.0 of the JDBC driver for PostgreSQL. Meanwhile Oracle has released a Python-based driver for Oracle. Python and Java users rejoice!full article on i-programmer:

by Nikos Vaggalis ( at June 16, 2022 06:10 PM

June 13, 2022

Nikos Vaggalis - Perl 5.36 Released - What's New?

Perl 5.36 was recently released and while we await Perl 7 it comes with many great features.First of all borrowing from Perl's 7 philosophy, 5.36 comes with modern and sensible defaults. That is, use 5.36; loads pragmas and features already being advised for years to programmers writing in Perl, like turning strict and warnings on, use 5.010 or importing Modern::Perl, which are now going to be

by Nikos Vaggalis ( at June 13, 2022 04:06 PM

June 10, 2022

Nikos Vaggalis - Bash-Oneliner and GameShell Teach Unix Command Line

Two great resources, one for beginners and one for intermediate users, for learning the Unix, well, Linux shell.Many wanted the command line bashed (pun intended), deprecated or replaced by something else. Still it has never gone away and never will, especially now that it has infiltrated even Windows through WSL.In "The PaSh Project - Advancing the Unix Philosophy One Step Further" I found

by Nikos Vaggalis ( at June 10, 2022 05:22 PM

June 06, 2022

Nikos Vaggalis - pg_ivm - Materialised Views On Steroids

pg_ivm is an extension module for PostgreSQL 14 that provides an Incremental View Maintenance (IVM) feature.That means that materialized views are updated immediately after a base table is modified.pg_ivm gives answer to the age old problem of when to refresh the materialized view. As a refresher or reminder, a materialized view versus a normal view is that the former keeps a copy of the data

by Nikos Vaggalis ( at June 06, 2022 05:16 PM

May 24, 2022

Nikos Vaggalis - Apache OpenJPA-Life Beyond Hibernate?

Apache OpenJPA is the Java persistence project of the Apache Software Foundation. After quite some time flying under the radar, there's a new release. Let's look into it.JPA, aka the Java Persistence API, manages persistence and object relational mapping in Java EE and Java SE environments. Libraries like OpenJPA, Hibernate or EclipseLink are those providing the implementations of the standard.By

by Nikos Vaggalis ( at May 24, 2022 03:55 PM

May 17, 2022

Nikos Vaggalis - Kalix-NoOps High-performance Microservices and APIs

What Kalix Platform-as-a-Service promises is massive - a way to write cloud applications based on Kubernetes under a unified API abstracting the lower layers away.We know that Kubernetes is magic, but at the same time hard - hard to setup, hard to configure, hard to operate, hard to write applications on, and this difficulty is a reason of why many are reluctant to let go of their monolith for

by Nikos Vaggalis ( at May 17, 2022 06:26 PM

May 16, 2022

Nikos Vaggalis - Dash Dash - Making Linux Documentation More Approachable

Dash Dash is a new website that aims to prettify the ugly that is the Man Pages. What once felt like a maze of weird symbols and hyper intense colors, now are visually subdued and easier to understand.Navigating Linux documentation when in need is not something enjoyable.Take for instance the Man Pages for chmod :full article on i-programmer:

by Nikos Vaggalis ( at May 16, 2022 04:05 PM

May 12, 2022

Nikos Vaggalis - Azure Toolkit for IntelliJ

The Azure Toolkit is a plugin for IntelliJ that provides templates and functionality with which you easily create, develop, test, and deploy Azure applications. The newest version 3.64.0 was recently released. The plugin is part of the Azure Toolkits for Java which also includes Azure Toolkit for Eclipse.The plugin is compatible with all version of IntelliJ (Ultimate, Community, Educational) and

by Nikos Vaggalis ( at May 12, 2022 05:10 PM