Pinned Loading

1. Open clicked URLs into a particular ... Open clicked URLs into a particular Google Chrome profile

   1

   ## Problem

   2

   When I click on links from Slack or Outlook on MacOS they open in seemingly random browser windows/profiles. This is annoying.

   3

   4

   ## Solution

   5

   Open links in a particular google chrome profile window. Be less annoyed.

2. Vector database for AI Vector database for AI

   1

   # Quick Setup: PostgreSQL with pgvector for AI Projects

   2

   3

   If you need a working vector database for your AI project in no time, this guide is for you. Setting up PostgreSQL with `pgvector` is super easy, and Docker makes it even more convenient.

   4

   5

   ## Step 1: Run PostgreSQL with `pgvector`

3. SQLModel Timestamp Mixing - add the ... SQLModel Timestamp Mixing - add the usual fields to your data model with ease

   1

   """

   2

   Adding this SQLModel mixin will add created_at, updated_at, and deleted_at to your tables.

   3

   `created_at` will auto-populate upon creation. `updated_at` will do the right thing on updates.

   4

   5

   Usage:

4. Recipe for converting Pydantic model... Recipe for converting Pydantic models to SQLModel while still supporting the ability to fully emit nested schema and model data.

   1

   # Emitting Fully Nested Python Schemas and Models with SQLModel

   2

   3

   I ran into a problem while developing some cool tools. I had a nested Pydantic structure that I needed to migrate to SQLModel. But, I needed to retain the ability to emit fully nested schema and models -- which was lost. So, I had to write a few helper functions and models.

   4

   5

   In the realm of modern web development and data-driven applications, managing complex data structures and their relationships can be a daunting task. SQLModel, a powerful library that bridges the gap between SQLAlchemy and Pydantic, offers an elegant solution for defining and interacting with SQL databases using Python. In this small write up, we dive  into a practical demonstration of leveraging SQLModel to emit fully nested Python schemas and models. Surprisingly, this doesn't work out of the box.

5. geolocation_mixin.py geolocation_mixin.py

   1

   ## Geolocation with SQLModel

   2

   3

   Need to use [postgis](https://postgis.net/) with [SQLModel](https://sqlmodel.tiangolo.com/)? This example will show you how.

   4

   5

   This gist demonstrates how to integrate a geolocation field into your SQLModel projects by directly adding a geometry column representing a point on Earth. The `GeolocationMixin` class provides an easy way to store and serialize geospatial data, specifically using PostGIS to handle `POINT` geometry types.

6. Llama Index Filtered Query Engine Ex... Llama Index Filtered Query Engine Example

   1

   # Selectively Querying Documents in Llama Index

   2

   3

   **Note:** This gist has been updated to be far simpler than the original implementation, focusing on a more streamlined approach to selectively querying documents based on metadata.

   4

   5

   ## Introduction