SELECT DISTINCT colA, colB, colC picks only one row per distinct combination of all columns colA and colB and colC, dropping the duplicates.
Source: https://chartscreator.com/blog/postgresql-distinct-on-multiple-columns/
Noitidart Noitidart
Noitidart
/ .gitignore
Last active
May 4, 2026 03:39
Difftastic Git Shortcuts — structural diff aliases (gdu, gds, gdh, gdb, gdr, gl, glo)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| .DS_Store |
Noitidart
/ persistoid__expo-file-engine.ts
Created
March 27, 2025 01:41
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import * as FileSystem from 'expo-file-system'; | |
| import { Platform } from 'react-native'; | |
| import { IStorageEngine } from 'lib/persistoid'; | |
| import { addDebugBreadcrumb, addErrorBreadcrumb } from 'lib/sentry'; | |
| function isAndroidMissingFileOrDirectoryError(error: unknown) { | |
| if ( | |
| Platform.OS === 'android' && | |
| hasMessage(error) && |
Noitidart
/ prefs.json
Last active
May 10, 2023 20:59
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "editor.inlineSuggest.enabled": true, | |
| "github.copilot.enable": { | |
| "*": false, | |
| "plaintext": false, | |
| "markdown": false, | |
| "scminput": false, | |
| "ts": true, | |
| "js": true, | |
| "jsx": true, |
Noitidart
/ useRadio.ts
Created
April 8, 2022 23:49
maybe useful maybe not. i made but never used it.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import { useMemo, useRef } from 'react'; | |
| import { useMemoizedFn } from 'ahooks'; | |
| import { noop } from 'lodash'; | |
| type UseRadioInputs = { | |
| // Defaults to undefined | |
| defaultValue?: any; | |
| onChange?: (value: any) => void; |
Noitidart
/ DetoxExpo.js
Created
February 27, 2022 18:04
— forked from haibert/DetoxExpo.js
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1. yarn add --dev detox jest-circus | |
| 2. detox init -r jest (This creates the e2e folder along with the .detoxrc.json) | |
| 3. yarn add --dev eslint-plugin-detox (optional) | |
| plugins: [...'detox'...], | |
| - Add this to your eslint config plugins | |
| 4.Make sure your your **eas.json** has a simulator build set up that looks like this then create a simulator release build by running: **eas build --profile simulator --platform ios** | |
| "simulator": { | |
| "ios": { | |
| "simulator": true, |
Noitidart
/ postgres-notes.md
Created
August 3, 2021 15:34
Noitidart
/ mac-hotkeys.md
Created
June 23, 2021 04:31
Paste without formating - Command+Option+Shift+V - https://www.howtogeek.com/285319/how-to-paste-text-without-formatting-on-macos/
Noitidart
/ _ff-addon-snippet-macIdleTime.js
Created
June 17, 2021 21:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Cu.import('resource://gre/modules/ctypes.jsm'); | |
| const cg = ctypes.open('/System/Library/Frameworks/CoreGraphics.framework/CoreGraphics'); | |
| const CFTimeInterval = ctypes.double; | |
| const CGEventSourceStateID = ctypes.uint32_t; | |
| const CGEventType = ctypes.uint32_t; | |
| const kCGEventSourceStateCombinedSessionState = 0; | |
| const kCGAnyInputEventType = 0xFFFFFFFF; |
Noitidart
/ modal-context.js
Created
June 3, 2021 16:30
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import React, { | |
| Children, | |
| createContext, | |
| useContext, | |
| useEffect, | |
| useRef, | |
| useState | |
| } from 'react'; | |
| import { |
Noitidart
/ withHookedInput.js
Created
May 19, 2021 02:45
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import React, { useCallback, useEffect, useRef } from 'react';import { defaults, omit, pick } from 'lodash'; | |
| import { useController, UseControllerProps } from 'react-hook-form'; | |
| import { TextInput, TextInputProps } from 'react-native';import { HookedInputTransformer } from 'src/lib/react-hook-form-transforms';interface HookedTextInputProps | |
| extends Omit<TextInputProps, 'defaultValue'>, | |
| UseControllerProps { | |
| transform?: HookedInputTransformer; | |
| }export default function withHookedInput( | |
| ControlledInputComponent: typeof TextInput | |
| ) { | |
| function HookedInput({ transform, ...props }: HookedTextInputProps) { |
NewerOlder