No Clocks

What’s your favorite command-line tool? In this post, Louis Lazaris shares a collection of relevant command-line apps and utilities that he has personally come across in the past few years. If there’s a useful one that hasn’t been mentioned and one you use regularly, please do share it in the comments.

Statistics about Obsidian Plugins. New, trending, favorite Obsidian Plugins.

Over 80K software development tech talks ranked algorithmically to surface the industry's best presentations from the past, present and future.

This document describes the AWS Well-Architected Data Analytics Lens, a collection of customer-proven best practices for designing well-architected analytics workloads. The Data Analytics Lens contains insights that AWS has gathered from real-world case studies, and helps you learn the key design elements of well-architected analytics workloads along with recommendations for improvement. The document is intended for IT architects, developers, and team members who build and operate analytics systems.

This post demonstrates how to extend the metadata contained in the Data Catalog with profiling information calculated with an Apache Spark application based on the Amazon Deequ library running on an EMR cluster. You can query the Data Catalog using the AWS CLI. You can also build a reporting system with Athena and Amazon QuickSight to query and visualize the data stored in Amazon S3.

Devart Excel Add-in for PostgreSQL allows connecting Microsoft Excel to PostgreSQL data, import data from Excel to PostgreSQL, edit these data and save them back to PostgreSQL.

This is the unofficial documentation for Obsidian plugin development.

Obsidian is an amazing tool for developer and developer advocates. You can use it as a second brain, for content creation, and more.

I was tinkering with the idea of finding the right way to help others to identify the resources that give you bang for the buck when it comes to upskilling yourself in data engineering… and this is what I came up with. The best data engineering courses, learning materials, data engineering training.

Introduction

This article reviews the differences between stored procedures and functions in Postgres and the types of functionality they provide.

In this article, we explain the concept of Stored Procedures, and how to write them effectively in PostgreSQL 9.6. PostgreSQL is an open source database

The book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries!

The book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries!

Business logic is supposed to be the part of the application where you deal with customer or user facing decisions and computations. It is often argued that this part should be well separated from the rest of the technical infrastructure of your code. Of course, SQL and relational database design is meant to support your business cases (or user stories), so then we can ask ourselves if SQL should be part of your business logic implementation. Or actually, how much of your business logic should be SQL?

Part I. Tutorial Welcome to the PostgreSQL Tutorial. The following few chapters are intended to give a simple introduction to PostgreSQL, relational …

Learn PostgreSQL quickly through a practical PostgreSQL tutorial designed for database administrators and application developers.

We here are very big fans of Postgres as a database and believe it is often the best database for the job. For many though, working with and maintaining Postgres involves a steep learning curve. This guide is designed as an aid for beginners and experienced users to find specific tips and explore tools available within Postgres. If you want to take the quick & painless approach instead, there are great services available for Postgres hosting.

One common misconception about DataOps is that it is just DevOps applied to data analytics. While a little semantically misleading, the…

Nobody wants to look at a dashboard or make decisions with yesterday’s data. We live in a world where real-time information is a…

Learn how to harness the power of Obsidian to create your connected-thoughts library. Make Obsidian your personal idea engine

Obsidian Publish!

Data engineering makes data more useful and accessible by sourcing & preparing the data to be handled by data scientists. Learn more about the responsibilities.

Top 20 Most Commonly Used Data Engineering Tools 2021