(Peter Zaitsev) When connecting to a local MySQL instance, you have two commonly used methods: use TCP/IP protocol to connect to local address – “localhost” or 127.0.0.1 – or use Unix Domain Socket.
Community
Sprint Name Generator In Angular 9.1.3
(Ben Nadel) I’ve had a stressful week. So, I wanted to cap it off with something a little on the fun side. At work, we’ve started to use “Sprints” to organize our team (as opposed to just working a Kanban board).
Production Tips for ASP .NET Core 3.1 Web Apps
(Shahed C) This is the sixteenth of a new series of posts on ASP .NET Core 3.1 for 2020. In this series, we’ll cover 26 topics over a span of 26 weeks from January through June 2020, titled ASP .NET Core A-Z!
Things every C# developer should know #1: hash codes
(Thomas Levesque) As a C# developer, there are obviously a lot of skills you need to master to be effective: language syntax, framework classes, third-party libraries, databases, regular expressions, the HTTP protocol, etc.
Capture DDL statements in Oracle DB
(Arun Gupta) There are many cases where we need to capture the ddl statements in our production environment where application team have direct access for create or drop any object in the application schema in the production database .
OJVM datapatch fails with ORA-29532 – but the root cause is noncdb_to_pdb.sql
(Mike.Dietrich) Kudos to Robert Ortel who brought this nice misbehavior to my attention. And even though it looks like this would be an OJVM issue, it is caused by noncdb_to_pdb,sql, the script which is used to convert a non-CDB to a PDB.
RPG Academy: Database Modernization – Methodology, Part 8
(Rafael Victoria-Pereira) Now that you’ve streamlined your database, gotten rid of unnecessary columns and/or tables, and moved all or at least part of the data validation code out of your programs, you’re ready to dive a little deeper into DB2’s advanced functionalities.
Extend (Reduce/Contract/Skrink) Function for Oracle
(Simon Greener) Recently I was looking at some cadastral data with a view to working out how to polygonize the linestrings. The data contains this sort of boundary understood anomaly.
Web Service Data Integration
(David McGahey) In a previous post we wrote that every data integration and reporting task needs to start with a clear understanding of the source data.
Completing SQL. Part 1: The difficulties with parsing or tales of polishing ANTLR
(Andrey Podkolzin) I’ve been working for a company that develops IDEs for database interaction for more than five years. Before starting to write this article, I had no idea how many fancy tales would lie ahead. Thus after making 30 pages of it, I decided to group up the tales thematically and divid