Systems | Development | Analytics | API | Testing

Databases

MongoDB vs. MySQL: Detailed Comparison of Performance and Speed

MongoDB and MySQL are similar is some ways, but they also have some obvious differences. Perhaps the most obvious one is that MongoDB is a NoSQL database, while MySQL only responds to commands written in SQL. Potential users may want to examine MongoDB vs. MySQL in the areas of performance and speed. The following article will help you understand the differences, as well as the pros and cons of each database.

Calling SQL Server Stored Procedures from a REST API

Using the DreamFactory API management platform it's easy to expose your database stored procedures via API endpoints. This short video demonstrates how to use DreamFactory's auto-generated API endpoints to list available stored procedures, learn more about a specific stored procedure, and call a stored procedure with several input parameters.

10 Tips to Help You Write a Flat File Database

Originally developed by IBM, flat file databases have been around since the 1970s. Because these files store data in plain text format, most people use MS Excel to create them. It’s an easy-to-use system that allows for the quick sorting of results. This is because each line of plain text has just one record. Tabs, commas, or other delimiters separate multiple records. In this article, you’ll learn some tips for optimizing your flat file.

How Xplenty Simplifies Heroku PostgreSQL Data Integration

What can you do with data collected on Heroku PostgreSQL? How will you analyze it and integrate it? With Xplenty, of course! Xplenty lets you connect to a PostgreSQL database on Heroku, design a Dataflow via an intuitive user interface, aggregate the data, and even save it back to PostgreSQL on Heroku or other databases and cloud storage services.

Which Cloud Database Platform to Choose for Your Applications

While a vital component of any app's stack is the database, managing a database is challenging and hard work. Not only do you need to set up, maintain, scale, and patch databases, but also you need to create strong backup policies, ensure sharding and replications. Long story short, managing a database is time-consuming and requires a dedicated and skilled team, which is why a major trend for managing databases is DBaaS, or Database as a Service.