cpursley

PostgreSQL is Enough

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

Background and Cron Jobs

prrao87

"""
HackerNews module.
"""
import logging

import asyncio
from operator import itemgetter

import httpx

osanseviero

""" Chrome Manifest file: https://developer.chrome.com/docs/extensions/mv3/getstarted/
{
    "manifest_version": 3,
    "name": "Hugging Face Question Generator",
    "version": "1.0",
    "description": "Generate questions based on selected text",
    "permissions": [
        "contextMenus",
        "storage",
        "tabs",

jeremychone

#![allow(unused)] // silence unused warnings while exploring (to comment out)

use sqlx::postgres::{PgPoolOptions, PgRow};
use sqlx::{FromRow, Row};

// Youtube episode: https://youtu.be/VuVOyUbFSI0

// region:    Section

// Start postgresql server docker image:

prrao87

function ConnectButton(){
    console.log("Connect pushed"); 
    document.querySelector("#top-toolbar > colab-connect-button").shadowRoot.querySelector("#connect").click() 
}

setInterval(ConnectButton,60000);

prrao87

# Install python ipykernel with environment name
python -m ipykernel install --user --name=<my_env_name>

# List or uninstall existing virtual envs for Jupyter
jupyter kernelspec list
jupyter kernelspec uninstall <my_env_name>

prrao87

# Do not use the alias `python3` 
# For this to work properly, explicitly specify the python version as necessary on your system
function venv {
    default_envdir=".venv"
    envdir=${1:-$default_envdir}

    if [ ! -d $envdir ]; then
        python3.12 -m venv $envdir
        python3.12 -m pip install ruff
        echo -e "\x1b[38;5;2m✔ Created virtualenv $envdir\x1b[0m"

anand2312

pymongo vs Motor

Motor is an async Python driver for MongoDB.

When should I use Motor?

You should use Motor when you're trying to interact with a MongoDB database in an asynchronous context. When you're making something that needs to be asynchronous (like a web server, or most commonly from what I've seen here, Discord bots), you also want all the database calls to be done asynchronously. But pymongo is synchronous, i.e it is blocking, and will block the execution of your asynchronous program for the time that it is talking to the database.

Okay, How do I switch now?!

Thankfully for us, switching from pymongo to Motor isn't too hard, and won't need you to change much code. This process can be roughly summarized as:

Step 1: Install Motor, and import it

Installing can be done with pip - pip install motor

danielmichaels

"""
HackerNews module.
"""
import logging

import asyncio
from operator import itemgetter

import httpx

ines

function venv {
    default_envdir=".env"
    envdir=${1:-$default_envdir}

    if [ ! -d $envdir ]; then
        python -m venv $envdir
        pip install ipython black flake8
        echo -e "\x1b[38;5;2m✔ Created virtualenv $envdir\x1b[0m"
    fi
    source $envdir/bin/activate