Simple Python Script to Test Multiple Models & Check Responses for Keywords
A guide to building an answer engine optimization monitoring tool in Python, using OpenRouter to query multiple models and PostHog for analytics.
Building a Network Visualization from an XML Sitemap
A guide to generating an interactive knowledge graph from an XML sitemap, using the vis-network JavaScript library.
Testing UI Reproduction from Multimodal Input in Lovable, Bolt, V0, Claude, and more
Measuring performance across multiple models at replicating UIs from an image.
Add AI Chat To Any Website, Powered By Pinecone Assistants
Add AI Chat To Any Website, Powered By Pinecone Assistants
Call Gemini CLI for backup, from within Claude Code CLI
A guide on using Claude Code Hooks with the userPromptSubmit trigger to call Gemini's CLI for help when stuck
Simple Script to Generate and Save Folder Icons
A guide to adding thumbnail previews to image folders in MacOS Finder using Python.
Open Source Tool to Extract Metadata & Images Missing in Export
A Guide To Migrating Your Blog From Hashnode
A guide to building offline AI apps and dealing with CORS
In this guide, I’ll show you how you can build and run your own AI-powered apps that work completely offline, and do it without writing a single line of code. I’ll be using my favorite vibe-coding...
A How-To Guide for Dealing with EDGAR's Oddities
Hello, yes I’d like to speak to the (developer experience) manager! 🤬 ☝️That was me a few weeks ago when I first tried using the SEC API. I’ve integrated with a lot of APIs over the years, but none...
Building A Text to Cypher Agent Without A Single Line Of Code
Knowledge graphs are more than just interesting data visualizations. They’re also extremely effective as a data source for RAG (Retrieval-Augmented Generation), and can significantly improve LLM...
Automating Server Moderation with Python
Discord may be known for gaming, but it’s also widely used as a community and support forum for tech companies. Regardless of the use though, pretty much ever server has to deal with spam and scammers...
Power up your Hashnode blog with advanced features
I’ve been using Hashnode for my blog for about 5 years now. I originally chose it because it was the only option that supported connecting a custom domain for free, and 5 years later I have no...
Self-hosted Markdown Generator in Python
Markdown is a great format for storing text files that need to be compatible with multiple systems. And LLMs excel at generating Markdown. If you regularly copy/paste responses from ChatGPT to a text...
A Star Wars Themed Knowledge Graph Generator with Neo4j & JavaScript
Knowledge graphs are powerful tools to visualize and explore your data, and can help uncover new insights and patterns in how your data is related. They are easy to search and navigate, but getting...
A guide for Reddit OAuth2 flow and refresh token using Apps Script and Google Sheets
Reddit offers several different options for integrating web apps, scripts, and installed apps. Just go to https://www.reddit.com/prefs/apps/ to create a new app and select the type. In this guide,...
Dealing with 405 Method Not Allowed Errors and 302 Redirects
Google Apps Scripts is incredible for a free product. There are so many things you can automate using script triggers and Google Sheets, Gmail, Docs, Calendar, and the rest of the Google ecosystem....
Generating Cypher Queries From Text Using Python & Hugging Face
Knowledge graphs, also known as semantic networks, are a specialized application of graph databases used to store information about entities (person, location, organization, etc) and their...
A Star Trek Themed Editor Inspired by Obsidian
Markdown is used widely in programming, documentation, content creation, GitHub, and lots of other areas in tech. One of the most popular Markdown editors is Obsidian, a note taking app with an...
Building a free web site contact form with no Google branding
Google Forms is the most obvious choice when you need a simple public form to collect information into a spreadsheet. You can share a link to the form, or embed the form directly in your website. The...
Extracting Object Data from Unstructured Text
What is NER (Named Entity Recognition)? Named Entity Recognition is a technique in Natural Language Processing (NLP), which involves identifying and classifying entities—such as names of people,...
Generate Custom UI Components With Plain Text Prompts
Web viewers in FileMaker Pro are a great way to extend the platform and create new UI components that would otherwise be impossible. The results can be extremely powerful, but working with web viewers...
A year-long journey of creating weekly tutorial content and key insights for content creators
Just over a year ago, I had no real experience in recording video tutorials, or in the editing or distribution process. I had experimented with a few, but never consistently, and I had no idea what I...
A Timer-driven Inbox Defender Against Spam
I get a LOT of spam email that make it passed Google’s spam detection, and I’m constantly marking emails as spam and blocking senders. It’s a never-ending battle. Most of them end with something...
Easily extract all images from a doc and sync with matching folder
Adding images to a Google Doc is no problem, but getting them back out can be a pain. I’ve written about this before with Five Ways to Extract All Images From a Google Doc, and more recently, with...
Retrieving Data from Markdown Files using Ollama on MacOS
There are plenty of online AI services like ChatGPT that make it easy to chat with your documents, using Retrieval Augmented Generation (RAG) to improve the LLM response. But these all require sending...
Fine-Tuning a Vision Model for Picture Perfect Results
AI image generation has been around for a while now and become fairly accessible. You can ask ChatGPT or MidJourney to draw anything you can imagine, and they can create some pretty impressive...
Web Viewer solution for constructing JSON from ExecuteSQL
Recently I needed to upload some data from a local FileMaker database to a REST API as part of a migration. FileMaker’s Insert from Url script step uses curl requests for sending data to another API,...
Using Google Colab for Bulk Image Extraction to Drive
Google makes it as easy as possible to add new images to a Google Doc, with options like drag-and-drop, paste from clipboard, insert from Drive/URL, etc. But they make it surprisingly hard to get the...
Retrieval Augmented Generation with Pinecone Assistants
LLMs can be a huge productivity boost for work, but the output is only as good as the input. To get the best results, you often have to provide extra reference data to go with the query. This is know...
Local and Offline Image Processing Made Easy With Ollama
Generative AI for image-to-text has been out for a while now, so we’ve all seen how well it can extract text compared to traditional OCR (optical character recognition). Sure, it can hallucinate, but...
Extracting Text From Images with a Self-Hosted LLM
Last week, Meta released the LLama3.2-vision models, adding image recognition to the existing v3.2 text models. GenAI with image-to-text has been out for a while now, but what’s new here is just how...
Why self-marketing and personal lead generation might be better than freelance platforms
Before we get started, I want to make one thing clear, this is not a post bashing UpWork. For many years, I chose to find and keep clients in UpWork, and pay the fees, because I found the service well...
Secure, Self-Hosted AI with Offline Access, Using Ollama
In just the last year or so, nearly every app and web service has integrated some form of AI into their product. Even many development platforms like FileMaker now include LLMs for building custom...
Using OrgChart JavaScript Library In A Web App
Organizational charts help visualize the reporting structure of a company in a tree-like graph. They are usually created with a design tool, and lots of manual data entry. Then, every time an employee...
A Web Viewer for Building Web Viewers
Web Viewers in FileMaker Pro are like an escape hatch. When you hit the limits of the native FMP platform, you can always extend it with a web viewer to add new functionality. You can add some really...
A primer on natural language processing with JavaScript
Lexical density measures word frequency within text. That sentence had a lexical density of 100%, but it's a little hard to understand. Let's unpack it. Lexical density, in the context of text...
Visualizing Aggregate Data Across Geographic Regions
Choropleth maps are similar to heat maps, but with regions defined by geometry, rather than a grid. These maps are useful for displaying aggregate values for each region, like census or voting totals,...
ChatGPT Clone In Google Sheets
AI can be a huge productivity boost, but it can also become a new bottleneck if it doesn't have existing access to your data. Bouncing back and forth between tabs and pasting sheets data into ChatGPT...
Custom Background Image With Markers Plotted From Sheets Data
Google Maps has a ton of features for plotting points on a map, but what if you want to plot points on an image? These XY Image Plot maps are commonly used for floor maps, job site inspections, and...
Interactive Heatmap in under 100 lines of code!
Heatmaps are a great way to visualize aggregate data so you can easily see trends and spikes in the data. They can summarize data across a range of time, display traffic and weather patterns, or any...
Adding custom chart types to Google Sheets using MermaidJS and Apps Script sidebars
Google Sheets has a ton of different chart types built-in, but there are a few types missing like Class, Sequence and Sankey diagrams, to name a few. When it comes to these types of charts, you...
Web Viewer Trick to Display Records in a Grid, with Click Events!
FileMaker Pro's layout design tools are top-notch. Between Form View, List View, Sub-Summary Parts, and Table View, you can build just about any type of UI you want... EXCEPT Grid Layouts! Yes, there...
Just add your API Key and Assistant ID to start chatting with your own custom assistant!
OpenAI’s Assistants allow developers to add a ChatGPT-like AI chat to other apps and websites. I’ve been using the Assistant API quite a bit lately in Appsmith, and I wanted to see if I could build...
Automate bulk image extraction from Google Docs using Apps Script
Recently, I needed to export all the images from a Google Doc and upload them to another service. Seems like a simple job, right? You would think... but not so much. Google Docs blocks the standard...
a starter solution for integrating any API or Database with FileMaker
Hey, I'm Joseph, I'm an engineer at Appsmith, and a long-time FileMaker Pro developer and consultant. I freelanced in FileMaker Pro for years, integrating APIs like Shopify, BigCommerce, eBay and...
A simple Apps Script web app for saving cloud-hosted files to Google Drive via API
I just found an old script I wrote that others might find useful, so I wanted to share. This script saves a file to Google Drive when you POST its URL to the webapp, using this format: { 'key':...
Building a Slack integration using OAuth 2.0 authentication flow in Appsmith
Joseph from GreenFlux, LLC here, with my 3rd and final entry for Appsmith's 2021 Hackathon. Let's build a Slack integration in Appsmith! Appsmith is great for connecting various APIs and bridging...
Integrating Google Maps Embed API for delivery route planning and driver notifications
Hello again, Joseph from GreenFlux, LLC here with another Appsmith tutorial; I'm submitting this one for Appsmith's Hacktoberfest . Today I will be integrating with the Google Maps Embed API to plot...
A collection of JavaScript and REGEX examples for common validation patterns
Hey, Joseph from GreenFlux, LLC here. I'm a full-time freelancer and a HUGE fan of Appsmith ! I've written a few other tutorials for Appsmith before but this one is gonna be a little...
A comprehensive review of the Appsmith low-code platform from a developer's perspective
Intro Hi, I'm Joseph Petty from GreenFlux, LLC - I'm a full-time freelancer/developer- focused on mobile/web apps, databases, and no/low-code platforms and integrations. I've been using Appsmith for a...
General purpose Apps Script web app for saving cloud-hosted files to Google Drive
In this tutorial, I'll be writing a general purpose Apps Script Web App to save a cloud-hosted file to Google Drive as a new file, when the original file url is POST-ed to the script's web app...
Using Reddit RSS feeds as a simple API alternative for browsing subreddit content
Did you know you can turn almost any sub-Reddit into an RSS feed by adding .RSS to the url?! RSS? Ok, by why is this useful? 🤨 Because it's basically an API to GET the recent posts, in XML format,...
A quick overview from an AppSheet Partner Developer
AppSheet is a no-code, mobile/web-app builder that connects to cloud spreadsheets and databases. It's a great tool for throwing together a quick mobile app with no coding experience, but also powerful...
-without breaking existing integrations!
Google Forms is widely used in various integrations and workflows that all start with capturing data and sending it to a Google Sheet. Whether it's a contact form embedded on your website, a...
Static Maps API & Appsmith Tutorial
Today I will be integrating with Google's Static Maps API and using Appsmith to retrieve a map image, given a text-string street address. There's a bit of setup involved if you've never used the...
Email validation service integration for verifying email addresses in Appsmith apps
Verifalia is an email validation service with an API and a free plan that can be used to verify up to 25 emails per day (or more with the paid plans). Send in one or more email addresses, and...
6 Tips for Better Results
UpWork is a great way for developers to start freelancing, and build an online profile with customer reviews to help gain further clients. But it can be a little tough to get started and close the...
Using Appsmith's Google Sheets integration to bulk insert API response data
Appsmith recently released a new Google Sheets integration with a huge list of options, including a method to Bulk Insert Rows to an existing sheet. ☝️ So let's say you want to take the response...
Publishing script as a web app to serve as API endpoint
I've been having a lot of fun building with Appsmith lately and wanted to do something with Google Contacts. It's easy to connect to a new API from Appsmith, but it's not so easy to enable the Google...
Beginner Apps Script tutorial
Apps Script is a powerful tool for automating routine tasks with Google Sheets, Docs, Gmail, and other Google services. On a recent job, I needed to create a daily backup of a Google Sheet for a...
