Databases

Migrate Heroku Postgres Databases Without Problems

Nov 3, 2021 By Mark Smallcombe In Integrate

Heroku Postgres databases are powerful tools for managing and analyzing data. You can run large-scale data processes for your business off of Heroku Postgres. While management is made much simpler with Heroku, the insight of a skilled developer and data analyst when manipulating databases makes a big difference in the outcomes. This is especially true when migrating a database. Here are five things you need to know about migrating Heroku Postgres databases.

Read Post

Integrate

Read more about Migrate Heroku Postgres Databases Without Problems

What is a MySQL REST API?

Nov 3, 2021 By Mark Smallcombe In Integrate

Databases are an important part of application development. They let you store data in a way that is easy to manage and manipulate. MySQL has been the standard for this for decades. The one drawback is that databases only store data. If you want to do something with that data, a MySQL REST API makes it possible. Here is what you need to know to use MySQL REST APIs in your projects.

Read Post

Integrate

Read more about What is a MySQL REST API?

Migrating from Postgres to Amazon Redshift

Oct 29, 2021 By Abe Dearmer In Integrate

Migrating from Heroku Postgres to Amazon Redshift might sound complicated, but moving data between these two systems is easier than you think. You might need to transfer data from Postgres to Redshift for all kinds of reasons. Here are two of the most common.

Read Post

Integrate

Read more about Migrating from Postgres to Amazon Redshift

How to Setup a MySQL Connection within Xplenty

Oct 22, 2021 By Xplenty In Xplenty

In this video, we will set up a MySQL connection with Xplenty so Xplenty can read data from your MySQL databases or write data to them. Today, many are moving from a relational database like MySQL to an analytical data warehouse. Why?

View Video

Xplenty

Read more about How to Setup a MySQL Connection within Xplenty

How to Setup a Database Connection in Amazon RDS with Xplenty

Oct 22, 2021 By Integrate In Integrate

In this video, we will set up a database connection in Amazon RDS with Xplenty. AWS RDS is a feature-rich and mature offering that makes it easy for even less tech-savvy users to operate their own relational databases. Xplenty can help you gain the most benefit from your Amazon RDS deployment. Xplenty offers comprehensive data analysis and management and can integrate your Amazon RDS database with dozens of other services and products. In this way, you can use the technology stack that gives your business the greatest advantage.

View Video

Integrate

Read more about How to Setup a Database Connection in Amazon RDS with Xplenty

Integrating Snowflake with MS SQL Server using DreamFactory

Oct 20, 2021 By Tony Harris In DreamFactory

Integrating Snowflake with MS SQL Server is a common situation we see here at DreamFactory. This article will break down exactly how to integrate MS SQL server and Snowflake and what are the benefits of the integration.

Read Post

DreamFactory

Read more about Integrating Snowflake with MS SQL Server using DreamFactory

Using DynamoDB in Your Rails App

Oct 11, 2021 By Julie Kent In Honeybadger

DynamoDB is a NoSQL database offered by AWS. It can be a great way to avoid adding load to your primary database when you need tens of thousands of reads/writes per second. In this article, Julie Kent walks us through the basics of using DynamoDB with Rails.

Read Post

Honeybadger

Read more about Using DynamoDB in Your Rails App

How to Transfer Data from Postgres to Salesforce

Oct 8, 2021 By Abe Dearmer In Integrate

While Salesforce is an excellent tool for storing and managing information about your contacts, leads, accounts, and other metadata pieces, the power of the system lies in its ability to integrate with other applications. One particularly powerful integration comes from integrating data in a Postgres database into Salesforce. Read on to learn more about Heroku Postgres, Salesforce, and how to transfer data most efficiently.

Read Post

Integrate

Read more about How to Transfer Data from Postgres to Salesforce

Database-driven realtime architectures: building a serverless and editable chat app - Part 2

Oct 7, 2021 By Srushtika Neelakantam In Ably

Hello again! Welcome to Part 2 of this article series where we go through database-driven architectures by understanding the nitty gritties of a chat app where you can edit messages. Here's the Part 1 of this article series, if you missed it: Database-driven realtime architectures: building a serverless and editable chat app - Part 1 Check out the editable chat app or explore the project on GitHub.

Read Post

Ably

Read more about Database-driven realtime architectures: building a serverless and editable chat app - Part 2

An Ultimate Guide about SQL Injection for WordPress Users

Sep 30, 2021 By Janani In Atatus

The Structured Query Language (SQL) is a Relational Database Management System (RDBMS) that is pronounced like the word "sequel." It was the first simple way to store and retrieve many sorts of data on computer systems, and it was invented in 1974. Since then, the language has grown in popularity, and it is still used in many content management systems (CMS) today, such as WordPress.

Read Post