DBplatz - Database News. Read our handpicked database-related articles. Where all databases are welcome. SQL and NoSQL. Windows, Linux and MacOS. #useThemAll


In the current year, one of the most popular stacks is GraphQl and Typescript (and for a while, I think). I started recently a new project, using this stack, I did some GraphQL API's using good Vanilla Javascript before, but even I'm using Typescript for few times.

  • dev.to

Discover in this article and video how BDR can be easily and quickly deployed on Kubernetes thanks to our Cloud Native BDR Operator. BDR is a full mesh replication solution for PostgreSQL databases developed by 2ndQuadrant that provides both high availability and multi-master capabilities.

  • 2ndquadrant.com
  • Gabriele Bartolini

Today’s video demonstrates Podman’s ability to generate and play Kubernetes YAML files. This is based on the following article.

  • oracle-base.com
  • Tim...

Recommendation engines have become a crucial component of modern applications of all types. This core need has triggered a shift from relational and big-data approaches to graph-based technologies that are purpose-built to handle the rigorous demands of real-time recommendations.

  • neo4j.com
  • Navneet Mathur

Choosing the right E-T-L tool can be difficult based on the many data integration offerings from Microsoft’s ever-growing Data integration ecosystem.

  • mssqltips.com
  • Ron L'Esteve

I've heard it dozens of times, in more places than I can remember. Usually frontend devs are more inclined to think so than their backend counterparts, and for a good reason: there's still room for improvement when it comes to frontend unit testing.

  • dev.to

8th Jun 2020

Wow, this feels nice. I am finally posting my first DEV Post and it definitely feels satisfying. Now now, enough about me. Diving straight into the topic.

  • dev.to

It is a well-known fact that MSSQL databases have ruled the world of data technologies and have been the primary source of data storage for over four decades. Generally, the MSSQL database is used mainly for accessing relational databases.

  • severalnines.com
  • Mani Yangkatisal

. After reading the https://cloudwars.co/oracle/oracle-deal-8×8-larry-ellison-picks-amazons-pocket-again/ paper, I am writing some thoughts about how a database can be serverless and elastic. Of course, a database needs a server to process its data.

  • blog.dbi-services.com
  • Franck Pachot

In this blog post, we are going to study a short overview of some data structures specific to Python3. Python has four basic inbuilt data structures: Lists, Dictionary, Tuple, and Set. We will see how to use each of them and how they make life easier for us.

  • dev.to

This article is about why I think everyone (Software Developers) should learn Git but before we delve into this proper, I want us to explore briefly what Git is.

  • dev.to

Leverage the Couchbase Eventing Service to run multiple scheduled tasks at specific recurring intervals in a cron like fashion completely inside the Couchbase database.

  • dzone.com
  • Jon Strabala

Originally written at: https://jayachandrika.

  • dev.to

While helping to build out Stripe, one of the payment startup’s early hires, Anurag Goel, realized the company was spending way too much time and money on the mundane aspects of managing Amazon Web Services. And too much of it was a black box to even top engineers.

  • thenewstack.io
  • Susan Hall

Prior to diving into this error, it’s important we discuss how Oracle processes queries logically and in what order. Oracle has a couple of rules as to how it executes each query in a specific processing order. Oracle processes a query as below:

  • virtual-dba.com
  • Joe Patton

What can you learn about 2020 database trends from StackOverflow latest survey? The survey results from StackOverflow's developers survey are already here, and we can now declare the most popular databases for 2020.

  • eversql.com

In this article, we will learn the basics of Parallel Execution Plans, and we will also figure out how the query optimizer decides to generate a parallel query plan for the queries. Let’s first look at how a query is executed and the role of the query optimizer in this process.

  • sqlshack.com
  • Esat Erkec

In this article, learn more about graph databases and the power of connected data. Published with permission from Terry Franklin. In today's economy, more and more companies exist primarily online.

  • dzone.com
  • Michael Bogan

Sometimes PostgreSQL users get errors and warnings and they are unable to understand why. To cater to these situations, this blog will cover some common errors and warnings in PostgreSQL. In some cases, it is a user setting problem or query error, but in other cases, it can be a PostgreSQL bug.

  • percona.com
  • Ibrar Ahmed

I’m working on a project where it’s useful to automate environment setup and teardown for testing some devops deployment scenarios for databases using transactional replication.

  • littlekendra.com

Backup of Database is the pillar of our system which is necessary and mandatory to provide us data incase of crash, new machine provisioning and many other scenarios listed here.

  • mysql-ninjas.blogspot.com

Not everyone brings to the table years of data modeling experience when working with document databases. We’ve seen that when relational modeling patterns are implemented in MongoDB, applications don’t run as efficiently and cost-effectively as possible.

  • mongodb.com

Recently we have setup Orchestrator in High Availability mode using RAFT. We are running a 3 node setup in which there used to be a leader and rest 2 are Healthy raft member.

  • mysql-ninjas.blogspot.com

TPAexec is an orchestration tool that uses Ansible to build Postgres clusters that follow Trusted Postgres Architecture (TPA). TPA basically includes a set of recommendations from 2ndQuadrant about how to set up a Postgres cluster in various scenarios.

  • 2ndquadrant.com
  • Bilal Ibrar

RDS provide automatic backup feature. This feature will backup the entire RDS instance. As a DBA sometimes you need to backup individual database, they are many reason for that (legal, migration, replication,…). Unfortunately individual database backups are not available within the RDS instance.

  • blog.dbi-services.com
  • Christophe Cosme

Having a backup plan is a must when running a database in production. Running a backup every day, however, can eventually lead to an excess of backup storage space, especially when running on premises.  One popular option is to store the backup files in the cloud.

  • severalnines.com
  • Agus Syafaat

Over the last 18 months, we have launched AMD-powered M5a and R5a/M5ad and R5ad, and T3a instances to provide customers additional choice for running their general purpose and memory intensive workloads.

  • aws.amazon.com
  • Channy Yun

DigitalOcean is a cost-effective cloud provider that caters to, and is widely adopted by the developer community. ScaleGrid is a fully managed DBaaS that supports MySQL, PostgreSQL and Redis™, along with additional support for MongoDB® database and Greenplum® database.

  • scalegrid.io

4th Jun 2020

Originally published at https://www.wisdomgeek.com on June 2, 2020. Developing APIs for the web has never been an easy task for developers. REST has been the defacto standard for designing web APIs for the last decade.

  • dev.to