My Notes
Search notes...
Algorithms & data structures
Trees
Binary trees
Algorithms & datastructures intro
Fuzzy find
Hashmap & Hashtable
Hashtable
Queues
Stack vs. Heap
Chess programming
Fishnet
Stockfish
Vectorization of chess positions
Clean code
intro
SOLID
Database & ORM
DB theory
Indexes (SQL)
Normalization
Pooling
Graph databases
FalkorDB
Graph Database
Neo4j
Key-Value databases
Redis
Atomic counters with Redis
Distributed locks with Redis
Persisting Redis data
Prefixes
Pub-Sub with Redis
Rankings with Redis
Redis
Dragonfly
Memcached
Valkey
Object databases
Minio
RustFS
S3
Postgresql
Note
DROP (Postgresql)
EXPLAIN ANALYZE
Full-text search in Postgres
Neon (Serverless Postgresql)
pgVector
Postgresql
PostgreSQL in Docker
Unlogged tables
Vector similarity in Postgres
Sqlite
Note
Dumping Sqlite
LibSQL
Sqlite in production
WAL mode
Vector databases
Chroma
Pinecone
Qdrant
Vector databases
Weaviate
Clickhouse
Column-oriented databases
Drizzle
DuckDB
Event store databases
EventSourcingDB
Grafana
Kurrent DB
MongoDB
OLAP & OLPT
Tigerbeetle
Turso
Design
Visual design
Actual speed vs. perceived speed
Designing websites
Golden ratio
Attention economy
Design
Design thinking
Nudging
Persuasive technology
User privacy
Docker
Containers (general)
containerd
Inspo for using containers
Best practices for Docker containers
Containers are not virtualization
Docker
Docker Compose
Docker logs
Docker networking
Docker on Arch
Docker Swarm
Image versioning
Lazydocker
Networks
Podman
Repositories and registries
Volumes
Excalidraw
Drawing 2025-01-11 20.59.18.excalidraw
Functional programming
Currying
Functional programming
Functors
Monads
Recursion
Tail recursion
General tools
Git
Cherry Pick
Git
Github
Merging
Precommit hooks
Worktrees
n8n
Google oAuth Integration
n8n
Read pdf file
Self-hosted AI starter kit
Vector Stores in n8n
Web Chat bot
Neovim
Building plugins
LazyVim
Neovim
NvChad
Agentic coding
AI digest
Brew
Claude Code
context7
Copilot CLI
Gemini CLI
Headroom (AI Coding)
Immich
index
KiloCode
Lefthook
Markdown
Matt Pocock Skills
Nixpacks
Ntfy
OfficeCLI
Oh My Pi
opencode
QMD
Raycast
Repowise
RunPod
Rust Token Killer (rtk)
Skills (AI Coding)
Stirling PDF
Tabby
Tmux
Treesitter
Vaultwarden
Z.AI Coding Plan (GLM)
Zed
Kubernetes
files
x-deployment.yaml file
x-namespace.yaml file
x-service.yaml file
Basics
Deployment
Distributions
Helm
Ingress
k3s
k9s
kompose
kubeadm
kubelet
Kubernetes
Local containers to Kubernetes (Local to prod)
MicroK8s
minikube
Tilt
Machine Learning
AI SDK
AI SDK
Huggingface
Huggingface
Intro
Note
PCA
Jina AI
Jina Reader
LangChain
Agents
Deep Agents
Integrations
LangChain
LangChain with Chroma
LangChain with Ollama
LangGraph
LangSmith
LLMs & Agentic AI
Agentic AI Architecture
Agentic Browsers & Search
Agentic memory
Agentic tool calling
Automem
Cognee
DeepSeek Harness
Frameworks for Agentic AI
Harnesses
Paseo
Metrics
False positive & True Positives
Precision & Recall
Mistral
Mistral API
Mistral OCR
Workflows
Models
ColBERT
DeepSeekOCR
Detectron2
MobileNet
Models (Existing)
PaddleOCR
Neural networks
Drop out
Multi layer perceptron
Neural networks
Open weights
Untitled
OpenAI (API)
Fine tuning
Temperature
Tokens
Papers
Highly relevant papers
PyTorch
Pretrained models
PyTorch with CUDA
Retrieval augmumented generation (RAG)
Dify
Graph RAG
Haystack
Hybrid Search
Hypothetical Document Embedding (HyDE)
Hypothetical Prompt Embedding (HyPE)
Pipeshub
Platforms for RAG
RAGFlow
Reranking
Retrieval augumented generation (RAG)
Tensorflow
Seeding & determinism
Activation functions
Autoencoders
Cache augumented generation
Chunking
Classification
Cost functions
CUDA
dsRAG
Embeddings & vectorization
Ensemble learning
FAISS
Firecrawl
Gradient descent
Image embedding models
LIME
Linear regression
LlamaIndex
LM Studio
Logistic regression
Measurement
Mixedbread
Modal (Platform)
N-Grams
Neuralwatt
Ollama
PCA
Regression
Regularization
Self-attention
Semantics
SentenceTransformers
SHAP
Tesserect
Text embedding models
Tf-Idf
Tokenizer
Vector similarity
Zero-shot classification
Math
Cryptography
Encryption
Hashing
Symmetric approaches
Probability theory
Independence
Vectors
Cosine similarity
Dot product (vectors)
Euclidean distance
Vectors
Convexitiy
Elo
Functions
Logistic function
Network
Mail
DMARC
E-Mail (Networking)
SMTP
Building VPN-only Web services
DHCP
DNS
Domain & Domain Records
Forward proxy
IP
Load balancing
NAT
NAT (Network address translation)
nc (netcat)
Newt Pangolin
Pi-hole
Reverse proxy
Socket
Tailscale
TCP
telnet
Tunnels
UDP
UDP Holepunching
UDP vs TCP
VPN
wg-easy
Wireguard
OS
Linux
Arch
pacman
Important directories
etc
usr local bin
apt
bash
Basic commands
cronjobs
gdm
GNOME
hostnamectl
iptables
Linux Kernel
Namespaces
Networking
Nmap
Pop OS
Rights
snap
SSH
sysctl.conf
systemd
Terminal Shell
UFW (Uncomplicated Firewall)
Useful CLI tools
zram
OS resources
Thread
Programming languages
C and C++
Structs
DOT NET
dotnet CLI
Fundamentals
Atomics
Casting
Concurrency
Error handling
Fundamentals of programming languages
Memory management
Typing
Gleam
Gleam
Gleam Event Sourcing
Gotchas in Gleam
Go
Concurrency
Concurrency
Concurrency Patterns
Fiber
Fiber (Go)
Libraries and frameworks
Agentic Development Kit (for Go)
Fyne (Go GUI Library)
Go Libraries and Frameworks
goes (Go Event Sourcing Framework)
GORM
Templ
Yaegi
Zog
Patterns & design
Composition in Go
Dependency injection
Inheritance in Go
Patterns in Go (overview)
Arrays and slices
Context
Datatypes
Defer
Enums
Errors
For
Functions
Go
go env
go fix
Gotchas in go
HTTP
If else switch
Interfaces
make and new
Maps
MCPs for Go
Methods
Networking
Packages and Package Management
panic & recover
Pointers
Resources (Learning Go)
runtime package
Strings
Structs
TinyGo
Variables
Java
Spring boot
JavaScript
Asynchronous
Callbacks
eslint
Event Loop
Formatters
Functional JavaScript
JavaScript intro
Label Syntax
Languages, compiling to JavaScript
Linters
OXC (JS Oxcidation compiler)
oxlint
prettier
Workers
Python
Arguments
Conda
Context manager
Decorators
Dockerizing Python
functools
index
Jupyter Lab
Maturin
Pip
Profile card - Python
sets (Python)
Streamlit
UV
Virtual envs
Rust
Neon (Rust)
Rust
Rust CLI (Cargo and rustup)
structs
TypeScript
any
as const
Basic types
Casting in TypeScript
Classes
Decorators
Dependency Injection (TS)
Enums
existing note
fallow
Generics
Interfaces
Interfaces vs Types
Intro TypeScript
Null-safety in Typescript
Nullish coalescing
Optional values
Profile Card - TypeScript
Resources
Setting up TypeScript
tsconfig
Type guards
Type narrowing
typeof
Types in TypeScript
TypeScript React
Union types
zod
Elixir
Elm
Kotlin
Programming languages
PureScript
Programming Paradigms
Declarative programming
Duck typing
Imperative programming
Intro
OOP
Procedural programming
Strategy pattern
Server
AWS
Amplify
AWS with SST
EC2
Lambda
Lightsail
Cloudflare
Cloudflare
Durable executions, objects and jobs
Celld
Durable execution and jobs
Durable objects
Hatchet
IONOS Cloud
Model Hub (IONOS Cloud)
Chat Models IONOS Cloud
Embeddings IONOS Cloud
Model Hub Overview
IONOS Cloud
Mailservers
AWS Simple Email service
Mail servers
Mailgun
Nodemailer
Messaging and queues
Kafka
Message Queues overview
RabbitMQ
Railway
Railway
Search engines
Apache Lucene
ElasticSearch
MeiliSearch
Paradedb
Tantivy
Typesense
Fly.io
gRPC
Infrastructure as a service
OpenAPI
Platform as a service
RPC
Scalar
Scaling
Self hosting
Serverless
Software as a service
Supabase
Temporal io
Terraform
VPS
Software design patterns
Asynchronous programming
Caching
Composition over inheritance
CQRS (Command Query Responsibility Separation)
Decorator pattern
Dependency Injection
Event sourcing
intro
Microservices
Monkey patching
Observer pattern
Reactive programming
Repository Pattern
Software dev general
Feature flags
Intro - Software development
Licensing
Monorepo
Technical debt
System Design
Caching
Load balancing
S3 (in System Design)
System Design
Tech general
LeetCode
Patterns
Coding platforms
Data leaks
If you are not paying, you are the product
Open source
Own your data
Privacy by design
Targeted advertising
I have nothing to hide
Templates
Daily Note.template
Idea Capture.template
Meeting Note.template
Project Note.template
Technical Note.template
Weekly Plan.template
Webdev
Angular
@Input (old)
@Output (old)
Analog
Angular - intro
Angular Cheatsheet
Angular Linting and Formatting
Authentication
CLI
Component input & output
Components
Decorators
Defferable views
Dependency injection (Angular)
Directives
effect
Event listeners
Forms
HTTP
LESSONS LEARNED - ANGULAR
ng-container
ng-content
NgComponentOutlet
NgRx
Nx
Observables
Proxy
Router
RxJS in Angular
Signals
Spartan
SSR
Subscriptions
Templating
TypeScript for Angular
APIs
API Authentication
API Authorization
GET vs. POST APIs
REST APIs
URL Parameters and Queries (REST)
Astro
Astro
CLI
Auth
2-Factor-Auth (2FA)
API Auth
Auth in SPA apps
Authentication
Authorization
Bearer Auth
Cookie Auth
Credential stuffing attack
CSFR
JWT Auth
Local Storage vs. Cookies (auth)
OAuth
Session Auth
Session hijacking
SSID
Token Auth
XSS
Better Auth
Better Auth for non-TS (Interopt)
Intro - Better Auth
Browser
Browser storage
Cookies
index
Links
local storage
Preconnect
Prefetch
Preload
Bun
Bun frameworks
Bun Intro
Bun package management
Production bun
Cloudflare
Cloudflare tunnels
Turnstile
Concepts
Web framework concepts
Component re-rendering
Composition vs. inheritance (frontend-frameworks)
effects (web)
Intro
Smart vs. dumb components
state (web)
Authorization
Client-side-rendering
Hydration
Incremental Static Regeneration
Isomorphic SPA
Multi page app
Optimistic UI
Partial prerendering
Prerendering
Resumability
Routing
Server islands
Server-side-rendering
Single Page App
Static site generation
Web Rendering paradigmas
Webhooks
CSS
Note
Box model
CSS
Flexbox
Grid
Layouting
Responsiveness
Units
Width and heigth
DaisyUI
intro
Elysia.js
intro
Express
Security issues
Hono
Cookies
Hono intro
Static files
HTMX
HTMX intro
HTTP
Websockets
Autobahn
WebSockets
HTTP
Redirects
Status codes
Streaming
Micro frontends
intro
Module federation
Next.js
cache
Next.js
Next.js web components
NextAuth
Preact
Preact intro
React
Activity
Compiler
Forms in React
Intro React
React Query
React.Memo
Strict mode (React.js)
Suspense
SWR
useEffect
useMemo
Remix
Remix
ReScript
ReScript Intro
RxJS
filter
fromEvent
map
merge
Observable and observers
of
Operators
pipe
Promises
ReplaySubject
RxJS intro
Subscriptions & subscribers
switchMap
tap
zip
Security
Cross-site-scripting
Shared mutable state vulnerability (web backend)
Solid
Conditional Rendering
Solid
Solid Start
Svelte
SvelteKit
Adapters
Bundle strategies
Forms
Layout
Loaders
Page options
Preloading
Server actions
Single-page SvelteKit
Streaming promises
Superforms
SvelteKit
$derive
$effect
$state
Actions
Binding values
Event handling
Form validation
Lazy loading
Logic blocks
Props
Reactivity
Runes
Stores
Svelte Intro
Tanstack Query
Untitled
Web components with Svelte
window object
Tailwind
Container
Flex
Frameworks
Gradients
Grid
Lists
Tailwind
Tailwind Basics
Tailwind Configuration
Transforms
Tanstack Start
Tanstack Start
Tauri
Distribution and Licensing (Tauri)
Tauri
Tools
rspack
Vue
Event handling
Intro
SFC
State management
Web Components
Intro Web Components
Lit.js
PWA
WebAssembly
WebAssembly
Wordpress
htaccess
Caddy
Clerk
Convex
Coolify
CORS
Dictionary
Error Tracking
Fly.io
Gobuster
Hanko
Immutable.js
ky
Lucia
MCP servers
NPM
PNPM
Pocketbase
Progressive web apps
Quartz
Qwik
React Router
RSS
RxDB
Sentry
SST
Subfinder
Supertokens
Tanstack Query
Traefik
tRPC
Vinxi
Vite
Vite Plus
Web sockets
2025-07-06
index
Kotlin
Obsidian
Home
/
Database & ORM
/
Postgresql
/
Full-text search in Postgres
1 min read
4 words
Updated Sep 24, 2026
Created Sep 24, 2026
#Database
#SQL
#postgresql
Resources
https://neon.com/postgresql/postgresql-indexes/postgresql-full-text-search