These instructions allow you to intall psql, pg_dump & pg_restore without a full installation of postgresql.
First, install libpq via homebrew
brew doctor
brew update
brew install libpq
DO NOT GIVE ME HIGH LEVEL STUFF, IF I ASK FOR FIX OR EXPLANATION, I WANT ACTUAL CODE OR EXPLANATION!!! I DON'T WANT "Here's how you can blablabla" | |
- Be casual unless otherwise specified | |
- Be terse | |
- Suggest solutions that I didn’t think about—anticipate my needs | |
- Treat me as an expert | |
- Be accurate and thorough | |
- Give the answer immediately. Provide detailed explanations and restate my query in your own words if necessary after giving the answer | |
- Value good arguments over authorities, the source is irrelevant | |
- Consider new technologies and contrarian ideas, not just the conventional wisdom |
These instructions allow you to intall psql, pg_dump & pg_restore without a full installation of postgresql.
First, install libpq via homebrew
brew doctor
brew update
brew install libpq
import requests | |
from tronpy import Tron | |
import trontxsize | |
from tronpy.keys import PrivateKey | |
def get_bandwidth_price(): | |
url = "https://api.trongrid.io/wallet/getchainparameters" | |
response = requests.get(url) | |
data = response.json() |
CREATE OR REPLACE FUNCTION "public"."create_profile_on_signup"() RETURNS "trigger" | |
LANGUAGE "plpgsql" SECURITY DEFINER | |
AS $$begin | |
INSERT INTO public.profile (id) | |
VALUES ( | |
NEW.id | |
); | |
RETURN NEW; | |
end;$$; |
const { | |
id, | |
createClient, | |
CreateAccountError, | |
CreateTransferError, | |
TransferFlags, | |
} = require("tigerbeetle-node"); | |
console.log("Import ok!"); |
########################################################## | |
# Sample .aider.conf.yml | |
# This file lists *all* the valid configuration entries. | |
# Place in your home dir, or at the root of your git repo. | |
########################################################## | |
# Note: You can only put OpenAI and Anthropic API keys in the yaml | |
# config file. Keys for all APIs can be stored in a .env file | |
# https://aider.chat/docs/config/dotenv.html |
let imageBuffer = Buffer.from(body.profilePicture.split(',')[1], 'base64'); | |
console.log(imageBuffer); | |
Jimp.read(imageBuffer, function(err, image) { | |
if (err) { | |
context.done(err, | |
prepareErrorResponse(response, 'Unable to remove EXIF data from profile picture')); | |
} | |
console.log('before transform: ', image); | |
image = image.resize(400, 400).exifRotate((err, exifRotatedData) => { |
import random | |
# Returns a random prime number with n bits | |
def generate_prime(n): | |
while True: | |
p = random.getrandbits(n) | |
if is_prime(p): | |
return p | |
# Returns the result of evaluating a polynomial with coefficients |
TL;DR - jump to the challenge at the end | |
====ON BLOCKING EVIL BOTS===== | |
On a resent job interview I had for "Incapsula" a few days ago I was put to the challenge to break | |
their bot protection mechanism. Apparently node.js is not that common among bot writes and most bots | |
are not able to run javascript. | |
The challenge had two parts - | |
1. find what the code does. | |
2. implement a bot that will break the code without using js. | |
3. think how to make this code unbreakable |