Hervé hervehobbes

$/
  artifacts/
  build/
  docs/
  lib/
  packages/
  samples/
  src/
 tests/

Redis FAQ or: what you learn when idling in #redis

First: this here is the unofficial FAQ, only containing things that come up by users in the IRC channel #redis on Freenode. There's also a more official FAQ. This document is also available on my site.

X is weird in my instance. Can you help?

Maybe. To better help please give the following info:

Output of redis-cli INFO
Output of redis-cli CONFIG GET '*'

Conventions:

Defining Eloquent model (will assume that DB table named is set as plural of class name and primary key named "id"):

class Shop extends Eloquent {}

Using custom table name

protected $table = 'my_shops';

Date/time pickers :

https://github.com/dbushell/Pikaday - Date picker with lots of customizations and easy time format options.

Sorting of items:

Capture Signature

Awesome PHP

Awesome PHP has been relocated permanently to its own Github repository. No further updates will made to this gist.

Please open an issue for any new suggestions.

Update 2020 Edition: Use something like Airsonic instead. Subsonic's code is closed source at this point, and thus this patch is useless, unless you are using a 9 year old verison of Subsonic for some reason.

A patch to disable the licensing functionality in Subsonic, a GPL-licensed media streaming server/web interface. Use of the mobile apps requires you to get a license after 30 days of trial. You obtain a license via donation.

Except that's not a donation. So, here's a patch to fix that. Support the Subsonic project with a donation that's actually a donation. The program is developed and maintained very well.

	* {
	font-size: 12pt;
	font-family: monospace;
	font-weight: normal;
	font-style: normal;
	text-decoration: none;
	color: black;
	cursor: default;
	}

	// Pre-requisites:
	// 1. Device core plugin
	// 2. Splashscreen core plugin (3.1.0)
	// 3. config.xml: <preference name="AutoHideSplashScreen" value="false" />
	// 4. config.xml: <preference name="DisallowOverscroll" value="true" />

	function onDeviceReady() {
	if (parseFloat(window.device.version) >= 7.0) {
	document.body.style.marginTop = "20px";
	// OR do whatever layout you need here, to expand a navigation bar etc

	#lo sauer, 2013 - www.lsauer.com
	#see: http://www.lsauer.com/2013/05/mysql-fuzzy-searching-fulltext-queries.html
	#Note: In MySQL SUBSTRING, the string-index starts at position 1
	SELECT * FROM tablename
	WHERE SOUNDEX(tablename_field)
	LIKE CONCAT('%',SUBSTRING(SOUNDEX('Fuzti serch derm'),2),'%');

	Copyright (c) 2012, Mark Embling
	All rights reserved.

	Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

	- Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.

	- Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.

	- Neither the name of Mark Embling nor the names of any contributors may be used to endorse or promote products derived from this software without specific prior written permission.