EPTThe fact that it's now even possible without needing cygwin and a huge amount of pain is already a win, imho.
The Big Programming Thread - Page 915
| Forum Index > General Forum |
Thread Rules 1. This is not a "do my homework for me" thread. If you have specific questions, ask, but don't post an assignment or homework problem and expect an exact solution. 2. No recruiting for your cockamamie projects (you won't replace facebook with 3 dudes you found on the internet and $20) 3. If you can't articulate why a language is bad, don't start slinging shit about it. Just remember that nothing is worse than making CSS IE6 compatible. 4. Use [code] tags to format code blocks. | ||
|
Acrofales
Spain18155 Posts
The fact that it's now even possible without needing cygwin and a huge amount of pain is already a win, imho. | ||
|
bo1b
Australia12814 Posts
I would think that if the performance was not critically slow enough people would jump ship from linux onto windows just from the sheer convenience of it all. Really, there aren't a ton of things that would be missing for me to really consider doing it. In fact, it's two. 1) fix the filesystem performance issues 2) create some sort of Xwindow system which doesn't suck and integrate it into bash All of a sudden I have i3, emacs, visual studio, pathofexile and an overall fantastic operating system. It's already really really good though. Unfortunately I just can't justify it when my job is built around both linux and c++, because 1) the tools on linux for c+ are amazing (rtags, aspell etc), and 2) I'm targetting linux lol. | ||
|
Hanh
146 Posts
In case someone is interested, I run the Oracle Virtualbox Debian VM in headless mode and SSH to it with mobaxterm. It has a decent X-Window server so tools like sublime text can run. Most of my work is command line driven (in rust, python & F#) and the occasional Visual Code. | ||
|
enigmaticcam
United States280 Posts
select * Suppose there's an index on TableA on Column1 and Column2, and an index on TableB on Column1. Will that join utilize both indexes for best performance? Or will the index on TableA be ignored because I'm substituting an actual SQL column with a literal value? Apologize if this is an easy Google search. I tried on my own but didn't really know how to phrase it right to get an answer. Thanks! | ||
|
supereddie
Netherlands151 Posts
I think the query will be slightly altered to:
This will utilize the index on TableB.Column1 for the join condition. The index on TableA(Column1, Column2) will be used for condition TableA.Column2 = 1. | ||
|
enigmaticcam
United States280 Posts
On November 03 2017 03:15 supereddie wrote: Just enable the Execution Plan and it'll show you. Learning to read the Execution Plan will help you understand how the server does things. I think the query will be slightly altered to:
This will utilize the index on TableB.Column1 for the join condition. The index on TableA(Column1, Column2) will be used for condition TableA.Column2 = 1. I always forget about checking the execution plan. Thank you! | ||
|
Thaniri
1264 Posts
On November 02 2017 10:34 bo1b wrote: Going all in on rust, wish me a lot of luck getting a job, cause there is no going back now. This language is amazing (I feel like a televangelist). Also, intellij is providing support to it now, and more importantly they're working on support for the windows subsystem. All I need now is microsoft to finally fix it's i/o speed and I'll be one happy man. For anyone newish to low level languages but knows enough basics to understand functions, strings etc a good project is literally anything simple which has a gui - one of the best things I ever did was learn how to use qt to make a sine wave generator which used mouse position in a window to select the output frequency. Of the "new C" meme languages I didn't know if I should pick Rust or Golang. I happened to pick Golang just because of exposure through my social/work circles. One reason I bet my marbles on Golang is that it's done by Google to be an easy parallel language. So in my pipe dream ambitions, if I need to manage tens of data centers with thousands of machines on them I want to be able to get the task done quickly, safely, and concurrently with other related tasks. Rust is similar in use-case to Golang, it's just reputed to be more difficult. It also works "closer to the metal" the way C does. I suppose Golang is probably like the Java of systems programming. Or maybe the Javascript of systems programming  I'll hopefully see articles in the future written by programmers way better than me telling describing the different use cases for each language. | ||
|
bo1b
Australia12814 Posts
On the other hand until you get used to it you'll hate the compiler, after you do some pretty incredible things have been done with it, such as ripgrep and the new Mozilla engine. | ||
|
Silvanel
Poland4736 Posts
I did see some microkernel mentioned in relation to Rust some maybe i am wrong but thats the feel i getting working in this field. And again thats just "feeling" didnt do any serious research into this. | ||
|
bo1b
Australia12814 Posts
On November 03 2017 17:01 Silvanel wrote: Granted i dont know Rust and Golang but from use cases i found on net they dont realy seem like replacment for C. C isnt used becuase its safe or easy. Its used when every bit count. When You have 700KB of flash memory and have to run 50 applications on it. I did see some microkernel mentioned in relation to Rust some maybe i am wrong but thats the feel i getting working in this field. And again thats just "feeling" didnt do any serious research into this. Rust can absolutely do super low level programming. Golang cannot. Rusts memory management is a little wierd, but you can definitely do pointer manipulation etc so there isn't a lot of reason you can't do it. Actually having thought about it all, I don't think you'd want to use rust for that type of thing, but you definitely could. In sort of the same way you wouldn't want to write web apps in c... just not as dramatic haha. | ||
|
dekibeki
Australia34 Posts
On November 03 2017 14:17 bo1b wrote: Years of c++ work has resulted in a language called c++17 which comes with modules, super safe memory usage, incremental compiling and more!. Besides modules slated for C++20, this is true... | ||
|
bo1b
Australia12814 Posts
| ||
|
R1CH
Netherlands10341 Posts
As a hash function, it's super fast and resistant to collisions which is what you want. But password hashing is a different thing altogether. If someone steals your database, you don't want a super fast hash function, as the attacker can then easily brute force all the hashes. Salts prevent rainbow table attacks, but a modern GPU can still process millions of hashes/sec, so the hashing offers very little protection. You want a hash function that's slow by design. Something like bcrypt2 or argon2i are the best choices as you can set the work factor required, allowing for a small delay that isn't noticeable to the user, but greatly reduces brute force effectiveness. As an example, my GTX 1080 can crack 1942.8 MH/s of SHA256, but only 77 H/s of bcrypt2. This works out to just over 1 minute to break all 8 character lower case passwords for SHA256, but 99 YEARS to break the equivalent in bcrypt2. | ||
|
R1CH
Netherlands10341 Posts
On October 29 2017 11:26 WarSame wrote: For the app I want to be able to store the user's private ethereum key(if this is stupid/if there is a better way to do it please let me know). I need to be able to store and retrieve, but I want to encrypt it(for security). In order to encrypt/decrypt I need a key. However, that key can't be encrypted(because I need it to do so), so it must presumably be stored in plain text. If I store it in the DB then if they have DB access they can just decrypt. If I store it in a secrets file and they have server access they can just decrypt. What am I missing about this? Is it worth it to encrypt, and if so where do I store this key? Apologies for my lack of knowledge, but I'm obviously not experience with implementing encryption. To be brutally honest, you have no business being near a cryptocurrency project from what I can tell of your current knowledge. You need a much stronger background in cryptography and web security, as well as strong server security fundamentals. You WILL be hacked and your users WILL lose their money. | ||
|
Manit0u
Poland17541 Posts
| ||
|
sc-darkness
856 Posts
| ||
|
Deleted User 3420
24492 Posts
Is it so that you avoid using invalid entries in calculations that take the entire array as an input? Basically, is it so that you can use premade functions rather than having to write your own functions to handle whatever kind of special circumstance? | ||
|
Thaniri
1264 Posts
Perhaps a masked array would be used to work with this type of data in memory. | ||
|
WarSame
Canada1950 Posts
On November 03 2017 21:51 R1CH wrote: To be brutally honest, you have no business being near a cryptocurrency project from what I can tell of your current knowledge. You need a much stronger background in cryptography and web security, as well as strong server security fundamentals. You WILL be hacked and your users WILL lose their money. No offense taken. This was a project for my own education, and so I could show it on my Github(both of which are why I appreciate the feedback). I was never planning to make it available for customers, for obvious reasons. | ||
|
WarSame
Canada1950 Posts
| ||
| ||
