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

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

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

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

cpursley

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

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

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

❯ Research "1082 S Nucla Street, Aurora, CO 80017", get it's assessment data and also any other data about the property that you can find (listings, etc). Save that to our property database. This is our subject property for a UAD 3.6 appraisal.

                                                                                                                     06:41 AM claude-fable-5

⏺ I'll use the opencomps and property-payload skills to guide this research-and-ingest task.

⏺ Skill(opencomps) ⎿  Successfully loaded skill ⎿  2 PostToolUse hooks ran

⏺ Skill(property-payload)