DEV Community: Stan Bright

Top 13 Trending TypeScript repos in May 2024

Stan Bright — Tue, 30 Apr 2024 22:11:07 +0000

Good day everyone!

I'm sharing 13 of the trending TypeScript libraries and projects from LibHunt. As the case is with other programming languages, we can notice the high number of AI related projects. And that's amazing. Given the growing importance of AI and systems depending on it, it's paramount to have good open-source presence.

If you think that there's a trending TypeScript project that is worth listing here, please add a link to it within the comments. Thanks!

⭐	Library	Description	Resources
1.6k	flyde - flow-based, flow-based-programming, Reactive Programming, Visual, visual-programming	⚡️⚡️⚡️ Open-source, visual programming for developers. Includes a VS Code extension, integrates with existing TypeScript code, browser and Node.js.	Repo, Web, Alternatives
6.4k	pragmatic-drag-and-drop - Drag and Drop	Fast drag and drop for any experience on any tech stack	Repo, Web, Alternatives
1.5k	jampack - Jamstack, static-site, Blog, Node, static-site-building	Optimizes static websites for best user experience and best Core Web Vitals scores.	Repo, Web, Alternatives
1.3k	dashpress - Storage, Admin, admin-ui, admin-dashboard, admin-panel	Generate powerful admin apps without writing a single line of code - Run `npx dashpress` to see some magic!	Repo, Web, Alternatives
4.1k	oneuptime - DevOps, Monitoring, incident-response, incident-management, status-page	OneUptime is the complete open-source observability platform.	Repo, Web, Alternatives
1.2k	paperlib - academic-paper, Management, computer-science, Computer Vision, neural-language-processing	An open-source academic paper management tool.	Repo, Web, Alternatives
17.6k	jan - llama2, llamacpp, localai, self-hosted, Electron	Jan is an open source alternative to ChatGPT that runs 100% offline on your computer. Multiple engine support (llama.cpp, TensorRT-LLM)	Repo, Web, Alternatives
25.6k	dify - AI, backend-as-a-service, Gpt, langchain, llm	Dify is an open-source LLM app development platform. Dify's intuitive interface combines AI workflow, RAG pipeline, agent capabilities, model management, observability features and more, letting you quickly go from prototype to production.	Repo, Web, Alternatives
3.1k	univer - Formula, Chart, Canvas, data-table, Excel	Univer is an open-source alternative to Google Sheets, Slides, and Docs	Repo, Web, Alternatives
0.8k	vector-admin - AI, aitools, Chroma, database-management, document-retrieval	The universal tool suite for vector database management. Manage Pinecone, Chroma, Qdrant, Weaviate and more vector databases with ease.	Repo, Web, Alternatives
29.3k	Lobe Chat - Chat, Bot, Agent, TypeScript, AI	LobeChat is a open-source, extensible (Function Calling), high-performance chatbot framework.It supports one-click free deployment of your private ChatGPT/LLM web application.	Repo, Web, Alternatives
1.2k	Cap - App, cap, coss, Mac, open-source	Effortless, instant screen sharing. Open-source and cross-platform.	Repo, Web, Alternatives
12.7k	FastGPT - gpt35, Nextjs, React, openai, Gpt	FastGPT is a knowledge-based platform built on the LLMs, offers a comprehensive suite of out-of-the-box capabilities such as data processing, RAG retrieval, and visual AI workflow orchestration, letting you easily develop and deploy complex question-answering systems without the need for extensive setup or configuration.	Repo, Web, Alternatives

Bonus - An interesting fact - TypeScript has become #2 on the Top 100 Programming Languages Popularity Index

21 Helpful and trending Ruby gems.

Stan Bright — Wed, 24 Apr 2024 23:47:07 +0000

Heya fellow Ruby devs!

I'm sure you that if you are a seasoned ruby expert, that you already know most of these gems. I will also bet that you are using at least some of them. However! I'm promising that you will find something new and useful, too. For example, I found Ferrum only a few months ago, and it's been delightfully easy to navigate a headless chrome with it (compared to Selenium. Selenium was always giving me some hard time for some reason.)

The list was extracted from LibHunt Ruby.

It's interesting that we have two different Admin UIs that are trending. I think this is indicative that our community needs a more useful Admin UI gem. Of course I know about ActiveAdmin and rails_admin. I've tried both of them, and they are surely useful but not perfect. I'd say Python tops us here with their Django admin. Anyways, it's great to see some active development in this direction in the ruby community.

Basecamp/Rails is working hard with trending work on four gems - solid_queue, solid_cache, console1984 & kamal. Many thanks for that. I'm not using solid_queue and solid_cache yet; however, they are definitely on my radar for my next project.

Without further ado, here's the list. Please note that it's not ordered by number of stars but rather by stars growth (percentage).

p.s. is there a gem you'd like to be added to the list :)?

⭐	Library	Description	Resources
0.6k	multiwoven - Data Analysis, data-engineering, data-ingestion, reverse-etl, data-pipeline	🔥 Open Source Reverse ETL and Customer Data Platform (CDP). An open-source alternative to Hightouch, Census, and RudderStack.	Repo, Web, Alternatives
1.5k	solid_queue - Queue, background-jobs, active-job, Rails, ruby-on-rails	Database-backed Active Job backend	Repo, Alternatives
1.1k	langchainrb - Artificial intelligence, langchain, Machine Learning, ML, Rubyml	Build LLM-powered applications in Ruby	Repo, Web, Alternatives
0.9k	Grover - PDF	A Ruby gem to transform HTML into PDFs, PNGs or JPEGs using Google Puppeteer/Chromium	Repo, Docs, Alternatives
5.2k	docuseal - Documents, PDF, self-hosted, daisyui, document-signing	Open source DocuSign alternative. Create, fill, and sign digital documents ✍️	Repo, Web, Alternatives
0.7k	solid_cache - Cache, Rails, Performance	A database-backed ActiveSupport::Cache::Store	Repo, Alternatives
0.7k	rage - Web, Web Framework, Rails	Fast web framework compatible with Rails.	Repo, Alternatives
26.5k	maybe - Finance, Nextjs, personal-finance, React, NodeJS	The OS for your personal finances	Repo, Web, Alternatives
0.7k	Amazing Print - pretty-print, terminal tools	Pretty print your Ruby objects with style -- in full color and with proper indentation	Repo, Alternatives
1.1k	phlex - Template engine, Ruby, view-components, UI Components, phlex	A framework for building object-oriented views in Ruby.	Repo, Web, Docs, Alternatives
0.6k	console1984 - Privacy, Security, Rails	The Rails console you love, 1984 style	Repo, Alternatives
2.2k	endoflife.date - eol, end-of-life, release-schedule, release-policy, Windows	Informative site with EoL dates of everything	Repo, Web, Alternatives
0.7k	sidekiq-throttled - Sidekiq, Throttling, Concurrency, threshold	Concurrency and rate-limit throttling for Sidekiq	Repo, Alternatives
0.5k	ruby-science - Book	The reference for writing fantastic Rails applications	Repo, Alternatives
0.6k	ronin - Security, Ruby, Hacking, Infosec, ctf-tools	Ronin is a Free and Open Source Ruby Toolkit for Security Research and Development. Ronin also allows for the rapid development and distribution of code, exploits, payloads, etc, via 3rd party git repositories.	Repo, Web, Docs, Alternatives
0.7k	motor-admin-rails - Admin Interface, Rails, Admin, Crud, Business Intelligence	Low-code Admin panel and Business intelligence Rails engine. No DSL - configurable from the UI. Rails Admin, Active Admin, Blazer modern alternative.	Repo, Web, Alternatives
0.7k	heya - Email, Rails, email-marketing, actionmailer	Heya 👋 is a campaign mailer for Rails. Think of it like ActionMailer, but for timed email sequences. It can also perform other actions like sending a text message.	Repo, Web, Alternatives
9.0k	kamal - Deploy, Rails, Docker, Ops	Deploy web apps anywhere.	Repo, Web, Alternatives
1.4k	Avo - Admin Interface, Rails, Ruby, Admin, Crud	Build Ruby on Rails apps 10x faster	Repo, Web, Docs, Alternatives
14.1k	Postal - Communication systems, Email, Mail Transfer Agents, Ruby, Mail	📮 A fully featured open source mail delivery platform for incoming & outgoing e-mail	Repo, Web, Alternatives
1.6k	ferrum - Chrome, Chromium, Headless, headless-chrome, Web	Headless Chrome Ruby API	Repo, Web, Alternatives

Top 10 Trending Python Libraries in April 2024

Stan Bright — Tue, 23 Apr 2024 00:40:22 +0000

Hey mates,

I'm sharing the list of the top trending Python libraries from LibHunt Python. This should help you find something new and useful. As expected, almost everything is AI related. AI is here to stay, and that's what almost everyone is raving after.

Is there a library you'd like being added here? Something that's been on your radar for the last few months that was growing fast.

Library	Description	Stars	Resources
R2R - AI, LLM	The framework for fast development and deployment of RAG backends.	1.2k	Repo, Web, Alternatives
ingestr - DB tools	ingestr is a CLI tool to copy data between any databases with a single command seamlessly. (by bruin-data)	2.3k	Repo, Web, Alternatives
dbrx - LLM, Gen-AI	Code examples and resources for DBRX, a large language model developed by Databricks (by databricks)	2.3k	Repo, Web, Alternatives
hatchet - Queue, Backend	A distributed, fault-tolerant task queue (by hatchet-dev)	2.7k	Repo, Web, Alternatives
OpenDevin - AI	An autonomous AI software engineer who is capable of executing complex engineering tasks and collaborating actively with users on software development projects.	22.1k	Repo, Alternatives
llama_parse - AI, RAG	Parse files for optimal RAG	0.8k	Repo, Web, Alternatives
great-tables - Tables, Data presentation	Easily generate information-rich, publication-quality tables from Python	1k	Repo, Web, Alternatives
MGM - AI, Language Models	Official repo for "Mini-Gemini: Mining the Potential of Multi-modality Vision Language Models"	2.8k	Repo, Alternatives
PyRIT - AI, Generative-Ai	The Python Risk Identification Tool for generative AI (PyRIT) is an open access automation framework to empower security professionals and machine learning engineers to proactively find risks in their generative AI systems. (by Azure)	1.3k	Repo, Alternatives
niquests - HTTP	Requests but with HTTP/3, HTTP/2, Multiplexed Connections, System CAs, Certificate Revocation, DNS over HTTPS / TLS / QUIC or UDP, Async, DNSSEC, and (much) pain removed!	0.7k	Repo, Web, Alternatives

How to steal a website and how to prevent it

Stan Bright — Tue, 13 Dec 2022 03:23:56 +0000

OK, this is going to be a quick showcase of how someone proxy-mirrored my website in a way that is very difficult to detect or prevent it. Moreover, I will share some of the helpful advice that was received from the Hacker News and /r/sysadmin communities.

Here it is the case

I noticed yesterday that one of my websites, SaaSHub, is not present on bing.com; however, its content is being served on a different and very suspicious domain name - sukuns.us.to. And, of course, I started digging my nginx logs - grepping for that domain name. All I could find was that domain name appearing as the referrer when accessing some images. Then, suspecting what might be going on, I started accessing some unpopular pages (on their domain name) and monitoring the logs for them. All requests to my server were coming from different IPs located in the US but with my browser's User-Agent. At that point, I was pretty sure what was happening - someone was proxy-mirroring SaaSHub and serving it on-demand on their domain name.

Here it is a simplified diagram of the case

I started thinking, brainstorming and searching for some generic advice on what I could do to prevent this...

Option 1 - block their IP. Unfortunately, that's not very effective in general, as they could easily change their IP address. What is more, in this particular case, they are using a very wide range of IPs coming from a variety of different ASNs (some of the cases I caught - AS55081, 35913, 36352, 21769, 52393, 394814, 55286). What is more, at first glance, collecting those IPs and ASNs isn't a trivial/quick task.

Option 2 - block them by user-agent - Again, not an option as they are copying the user-agent of the user making the request on their domain-name.

Option 3 - add a small piece of JavaScript that checks for the domain name, and if not www.saashub.com - redirect to it. This isn't a viable option in this case as the perpetrator is stripping all <javascript> tags and files.

Option 4 - use absolute URLs everywhere. Well, they are rewriting all mentions of www.saashub.com in links to their own domain name. So that doesn't seem like an option, too.

At that point, I felt helpless and asked for help on Hacker News & /r/sysadmin

Possible solutions and advice

i.e. what can you do if this happens to you... based on the suggestions and advice that I received on HN & /r/sysadmin.

1) File a DMCA to their host. I've sent a request to their free domain name provider so far.

2) Covert the whole website to JavaScript. Yup, that would work, but then no one without JS would be able to open SaaSHub, I'm guessing SEO will suffer too. So, this is not a path I'd like to take.

3) Block all images being accessed with a referrer that's not the expected domain name - I haven't implemented this one yet, but this could actually work in a generic way. I'm keeping this one in my toolbox of viable options.

4) Implement a honey-trap URL so that all their IPs could be exposed and blocked. This could work as well. "All" you have to do is add an endpoint that is not accessible by normal users - e.g. /honeytrap?some-random-param=rand-number (Note: you need the randomness as the culprit is loading each page once only and caching it after that). Then, add a cron script that will call that end-point on the proxy-mirror domain name and expose all their IPs. That way, we can block them in a relatively automated manner (as long as we know their domain name).

5) Add some hidden and random text to your pages. Why? So that you can search for that text later on and find out all the domain names that mirror your content.

Moral of the story

We are not absolutely helpless! It is unfortunate that we have to deal with it, but, as they say - it is what it is. At least we have a small toolbox of viable options on how to react and what we can try out.

Also, I guess there could be other things and means available to prevent and mitigate similar vicious actions. I'd be happy if you shared your experience and solutions in the comments here. You can find more advice within the discussions linked above, too. Nevertheless, whatever we (you and I) decide to do in similar cases, it's always a difficult and time-consuming battle. And I believe that bringing some awareness to this might help others resolve it quicker than I.

As of now, I think that the report to their free DNS provider has worked out, as their domain-name is not responding to an actual IP anymore. I will have to work on #5 from above, though, so that I can know when they move to a new domain-name.

p.s. if someone working at Microsoft or Bing is reading this, please could you help get SaaSHub indexed instead of the fake mirror sukuns.us.to. Thanks 🙇!

A convenient method to find alternatives to almost any popular open-source project

Stan Bright — Tue, 17 Aug 2021 00:54:19 +0000

I've been improving the new version of LibHunt here and there for the last several months, and I think I've reached a reasonably presentable version. As a software dev myself, I'm looking for alternatives to the libraries I use quite often. Of course, I've been "eating my own dog food" and using LibHunt to find alternatives. What I had been doing is using the regular search function. I'd copy the name of the library from github, paste it in LibHunt's search box, and click on the first result in most cases. That has been working pretty well, yet it felt a bit cumbersome.

This morning I had the following idea. Given that most popular open-source projects are hosted GitHub, and I'm already tracking them, I could support a similar URL schema in LibHunt so that the only difference from GitHub is the domain name. I got it implemented, tested and deployed in less than half an hour. So simple, and it saves all the copy-pasting, clicking and searching.

Now, if you are looking for alternatives to a popular open-source project, I strongly believe that the quickest and most convenient solution is LibHunt.

All you have to do is:

Open a project on GitHub (e.g. https://github.com/facebook/react)
Replace "github" with "libhunt" in the URL
Hit enter 🚀

As of now, the lists with alternatives (and similar projects) on LibHunt are based on three factors:

The projects were mentioned on common posts on Reddit, HackerNews, and dev.to (mentions are monitored almost in real-time)
User suggested alternatives (directly on LibHunt)
Users comparing projects on LibHunt

Of course, these factors and methods are not perfect. However, they work pretty well in most cases. And as more people suggest alternatives and more posts from around the net are tracked, the quality of the lists will only improve.

I hope this will be helpful to many of you fellow devs.

Stan 🙇

p.s. as always, any feedback is highly appreciated.

How to speed up your Ruby/Rails app by ~5% with zero efforts

Stan Bright — Mon, 04 May 2020 06:07:33 +0000

This is going to be a quick one. Yet I think it might be helpful to almost everyone using ruby. A few days ago, I learned about a gem by Shopify - symbol-fstring. Thank you @strzibnyj.

It does something very simple - very well: Access symbols internal strings without duplicating them. Why is that important?

In Ruby many APIs tend to accept symbols, but regularly convert them to string internally. The typical example is ActiveSupport::HashWithIndifferentAccess, but there are plenty more.

The problem with this is that Symbol#to_s creates a new string every time it is invoked, and since it often happens in hotspots, it causes a lot of work for the garbage collector, and cause many identical strings to be kept in memory.

To activate the gem in an app, all you need is adding the gem to your Gemfile and requiring the "patch".

e.g. gem 'symbol-fstring', require: 'fstring/all'

That's all. SaaSHub has been running with it for 3 days now, and there haven't been any unexpected issues. Based on my rough benchmarks, a typical page like "basecamp alternatives" responds about 5% faster and allocates about 5% fewer objects.

I know, 5% isn't that much, yet it's "FREE". Moreover, this gem is maintained by a billion-dollar company, Shopify, popular with its high-quality dev standards. So, I guess it is both safe and worth it giving it a go.

Cloudflare replaced reCAPTCHA with hCaptcha. I followed their example. It took me 18 min.

Stan Bright — Fri, 10 Apr 2020 02:25:20 +0000

Cloudflare announced yesterday that they are moving away from Google's reCAPTCHA in favour of hCaptcha. In my opinion, that is huge! Given the amount of traffic transiting through CloudFlare. That has cut some significant level of vision from Google's all-seeing and tracking eye. Moreover, they are giving a good example for others to follow.

I'd be happy to be amongst their first followers ▶.

Immediately after reading their article, I set my next to-do: "Replace Google's reCAPTCHA with hCaptcha on LibHunt". For those that don't know, LibHunt is a small network of websites (e.g. ruby.libhunt.com) focussed on different programming languages and tech in general. One of the features is allowing people to share links to their blog-posts (e.g. this one). All good, but historically, I have had a lot of issues with SPAM and dealing with it. Of course, one of the measures I've implemented is including a "captcha" - and more specifically, Google's reCAPTCHA. That has helped. However, I've always been a bit sceptical in pouring even more data into Google's hands. That's also why I didn't implement reCAPTCHA v3 (which is expected to be installed side-wide 🙀) but stayed with the older v2. (please, let's not involve Google Analytics now, I'd be happy to replace that too, but I can't as of now).

I also decided to note down the process so that I can share my experience. Well, it was easier and more straight-forward than I expected. It took me about 18 mins altogether. ~3 min reg + browsing around; ~10 min reading the docs and replacing "recaptcha" code and configs with "hcaptcha". ~5 min manually testing. There weren't any unexpected bits. It is almost a direct replacements. Literally. All the methods and functions are the same. You have to update your configs, a few param names and some links only.

These are all the essential changes:

Update your site and secret keys
Post data to https://hcaptcha.com/siteverify instead of to https://www.google.com/recaptcha/api/siteverify
Load scripts from https://hcaptcha.com/1/api.js instead of https://www.google.com/recaptcha/api.js
Replace "g-recaptcha" div with "h-captcha" (that includes the site key)
Replace a div's class: from "g-recaptcha" to "h-captcha"
Google is passing back "g-recaptcha-response" param, while hCaptcha is returning "h-captcha-response". So, use that param to validate results and the newly configured secret key.

That's all.

What is more, when people solve captchas on your website, you are supposed to earn some crypto coins - HMT (The HUMAN Token®). To be honest, I hadn't heard about it and couldn't find much info about it apart from what's on hcaptcha's website. What I found was references to some other token "Hamster Marketplace Token" :D. Anyways, I guess we are not in it for the crypto tokens. Although, I can imagine that if you run a very busy website, it could add up 🤷‍♂️. You also have the option to donate all your earnings from people solving captchas to Wikimedia foundation, which is an honourable. I guess many people will do that.

To summarise the process of migrating from reCaptcha to hCaptha:

👌 It's super easy, straightforward and shouldn't take you more than 20-40 minutes
👁 You are feeding less data to Google
💸 You earn crypto/money (I have no idea what's the potential though)

My advice: go for it!

p.s. as another means to spread hCaptcha, I will be featuring and promoting it on one of my other websites - SaaSHub
p.p.s. you can find more reCaptcha Alternatives on SaaSHub

Replacing React with Preact. It was easy and worth it.

Stan Bright — Fri, 17 Jan 2020 10:47:35 +0000

I had been considering preact for quite some time. After all, the sell is easy:

100% compatible with the React ecosystem (kind of)
Much smaller (js bundle size)
Faster (performance)

About two years ago, I went to a local meet-up in Sydney where the presenter was sharing how they were integrating Preact successfully in some parts of Qantas. That was interesting. And he was convincing. Yet, given that everyone is using React, I thought it was a daunting task and never put the time to research it further. Until recently.

I was working on optimizing the page-load speed of SaaSHub, and one of the paths was decreasing the JS bundle size. I played a bit with webpack-bundle-analyzer and source-map-explorer, and it was apparent that 35% of all the libs were taken by React & react-select. Then I remembered preact... and decided to review it again.

It happened that that task was more scary than difficult. After going through the docs, the whole switch to preact consisted of adding it to packages.json, adding the relevant aliasing to webpack's build configs:

environment.config.resolve.alias = {
  "react": "preact/compat",
  "react-dom/test-utils": "preact/test-utils",
  "react-dom": "preact/compat",
  // Must be below test-utils
}

module.exports = environment

and importing 'preact/debug' somewhere in the app:

import 'preact/debug'

That was all. So simple. Everything worked without touching another line of code. Of course, the process could be more complicated for web apps with more sophisticated code.

What are the benefits:

SaaSHub's JS bundle file-size decreased with 20%: from 577k down to 460k
Faster JS (although I haven't benchmarked that, neither have felt it being slow)

In the end, if you are working on optimizing your JS, and you don't have super complicated setup, I'd highly recommend giving preact a go. It might be easier than you think.

p.s. the next step will be replacing react-select with downshift. I've already implemented one small component with it, and it is amazing. Unfortunately, that migration will require a lot more code changes.

Postgres Trigram indexes VS Algolia

Stan Bright — Mon, 19 Aug 2019 09:06:23 +0000

I want to share my experience of using the native "trigram indexes" of Postgres to achieve a robust "typeahead/autocomplete/fuzzy search" functionality. I am using Algolia as an example, as I have noticed that a lot of people are using it precisely for that. Yet, I believe that you could do perfectly fine by using only Postgres in many situations.

What are trigram indexes? They are a special type of index in Postgres that is available by default; however, they have to be explicitly enabled. Here it is an extract from the official docs:

"The pg_trgm module provides functions and operators for determining the similarity of alphanumeric text based on trigram matching, as well as index operator classes that support fast searching for similar strings.", "A trigram is a group of three consecutive characters taken from a string."

For example, the set of trigrams in the string "cat" is " c", " ca", "cat", and "at ". The set of trigrams in the string "foo|bar" is " f", " fo", "foo", "oo ", " b", " ba", "bar", and "ar ".

Now let's follow what's necessary to build our autocomplete engine.

1) Enable the Postgres extension

CREATE EXTENSION IF NOT EXISTS pg_trgm

2) Index the columns you are going to query

Once you have enabled pg_trgm you have to index varchar and text columns to make use of it. e.g. CREATE INDEX index_fuzzy_searches_on_name_trgm ON fuzzy_searches USING gin(name gin_trgm_ops). Notice USING gin(name gin_trgm_ops)

Now we have very fast LIKE queries with leading and trailing wild cards (%).

3) Prepare the query

The next step is splitting the user query by spaces and adding a separate WHERE clause per name. For example, if a user searches for "sales cloud". We'd end up with a query like SELECT * FROM mytable WHERE name LIKE '%sales%' AND name LIKE '%cloud%'

A simplified implementation in Ruby on Rails could look like (in this case ServiceSearch would be MATERIALIZED VIEW that I will explain down the post):

relation = ServiceSearch.popular_first.limit(limit).includes(:service)
query.split("\s").each do |word|
  relation = relation.where("content LIKE ?", "%#{word}%")
end
relation.map(&:service)

4) Search for different types of records simultaneously

One of the use cases of using a dedicated full-text search engine is querying all your records simultaneously. That could be achieved through a MATERIALIZED VIEW. Moreover, you can easily give priority to some records. For example, showing Products before Categories. I am managing my views by the awesome scenic gem, but you don't need to.

Here it is the body of an exemplary materialized view:

SELECT
  id AS searchable_id,
  'Service' AS searchable_type,
  1 AS priority,
  post_services_count AS weight,
  LOWER(name) AS name
FROM services
WHERE state IN ('approved', 'closed')

UNION

SELECT
  categories.id AS searchable_id,
  'Category' AS searchable_type,
  2 AS priority,
  COUNT(*) AS weight,
  LOWER(name) AS name
FROM categories
JOIN categorizations cats ON cats.category_id = categories.id
WHERE state = 'approved'
GROUP BY categories.id, categories.name

By having a view like that one, we can query multiple records with something as simple as:

SELECT * FROM fuzzy_searches WHERE name LIKE '%test%' ORDER BY priority, weight DESC

Real-world examples

One of the top competitors of SaaSHub - alternativeto.net is using Algolia for their search autocomplete. I'd suggest testing their search and SaaSHub's. You won't find many differences in the UX or speed.

In the end, if you need a simple autocomplete functionality for your project, and you are using Postgres, my suggestion is to consider its trigram indexes + materialized views. Reaching out to external services may not be necessary and could be an overkill. However, I'm sure that there will be many cases in which it will make sense to pay for a professional SaaS product.

p.s. you can find more Algolia alternatives on SaaSHub 🙈.