The Developer Space

Developer's Cafe

  • Cloud
  • Database
  • Open Source
  • Programming
  • Web Dev
  • Mobile
  • Security
  • QuickRef
  • Home
  • Database

Category: Database

Book: Migrate your SQL Server Workloads to PostgreSQL: Quick Reference – Second Edition

Book: Migrate your SQL Server Workloads to PostgreSQL: Quick Reference – Second Edition

Shameel Ahmed
October 18, 2022October 22, 2022 1 Comment

The First Edition of this book was released in May 2020, about two and a half years ago. Since its…

How to fix Redis Error “ERR DEBUG command not allowed.”

How to fix Redis Error “ERR DEBUG command not allowed.”

Shameel Ahmed
July 4, 2022July 5, 2022 No Comments

While developing apps using Redis, if you are trying to use the command DEBUG and Redis throws the error “ERR DEBUG command not allowed.”, here’s how you fix it.

Migrate MySQL table data to MongoDB collections using Python

Migrate MySQL table data to MongoDB collections using Python

Shameel Ahmed
June 18, 2021June 25, 2021 1 Comment

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.

Book: Migrating your SQL Server Workloads to PostgreSQL

Book: Migrating your SQL Server Workloads to PostgreSQL

Shameel Ahmed
May 5, 2020October 22, 2022 No Comments

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.

Minimize Non-Critical Database Workload costs in AWS

Shameel Ahmed
April 23, 2020April 24, 2020 4 Comments

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.

Generated Columns in PostgreSQL

Shameel Ahmed
September 18, 2019April 18, 2021 No Comments

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

PostgreSQL 12: New Features and Enhancements

PostgreSQL 12: New Features and Enhancements

Shameel Ahmed
September 16, 2019September 21, 2019 No Comments

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

PostgreSQL finally gets Stored Procedures

PostgreSQL finally gets Stored Procedures

Shameel Ahmed
September 12, 2019September 21, 2019 No Comments

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

Check PostgreSQL Edition

Check PostgreSQL Edition

Shameel Ahmed
July 29, 2019September 21, 2019 No Comments

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

Restrict access to SQL Server Data using a Facade Database

Restrict access to SQL Server Data using a Facade Database

Shameel Ahmed
July 25, 2019September 21, 2019 No Comments

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 (beta) Launched

DbStudio (beta) Launched

Shameel Ahmed
May 12, 2018September 21, 2019 No Comments

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

Categories

.NET Architecture Artificial Intelligence ASP.NET AWS Azure Books C# Career Cloud CodeProject Conversational Bots Database Data Security Facade IDEs Java Mobile MongoDB MySQL Open Source Patterns PostgreSQL Programming Python Redis Security SQL Server Tools Uncategorized Web Development Windows Phone

Recent Posts

  • Developer to Architect Series (Red Hat Enable Architect) January 16, 2023
  • Can ChatGPT replace Google Search? January 11, 2023
  • Learn Python with ChatGPT December 26, 2022
  • Book: Migrate your SQL Server Workloads to PostgreSQL: Quick Reference – Second Edition October 18, 2022
  • Increase Visual Studio Code Terminal Buffer Size July 14, 2022

Archives

  • January 2023 (2)
  • December 2022 (1)
  • October 2022 (1)
  • July 2022 (2)
  • February 2022 (1)
  • November 2021 (1)
  • July 2021 (1)
  • June 2021 (1)
  • September 2020 (1)
  • May 2020 (2)
  • April 2020 (1)
  • October 2019 (1)
  • September 2019 (4)
  • July 2019 (2)
  • May 2018 (1)
  • September 2017 (1)
  • April 2017 (1)
  • April 2014 (1)
  • August 2011 (1)
  • June 2009 (1)
Copyright 2022. The Developer Space | Theme: OMag by LilyTurf Themes
  • DbStudio
  • Re:Link
  • shameel.net
  • Privacy Policy
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
SAVE & ACCEPT