Background In our last post spoke of a little issue we experienced issuing a query against a PostgreSQL Instance. Issue The Issue is that our result set included an array column. array_agg Documentation Link SQL Output Troubleshooting Dbeaver Support Visited dbeaver support website @ Github. Here is the URL ( https://github.com/dbeaver/dbeaver/issues ) [ Link ] … Continue reading DBeaver / ProgreSQL – Array Datatype
Uncategorized
PostgreSQL :- Permit Network Access
Background It is time to allow network access to our PostgreSQL server. Outline Server Configuration ( Files ) postgresql.conf IP Interface ( Listen address ) Port Number Default :- 5432 pg_hba.conf ( PostgreSQL Client Authentication Configuration File ) Rules Firewall Host Firewall Network Firewall Reload Configuration pg_hba configuration Either of these options Command Line Shell … Continue reading PostgreSQL :- Permit Network Access
Annabell Om, A Jamaican Architect in Japan
Videos Profile In this episode of The Melanated Files (MFiles) we introduce Annabell, a Jamaican Architect who works at a Japanese architectural firm in Tokyo, Japan. Annabell shares her experience living and working in Japan for the past five and a half years. Listen as she shares her journey to Japan by way of the … Continue reading Annabell Om, A Jamaican Architect in Japan
XPath – Axis
Definition Definition matters. W3C - XPath W3C defines Axis this way :- Link An axis is either a forward axis or a reverse axis. Forward Axis An axis that only ever contains the context node or nodes that are after the context node in document order is a forward axis. Reverse Axis An axis that … Continue reading XPath – Axis
Transact SQL – XQuery – Ancestor
Background Playing around with XML, but dug in a quick sand. XML Here is the XML Image Code Code Code Find Nodes whose element matches specific value SQL Output Pass X PATH :- Child::bar/Attribute SQL Output Find Descendants SQL Output Find Ascendants SQL Output Output - Textual Output - Image Source Code Control Git Hub … Continue reading Transact SQL – XQuery – Ancestor
IBM Divestiture – 2019
Background IBM recently completed its purchase of Raleigh's North Carolina Linux Powerhouse, Red Hat. As part of that corporate merger, it appears regulars whether here overseas are concerned of allowing too much vertical technology ( Application software, Operating System, and Integration Software ) to rest in a single entity. Affected Product Lines HCL Software … Continue reading IBM Divestiture – 2019
SQL Server Data Tools ( SSDT ) – Error – “The Application is not installed”
Background Wanted to quickly go over an error that is easy to self trigger when working with SQL Server Data Tools ( SSDT ). Triggering Point A few days ago I was working with SSDT, and I was informed that one of the plugins is running slow and prompted if I want to disable … Continue reading SQL Server Data Tools ( SSDT ) – Error – “The Application is not installed”
