-
Sep 12, 2024 | 
smashingmagazine.com | Paul Scanlon
16 min readData Visualization,Workflow,UX,DesignShare on Twitter, LinkedInBringing data to life in your application can be done without the usual headaches. Paul Scanlon shows you how you can build beautiful data visualizations using the Google Analytics API, and you won’t have to spend any time “massaging” the data.
-
Sep 6, 2024 | 
smashingmagazine.com | Paul Scanlon
11 min readWorkflow,Analytics,User ResearchShare on Twitter, LinkedInGoogle Analytics is often on a “need to know” basis, but why not flip the script? Paul Scanlon shares how he wrote a GitHub Action that queries Google Analytics to automatically generate and post a top ten page views report to Slack, making it incredibly easy to track page performance and share insights with your team. Google Analytics is great, but not everyone in your organization will be granted access.
-
Jul 4, 2024 | 
paulie.dev | Paul Scanlon
Thursday, July 4, 2024 By Paul Scanlon PostgreSQL GitHub Actions If youāve ever connected to a PostgreSQL database that required an SSL certificate, youāll have probably downloaded the certificate and added it to you key chain, or provided a path to the .pem file in the connection credentials or string.
-
Jun 27, 2024 | 
thenewstack.io | Paul Scanlon |Michelle Gienow |David Cassel |Vidya Shankaran
With React’s evolving ecosystem, particularly with Next.js shifting toward a “server-first” approach, applications using CSS-in-JS solutions like Emotion and styled-components are facing significant challenges. These CSS-in-JS libraries are inherently incompatible with the new React paradigm. While one could argue these libraries could be updated to align with the new server-first direction, it’s important to remember that they’re maintained by unpaid open source contributors.
-
Jun 21, 2024 | 
thenewstack.io | Paul Scanlon |Jack Wallen |Loraine Lawson |Darryl Taft
In this article, we’ll demonstrate how to write a GitHub Action that queries a data-centric software system — in this example, Google Analytics — to generate an automated Slack notification and message.
-
May 29, 2024 | 
thenewstack.io | Paul Scanlon |Joe Fay |Mike Barborak |Usama Jamil
The need for standardization is all around us, but on occasion, the JavaScript ecosystem — or rather, the tools and services built using JS — have a tendency to stray off course, which can cause disruption in the ecosystem. In this article I’ll be discussing JavaScript clients and SDKs for SQL databases where I’ve encountered issues. I’ll ask the question: Should SaaS database providers consider dropping support of their own clients in favor of backing Drizzle ORM?
-
May 22, 2024 | 
thenewstack.io | Paul Scanlon |Joe Fay |Mike Barborak |Usama Jamil
Drizzle ORM is described by its makers as “a headless TypeScript ORM with a head.” But what is an ORM? The abbreviation ORM is short for “object-relational mapping,” which is a programming technique used to convert data between incompatible type systems. In the case of Drizzle ORM, this means converting types from SQL to TypeScript.
-
May 16, 2024 | 
thenewstack.io | Paul Scanlon |David Cassel |Mary Branscombe |Amanda Kelly
Hello. You’re a JavaScript developer, right? Would I also be right in assuming that you don’t know SQL, and you don’t want to learn SQL? In this article, I’d like to introduce you to Outerbase which, among other things, allows you to create, edit, visualize and explore the data in your database — all without having to write SQL. More on that in just a moment, but first, let’s address the elephant in the room (pun intended)JavaScript developers are running out of excuses not to learn SQL.
-
May 5, 2024 | 
blog.stackblitz.com | Paul Scanlon
If you’re building a product, you’ll no doubt be familiar with the concept of design systems and component libraries. Using a predefined “set” of components allows users to more easily and more efficiently develop user interface (UI) features that are on brand and meet accessibility requirements. Components are often the most important part of any design system.
-
May 1, 2024 | 
thenewstack.io | Paul Scanlon |Loraine Lawson |Liam Crilly |Cameron Carlin
I’ve been doing a lot of work in and around PostgreSQL for JavaScript developers lately, and my general understanding is that JavaScript developers will do absolutely anything to avoid writing code that isn’t JavaScript. They’ll put their CSS in JavaScript, HTML in Jsx and now SQL in JavaScript!This is what I’m talking about. This syntax doesn’t have an official name, and in the case of Supabase, it’s an abstraction on top of PostgREST.
