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 |