Foxhound Systems
@FoxhoundSystems
Followers
101
Following
34
Media
4
Statuses
49
Precision-built custom software systems. Made in the USA. We specialize in building with Haskell, PostgreSQL, and Nix on AWS.
Chicago
Joined December 2019
Here's deep dive on the 5 most annoying website usability issues on the web in 2024. Get any one of these wrong and you're significantly harming your user experience. #webdev #a11y #ux
https://t.co/f3b6MpBLLT
cloudtrellis.com
How to identify and fix the biggest user experience problems on modern websites for better engagement.
0
2
3
One of the most common website issues that harms both usability and #SEO often goes completely unnoticed. What's the issue? Unnecessary redirects that slow down user navigation and waste your search engine crawl budget. Learn more in our article below👇 https://t.co/58s7nXlxYC
cloudtrellis.com
A guide to identifying and fixing redirect issues that are hurting your website performance
0
2
1
Who knew that selecting a SQL database key type could be as nuanced as picking a fine wine? 🍷 @charukiewicz's article on TSIDs vs. UUIDs vs. auto-incrementing integers is a sommelier's guide to database keys. #sql #databases
https://t.co/YEyQE9yItZ
foxhound.systems
A look at why TSIDs are the best of both worlds when it comes to database keys.
0
1
1
Technical Debt is not real https://t.co/zlCcgflmVA
@FoxhoundSystems
0
1
2
Exploring the depths of technical debt, we examine the subtle art of balancing rapid innovation with sustainable code quality. Spoiler: There's no magical 'clean up' button Read the article below #SoftwareEngineering #TechDebt
https://t.co/agQfbq91Ok
foxhound.systems
It's a metaphor for the accumulated consequences of past decisions and shortcuts we make in software development
0
1
1
Solo founder? Growing startup? Struggling with technical decisions? We're now offering monthly, flat rate subscriptions for unlimited access to guidance from our senior engineers. Starting at $600 per month. Cancel anytime. See plans and more info: https://t.co/Wiuu2hSqdN
0
1
1
The issue with MVP isn’t that the concept is fundamentally flawed, but that it is incomplete. #startups #SaaS #mvp #SoftwareEngineering
https://t.co/cfYRLPWhSM
foxhound.systems
What discussions about the value of minimum viable products consistently miss.
0
1
1
Have an app idea? Don't mind wasting money? - Skip problem discovery - Don't make a detailed specification - Don't build wireframes Find a developer that will take your basic plan and immediately start writing code. Your app will cost at least 35% more to build, guaranteed.
0
1
1
There's always two orders of magnitude in the price range of a software project. $2.5mm can get you 100% of the value for 100% of the cost. $250k can get you 60% for only 10% of the cost. $25k can get you 35% for a mere 1% of the cost. Recognize which version you need.
0
1
2
Ease of concurrent programming is one of many reasons to use Haskell in production. Read our whole article on the topic below. https://t.co/xdx0vUSfT6
foxhound.systems
Haskell's features enable rapid development, easy maintainability, and excellent performance, making it a top choice as an industrial-strength programming language.
0
0
0
Why use Haskell for building production software systems? Haskell makes writing concurrent programs trivial. Write a single threaded implementation, and then invoke concurrency operators for a multi-threaded implementation. Below: 75% speedup after `for` -> `forConcurrently`
1
1
4
Server side caching is a technique that reduces the need to run expensive queries and computations. There's several facets to consider when designing caching in a system—read about them in the latest post in our series on high performance applications. https://t.co/WbmArjajsN
foxhound.systems
Server side caching can be used to cut down the time required to return the results of expensive queries by orders of magnitude.
0
1
3
Functional Design Code Smells: The Hourglass Call Graph Instead of passing a flag that dictates control flow, maintain the control flow in the caller and break out only common computations.
4
5
31
Don't know where to start? Check out our article on getting the most out of your database:
foxhound.systems
Offloading work from the application server to the database through the effective use of advanced SQL features can greatly improve application performance.
1
0
3
In 2022 a machine with 1GB of RAM and 2 CPUs is considered a hobbyist machine. In 2022 consider using your database to its fullest potential, don't be hamstrung by advice from 20 years ago.
1
0
2
In 2002 @martinfowler warned that "databases are optimized to handle up to three or four joins per query. Beyond that, performance suffers" In 2002 1GB of RAM was considered to be a lot of memory and multi-core processors were brand new.
1
3
10
Building a fast application requires effectively utilizing your SQL database. In our latest post on building high performance applications, we demonstrate offloading work to the database, how it leads to improved system performance. #sql #webdevelopment
https://t.co/pcNvG2Txsu
foxhound.systems
Offloading work from the application server to the database through the effective use of advanced SQL features can greatly improve application performance.
0
1
3
We're kicking off a series that covers essential elements of building high performance web applications. One of the biggest boons to performance in an application is effective use of SQL indexes. We'll take a look at them in this post. #webdevelopment
https://t.co/WtAVH61EYg
foxhound.systems
Effectively using SQL indexes is a huge boon to performance of a web application.
0
1
5