article thumbnail

Citus Data: Distributed PostGreSQL for Big Data with Ozgun Erdogan and Craig Kerstiens - Episode 13

Data Engineering Podcast

Summary PostGreSQL has become one of the most popular and widely used databases, and for good reason. In this episode Ozgun Erdogan, the CTO of Citus, and Craig Kerstiens, Citus Product Manager, discuss how the company got started, the work that they are doing to scale out PostGreSQL, and how you can start using it in your environment.

article thumbnail

TimescaleDB: Fast And Scalable Timeseries with Ajay Kulkarni and Mike Freedman - Episode 18

Data Engineering Podcast

release of PostGreSQL had on the design of the project? release of PostGreSQL had on the design of the project? Can you start by explaining what Timescale is and how the project got started? The landscape of time series databases is extensive and oftentimes difficult to navigate. What impact has the 10.0 What impact has the 10.0

Insiders

Sign Up for our Newsletter

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

Trending Sources

article thumbnail

RDBMS vs NoSQL: Key Differences and Similarities

Knowledge Hut

Making decisions in the database space requires deciding between RDBMS (Relational Database Management System) and NoSQL, each of which has unique features. RDBMS uses SQL to organize data into structured tables, whereas NoSQL is more flexible and can handle a wider range of data types because of its dynamic schemas. What is NoSQL?

NoSQL 52
article thumbnail

How to query JSONB array of objects in PostgreSQL

Hevo

Do you have a NoSQL database that has no rigid shape and is causing data analysis complexity nightmares? With JSON in PostgreSQL, you can have a solution to your complex problem. PostgreSQL is a high-performing, open-sourced object-relational database with two JSON data storage types, JSON and JSONB.

article thumbnail

CockroachDB In Depth with Peter Mattis - Episode 35

Data Engineering Podcast

I know that your SQL syntax is PostGreSQL compatible, so is it possible to use existing ORMs unmodified with CockroachDB? I know that your SQL syntax is PostGreSQL compatible, so is it possible to use existing ORMs unmodified with CockroachDB? What are the edge cases and failure modes that users should be aware of?

article thumbnail

Why Real-Time Analytics Requires Both the Flexibility of NoSQL and Strict Schemas of SQL Systems

Rockset

So are schemaless NoSQL databases, which capably ingest firehoses of data but are poor at extracting complex insights from that data. Take PostgreSQL , the popular transactional database that many companies have also used for simple analytics. NoSQL Comes to the Rescue. The same problems face the NewSQL database, CockroachDB.

NoSQL 52
article thumbnail

Popular PostgreSQL Tools to Know in 2024

Knowledge Hut

In the database ecosystem, Postgres is one of the top open-source databases, and one of the most widely used PSQL tools for managing PostgreSQL is pgAdmin. To run PostgreSQL instances on the Azure cloud, Azure offers Azure Database for PostgreSQL. What are PostgreSQL Tools? Why Use a GUI Tool?