In the second part of this blog series on PostgreSQL and YSQL date-time data types, the focus shifts to representing durations, or how long things last. Assuming the reader has read the first part and downloaded the companion code kit, this post explores the relevant data types, including interval, timestamp difference, and other related functions.
This is the first of a two-part blog post series that deals with the basic business of representing moments using time, date, and timestamp data types. YugabyteDB’s YSQL subsystem provides a similar experience to PostgreSQL, so the topic may still be enlightening for some YSQL users.
PostgreSQL has eaten the world. And so Yugabyte set out to build the most Postgres-compatible, scalable, and resilient database. YugabyteDB is not only wire compatible with PostgreSQL, it is code compatible by reusing the upper half of PostgreSQL. Thanks to this compatibility, YugabyteDB can connect to the vast majority of database tools that integrate with Postgres.
In a previous blog post, Yugabyte Developer Advocate Franck Pachot showed how to connect YugabyteDB in Arctype.
…
In this blog post, we’ll explore why Abra Controls needed a new database. We’ll detail why it chose YugabyteDB. We’ll then discuss how the company used YugabyteDB Managed to implement its IoT application.
Welcome back to our tips and tricks blog series! I have the distinct pleasure of recapping distributed SQL questions from around the Internet for the month of December.
This ongoing series would not be possible without Dorian Hoxha, Franck Pachot, and Frits Hoogland. We also thank our incredible user community for their work with the technology.
Do you have any questions?
…
Learn how to integrate Temporal and Maru with the YugabyteDB database to run sample workflows and operate resilient applications using developer-friendly primitives.
Welcome back to our tips and tricks blog series! With October officially a wrap, I have the pleasure of recapping some distributed SQL questions from around the Internet. There was no Tips and Tricks edition for September as the Yugabyte team was focused on our 2021 Distributed SQL Summit. If you did not have a chance to check it out, you can view the sessions on-demand.
As always,
…
At Distributed SQL Summit 2021, we presented a workshop on how to build an application using the YugabyteDB Spark Connector and YugabyteDB to deliver business outcomes for our customers.
The YugabyteDB Spark Connector brings together the best of breed technologies Apache Spark — an industry-leading, distributed computing engine — with YugabyteDB, a modern, cloud-native distributed SQL database. This connector allows customers to seamlessly and natively read from, perform complex ETL,
…
In this blog post, you’ll learn how to implement a timer for multi-statement operations using SQL with YugabyteDB or PostgreSQL. These tools are commonly used for various tasks, but their native timing feature only times individual SQL statements and doesn’t support end-to-end timing or output to spool files.
A few weeks ago, Yugabyte CEO Bill Cook and I had the pleasure of speaking with Paul Gaffney, the CTO and Chief Supply Chain Officer of Kohl’s during a virtual fireside chat as part of our Catalysts of Change series. Paul is a visionary tech leader with an extensive track record of driving technology change and innovation at companies like Dick’s Sporting Goods, The Home Depot, and AAA of Northern California,
…
