Notion is underrated

https://curious-woolen-937.notion.site/ASSIGNMENTS-e4aeb29e51e345b5b326d67dfd8207c8
I'm learning to create templates onNotion Course practice
the notion and later will sell them.

Read: https://shreyashbuilds.hashnode.dev/notion-is-underrated

Deploying Apache Airflow on OCI with MySQL HeatWave Database Service

Read: https://lefred.be/?p=5448

A List of PostgreSQL Commands for Beginners

Yes, My First-ish Time
I've dabbled with SQL a couple times, but never truly dove all the way in. I took Google's Data Analytics certification last year, and it gave a nice cursory overview of SQL, Big Query, Tableau and the R language. But, I'm read...

Read: https://blog.eamonncottrell.com/a-list-of-postgresql-commands-for-beginners

Auditing & Implementing Data Change Capture with Triggers in SQL Server

Database Auditing is a process of tracking and logging all events and capturing data changes in database objects, it not only helps businesses but is also a compliance requirement.
In most cases when we want to implement capturing of data changes in ...

Read: https://mssqlserver.dev/auditing-and-implementing-data-change-capture-with-triggers-in-sql-server

Docker and SQL Server 2017 Installation On WindowsVM In Azure

In today’s article, I will explain Docker and SQL Server 2017 Installation On WindowsVM In Azure. In my previous article, I told you how to install Docker and SQL Server 2017 on LinuxVM on Azure. This article, I will be telling you about the “Windows Server 2016 Datacenter – with Containers”, which we will install …

Read: Docker and SQL Server 2017 Installation On WindowsVM In Azure.

Real Apps Built with a MongoDB Atlas Serverless Database

Read: https://www.mongodb.com/blog/post/real-apps-built-mongodb-atlas-serverless-database

Полмегабайта пустоты в каждом файле Apple Music

Вы когда-нибудь докупали расширенный объём хранилища для iPod, iPhone или Mac, чтобы иметь больше места для своей цифровой коллекции музыки Apple Music (iTunes)? Возможно, вы заполняли его гигабайтами пустого пространства.

Музыкальные файлы, которые вы покупаете в Apple Music Store (AMS; ранее назывался iTunes Music Store) содержат приблизительно 6% цифрового аналога пустоты. Я говорю не о тишине, а о сплошных блоках пустого пространства, находящихся внутри файлов. Они нужны только для того, чтобы заполнять файлы, делая их на 0,5 МБ больше. Так зачем же Apple делает музыкальные файлы излишне большими? И как вернуть впустую занимаемое пространство?


Читать: https://habr.com/ru/post/659799/

Разработка архитектуры для чайников. Часть 2

Monolite or MicroService ?

Программисты последнее время часто работают с микросервисами и часто пытаются их встроить туда, куда это не нужно. Микросервисы это естественно хорошо, но как и всегда это не серебряная пуля которая может решить любые проблемы, а скорее наоборот их добавит.

Давайте для начала разберём что такое монолит и его преимущества и недостатки.


Читать: https://habr.com/ru/post/658151/

Oracle Business Process Management

In today’s article, we will talk about Oracle Business Process Management RCU installation. I prepared the installation on Oracle Linux 6.5 with RCU version 11.1.1.7. You can check the current versions via oracle and install them in the same directory. First of all, we create a folder named “OracleSetup” in the root directory of the …

Read: Oracle Business Process Management.

Flutter: Все способы защиты данных

Эта статья расскажет, какими общими способами можно защитить свое приложение от взлома или получения персональной информации третьими лицами посредством исполнения нескольких простых шагов, но стоит помнить, что нет вещей, которые невозможно взломать, все зависит лишь от потраченного времени и наличия мотивации у взломщика, но т.к. у нас стоит цель обезопасить наше приложение, то давайте усложним им жизнь как можно сильнее.


Читать: https://habr.com/ru/post/659999/

How to Import Data into your Heroku PostgreSQL Database From Your Local PostgreSQL Database

Introduction
Oftentimes, you will need to migrate data from one PostgreSQL database to another. Importing data into your Heroku PostgreSQL database can be done easily with a few steps.
The Heroku PG Backups is a tool that you can use to export to an...

Read: https://ehizmantutored.hashnode.dev/how-to-import-data-into-your-heroku-postgresql-database-from-your-local-postgresql-database

Steps to Enable Exadata Cloud Service Monitoring using OCI Performance Hub

Detailed step by step instructions for enabling Exadata monitoring in ExaCS using Performance Hub.

Read: https://blogs.oracle.com/database/post/steps-to-enable-exadata-exacs-monitoring-using-oci-performance-hub

How does BookMyShow handle concurrent bookings

Introduction
Book my show is a ticket booking application which helps users in booking single/multiple seats for a movie/show/event etc. in a particular geographical location. It is possible that multiple users try to book the same show and sometime ...

Read: https://codeminion.hashnode.dev/how-does-bookmyshow-handle-concurrent-bookings

Slowly Changing Dimension type 2 in action -Practical-

SCD (Slowly Changing Dimension) is a very important concept in ETL and Data Warehouse in general.
"Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse"
-Oracle
If you w...

Read: https://dataengineeringmokda.hashnode.dev/slowly-changing-dimension-type-2-in-action-practical

#9 System Design: Sharding

Welcome to the 9th episode :)

Hey ! I want to store the data of how many of my house devices are connected to the network and their utilization metrics on a database.
Here you go take it !

Now I have to do it for my entire community !! They love th...

Read: https://devblossoms.hashnode.dev/9-system-design-sharding

I've built an iOS/macOS/iPadOS app using low code within 72 hours

I'm fairly new to backend dev & have a decent knowledge on how to build frontend apps using Swift. When I chose to become Indie, I wanted to have a clear idea of what Indie implies in terms of product development.
For me Indie 101 is:

Product 20%
De...

Read: https://pradeepb28.hashnode.dev/ive-built-an-iosmacosipados-app-using-low-code-within-72-hours

Django PostgreSQL Migration from SQLite

Full Article on Sweetcode
PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many other features that safely store complicated data workloads.
The database comes with many feat...

Read: https://larymak.hashnode.dev/django-postgresql-migration-from-sqlite

DBMS Vs RDBMS - Explained Differences

In today's modern age, where we are flooded with data, we can find that managing or storing data tends to be very arduous. Most people are unable to deal with data, and some even hire people to manage their critical data. This may consume a big chunk...

Read: https://hashnode.com/post/dbms-vs-rdbms-explained-differences-cl1uev6xd0b1osvnv0zzv6ke4

OpenLampTech issue #21 – Substack Repost

Read: https://joshuaotwell.com/?p=36041

How databases recover data. ARIES algorithm

Hi everyone!
Most of you have probably heard of an acronym ACID which is a property of a transactional system e.g. database meaning it can provide A — Atomicity, C — Consistency, I — Isolation and D — Durability... But how does it work exactly?
Thi...

Read: https://sharkinit.hashnode.dev/how-databases-recover-data-aries-algorithm

Integrating an ORM in Node.js in 5 easy steps

Hi developers! In this post we are going to implement an ORM (TypeORM) to interact with the Database (MySQL) performing the basic operations CRUD (Create, Read, Update and Delete). Let's start.
❤️ Follow me

🐦 https://twitter.com/thebug404
🐙 https:...

Read: https://thebug.hashnode.dev/integrating-an-orm-in-nodejs-in-5-easy-steps