Systems | Development | Analytics | API | Testing

Now in preview, BigQuery search features provide a simple way to pinpoint unique elements in data of any size

Today, we are excited to announce the public preview of search indexes and related SQL SEARCH functions in BigQuery. This is a new capability in BigQuery that allows you to use standard BigQuery SQL to easily find unique data elements buried in unstructured text and semi-structured JSON, without having to know the table schemas in advance. By making row lookups in BigQuery efficient, you now have a powerful columnar store and text search in a single data platform.

Interview With Author and Adobe Creative Director Chris Duffey

In the latest instalment of our interviews speaking to leaders throughout the world of tech, we’ve welcomed Chris Duffey, who leads Strategic Development at Adobe. Chris spearheads Adobe's Creative Cloud strategic development partnerships across the Creative enterprise space and has been profiled by The Wall Street Journal, The Guardian, Inc., Adweek, Adage, Cheddar, The Mirror, The Drum, Campaign and CMO.com.

Principles of Object-Oriented Programming in TypeScript

Object-oriented programming (OOP) is hard to achieve in a dynamic prototypical language like JavaScript. You have to manually stick to OOP principles because of language features like duck typing. This requires discipline, as nothing in the language enforces the principles. If a diverse team of developers with different backgrounds is involved, a codebase filled with good intentions can quickly become one chaotic mess.

Ably migrates to Graviton2

Ably provides an edge messaging service to deliver data at low latency and power live and collaborative applications on millions of simultaneously connected devices. Our platform runs tens of millions of concurrent, long-running WebSocket and HTTP streaming connections and reaches more than 300 million devices across 80 countries each month. Ably is on track to power realtime digital experiences for one billion devices per month by 2024.

Google Cloud names ThoughtSpot a Google Cloud Ready - BigQuery company to help customers dominate the decade of data

We’re entering the defining decade of data. While every aspect of our lives have been changed by data in recent years, the next ten will see data rebuild the world around us. Every business, in every industry, needs a plan to adapt to this new world if they want to thrive. But how? That’s a question in the minds of data leaders, CEOs, and board members. The right approach is critical if companies want to dominate this new era. The wrong decision can spell disaster.

Updates from Bugfender, Q1 2022

In June, more than 200,000 people will gather at one of the most emblematic festivals in Barcelona: Primavera Sound. In addition to pleasing the visitors (which is easy considering the line-up), the organizers must ensure that the sound levels do not disturb the neighbors in the area, something complicated considering it is an open-air festival. That’s where EmmaDB comes in.

Error Reporting: Improving Outcomes with Proactive Identification

Errors happen. Despite best efforts, no piece of software is perfect. Unintentional issues with code, updates to existing frameworks, or unexpected interactions with other tools can all cause errors. As a result, it's critical for companies to deploy robust and reliable error reporting processes that help them proactively identify potential issues and improve operational outcomes.

SQL Puzzle Optimization: The UDTF Approach For A Decay Function

How do you implement a decay function in SQL? You can use window functions, which scale better than joins, or better yet, you can try what Felipe Hoffa did: use tabular UDFs. In this video, Felipe shows you how you can use a tabular UDF to write custom code that can analyze a table row by row while preserving state. Felipe wrote a table UDF in JavaScript that uses a low amount of memory to keep track of the decaying values. He was able to run it in 36 seconds, instead of the 46 seconds that the SQL with windows solution took; and then he optimized the JavaScript even further and ran it in just 9 seconds.