The Developer Space

MySQL is an RDBMS platform that stores data in a tabular format in a normalized manner, whereas, MongoDB is a NoSQL database that stores information in the form of documents that are grouped under collections. The representation of data is completely different and hence migration of MySQL table data to MongoDB collections might sound like a mammoth task. Fortunately, Python makes it a breeze with its strong connectivity and data handling capabilities.

Are you looking for resources to get started with migrating SQL Server Databases to PostgreSQL? This is the book for you. This concise eBook is intended to be a ready reference and a checklist for migrating your databases, applications and services from Microsoft SQL Server to PostgreSQL and discusses all the important information you need to be aware of before beginning a migration project.

One of the major challenges in Cloud is controlling costs effectively. This article discusses various strategies you can adopt to set up and operate non-critical workloads of your databases with minimal cost.

This article describes different ways of setting up generated (computed) columns in different versions of PostgreSQL.

This article walks you through the summary of most important new features. enhancements and breaking changes in PostgreSQL 12.

This article describes the new Stored Procedure feature in PostgreSQL 11.5 and shows you how it differs from Functions.

This post explains a neat way to check if your are running on open source PostgreSQL or AWS Aurora (PostgreSQL compatible)

This article describes a simple and elegant way to allow write access to ASP.NET apps to the App_Data folder. This is required for applications to work properly when deployed in AWS Beanstalk.

DbStudio is a Database access tool that enables you to connect to a wide variety of databases. It is designed…