Hacker Newsnew | past | comments | ask | show | jobs | submit | itroot's commentslogin

I'm from Russia (currently in Moscow), and I can read your comment just fine without VPN. BBC won't open... which is fine, as I jump straight to comments as many do here :))) .

Also do not miss twitter and facebook. Youtube is working (so far) with no ads.

Also stuff like WaPo is perfectly acessible. Sometimes I skim through it (also mostly comments), then check ZeroHedge to get the opposite view.

So a lot of info is acessible. Quite a few of resources are blocked on the other side though.

I surely can use VPN but prefer not to unless that required for more intellectual activity then reading news.


> check ZeroHedge to get the opposite view

Can you elaborate here? ZeroHedge isn't an opposing viewpoint nor opinion, it's mostly made-up nonsense. Even calling it pseudoscience would be generous.


Yeah, I see it as a radical anti-establisment resource. I would not call it a complete nonsence though, for me it's a place where you can "get" thinking of folks who are opposing "the System". So there is some value.

I'm not political or activist of any kind. However sometimes it makes sense to get understanding how other people think, so sometimes I read comments here and there.

HN has its own bias as well. Usually the quality of discussion here is quite high though.


FYI: ZeroHedge is a project of two pro-Kremlin Bulgarians, a father and son:

https://newrepublic.com/article/156788/zero-hedge-russian-tr...


> Yeah, I see it as a radical anti-establisment resource.

Only if the 'establishment' involved is, well, reality.

> I would not call it a complete nonsence though, for me it's a place where you can "get" thinking of folks who are opposing "the System".

No, it's where you can get thinking from crazy people. Actual dissidents are elsewhere.


They've been fairly pro-system since January, just look at today's posts. ZH has no ideology, just a source of funding.

Unless you mean the comments section, which is something else altogether.


> Can you elaborate here? ZeroHedge isn't an opposing viewpoint nor opinion

People's worldviews define their opinions, no matter how bizarre or fantastical a worldview may be.


I think you can just ask for it. IMO it's better to specify more what kind of mentorship do you need.

I have experience in mentorship, and now I'm mentoring a FE guy who wants to move into go development. It very interesting and fulfilling to help another person to achieve theirs goals.


It's a complex question. I had experience of working with ~60petabytish system back in 2016, and there a lot of things to cover (not only storage):

* network access - do you have data that will be accessed frequently, and with high traffic? You need to cover this skewed access pattern in your solution.

* data migration from one node to another, etc...

* ability to restore quickly in case of failure.

I would suggest to:

* use some open-source solution on top of the hosted infrastructure (Hetzner or similar is a good choice)

* bring in a seasoned expert to analyze your data usage/storage patterns, maybe there are some other ways to make storage more cost effective, that simply moving out of AWS S3.


I also do not want to push... I just want to play with that robot by myself, and see if kid will be interested to join. It's just fun thing to do!


:-) it will be nice from some point of view...


Guy from Russia here. Not an expert, but I feel the pain when my country looks so negative in the news.

First, I wish Alexey fast recovery.

Second, Alexey wasn't a popular politic figure in past time, I believe that his peak of popularity was in 2013-2015.

Third, I think no one here is actually benefiting from this tragic event... the whole story just seems quite strange. Frankly, there a lot of more simple approaches that can kill a man - no need to use sophisticated things like chemical weapons (which actually doesn't work as intended).

I hope that this story will be more clear pretty soon.


> I feel the pain when my country looks so negative in the news.

I'm from Russia, and I feel pain when people mix my country and my my country corrupt and criminal government.


> I'm from Russia, and I feel pain when people mix my country and my my country corrupt and criminal government

+1000 - it often feels that people geniunely don't see any difference.


Strange when it often comes from people who, when asked about their own country, have the same opinion about it.


Navalny wasn't popular? I have seen Russian people cry, when they heard about the assassination attempt on him.

Here are some videos of the many videos from his anti-corruption campaign that made him popular and even a hero in the eyes of many Russians:

- https://en.wikipedia.org/wiki/Chaika_(film)

- https://en.wikipedia.org/wiki/He_Is_Not_Dimon_to_You

- https://www.youtube.com/watch?v=RQZr2NgKPiU

- https://www.youtube.com/watch?v=ZjY3IMXMmVE

For more, see

- https://fbk.info/english/english/

- https://en.wikipedia.org/wiki/Anti-Corruption_Foundation


>Alexey wasn't a popular politic figure in past time, I believe that his peak of popularity was in 2013-2015.

He was banned from being a politician. Banned from media with any kind of reach, banned from elections. And we don't know how popular or not he actually is -- in a country like Russia accuracy of polling, any kind of statistics that is threatening to the dictator is one of the first victims.

>Third, I think no one here is actually benefiting from this tragic event...

A ridiculous statement. It's a signal to those who oppose Putin. In the light of what is happening in Belarus the signal is pretty clear -- Putin won't tolerate any real opposition, and he will not allow the situation to deteriorate to the level where he's actually threatened. "If you are willing to oppose Putin we will poison you with invisible deadly substances, and state doctors whose careers completely depend on their superiors won't treat you" is what it conveys. The goal is to have a chilling effect on the opposition's activities.

>simple approaches

Simple approaches are not as good for conveying a message. Using Chechens from Kadyrov's personal guard(in case of Nemtsov), expensive and hard to obtain isotope(in case of Litvinenko), or chemical warfare agents (in cases of Kara-Murza, Verzilov, Navalny, Skripal) indicates that's it's a state poisoning/killing, something only the state can do. It asks those who are not yet poisoned a question "Are you willing to fight the state/regime who's willing to kill you, make you disabled?

It's rather surprising that the regime doesn't yet target family members. Although I'm not completely up to date on the subject. Maybe it already does.


> no one here is actually benefiting from this tragic event

The opponents of Nord Stream 2 are clearly benefiting from it.

People should ask themselves why he was flown to Germany of all places. People should generally ask more questions and try to see behind all the quick finger-pointing.


You can have several clients. If you do not have long-live write transactions, performance will be fine.


https://www.sqlite.org/appfileformat.html - it is OK to use sqlite that way! =)


I recently impletented an extension to sqlite - https://github.com/itroot/sqlite-brotli-compress - that adds ability to compress blobs to sqlite via brotli, and I think it is trivial to add any compression format to sqlar (with some format extension, of course). But sqlar I believe is not very popular, and just an example of how sqlite can be used.


I think that this applies to all modifying operations - INSERTs, UPDATEs, DELETEs.

It's perfectly ok to write to sqlite from different processes in the same time, but to achieve good results it's better to:

* use WAL mode - so the readers and writers do not block (you can turn on it with `PRAGMA journal_mode=WAL;` in CLI, and it's better to add `PRAGMA main.synchronous=NORMAL;` also).

* all concurrent writes will be queued by sqlite3 lib and done in sequential manner, and if any write attempt will wait longer that BUSY_TIMEOUT ( see https://www.sqlite.org/pragma.html#pragma_busy_timeout ) , it will return error.

Snippet

  # setting things up...
  itroot@l7490:/tmp$ grep -i pragma ~/.sqliterc
  PRAGMA journal_mode=WAL;
  PRAGMA main.synchronous=NORMAL;
  PRAGMA busy_timeout=1000;
  itroot@l7490:/tmp$ sqlite3 test.sqlite 'CREATE TABLE records (id INTEGER PRIMARY KEY, record TEXT);' > /dev/null 2>&1

  # running 10 parallel processes that inserts numbers from 1 to 1000...
  itroot@l7490:/tmp$ echo {1..1000} | xargs -n1 -d' ' -P 10 -i% sqlite3 test.sqlite 'INSERT INTO records (record) VALUES (%);' >/dev/null 2>&1

  # getting number of records
  itroot@l7490:/tmp$ sqlite3 test.sqlite 'SELECT count(*) FROM records;'
  count(*) = 1000


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: