Jak często zdarzało Ci się, w wynikach zapytań SQL-owego dostać zduplikowane wiersze? Domyślam się, że skoro jesteś tutaj ze mną to pewnie więcej niż 1 raz. Zwykle zduplikowane wiersze nie są czymś pożądanym, ale czy tak jest zawsze? Jak sprawdzić czy w danych wynikowych znajdują się powielone wpisy i jak je ewentualnie usunąć? Odpowiedzi na te pytania znajdziesz w …
Co się wydarzy, gdy w naszym systemie bazodanowym wystąpi awaria? Czy operacje, które są w trakcie przetwarzania zostaną wykonane, a może dojdzie do ich anulowania?No właśnie, zwykle rzeczywistości nie jest tak kolorowa jak byśmy chcieli, awarie się zdarzały, zdarzają i zdarzać będą. Jednak czy można zrobić coś co gwarantowałoby wykonanie operacji lub jej wycofanie w …
Wszystko co chcesz wiedzieć o Transakcjach i ACID Read More »
This is part 2 of PostgreSQL Queries Tips & Tricks from performance and overall backend side of your database. In Part 1 we have covered, duplicated, rarely used indexes and general amount of elements in your DB. This time we will dive into the details of tables and indexes. Below you can find 2 queries …
When we think about data, gathering or streaming, analyzing and visualizing. In most of the cases we have “big” things in minds. Companies that process terabytes of data and make decisions based on them. However there is also another side of it. Private one, that all of us are able to leverage. We are all …
Data Engineering 101 – 7 ideas how to use Your Own data Read More »
If you are working daily with PostgreSQL database, sometimes you may have a need to get some information or valid stuff that normally are inside of a Database Administrator scope. In this article I will share with you 3 useful queries mainly for working with indexes in PostgreSQL, version 9.6+. Duplicate Indexes When multiple developers …
10 important elements of data warehouse, elements relevant for you if you are working with data, you are part of data engineering team, or your are generally interested in this topic. Below list is not a comprehensive guide to Data Warehousing it is a subjective list of important components that should be considered in each …
In September (2018 if you are reading this post in the future) I had an opportunity to conduct a workshop session during a conference called ML (Machine Learning) @ Enterprise. Topic of my workshop was “From Data to Actions” and it was meant to show all the steps in the process of working with data, …
Chained Weekly Digest #7 – 16 – 22 July incoming! This week we’ve found a lot of interesting articles in Hyperledger space, but not only there. Notes from news about regulations, interviews, points and remarks in blockchain space are also part of this summary, enjoy the read! „EU Parliament Study: Central Bank Digital Currencies ‘Will …
This is the end, I mean FIFA World Cup has ended. France is a World Champion in football, but that doesn’t mean that Chained Weekly Digest is ending as well – not even close. In Chained Weekly Digest #6 you can read summaries of articles, read and reviewed between 9 and 15 of July, enjoy …
First full week of July brings a lot of news into Chained Weekly Digest #5. Below you can find summary of 6 articles, looking forward to your opinion about any of the information provided, enjoy the read! „Cars on the Blockchain? Six Ways Automakers Could Employ the New Technology” Author: Kristin Houser Source: Cars on …
