| SELECT slot_name, | |
| pg_wal_lsn_diff( | |
| pg_current_wal_lsn(), | |
| restart_lsn | |
| ) AS bytes_behind, | |
| active, | |
| wal_status | |
| FROM pg_replication_slots | |
| WHERE wal_status <> 'lost' | |
| ORDER BY restart_lsn; |
Modern OpenSSH has native support for FIDO Authentication. Its much simpler and should also be more stable with less moving parts. OpenSSH also now has support for signing arbitary files witch can be used as replacement of gnupg. Git also supports signing commits/tags with ssh keys.
ssh, ssh-add and ssh-keygen on most computers
| /** | |
| Copyright <2021> <Lexxicon Studios LLC.> | |
| Permission is hereby granted, free of charge, to any person obtaining a copy of this | |
| software and associated documentation files (the "Software"), to deal in the Software | |
| without restriction, including without limitation the rights to use, copy, modify, | |
| merge, publish, distribute, sublicense, and/or sell copies of the Software, | |
| and to permit persons to whom the Software is furnished to do so, subject to the | |
| following conditions: | |
| The above copyright notice and this permission notice shall be included in all copies | |
| or substantial portions of the Software. |
| alter table books | |
| add constraint books_doc_isbn_ok | |
| check( | |
| doc->>'ISBN' is not null and | |
| jsonb_typeof(doc->'ISBN') = 'number' and | |
| (doc->>'ISBN')::bigint > 0 and | |
| length(doc->>'ISBN') = 13 | |
| ); |
| import xml.etree.ElementTree as ET | |
| import urllib.request | |
| import re | |
| namespaces = {'nhc': 'http://www.nhc.noaa.gov'} | |
| # Drill: https://www.nhc.noaa.gov/rss_examples/index-at-20130605.xml | |
| xml = urllib.request.urlopen('https://www.nhc.noaa.gov/index-at.xml').read() | |
| root = ET.fromstring(xml) | |
| hurricane = root[0].find('item/nhc:Cyclone', namespaces) |
| <?php | |
| require '../vendor/autoload.php'; | |
| $request = Symfony\Component\HttpFoundation\Request::createFromGlobals(); | |
| $context = (new Symfony\Component\Routing\RequestContext())->fromRequest($request); | |
| $configLocator = new Symfony\Component\Config\FileLocator(__DIR__ . '/../config'); | |
| $file = '../var/cache/container.php'; | |
| if (\file_exists($file)) { |
| #define FFI_SCOPE "SDL" | |
| #define FFI_LIB "libSDL2.so" | |
| typedef uint8_t Uint8; | |
| typedef uint16_t Uint16; | |
| typedef uint32_t Uint32; | |
| typedef uint64_t Uint64; | |
| extern int SDL_Init(Uint32 flags); | |
| extern int SDL_InitSubSystem(Uint32 flags); |
| if ( $var == 'crazy' && $foo != 'bar' ) | |
| seems very unreadable for me. |
| Github Suggestion Box | |
| --------------------- | |
| Please, put your suggestions here. Octocat thanks you! | |
| * Discussion module for each repository, allowing contributors and users to discuss various aspects of the repository |
| #!/bin/bash | |
| if [ "${GIT_BRANCH}" == "origin/master" ] | |
| then | |
| do stuff | |
| else | |
| do other stuff | |
| fi |