Fixing slow PostgreSQL queries: How to make a smart optimizer more stupid | OtterTune You've got a slow-running PostgreSQL query, so you run ANALYZE, but what if ANALYZE can't fix it?
Building an image search engine on Postgres | Tembo Search images with text and existing images using Postgres.
Solid Cache for Rails and PostgreSQL Solid Cache is a relatively new cache framework that’s available as a Ruby gem for Ruby on Rails. In the next major version of Rails, version 8, it’s becoming the default cache backend.
Doing Something Once Vs. Doing It Every Day When you show up every day. When you don't stop when others stop, you become unstoppable. Keep this in mind the next time you want to quit.
The Summer I MacGyvered a Smart Bug Repeller and Saved $700 🎥 Video Version Available! You can watch the video version of this project on YouTube as given at the Tech Lancaster Meetup in July Sometimes, all you need is duct tape. As a software guy, hardware hacking has long appealed to me...
Scalability works in two directions When talking about scalability in the context of software, it is always about being able to handle more: users, data, network traffic, etcetera.
~fpereiro The edge, in cloud computing, is deploying servers in multiple physical locations to serve users that are also distributed geographically. A service that uses edges will serve (say) users in the US with servers in North America, and Indonesian users with ...
WordPress, Hosts, and Hosting After nearly a decade out of WordPress, I visited WordCamp US and met with several hosts. TLDR: the state of WordPress hosting is stale.
Fun driven development I use a lot of nerdy tools (linux, nix, river), some tools also have a steep learning curve (vim, dvorak). I also type on a 32 split keyboard I made myself. A lot of developers would say I am wasting time, using tools that have no use or slow me down, and...
Tiny Guide to Webscaling Someone on Twitter asked what if Khairul Aming wanted to set up his own website for his sambal? For those who may not know, his product has gained fame and typically sells out quickly once he opens orders. At present, he utilizes Shopee. From a business s...
Scott Fryxell I don't have a degree, but I have worked in tech two plus decades and I can tell you it's interesting as all get out to watch the status economy begining it's downward spiral. Imagine spending the first twenty five years of your life striving to become th...
Exploring the limits of Postgres: when does it break? – StepChange In this post, we explore the limits of single-node Postgres and what optimizations can extend its usefulness as a primary application database before requiring more advanced scaling solutions. Monolithic ecommerce app on RDS PostgreSQL Let's use a real...
Being Raised by the Internet I grew up relatively poor. I was fortunate enough to have a roof over my head, clean water, electricity, a computer, internet, and cable tv. But food was often harder to come by. This may seem like a contradiction, but when your mom has left to marry her ...
Dynamic Height WebView from Static HTML in React Native Expo Let’s say your app is consuming rich text content from an API. That content is returned via a get request and returns a response that is a plain-text string of HTML content. How would you dis…
Running Docker in an Azure Windows Virtual Machine – Not so fast! This blog post describes getting Docker up and running inside an Azure Windows Virtual Machine. This might sound like a simple task, but trust me, there are some surprises on the way that took me a day or so to figure out. Background As a trainer for deve...
GitHub - WinampDesktop/winamp: Iconic media player Iconic media player. Contribute to WinampDesktop/winamp development by creating an account on GitHub.
Receiving GitHub Webhooks When Using the ASP.NET Core Developer Certificate - Steve Gordon - Code with Steve In this post, I share how to enable testing GitHub webhooks locally using HTTPS with the self-signed ASP.NET Core developer certificate.
Difference Between “Promise” and “Observable” in Angular In this article, I will mention the differences between Promise and Observable. They have different uses cases and behaviors. Read more…
ASP.NET Core 9 and IAsyncEnumerable - Async Streaming JSON and NDJSON From Blazor WebAssembly This post explores streaming data asynchronously from Blazor based on async streamed JSON and NDJSON.
Boosting Loop Performance in .NET: The Simple Trick of Caching Array Length The post discusses optimizing array iteration in programming by caching the array’s length for performance improvements. This method yields a 1.021x performance boost, particularly beneficial…
Tune Llama3 405B on AMD MI300x (our journey) - Felafax Blog - Obsidian Publish Tune Llama3 405B on AMD MI300x (our journey) - Felafax Blog - Powered by Obsidian Publish.
Augmenting the client with Vue.js In my previous post, I laid the ground to build upon; now is the time to start 'for real'. I heard a lot of Vue.js. Additionally, a friend who transitioned from developer to manager told me good things about Vue, which further piqued my interest. I deci...
Ideal Number of Direct Reports Learn why 7 direct reports is ideal for managers. Discover how team autonomy, and project complexity shape the best span of control in tech and engineering
Fabio Manganiello (@fabio@manganiello.social) 📦 #Platypush 1.3.0 is out!This release turns procedures into first-class citizens.Procedures are the bread-and-butter of Platypush customizations. They allow you to specify some custom logic that c...
Small Products that Improved My Life Each of these products solved some problem in my life and took a long time to figure out.
Shivasurya on Security | Tech Blog Tech blog on cyber security, android security, android development, mobile security, sast, offensive security, oscp walkthrough, reverse engineering.
Recommendations Are Tough, Commercialization Is Harder Recommendations and commercialization of a product face challenges that come from non-platform controlled data sources.
Understanding and Preventing Race Conditions in Web Applications | gavide's Blog Spot and fix race conditions in Python, FastAPI, and PostgreSQL to prevent data corruption and security issues
The magic of software; or, what makes a good engineer also makes a good engineering organization The people who create software generally refer to themselves as software engineers, and yet if they graduate from university, it is typically with a degree in computer science. That has always felt a little strange to me, because science and engineering a...
Partial Prerendering for Everyone with Cloudflare Workers Implementing Next.js-style PPR in a normal React SSR app
Easy-to-use NoSQL Prompt Database for Small Projects Ever needed a database for your LLM project that:
AdaptKeyBERT: Stumbling Through Two Years of Keyword Extraction AdaptKeyBERT: Stumbling Through Two Years of Keyword Extraction Quick links (in case you want to skip my ramblings): PyPI Package GitHub Repository Alright, gather ‘round, word enthusiasts and syntax sorcerers! 🧙♂️📚 Remember that time you tried to expl...
Decoupling time spent from value provided as a software developer As software developers, we are uniquely positioned to create something and give it a life of its own. So why are so many of us content to clock in and sell our time, 19th century factory style?
Some Notes on Adversarial Attacks on LLMs Intro Last week I was catching up with one of my best mates after a long while. He is a well-recognised industry expert who also runs a successful cybersecurity consultancy. Though we had a lot of other things to catch up on, inevitably, our conversation ...
The pipeline problem Here's a story about how Laravel/Rails might fix the "pipeline problem:" by hiring new grads to build the awesome tools we've always wanted.
Try, catch, but don't throw The standard try-catch-throw approach to error handling in TypeScript is not type-safe, making it difficult to explicitly handle different kinds of errors in business logic. This might be okay in smal
The Web Component Success Story | jakelazaroff.com Web components won't take web development by storm, or show us the One True Way to build websites. What they will do is let us collectively build a rich ecosystem of dynamic components that work with any web stack.
I messed up my calendar and wrote a script to fix it A little automation overcomes Google's questionable UX design.
The Hidden Costs of Over-Collaboration In the wake of Agile’s success and the benefits it offers organizations to help them achieve faster delivery, happier customers, and more engaged teams, “Collaboration” has become…
How to fork: Best practices and guide Fork maintenance — keeping your changes in sync with the latest updates from the original project — can quickly become a mess. Trust me. Over the years, my work did sometimes involve maintaining forks of various open-source projects. That’s not the case w...
HTTP/1.1 500 Segfault: Building a web server in C It feels like every single web service wants to use OAuth to get user data, and for good reason too. The alternatives include requiring users to create access tokens manually (yikes) and asking users to input their usernames/passwords to impersonate them ...
How Long Is Too Long? Navigating the Lifespan of Digital Connections Embark on an existential journey through the digital landscape, exploring the impermanence of online communities and reimagining how we can design more meaningful, fluid, and purpose-driven information pathways for the future.
A simple way to deal with the principal threat to scalability If you have a distributed system one of the main worries you probably have is scalability. Well, what is the principal threat to scalability in such systems is the conflict between transactions that are used to guarantee correct results in concurrent oper...
Two kinds of LLM responses: Informational vs Instructional When thinking of LLM evals especially in the context of RAGs, it occurred to me that there are two kinds of distinct responses people get from LLMs: informational and instructional.
The Intelligence Age In the next couple of decades, we will be able to do things that would have seemed like magic to our grandparents.