Skip to content

Instantly share code, notes, and snippets.

@esasse
esasse / gist:3230632
Created August 1, 2012 20:55
Stored procedure to generate UUID32 in Firebird 2.5+
CREATE OR ALTER PROCEDURE GEN_UUID32 RETURNS (RESULT CHAR(32))
AS
DECLARE VARIABLE UUID36 CHAR(36);
BEGIN
SELECT
UUID_TO_CHAR(GEN_UUID())
FROM RDB$DATABASE
INTO :UUID36;
SELECT
@esasse
esasse / gist:3497615
Created August 28, 2012 12:22
Function to generate UUID32 in Delphi
function NewUUID32: string;
var
GUID: TGUID;
begin
CoCreateGuid(GUID);
SetLength(Result, 32);
StrLFmt(PChar(Result), 32,'%.8x%.4x%.4x%.2x%.2x%.2x%.2x%.2x%.2x%.2x%.2x',
[Guid.D1, Guid.D2, Guid.D3, Guid.D4[0], Guid.D4[1], Guid.D4[2], Guid.D4[3],
Guid.D4[4], Guid.D4[5], Guid.D4[6], Guid.D4[7]]);
end;
@esasse
esasse / gist:6346957
Created August 26, 2013 21:37
Minimum permission required to upload files to S3 bucket
{
"Version": "2012-10-17",
"Statement": [
{
"Action": [
"s3:PutObject"
],
"Sid": "Stmt1377549922000",
"Resource": [
"arn:aws:s3:::bucket-name/*"
@esasse
esasse / gist:c2df8af137125fff984d
Created August 19, 2014 01:18
Sublime Text Settings
{
"color_scheme": "Packages/User/Railscasts.tmTheme",
"hot_exit": false,
"ignored_packages":
[
"Vintage"
],
"remember_open_files": false,
"rulers":
[
@esasse
esasse / gist:4aa7c48cb262931b1840
Created February 11, 2015 10:37
SublimeText Settings
{
"color_scheme": "Packages/User/Railscasts (SL).tmTheme",
"ensure_newline_at_eof_on_save": true,
"hot_exit": false,
"ignored_packages":
[
"RubyTest",
"Markdown",
"Vintage"
],

Keybase proof

I hereby claim:

  • I am esasse on github.
  • I am esasse (https://keybase.io/esasse) on keybase.
  • I have a public key ASDD68C7WBmZde3I8qxk8x16HJjJJMiW2oafooyBmrsGNAo

To claim this, I am signing this object: