⚡ Live Sandbox: AI Dev Tool: Show HN SubSmith

📝 Editable Code Sandbox

```python
# AI Dev Tool: PostgreSQL Vector Search Extension Boilerplate
# Description: A production-ready boilerplate for building vector search applications with PostgreSQL

import os
import psycopg2
from psycopg2 import Error
from typing import List, Dict

# PostgreSQL connection settings
DB_HOST = os.environ.get('DB_HOST', 'localhost')
DB_NAME = os.environ.get('DB_NAME', 'vector_search')
DB_USER = os.environ.get('DB_USER', 'postgres')
DB_PASSWORD = os.environ.get('DB_PASSWORD', 'password')

# Create a PostgreSQL connection
def create_connection():
    """
    Creates a connection to the PostgreSQL database.
    
    Returns:
    connection (psycopg2.connection): A connection object to the PostgreSQL database.
    """
    try:
        connection = psycopg2.connect(
            host=DB_HOST,
            database=DB_NAME,
            user=DB_USER,
            password=DB_PASSWORD
        )
        return connection
    except Error as e:
        print(f"Error creating connection: {e}")
        return None

# Create a vector search table
def create_vector_search_table(connection: psycopg2.connection, table_name: str):
    """
    Creates a vector search table in the PostgreSQL database.
    
    Args:
    connection (psycopg2.connection

🖥️ Interactive Execution Terminal Console

⚡ Ready! Click ▶️ Run Code to execute code in browser terminal...