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

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

Background and Cron Jobs

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