RSSAmplifier

Blog

nickgeorge.net home on nick

Recent content from nick

nickgeorge.netRSS feed ↗10 posts

Latest posts

Simple and Efficient SEC Filing Parsing Using Go

There are many SEC filings parsers, this one is mine . Public companies in the US are required to file standardized disclosures with the SEC. Tracking those filings and extracting structured data from them is extremely useful, but surprisingly difficult to do. I run an application focused on biotech company activity , and SEC filings are a core input that can tell you a lot about what companies…

Debugging 'Malformed Database Schema' in SQLite

I run a biotech investment and competitive intelligence tracking application. The app is a go app run on a bare-bones VPS with a SQLite database as the data store, dead simple. I was recently working on a major rebuild of the database on a separate server ( build-server ). When I was satisfied, with the changes, I tried to deploy: # on the build-server sqlite3 rxdatalab.db 'PRAGMA quick_check;' #…

Paddle Overlay Checkout

First, let&rsquo;s make a frontend key and save it in our hugo.toml under a key like paddleSandboxClientSideJsToken (you&rsquo;ll also have a paddleProdClientSideJsToken ). Then, on your layouts/products/single.html template make a javascript snippet like so: <script src='https://cdn.paddle.com/paddle/v2/paddle.js'></script> <script type='text/javascript'> {{- $paddleToken := '' -}} {{- $priceIds…

Listening to Paddle Webhooks

First, create a sandbox account at https://sandbox-login.paddle.com/signup and a live account at https://login.paddle.com/signup . Yes, there are two separate accounts for testing and live. Use the same email address and business details. Since Paddle is a merchant of record, they are more careful about who they approve than payment providers like stripe. It will take time and a few manual…

Tracking Salary Transparency in Biotech Jobs with PharmaPayWatch.com

What can we learn from company job postings? I&rsquo;ve been collecting job posts from 13 major pharma and biotech companies since November 2024. At first, I was interested in providing accurate and timely information about new jobs to the community since LinkedIn is a dumpster fire . However, it turns out there may be a lot of information you can learn about companies and the industry in general…

NIH Should Buy 23andMe

23andMe is a remarkable company. Founded in 2006, they pioneered direct-to-consumer genetic testing and have since genotyped DNA from over 15 million individuals, making it the “world’s largest crowdsourced platform for genetic research” 1 . Importantly, over 80% of 23andMe customers have consented to the use of their data for research, creating a unique and invaluable resource for genetic and…

Static Dashboards

I&rsquo;ve been building dashboards (essentially just pretty tables and some plots) that display data from different public data sources in a novel ways. Most of these dashboards are ephemeral and experimental, so I&rsquo;d rather not host a separate public application + database before I&rsquo;m sure they&rsquo;ll be around for a while. The simplest and most secure way to do this is to setup a…

Open Knowledge - An Open Alex Explorer

OpenKnowledge OpenAlex API Explorer Enter search terms [info] : Related terms: Click a concept to search

man(ual) pages are all you need

With the ever decreasing quality of search thanks partly to ad-tech, google, and SEO (and more recently AI/LLM- enhanced SEO 1 ) I&rsquo;m noticing that it is becoming much more difficult to find quality technical information online. In the past, I defaulted to tutorial style learning, involving web searches for tutorials and &ldquo;getting started with &hellip;&rdquo; style articles, skim those…

Bootstrapping Ansible on FreeBSD

Automating tasks with Ansible has been a great way to learn about server management best practices and get Linux servers up and running quickly. When I started experimenting with FreeBSD 1 in my homelab I was surprised that Ansible wasn&rsquo;t well supported. Python and sudo The primary difficulty is that while Ansible is &ldquo;agentless&rdquo; , it does require Python on the target server .…