NigelEarle

Migrations & Seeding

What are migrations??

Migrations are a way to make database changes or updates, like creating or dropping tables, as well as updating a table with new columns with constraints via generated scripts. We can build these scripts via the command line using knex command line tool.

To learn more about migrations, check out this article on the different types of database migrations!

Creating/Dropping Tables

NigelEarle

Knex Setup Guide

Create your project directory

Create and initialize your a directory for your Express application.

$ mkdir node-knex-demo
$ cd node-knex-demo
$ npm init

lg3bass

//Use FFprobe to get data.
//source (and other things to query.)
https://trac.ffmpeg.org/wiki/FFprobeTips

//get the bitrate on a list of files.
for FILENM in *.flv; do ffprobe -v error -show_entries format=bit_rate -of csv $FILENM; done;
//result
format,509845
format,519899
format,504639

vadimshvetsov

/**
 * Consume update args object for document and can handle one level nesting.
 * Returns object for leverage by $set in Mongoose update function.
 *
 * @param args
 * @returns {{}}
 */
const objectToDotNotation = (args) => {
  const setObject = {};
  Object.keys(args).forEach((key) => {

Nks

<?php

namespace App\Listeners;

use App\Media;
use FFMpeg\FFMpeg;
use FFMpeg\Format\Video\X264;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Queue\SerializesModels;

vielhuber

# best practice: linux
nano ~/.pgpass
*:5432:*:username:password
chmod 0600 ~/.pgpass

# best practice: windows
edit %APPDATA%\postgresql\pgpass.conf
*:5432:*:username:password

# linux

vasanthk

System Design Cheatsheet

Picking the right architecture = Picking the right battles + Managing trade-offs

Basic Steps

1. Clarify and agree on the scope of the system

• User cases (description of sequences of events that, taken together, lead to a system doing something useful)
  • Who is going to use it?
  • How are they going to use it?

vluzrmos

<?php

namespace App\Http;

/**
 * Description of VideoStream
 *
 * @author Rana
 * @link https://gist.github.com/vluzrmos/d5682ad426525196d069
 */

jakebathman

<?php
  /*
    * 
    * Based on (forked from) the work by https://gist.github.com/Kostanos
    *
    * This revision allows the PHP file to be included/required in another PHP file and called as a function, rather than focusing on command line usage.
    * 
    * Convert JSON file to CSV and output it.
    *
    * JSON should be an array of objects, dictionaries with simple data structure

msurguy

Other people's projects:

• https://github.com/laracasts/URL-Shortener URL Shortener by Jeffrey Way
• https://github.com/basco-johnkevin/laravelsnippets Source code of http://laravelsnippets.com website
• https://github.com/jesseterry/FusionInvoice FusionInvoice is built for freelancers and small businesses who need a simple, yet powerful self-hosted web based invoicing system.
• https://github.com/ezynda3/burnmsg is a self-destructing encrypted message app. A demo is also running on https://burnmsg.com
• https://github.com/martindilling/auto-generating-gallery the demo is at http://gallerydemo.martindilling.com/

My projects (tutorials are on my blog at http://maxoffsky.com):

• https://github.com/CodepadME/laravel-tricks - Source of Laravel-tricks.com