ibraheem4

Installing Postgres via Brew

Pre-Reqs

Brew Package Manager

In your command-line run the following commands:

1. brew doctor
2. brew update

imankulov

#!/usr/bin/env ipython -i
import datetime
import json
from typing import Optional

import sqlalchemy as sa
from sqlalchemy.orm import declarative_base, sessionmaker
from sqlalchemy.dialects.postgresql import JSONB

from pydantic import BaseModel, Field, parse_obj_as

macintux

• Getting into public speaking (https://james.brooks.page/blog/getting-into-public-speaking)
• So You Want To Speak At Software Conferences? (https://dylanbeattie.net/2025/12/08/so-you-want-to-speak-at-software-conferences.html)
• How to Give a Good Talk (https://blog.sigplan.org/2025/03/31/how-to-give-a-good-talk/)
• My 18 tips to deliver great presentations (https://jmmv.dev/2020/07/presentation-tips.html)
• My 18 steps to prepare a great presentation (https://jmmv.dev/2020/07/presentation-preparation.html)
• 100 Tricks to Make Better Presentations (https://github.com/ciberado/100-trucos-para-hacer-mejores-presentaciones/blob/main/README.en.md)
• A command-line based markdown presentation tool (https://github.com/visit1985/mdp)
• Giving a presentation with perfect UI/UX design (https://habr.com/en/post/471624/)
• Very Important Strangers (http://randsinrepose.com/archives/very-important-strangers/)
• Edward Tufte's site (http://www.edwardtufte.com/)

rosswd

Setting up github and bitbucket on the same computer (Windows)

Guide for Windows

mix3d asked for some help using this guide with windows so here we go. This was tested with Windows 10. Run all commands in Git Bash once it's installed.

Github will be the main account and bitbucket the secondary.

Git for Windows

• Download and install Git for Windows
  • In the installer, select everything but decide if you want a desktop icon (2nd step)

Filimoa

"""
Based off Stripe's checkout repo, see the link for the Flask analogue. 

https://github.com/stripe-samples/checkout-one-time-payments/blob/master/server/python/server.py

Assumes project is structured like:

    src/
        backend/
            app.py

Filimoa

import re
from typing import Dict
from io import StringIO
from dateutil import parser

from sqlalchemy import create_engine
import pandas as pd

def is_date(string):
    if string.isnumeric():

savchenko

anhthii

Prepare for SQL interview questions

Tutorial

SQL tutorial: https://tutorial.techaltum.com/SQLServer.html

Sample questions and solutions

• SQl subquery: https://www.dofactory.com/sql/subquery
• SQL Query Questions and Answers for Practice: http://www.complexsql.com/sql-query-questions-and-answers-for-practice/
• Database/SQL Interview Questions: https://www.programmerinterview.com/index.php/database-sql/introduction/
• 50 SQL Query Questions And Answers For Practice: https://www.techbeamers.com/sql-query-questions-answers-for-practice/

juanplopes

import heapq

def schedule(tasks):
    heap = []
    def offer(begin, end):
        while heap and heap[0] <= begin:
            heapq.heappop(heap)
        heapq.heappush(heap, end)
        return len(heap)