Databases

PostgreSQL Link to heading
- PostgreSQL
SQLite Link to heading
- Quirks, Caveats, and Gotchas In SQLite
- Appropriate Uses For SQLite
- libSQL- fork of SQLite that is both Open Source, and Open Contributions.
Learnings from migrating from PostgreSQL to SQLite. Link to heading
- Ordering nulls Link to heading
  - On PostgreSQL, date columns ordered DESC returns nulls first and ASC returns nulls last;
  - On SQLite, it’s the opposite: ASC returns nulls first and DESC returns nulls last. This can be changed using the “NULLS LAST” or “NULLS FIRST” syntax. “SQLite considers NULL values to be smaller than any other values for sorting purposes.”.
- Ordering unicode chars Link to heading
  - SQLite doesn’t support ordering unicode chars by default (documented here).
Vector Link to heading
- What is a Vector Database? by Pinecone
- Why Use a Vector Database?
  1. Semantic search;
  2. Similarity search for images, audio, video, JSON, and other forms of unstructured data;
  3. Ranking and recommendation engines;
  4. Deduplication and record matching;
  5. Anomaly detection
- Options Link to heading
  - Amazon OpenSearch
  - Chroma - SQLite of vector databases
  - Elasticsearch Vector Search
  - GraphDB
  - Kùzu
  - LanceDB - Repo
  - milvus
  - pgvector - Python support
  - Pinecone
  - Qdrant - vector similarity search engine and database - Python client - used by OpenAI and xAI #OpenSource
  - typesense - #OpenSource
  - VectorDB
  - Weaviate

PostgreSQL Link to heading