Skip to content

Instantly share code, notes, and snippets.

@deni64k
deni64k / README.md
Last active July 21, 2021 14:02
Ethereum Archive Node (mainnet)

Hi all,

I got my archive node fully synced and want to share access to it for anyone interested.

You can access it via an ngrok tunnel. If I see real interest in it, I will come up with a better solution. In terms of SLA, I think 95% would be reasonable to expect: my Internet connection can be flaky. I can also share the database by request: ~8.1 TB.

The node is available by this URL: https://ec453b92cd8c.ngrok.io/

Here is an example of an API call:

Keybase proof

I hereby claim:

  • I am deni64k on github.
  • I am deni64k (https://keybase.io/deni64k) on keybase.
  • I have a public key ASC81dUCG-d6jPJniOOi5qrgJXI_1mxmCidMe0HCK_WABgo

To claim this, I am signing this object:

#include <tuple>
#include <utility>
// Based on
// * http://alexpolt.github.io/type-loophole.html
// https://github.com/alexpolt/luple/blob/master/type-loophole.h
// by Alexandr Poltavsky, http://alexpolt.github.io
// * https://www.youtube.com/watch?v=UlNUNxLtBI0
// Better C++14 reflections - Antony Polukhin - Meeting C++ 2018
#include <iostream>
#include <sstream>
#include <string>
#include <tuple>
#include <array>
#include <experimental/array>
namespace std { using std::experimental::make_array; }
#include <boost/preprocessor.hpp>
#include <iostream>
#include <string>
#include <tuple>
template <typename T>
std::ostream& operator << (std::ostream& os, T const& obj) {
using std::operator <<;
std::apply([&os](auto const& fst, auto const&... rest) {
os << fst;
@deni64k
deni64k / gist:1020130
Created June 11, 2011 01:04
Bug in ActiveSupport::TimeWithZone#xmlschema
# rails3
require 'active_support/time'
Time.zone = ActiveSupport::TimeZone['Eastern Time (US & Canada)']
Time.zone.at(0.000123).xmlschema(6) #=> "1969-12-31T19:00:00.123-05:00"
# rails2
require 'active_support'
Time.zone = 'Eastern Time (US & Canada)'
diff --git a/lisp/term/ns-win.el b/lisp/term/ns-win.el
index 157b2dd..f3807b7 100644
--- a/lisp/term/ns-win.el
+++ b/lisp/term/ns-win.el
@@ -1263,6 +1263,11 @@ the operating system.")
(add-to-list 'window-system-initialization-alist '(ns . ns-initialize-window-system))
+(declare-function ns-toggle-fullscreen-internal "nsfns.m" ())
+(defun ns-toggle-fullscreen ()
-- Подготовим свои таблицы
TX> create table deadlock_test (id int unsigned primary key, num int) engine=innodb;
TX> insert into deadlock_test values (1, 1), (2, 2);
-- TX1 захватила лок записи (id=1), TX2 пытается её изменить; получаем deadlock
TX1> begin;
TX2> begin;
TX2> update deadlock_test set num = 22 where id = 2;
TX1> create temporary table tmp_table select * from deadlock_test;
TX1> (wait)