An open-source tool to seed a development database with real data

A bunch of contributors and myself have created RepliByte - an open-source tool to seed a development database from a production database.
Features 🔥

Support data backup and restore for PostgreSQL, MySQL, and MongoDB
Replace sensitive data with fa...

Read: https://hashnode.com/post/an-open-source-tool-to-seed-a-development-database-with-real-data-cl372ak9m04kkmqnvhjw9htuv

An ORM can bite you

Object Relational Mappers (ORMs) are widely used in software development to abstract database operations in our application code by providing a layer between object-oriented programming language and tables in a database. However we should be consciou...

Read: https://jorzel.hashnode.dev/an-orm-can-bite-you

Interacting with Database in Go

In this article I would like to write about how can the model layer interact with the database. In this case I will use a PostgreSQL database.
There are a couple things we need to do to connect to a database in our application.
Driver
The first thin...

Read: https://renatobogar.me/interacting-with-database-in-go

Understanding Data Transfer Objects (DTO) and Data Validation in TypeScript (NestJS).

Data Transfer Objects (DTOs) are the basis of data validation in NestJS applications. DTOs enable various layers of flexible data validation in NestJS.
In this publication, you will take a deep dive into data transfer objects, discussing validation ...

Read: https://davidekete.hashnode.dev/understanding-data-transfer-objects-dto-and-data-validation-in-typenoscript-nestjs

Migration In Laravel

Overview
Migration in Laravel makes it possible to create tables in your database without using your database manager. This can be done right within your terminal with the use of laravel artisan command, php artisan make:migration. Migration in larav...

Read: https://kindnesso.hashnode.dev/migration-in-laravel

Kaggle like a King

Kaggle is been here for quite a while now and we all know its like gold mine when it comes to working with data-science projects and in many cases we prefer to use google drive to access our data sets.
so, today we shall look at how can one access ...

Read: https://waleed.hashnode.dev/kaggle-like-a-king

Introduction to Airflow

In my previous blog, I briefly introduced apache airflow and mentioned how the tool can be used to orchestrate tasks however I did not set it up locally. This was a deliberate attempt to discuss the tasks I'd like to orchestrate before installing the...

Read: https://kingmoh.hashnode.dev/introduction-to-airflow

Upgrade Cloud SQL Postgres version using Google Database Migration Service(DMS)

Background
A few days ago, I came across an interesting blog post from Google Cloud. In the blog, it used Google Database Migration Service(DMS) to upgrade underline Postgres version in Cloud SQL instance. I found it is interesting and decided to hav...

Read: https://derrickqin.com/upgrade-cloud-sql-postgres-version-using-google-database-migration-servicedms

Локальный или облачный сервер: плюсы каждого выбора

Еще 20 лет назад, когда только запустили первое облако LaaS, многим казалось, что облачный и локальный сервер – это как небо и земля. Спустя время опросы показывают, что пользователи перестали замечать разницу между двумя средами. А выбор сервера по большей части зависит от потребностей конкретного бизнеса. Кто-то сразу останавливается на одном из вариантов, а кому-то приходиться пройти немалый путь, чтобы найти свое. Хочу, чтобы у Вас сразу сформировалось четкое представление о двух средах, поэтому прошу под кат.


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

Gartner® recognizes Amazon RDS in new report

Read: https://aws.amazon.com/blogs/database/gartner-recognizes-amazon-rds-in-new-report/

Designing Data-Intensive Applications CH7 - Transactions Part I

Hello guys, today's article is going to be about chapter 7 from the book 'Designing Data-Intensive Applications' by the brilliant Martin Kleppmann. This chapter talks about transactions in a database, without further or do lets dive right in.
The cha...

Read: https://hewi.hashnode.dev/designing-data-intensive-applications-ch7-transactions-part-i

Starting a new chapter: RelationalAI

Some of you may have seen one of my recent tweets that left a big question hanging in the air: Dude, what are you doing next??
I'm excited to announce today is my first official day working at RelationalAI! I've walked through a lot of the story here...

Read: https://quinnj.hashnode.dev/starting-a-new-chapter-relationalai

Transactional REQUIRES_NEW considered harmful — Spring/Java transaction handling pitfalls

Databases and Transactions are great, Spring is great, Kotlin/Java are great (ofc. Kotlin is better 😉), simplifying transaction-handling is great. But as we all know, simplifying things almost always creates some new pitfalls if the things that were...

Read: https://engineering.cloudflight.io/transactional-requires-new-considered-harmful

Установка Nextcloud на Synology. Настройка OnlyOffice и External storage

В данном посте я хотел бы рассмотреть способ установки персонального облака на домашний сервер Synology при помощи Docker, поделиться своими ошибками и опытом использования в повседневной жизни. Я буду признателен, если более опытные пользователи habr также поделятся своим опытом и расскажут, как им помог Nextcloud в повседневной жизни или какие трудности в установке ими были пройдены.


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

Dissecting the architecture of Google AlloyDB, Amazon Aurora, and MariaDB Xpand

Read: https://mariadb.com/?p=31464

Oracle. Ещё один способ партиционирования больших и нагруженных таблиц

Всем привет! Меня зовут Ольга и я разработчик в Ингосстрахе. В этой статье-туториале хочу поделиться способом партиционирования оооочень большой таблицы в Oracle 12c. Итак, погнали.

В жизни любой давно функционирующей системы наступает момент, когда уже невозможно хранить все исторические данные без разбору и пора думать, что это надо как-то поделить. Старое отправить на архивный или отчетный сервер, а оперативный слой существенно проредить. И самый очевидный и распространенный путь – партиционировать таблицу, а старые секции перенести на другое хранилище.


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

How to connect SuperTokens to a MySQL or to a PostgreSQL database

This is only applicable if you are self-hosting the SuperTokens core service.

There are several methods for how you might want to run SuperTokens along with a database.
Please feel free to navigate to the correct section based on your setup. In eac...

Read: https://supertokens.hashnode.dev/how-to-connect-supertokens-to-a-mysql-or-to-a-postgresql-database-cl3bknpf505ahx2nveryr1bra

Discover new insights from your data using SQL Server Integration Services (SSIS) and Amazon Neptune

Read: https://aws.amazon.com/blogs/database/discover-new-insights-from-your-data-using-sql-server-integration-services-ssis-and-amazon-neptune/

Enable near real-time notifications from Amazon Aurora PostgreSQL by using database triggers, AWS Lambda, and Amazon SNS

Read: https://aws.amazon.com/blogs/database/enable-near-real-time-notifications-from-amazon-aurora-postgresql-by-using-database-triggers-aws-lambda-and-amazon-sns/

From Core Banking to Componentized Banking: Temenos Transact Benchmark with MongoDB

Read: https://www.mongodb.com/blog/post/from-core-banking-componentized-banking-temenos-transact-benchmark-mongodb