In this post, we will walk through an example of how to replicate and synchronize your data from on-premises MySQL to BigQuery using change data capture (CDC). Data warehouses have traditionally been on-premises services that required data to be transferred using...
First released in 1997, PostgreSQL is in its twenties—quite something in the fast-paced software industry. Despite its age, PostgreSQL is the second most-used relational database system in the world, and has won (for the second consecutive time) the DBMS of the...
SQL transactions can feel like magic at first: they seem to enable a giant Ctrl-Z/undo on data access. Nevertheless, concurrency issues still exist when multiple queries happen at the same time, and you must wield the mighty TRANSACTION ISOLATION LEVEL to vanquish...
Most software developers who have coded systems that require inter-process communication (whether for asynchronous message-driven systems or for synchronous request/reply services) use the beloved JavaScript Object Notation (JSON) as the message payload format of...
InterSystems IRIS supports a unique data structure, called globals, for information storage. Essentially, globals are persistent arrays with multi-level indices, having several extra capabilities—transactions, quick traversal of tree structures, and a...
