cpursley

{
    "status": {
        "code": 200,
        "text": "OK"
    },
    "results": {
        "properties": [
            {
                "_id": "00c72799d8c05b7158357c3bf4d0906b",
                "dateModified": "2023-07-07T03:40:17.731Z",

cpursley

Free Web Developer Curriculum

Overview

• Learn To Code In 2019, Get Hired, And Have Fun Along The Way
• The 2019 Web Developer Roadmap

Linux, Terminal & Bash

Books

• Conquering the Command Line
• Learn Enough Command Line to Be Dangerous

cpursley

# You will need to install https://github.com/cpursley/html2markdown

defmodule Webpage do
  @moduledoc false
  defstruct [:url, :title, :description, :summary, :page_age]
end

defmodule WebSearch do
  @moduledoc """
  Web search summarization chain

cpursley

See: https://github.com/cpursley/vecto

cpursley

Deduplication with PostgreSQL, Elixir, and AI

A practical guide to building a multi-layer deduplication system using PostgreSQL's native text-matching capabilities, Elixir for orchestration and scoring, and an LLM for fuzzy name resolution.

---

Strategy: Three Lines of Defense

Deduplication works best as layered prevention, not a single pass.

cpursley

Postgres Full Text Search

Do you really need Elastic Search?

• https://www.postgresql.org/docs/current/pgtrgm.html
• https://scoutapm.com/blog/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity
• https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/
• https://mazeez.dev/posts/pg-trgm-similarity-search-and-fast-like
• https://alexklibisz.com/2022/02/18/optimizing-postgres-trigram-search.html
• https://www.freecodecamp.org/news/fuzzy-string-matching-with-postgresql/

cpursley

{
  "swagger": "2.0",
  "info": {
    "version": "1.0",
    "title": "QuickBooks Online V3API Collections - OAuth2",
    "description": "The QuickBooks Online Accounting API is a RESTful API that is used to access QuickBooks companies.\n\nDocs Ref - https://developer.intuit.com/docs/api/accounting"
  },
  "host": "DefaultParameterValue",
  "basePath": "/v3/company/DefaultParameterValue",
  "securityDefinitions": {

cpursley

PostgreSQL is Enough

See the new site: https://postgresisenough.dev

---

• Simplify: move code into database functions
• Just Use Postgres for Everything
• Just use Postgres
• PostgreSQL is the worlds’ best database