Remove Database Remove PostgreSQL Remove SQL
article thumbnail

Top 8 Interview Questions on Apache Sqoop

Analytics Vidhya

Apache Sqoop stands for “SQL to Hadoop,” and is one such tool that transfers data between Hadoop(HIVE, HBASE, HDFS, etc.) and relational database servers(MySQL, Oracle, PostgreSQL, […] The post Top 8 Interview Questions on Apache Sqoop appeared first on Analytics Vidhya.

Hadoop 228
article thumbnail

Shining Some Light In The Black Box Of PostgreSQL Performance

Data Engineering Podcast

Summary Databases are the core of most applications, but they are often treated as inscrutable black boxes. When an application is slow, there is a good probability that the database needs some attention. It’s the only true SQL streaming database built from the ground up to meet the needs of modern data products.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Building An Internal Database As A Service Platform At Cloudflare

Data Engineering Podcast

In the era of the cloud most developers rely on hosted services to manage their databases, but what if you are a cloud service? In this episode Vignesh Ravichandran explains how his team at Cloudflare provides PostgreSQL as a service to their developers for low latency and high uptime services at global scale. Why Postgres?

Database 130
article thumbnail

Cloud Data Warehouse Migrations: Success Stories from WHOOP and Nexon

Snowflake

Before it migrated to Snowflake in 2022, WHOOP was using a catalog of tools — Amazon Redshift for SQL queries and BI tooling, Dremio for a data lake, PostgreSQL databases and others — that had ultimately become expensive to manage and difficult to maintain, let alone scale.

article thumbnail

WebSockets in Scala, Part 2: Integrating Redis and PostgreSQL

Rock the JVM

We’ll also need to insert messages into our database, for this we’ll need another case class, create a message.scala file under domain , and add the following code: package rockthejvm.websockets.domain import java.util.UUID import java.time.LocalDateTime import rockthejvm.websockets.domain.user. object message {. object message {.

article thumbnail

Stop Overcomplicating Data Quality

Towards Data Science

TL;DR Take advantage of old school database tricks, like ENUM data types, and column constraints. And would you believe all of this was available to us since the release of PostgreSQL 6.5 Ultimately, all you need for dynamic data lineage is a machine that scans your SQL files, and something to output a user-friendly lineage map.

article thumbnail

PostgreSQL Import CSV: 3 Easy Methods

Hevo

A popular open-source relational database used by several organizations across the world is PostgreSQL. It is a perfect database management system that also assists developers to build applications, and administrators to protect data integrity and develop fault-tolerant environments. […]