Skip to content

Instantly share code, notes, and snippets.

Gajus Kuizinas gajus

Block or report user

Report or block gajus

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View query.sql
EXPLAIN ANALYZE
SELECT
hrp1.id
FROM http_request_plan hrp1
LEFT JOIN LATERAL (
SELECT
count(*) request_count,
CASE
WHEN count(*) = 0
THEN NULL
View gist:4d6da2135c0563cb7593352903b5d9d0
(node:73239) UnhandledPromiseRejectionWarning: Error: Client was closed and is not queryable
at process.nextTick (/Users/gajus/Documents/dev/gajus/slonik/node_modules/pg/lib/client.js:471:25)
at process.internalTickCallback (internal/process/next_tick.js:70:11)
(node:73239) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 2)
(node:73239) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
error TypeError: cancellableConnectionRoutine(...).resolve is not a function
at resolve (/Users/gajus/Documents/dev/gajus/slonik/src/.sandbox/test.js:33:12)
at new Promise (<anonymous>)
at pool.connect (/Users/gajus/Documents/dev/gajus/slonik/src/.sandbox/test.js:19:14)
at process.in
View lookup_alternative_ids_by_imdb_id.sparql
SELECT
?ROTEN_TOMATOES_ID
?METACRITIC_ID
WHERE
{
?item wdt:P345 "${movieRecord.imdbId}" .
OPTIONAL {
?item wdt:P1258 ?ROTEN_TOMATOES_ID .
?item wdt:P1712 ?METACRITIC_ID .
}
View deduplicated-response.json
{
"data": {
"events": {
"__typename": "EventsConnection",
"edges": [
{
"__typename": "EventsEdge",
"node": {
"__typename": "Event",
"attributes": [
View full-response.json
This file has been truncated, but you can view the full file.
{
"data": {
"events": {
"__typename": "EventsConnection",
"edges": [
{
"__typename": "EventsEdge",
"node": {
"__typename": "Event",
View campaigns.csv
Yakuza €25.00
Leonardo Da Vinci €25.00
St Peter's and the papal Basilicas €25.00
Chocolat €25.00
Les Tuches 2 €25.00
Hail Ceasar €25.00
Les Visiteurs €25.00
Marseille €25.00
Thomas & Friends: The Great race €25.00
Retour chez ma mère €25.00
View gist:01aca278295325d750f97341acb3d5cb
Yakuza,€25.00
Leonardo Da Vinci,€25.00
St Peter's and the papal Basilicas,€25.00
Chocolat,€25.00
Les Tuches 2,€25.00
Hail Ceasar,€25.00
Les Visiteurs,€25.00
Marseille,€25.00
Thomas & Friends: The Great race,€25.00
Retour chez ma mère,€25.00
You can’t perform that action at this time.