PostgreSQL 16 was officially released by the PostgreSQL Global Development Group on September 14, 2023, with significant improvements in logical replication, parallel queries, and bulk data loading. With ScaleGrid’s managed PostgreSQL DBaaS solution, businesses can effortlessly scale their workloads, gain actionable insights, and ensure optimal data management. PostgreSQL 16 New Features Key features of…
MongoDB ACID Transactions – Keep your Data Safe
Most popular relational databases today support “ACID” properties – Atomicity, Consistency, Isolation and Durability. Developers and DBAs (Database Administrators) working with databases have a good understanding of ACID behavior. However, when working with NoSQL databases like MongoDB cloud, there are some key differences that are important for you to understand. MongoDB offers great flexibility in…
Introducing pgVector Integration for PostgreSQL
Palo Alto, California – September 8, 2023 – ScaleGrid, a leading multi-cloud provider specializing in managed database solutions, proudly announces the integration of pgVector for PostgreSQL. This innovative feature places PostgreSQL at the cutting edge of AI and machine learning capabilities, empowering businesses to leverage vectorized data for superior application experiences. About pgVector in ScaleGrid’s…
[Tutorial] How to Connect DBeaver to MySQL
DBeaver stands out as a leading open-source database management tool, supporting MySQL, SQL Server, and various NoSQL databases. When it comes to connecting DBeaver to these databases, the process is seamless, making it an indispensable tool for database administrators and experts. Why Use DBeaver for MySQL? The synergy between DBeaver and MySQL offers database…
Redis vs. MongoDB Performance Comparison with Percona Memory Engine
In this post, we’re comparing two of the most popular NoSQL databases: Redis (in-memory) and MongoDB (Percona memory storage engine). Redis: A Fast and Powerful In-Memory Key-Value Store for Caching Redis is a popular and very fast in-memory database structure store primarily used as a cache or a message broker. Being in-memory, it’s the fixed data…
How to Connect PostgreSQL Database in Node.js
In today’s digital era, data-driven applications are becoming increasingly prevalent, making it essential for developers to efficiently manage databases. Node.js, a popular runtime environment, offers seamless integration with various databases, including PostgreSQL. This article aims to provide a comprehensive step-by-step guide on connecting PostgreSQL with Node.js, enabling you to harness the power of this robust…
Connect MySQL to Power BI – Step by Step
In today’s data-driven world, organizations rely heavily on data analysis and visualization to make informed decisions and gain a competitive edge. Microsoft Power BI and MySQL are two powerful tools that can facilitate this process. In this article, we will explore the process of how to connect MySQL to Power BI, a leading business intelligence tool.
What’s new at ScaleGrid – August 2023
We’ve got a few new features and updates to share with you this month! We have been focusing a lot on PostgreSQL this past month, and we also have a brand new customer story we’d like to share with you. Without further ado, let’s get started with the new PostgreSQL updates. pgVector Support pgVector is…
Mastering Disk Space Management with MongoDB Storage Engines
MongoDB offers several storage engines that cater to various use cases. The default storage engine in earlier versions was MMAPv1, which utilized memory-mapped files and document-level locking. This allowed for sequential access and indexed access, but random writes could cause performance issues. The newer, pluggable storage engine, WiredTiger, addresses this by using prefix compression, collection-level…
What’s new at ScaleGrid – July 2023
June was a productive month for our engineering team, with several new additions to our DBaaS that we’d like to share with you. We have a bunch of new data centers you can deploy to, including new Akamai data centers, as well as an exciting new addition in the form of AWS Local Zone support…