|
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. |
On January 26 2018 02:26 emperorchampion wrote:
So I have a database that is currently an Excel file of about 150 entries (lines), each entry has about 100 or so properties (columns). I want to parse this and make a plain text file to make life easier in the future. The properties are a mix of floats and strings.
Are there any standard formats for storing such data, or should I just go for comma separated? Also for accessing, is looking in SQL overkill for this size of database (i.e., pretty small)?
If it's in excel, it's not a database, it's a spreadsheet. Different data structure.
Given the size, I'm not sure why you think plain text (csv) would be easier than excel to read or parse. The main question is what you want to do with the data. If you want to pull it apart into different entities and relations, then SQL is a good choice. If you want to keep it in a big 150x100 sheet, then a csv, or excel is fine. If your 150 rows are just a test, and you expect to have millions of rows when moving to a production environment, think of more performance oriented solutions such as NoSQL databases.
|
Excel is great because it's unstructured. You're free to do whatever you want with the data very quickly with formulas and pivots. However, this is at the cost of control. You can build all kinds of cool stuff, but someone else who doesn't understand the rules of the spreadsheet can come in and mess everything up. So yeah, it depends on what you want to do with the data and how much control you want around it.
|
On January 26 2018 02:37 Acrofales wrote:Show nested quote +On January 26 2018 02:26 emperorchampion wrote:
So I have a database that is currently an Excel file of about 150 entries (lines), each entry has about 100 or so properties (columns). I want to parse this and make a plain text file to make life easier in the future. The properties are a mix of floats and strings.
Are there any standard formats for storing such data, or should I just go for comma separated? Also for accessing, is looking in SQL overkill for this size of database (i.e., pretty small)? If it's in excel, it's not a database, it's a spreadsheet. Different data structure. Given the size, I'm not sure why you think plain text (csv) would be easier than excel to read or parse. The main question is what you want to do with the data. If you want to pull it apart into different entities and relations, then SQL is a good choice. If you want to keep it in a big 150x100 sheet, then a csv, or excel is fine. If your 150 rows are just a test, and you expect to have millions of rows when moving to a production environment, think of more performance oriented solutions such as NoSQL databases.
Technically, any structured stored type of data can be considered a database, including an excel document. SQLite is literally just a file on the computer after all. Not saying treating an excel doc as a database is in any way reasonable tho  But it's nowhere near me at my worst (Which was tens of thousands of lines of data stored in a single .txt file. Rows separated by \n and columns separated by semicolon. It worked but omg was it slow. I can get really stupidly lazy with my small side-projects..)
|
On January 25 2018 07:53 WolfintheSheep wrote:Show nested quote +On January 25 2018 07:45 sc-darkness wrote:
Is anyone into Linux and networking? Could you suggest something to read over the weekend about this topic? Of course, I can google something but I was wondering if there any recommendations. I've just been advised to read about it but no specifics; I doubt TCP and UDP would be enough because they're cross-platform. Maybe something like multicast and IPC protocol? Given the last assignment you brought up here, I think you need to start asking the right questions to whoever is assigning these tasks to you. No one wants to feel stupid by having to ask their coworkers the simple questions, but I would much rather have someone ask me for details up front instead of spending a weekend shooting in the dark and hoping they hit the right mark. And, in general, it's a completely applicable skill in almost everything you're going to do. Plan properly first, and then work, don't work without planning.
I have another interview. One of interview's components would involve Linux & networking. That's all they said to me. I guess that would defeat the purpose of interview if they tell you everything they're going to ask you about. Either way, I can find my way on Linux, but it's the networking part which I find difficult to guess. I guess I just have to read a little bit of basic things and see how it goes.
Thanks for help everyone else. 
|
So i want to share story of frustartion and joy and also an advice.
Since few weeks i am automating tests of one of our modules. This has two main parts: the web part and hardware part. For web part i am using selenium and it was frustrating but managable. I pulled trough and made it work. Then i moved to hardware part. And oh boy that was HARD. First huge obstacle was finding proper CAN messages to send (in order to invoke desired functions on hardware). That was tiresome but i also managed. And then i hit a wall. I succesfuly injected messages on CAN, but there was no reaction. For last three days i tried mutiple different things and to no avail. I promised myself that if i dont manage to do it until end of week i will switch to difrent aproach --> circumvent CAN network entirely. And today i came to work broken and without hope. Made one last try and i noticed something about setting that made me wonder and also set me in right direction. Then i made some inquiries (not the first time but right now i knew where to look) and i found out the source of error. It was something absolutely basic. During the development they changed baud rate of one of CAN networks. And i didnt notice it is wrong because i used sample configuration for our project and in this configuration it is still the baud rate before changes, so not correct right now. Configuation wasnt updated (or perhaps it was but in the source from which i downloaded it wasnt). And until today i didnt question the configuration, it "should be ok" i assumed. Afterall it is official configuration.
Once i changed baudrate of injected messages it all works very smothly. I wasted three days and become so frustrated during the process....
But now i am SOOOO happy. IT WORKS!. I still have a lot of work ahead of me but overcoming major obstacle is always so rewarding,
So i have an advice. If it doesnt work and You ahve no idead why,m start with checking the vary basic things and move up. Not the other way around.
|
Ha thanks for that, I needed a reminder why I abandoned EE for greener pastures
I know what you mean once it finally works though.
|
Woke up earlier for an interview. It turns out it was scheduled for tomorrow when I have another interview. I had to apologise and reschedule it for another day. :D
Conclusion: Add your events to calendar as soon as possible. Don't delay it for too long.
|
On January 25 2018 04:05 WarSame wrote:Show nested quote +On January 10 2018 01:00 Hanh wrote:On January 09 2018 04:39 WarSame wrote:On January 09 2018 03:29 Excludos wrote:
I'm more confused to what he's actually trying to do. Why would an app ever require access to a private wallet? For the app's author to divert your money into his own wallet :-) Every crypto wallet app has a private wallet unless they delegate to an external client. If done properly, offline signing is safer than trusting some service to manage your keys. If it was my app, I would use web3j wallet management https://docs.web3j.io/transactions.html#creating-and-working-with-wallet-filesYour app has a receiving address and you can top it off by transferring from your bigger stash. I don't see the point of the guys who are bashing the security of your app. It seems fine considering that it aims to protect a wallet held on a phone and what they say seems not applicable in this context. I'd look into the fingerprint api that links with the keystore. How about 1. generate a long random string as the wallet password 2. generate a keypair in the keystore 3. encrypt (1) with (2) 4. store the result in a db 5. link (2) to finger print auth Thanks for this post. I've been trying to implement wallets for my app, rather than ask for their private key, and this really is helping me clear up how my understanding of how to do that properly. Especially the idea of having a "proxy" account with my app that they just transfer some ETH to.
I've been following up on this and ran into some snags:
1, I don't have a fingerprint scanner
2. If you hide your long random string behind a KeyStore protection like fingerprints or a PIN, those keys get permanently deleted if you remove your protection. Since I am generating an Ethereum wallet file, losing the key would be very bad. Does anyone know a good way around that?
|
Standard practice is to offer backup/restore of the key and remind the user until he does.
|
Well, I've got an offer and I've accepted it. I'm so glad it's going to be C++ again, I'm looking forward to become even better at it. I don't mind other languages though.
|
Grats
|
On January 31 2018 07:49 sc-darkness wrote:Well, I've got an offer and I've accepted it. I'm so glad it's going to be C++ again, I'm looking forward to become even better at it. I don't mind other languages though.
Congrats.
The first few positions are the hardest, once you have a fair mastery level of one coding language, and one scripting language, a lot more opportunities open up.
|
On January 30 2018 13:43 Hanh wrote:
Standard practice is to offer backup/restore of the key and remind the user until he does.
Thank you, Mr. Hanh! I was hoping there was a more elegant solution, but thought this might be the way around it.
|
gj darkness, c++ is a dream.
|
Thanks guys. Yeah, C++ is such a nice language when you consider C++11 and 14. I probably have to start learning C++17 at some point.
|
yes, automatic class template argument deduction! and c++20! concepts! hopefully! already been using it for a while with gcc, i love it.
|
honestly though sometimes I feel C++ 14 and beyond is completely incomprehensible colon colon life
grats darkness
|
On February 01 2018 15:33 Blisse wrote:
honestly though sometimes I feel C++ 14 and beyond is completely incomprehensible colon colon life
grats darkness
There's too much meta-programming with templates and operator overloading everywhere in C++ nowadays. Makes reading the code super confusing and way too abstract if you haven't been following it for some time. At least in my opinion.
|
Ughh, I've been trying to open a VS project in VS Code OSX for the past few hours. It's been quite rough since the C# extension can't find Microsoft/VisualStudio/v10.0/WebApplications/Microsoft.WebApplication.targets - I can see it calling the wrong directory, and the funny thing is, this was suppose to be fixed as mentioned here:
https://github.com/OmniSharp/omnisharp-vscode/issues/1597
I'm assuming it has to do with my .NET CLI version. I'm running 1.1.7, while .NET 2 is out. This is the problem of running a hackintosh. Trying to update everything so I can run different frameworks lol.
|
So i started learning C#. Not that i have other choice since company framework i need to use is exclusively written for C#. Any advices for beginner? (The only language i know already is Python).
|
|
|
|
|
|
EPT
