February 2023 Summaries

Visual Studio Code (VSCode) has become the preferred integrated development environment (IDE) for 71% of developers, significantly overshadowing the second choice, Visual Studio, at 33%, according to a StackOverflow survey. Recognizing a gap in syntax highlighting for Tinybird data projects, which are intended to be managed like typical code with versioning and CI/CD, a developer decided to create a syntax highlighter for VSCode. This newly developed tool provides syntax highlighting for .datasource and .pipe files and is now available in the VS marketplace. The initiative aims to enhance the ease and enjoyment of managing data projects, aligning them with the treatment of traditional code projects, and the developer invites feedback from users of other IDEs who might benefit from similar functionality.

An introvert working from home explored the cultural and linguistic functions of emojis worldwide by analyzing Twitter data over the course of 2022, using a simple script to ingest tweets via the Twitter streaming API to a Tinybird account. The project tracked the most used emojis for each hour of the year, revealing the sob emoji as the most frequently used, twice as much as any other. Significant global events throughout 2022 were marked by emojis, including the Winter Olympics, Russia's invasion of Ukraine, and Argentina's World Cup victory. The analysis covered over 1 billion tweets, processing more than 1.6 billion emojis, and highlighted the year's emotive digital expressions. Additionally, Tinybird experienced a successful year, with advancements in their platform and business growth, looking forward to new opportunities in 2023.