Ryan Marvinblog.ryanmarvin.dev·Oct 1, 2024Zero Downtime Postgres Database Migration from GCP to AWS RDSIn 2023, I was working at a company where we were running our Elixir backend on Gigalixir. Gigalixir is a PaaS similar to Heroku that at the time we were using provided its managed database service for Postgres via GCP (Google Cloud Platform). I foun...Discuss·41 readsgigalixir
Anthony Nzukitonynzuki.hashnode.dev·Aug 15, 2024Securely Hosting MySQL with Amazon RDS in Your AWS VPCIntroduction In this blog post, we will explore how to create a MySQL database. We will first have to create a VPC for a couple of reasons: A VPC provides network isolation, meaning your RDS instance is not exposed directly to the internet. You cont...Discuss·135 readsAWS
Cheng Yongfreeman983.hashnode.dev·May 31, 2024A new way of managing databasesDiscover a Novel Data Management Platform: SQLDev In the field of data management, there are many well-known and widely used platforms. For example, the Oracle Database Management System, Microsoft SQL Server, IBM Db2, MySQL, and open-source options ...DiscussDesensitization
Shiv IyerProshiviyer.hashnode.dev·Mar 9, 2024Guide to Importing Data from Spreadsheets into PostgreSQL ServerLoading data from a spreadsheet into a PostgreSQL server can be accomplished through several methods, depending on the format of your spreadsheet and your working environment. Here's a guide to help you with this task, assuming your spreadsheet is in...Discuss·195 readsPostgreSQL
ReadySetreadyset.hashnode.dev·Jan 26, 2024Stateful Property Testing in RustMost developers have written unit tests: you feed your code some inputs and verify the outputs. Property tests automate this process. Instead of manually creating inputs, your test generates them for you and validates the input/output pairs against a...DiscussRust
Matej Zamecnikdatalisk.hashnode.dev·Jan 23, 2024Oracle Database Redo Logs StoryFrom time to time, I am called to check DB performance for various clients, and quite often, I observe a similar pattern: - The DB can’t handle higher traffic.- There is currently no DBA, and maybe never was.- It has been an issue from the start, b...DiscussOracle
Travis Horntravishorn.com·Dec 20, 2023Getting Started with MariaDBMariaDB is a great open-source relational database management system. This article will walk you through the process of installing and configuring MariaDB, creating database users, granting appropriate privileges, and enabling remote connections. Wit...Discuss·160 readsMariaDB
Ian Carsoniancarson.hashnode.dev·Dec 13, 2023Database Roadmap.The database is a wide field yet very important. Every application and system uses some sort of database. Below are concepts and topics that one should be familiar with. Data Modelling- This concept refers to how data is curated and handled and the ...Discussdatabase design
Richmond Damaghateryx.hashnode.dev·Sep 12, 2023Fundamental Snippet: Database Backup and RecoveryDatabase backups are crucial for safeguarding data, ensuring business continuity, and meeting regulatory requirements. They provide a safety net to recover from various types of data loss scenarios, helping organizations maintain data integrity and o...Discussdata-engineering
Data Senseisihan.hashnode.dev·Jun 16, 2023SQL: Scalar Subquery with Case When... Else...Lets first create a table: Create database blog_port; use blog_portal; -- Create the Employee table CREATE TABLE Employee ( employee_id INT, team_id INT, PRIMARY KEY (employee_id) ); -- Insert the data into the Employee table INSERT INTO ...Discuss·58 readsSQL
