This message was sent first to subscribers of Data Craze Weekly newsletter.
Article is a bit old, but still brings a lot of value. Especially if you want a gentle introduction to CDC - Change Data Capture.
You can get from it, what is CDC, what you can expect out of it and how Netflix approached this topic.
Starting from version 15 of PostgreSQL, default CREATE privilage for none admin / superuser privilege will be revoked from PUBLIC schema. If you are relying heavily on public schema please read it carefully.
The longer we work with data, models, tables, schemas etc. The more we are starting to get lost in all of these objects.
Questions are starting to arise:
What is this table for?
Is it being used?
What was it’s goal?
I guess you can agree that documenting stuff is not the most attractive part of working with data … but hell it is essential. The sooner we realise that the easier our work will be down the road.
Fortunately or unfortunately we as people working with data are like librarians, we are creating order out of chaos (by cataloging, describing etc. data). In attached articles author is describing some best practices to help us out in this journey.
sql_formatter - are you working in a Team were you are constantly discussing where commas should land in SQL (at the end or at the beginning of an attribute)?
Why don’t you use a formatter that you can seamlessly add to you git workflow, and will do all the work for you - with one proper way of setting commas (at the beginning :)).
Bez użycia funkcji MAX wyświetl drugi największy identyfikator produktu (kolumna PRODUCT_ID) z tabeli PRODUCTS.
SELECT product_id FROM products ORDER BY product_id DESC LIMIT 1 OFFSET 1;
- Senior Data Engineer – Wayflyer – UK / EU Remote – 80000£ – 100000£