Skip to content

Instantly share code, notes, and snippets.

View jimmyff's full-sized avatar

Jimmy Forrester-Fellowes jimmyff

View GitHub Profile
@jimmyff
jimmyff / pg_random_int_array.sql
Created July 14, 2020 15:38 — forked from ekho/pg_random_int_array.sql
Postgresql function for generating random integer array
CREATE OR REPLACE FUNCTION random_int_array(dim integer, min integer, max integer) RETURNS integer[] AS $BODY$
begin
return (select array_agg(round(random() * (max - min)) + min) from generate_series (0, dim));
end
$BODY$ LANGUAGE plpgsql;
-- usage example
select random_int_array(15, 6, 40);
-- return example
@jimmyff
jimmyff / User Settings.json
Created April 17, 2018 10:58
Dart development user settings [VS Code]
{
"window.zoomLevel": 0,
"workbench.activityBar.visible": true,
"editor.minimap.enabled": false,
"editor.formatOnSave": true,
"editor.formatOnType": false,
"workbench.colorTheme": "Ayu Mirage",
"workbench.iconTheme": "material-icon-theme",
"editor.fontSize": 12,
"editor.lineHeight": 0,
// error:
// `EXCEPTION: CastError: Casting value of type '_Future<BaseModel>' to type 'Future<SearchPublicProfileSummaryResponse>' which is incompatible`
// search_public_response.dart
abstract class SearchPublicProfileSummaryResponse extends BaseModel
implements
Built<SearchPublicProfileSummaryResponse,
SearchPublicProfileSummaryResponseBuilder>

Keybase proof

I hereby claim:

  • I am jimmyff on github.
  • I am jimmyff (https://keybase.io/jimmyff) on keybase.
  • I have a public key whose fingerprint is EF10 AA8D 9D00 B24B 752D 61F4 FE93 C44A 8EE1 7ECE

To claim this, I am signing this object:

div : x56 paragraphs, 7184 length. 156 tags. 46.05 content ratio. Score: -2816
div : x56 paragraphs, 7184 length. 149 tags. 48.21 content ratio. Score: -2116
div : x55 paragraphs, 7088 length. 146 tags. 48.55 content ratio. Score: -2012
div : x53 paragraphs, 7064 length. 135 tags. 52.33 content ratio. Score: -1136
div : x7 paragraphs, 1965 length. 4 tags. 491.25 content ratio. Score: 2265
div : x7 paragraphs, 1965 length. 1 tags. 1965 content ratio. Score: 2565
div : x45 paragraphs, 5067 length. 116 tags. 43.68 content ratio. Score: -2033
div : x1 paragraphs, 117 length. 5 tags. 23.4 content ratio. Score: -283
div : x1 paragraphs, 117 length. 0 tags. 117 content ratio. Score: 217
div : x1 paragraphs, 266 length. 5 tags. 53.2 content ratio. Score: -134
<IfModule mod_fastcgi.c>
AddHandler php5-fcgi .php
Action php5-fcgi /php5-fcgi
Alias /php5-fcgi /usr/lib/cgi-bin/php5-fcgi
FastCgiExternalServer /usr/lib/cgi-bin/php5-fcgi -host 127.0.0.1:9000 -pass-header Authorization
</IfModule>
// see the 9second time delay in the close event being called:
07-04 15:01:44.695: I/TiAPI(21351): 15:1:44.710: Back button hit!
07-04 15:01:44.715: I/TiAPI(21351): 15:1:44.728: close command issued!
07-04 15:01:54.786: I/TiAPI(21351): 15:1:54.793: WINDOW_HANDLER: Handling close event
// this is the code that fired the above:
var backButtonHandler = function () {
# This is a basic VCL configuration file for varnish. See the vcl(7)
# man page for details on VCL syntax and semantics.
#
# Default backend definition. Set this to point to your content
# server.
#
backend default {
.host = "127.0.0.1";
.port = "8080";
}
try {
if (e && e.success && e.media && e.media.nativePath) {
var encoded = Titanium.Utils.base64encode(e.media);
photoData = encoded.getText();
} else {
}
} catch (e) {
}
explain analyze SELECT c.id,c.user_id,c.memorial_id,c.created,c.modified,c.published, c.requires_approval,
body, heading,
u.title, u.first_name, u.last_name, u.main_pic, u.profile_address, u.verified, u.published, u.active_content,
case when (r.relation is null or r.id=0) then c.relation else r.relation end
FROM memorial_tribute_set_1 c
INNER JOIN "user" as u ON user_id = u.id AND (u.active_content = true OR c.user_id = 312826)
LEFT JOIN user_memorial_relation umr ON (umr.memorial_id = c.memorial_id AND umr.user_id = c.user_id)
LEFT JOIN relation_type r ON umr.relation_id = r.id
WHERE c.memorial_id = '9008'::integer AND c.published = true
AND c.requires_approval = false