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.

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.

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.

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.

Database-driven realtime architectures are becoming more and more common as evidenced by key backers and widespread use of software like Firebase and Supabase. The two key priorities for an app following database-driven realtime messaging are long-term storage and change data capture (CDC) updates from the database. In this two part article series, we’ll take a detailed look at a fully serverless chat app where you can edit previously published messages.

Ever since E. F. Codd introduced the first relational model for storing data at IBM in 1970, the industry has picked up the database technology and used it for its competitive advantage. The relational database management system - or RDBMS - was the default technology for storing and accessing data for a long time. It supported transactional data storage, the building of data products, and was the go-to model for data that was used in data-driven decisioning.

MongoDB vs DynamoDB: How do you choose between them? Whether you are a two-man team bootstrapping a proof of concept or an established one battling with high throughput and heavy load; this post can serve as a guidepost in your decision process. Before going into the details, a brief history lesson on how these technologies emerged is pertinent; you must understand the optimal conditions for running these systems and how they operate in the wild before making an informed choice.

The world of big data is getting bigger every day. As the volume of data increases exponentially, businesses of all sizes try to capture raw data, process it, and extract insights for competitive decision-making. The end-to-end operation of extracting value from data is called the ETL process. It stands for: A crucial component of the ETL process is the data storage aspect. The two main contentious architectures for storage solutions are databases and data warehouses. But how do they differ?

In this guide, we'll discuss what a database schema is, six database schema designs, and how and why they are used. We know a lot of thought goes into database construction. Before creating any database, developers plan what it should include and how the different aspects work together. This planning ensures a database has the necessary design for its intended use. Coders then use the schema to implement the database’s design.

Built by our long-time community expert Apoorv Vardhan, the Ably-Postgres connector can listen to changes in a Postgres table and publish realtime messages on Ably channels whenever a change occurs. The connector enables building database-driven realtime applications where long-term storage and update triggers from previously published messages are essential. One such example is an editable chat app, which we’ll talk about later in this article.