Viewing profile — itroot

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 "…

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 :))) . Als…

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 m…

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 d…

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...

I want to show my kids what you can achieve with software development, and I think dealing with some physical thing that is controlled by your code is incredible fun - you are gett…

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 …

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 trivi…

If you are doing this for analytical things, setup with one database is OK. But, imagine that you a running something on production with sqlite, and database is really big. It is h…

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 go…

Yep, that's a great use-case! However on such amounts of data I would recommend to split it to several databases - backup, replication, vacuum will be much easier and better. Doesn…

Is it go implementation of sqlite3 data format?

Why single connection? Sqlite in WAL mode will allow to co-exist writer and readers.

I think there are a lot of places where sqlite can outperform postgres... This is read-heavy and latency-critical apps, where additional hop is costly, for example.

I made a lot of migrations with MongoDB without downtime with dbs up to 200-300Gb. Most easy way is to support this on your backend side, and then gradually switch data. It is easy…

Also --reference (or --shared) is a good parameter to speed-up cloning (for build, for example), if you have your repository cached in some other place. I was using it a long time …

Hey, Michael! I was following you story since your first post two years ago. I just want to say that to succeed you need to sell something. As a software developers we can scale so…

Hi! This is a great app! Is it works only in US? How do you get actual prices? Is it some kind of scraping, or some other channels? (If is it not a secret) Thanks!

geogebra is just an aspiring example, I do not have any encounter there. So, kudos to geogebra founders =)))

Thanks for the feedback, espacially for #2. I really like to see visualisation with feedback loop ( ability to change source code and commit a-la wikipedia) in educational process.…