techntools

pragma	value	explanation
journal_mode	wal	Allows many readers to operate with 1 writer
cache_size	-1 * 64000	Set page-cache size in KiB, e.g. -64000 = 64MB
synchronous	1	Sync at the most critical moments
foreign_keys	1	Enforce foreign-key constraints
ignore_check_constraints	0	Enforce CHECK constraints
busy_timeout	5000	Wait until the database is not locked/timeout is reached
temp_store	2	Temporary files are stored in memory

techntools

'''
Proof of Concept: 

Django devs built an ORM that seems way more straightforward than many existing tools. This class lets you leverage the django-orm without any project settings or other aspects of a django setup.

There are probably weak points and functionality missing, but it seems like a relatively intuitive proof of concept
'''
import os
import django
from django.conf import settings

techntools

plugin
    naming convention: name_of_plugin.vim
    these files are sourced for all file types

doc
    naming convention: name_of_plugin.txt
    these files document the functionality of a plugin

color
    naming convention: name_of_colorscheme.vim

techntools

Off the beaten path

What is &path used for?

Vim uses :help 'path' to define the root directories from where to search non-recursively for files.

It is used for:

• gf, gF, <C-w>f, <C-w>F, <C-w>gf, <C-w>gF,
• :find, :sfind, :tabfind,

techntools

" Adapted from https://github.com/drmikehenry/vimfiles/blob/e5c369dadde340ead7438b0c4937c3f470acf524/vimrc#L3239
"
"  With --extra=+f in ~/.ctags respectively --extras=+f in
"  ~/.config/ctags/default.ctags, filenames are tags, too, so
"  the following mappings will work when a file isn't in the path.
"
" For automatic (C)tags generation, see either
" https://tbaggery.com or https://bolt80.com/gutentags/

nnoremap <silent> gf         :<c-u>call <sid>gf("gf")<cr>

techntools

TypeScript ftplugin

Attention! All this is a work in progress.

Include search

:help 'include' is set so that Vim recognizes both:

import Foo from 'foo';

techntools

Pub/sub with MongoDB and Node.js

Setup:

$ mongo
> use pubsub
> db.createCollection('messages', { capped: true, size: 100000 })
> db.messages.insert({})

techntools

Create ssh tunnel and connect to the remote mongo database on command line

Assume followings:

/mykeys/.ssh/prodserver.pem - is a certificate file

umid - is a user name

111.111.111.111 - is a remote host, that mongodb runs

techntools

// ------------------------------------------------------------------
// Friend collection, where _id is a user.Id and Friends is a list, of user.Id.
// Note: friending and unfriending is a two step operation in this scheme:

> db.friends.find()
{ "_id" : 1, "friends" : [    2, 3, 4    ] }
{ "_id" : 2, "friends" : [ 1,    3,    5 ] }
{ "_id" : 3, "friends" : [ 1, 2,    4, 5 ] }
{ "_id" : 4, "friends" : [ 1,    3,    5 ] }
{ "_id" : 5, "friends" : [    2, 3, 4    ] }