Main Page - Revision history

Admin: /* PSQL, Postgres, PostgreSQL */

2021-07-09T15:34:24Z

‎PSQL, Postgres, PostgreSQL

2021-05-17T15:15:03Z

‎Python

2021-04-23T00:49:51Z

‎MySQL

2021-01-25T22:05:50Z

‎Up-to-Date Versions of Packages

2020-05-11T07:17:08Z

‎Up-to-Date Versions of Packages

2020-04-08T15:42:36Z

‎PHP

2020-04-01T12:40:59Z

‎Bash

2020-03-20T17:52:16Z

‎ffmpeg

2020-01-24T12:12:42Z

‎git

2020-01-06T08:40:35Z

‎AWS

← Older revision		Revision as of 15:34, 9 July 2021
Line 211:		Line 211:

	=== [[Short Notes on PSQL\|PSQL, Postgres, PostgreSQL]] ===		=== [[Short Notes on PSQL\|PSQL, Postgres, PostgreSQL]] ===
		+
		+	* Dump and Restore
		+	* Delete Duplicate Rows
		+	* Set Sequence Value to Max of Table's ID

	=== [[Short Notes on Python\|Python]] ===		=== [[Short Notes on Python\|Python]] ===

@@ Line 220: / Line 220: @@
 * virtualenv
 * SQLAlchemy
 === [[RedBeanPHP Cheat Sheet]] ===

@@ Line 193: / Line 193: @@
 * Error 1045: Access denied
 * The <tt>insert ... on duplicate key update</tt> Pitfall
 === [[Short Notes on PDF|PDF]] ===

@@ Line 277: / Line 277: @@
 * '''NPM, node.js, etc.'''
 The default <tt>apt</tt> ''npm'' version is awfully outdated.
 Add NodeSource APT repo; for other versions, e.g. 12.x, change to <tt>setup_12.x</tt>.

@@ Line 271: / Line 271: @@
 <pre>$ sudo add-apt-repository ppa:deadsnakes/ppa
 $ sudo apt update
-$ sudo apt install python3.7</pre>
+$ sudo apt install python3.7 python3.7-venv</pre>
 Since these do not override default <tt>python</tt> and <tt>python3</tt> links (and better not!), you should create corresponding venv's as:
 <pre>$ python3.7 -m venv [env-dir]</pre>

@@ Line 207: / Line 207: @@
 * Prevent Client Disconnect from Killing PHP
 * Disconnect Client and Continue Processing
 === [[Short Notes on Python|Python]] ===

@@ Line 65: / Line 65: @@
 $ find . -mtime +5 -exec rm {} \; - delete all files in this folder that are older than 5 days
 <Ctrl-u> ... <Ctrl-y>             - Ctrl+u will cut current command, then you can do whatever you need, and Ctrl+y will paste it back
-$ date -d @1234567890             - convert unix timestamp to human-readable</pre>
+$ date -d @1234567890             - convert unix timestamp to human-readable
 * ''Informations''
 <pre>$ mount | column -t               - pretty-print mount table

@@ Line 138: / Line 138: @@
 * ''fade in and out, first and last 25 frames of a 1000 frame video''
   ffmpeg -i input.mp4 -vf "fade=in:0:25,fade=out:975:25" -acodec copy out.mp4
 ==== [[Short Notes on ffmpeg|more on ffmpeg]] ====

← Older revision		Revision as of 12:12, 24 January 2020
Line 148:		Line 148:

	=== [[Short Notes on git\|git]] ===		=== [[Short Notes on git\|git]] ===
		+
		+	=== [[Short Notes on JS\|All things JS - React, Vue, ...]] ===

	=== [[Small Kyoto Cabinet and Kyoto Tycoon Notes\|Kyoto Cabinet and Kyoto Tycoon]] ===		=== [[Small Kyoto Cabinet and Kyoto Tycoon Notes\|Kyoto Cabinet and Kyoto Tycoon]] ===

@@ Line 40: / Line 40: @@
 * Debugging (lack of) connection to instance
 * Authorization header being removed by ElasticBeanstalk
 === [[Short Notes on Bash|Bash]] ===