10,279 reputation
43650
bio website programmers.stackexchange.com/…
location Bad Rappenau, Germany
age 44
visits member for 4 years, 4 months
seen 20 mins ago

writes code

ruby (on rails), c++, python, pascal, vb, ti-basic, sql, js, jquery, html, xml, qt

find me on Google+


20h
comment The best way to learn Javascript or any programming language
Off topic. Anyway, try to do something that you feel is motivating you. If you don't like how this books teachs then search the internet for other resources. There are more than enough free javascript tutorials. Many of them focus more on writing code. Maybe have a look at Codecademy. Just keep in mind that some of those minute details have their place and you will want to come back to them later.
1d
comment Do common relational database systems work 'out of the box'?
Installation of those systems is mostly straightforward (assuming basic systems knowledge). Just use what gets your job done, you are right that most of the advanced features are for larger problems. But so what? Ignore them. Also the more commonly used something is the easier you find help and tools. Though lately we have some move towards various NoSQL databases in Web development for different reasons. Maybe have a look at MongoDB, though you will find the same amount of features you do not actually use.
2d
comment How should an API or server respond when a device connects with a different account than it is bound to?
Would depend maybe. Why do devices need binding to begin with? How do you find out a device is 'bound'? (Cookies?) Are there possible errors? What are the user patterns? In our company it would be quite common that hardware is moved around between users, so if several of our employees would use your service they would have to 'rebind' once in a while at least.
2d
comment Should I remove logging statements on production?
Primarly opionion based also possible duplicate: stackoverflow.com/questions/8002116/… or stackoverflow.com/questions/1114187/… or stackoverflow.com/questions/7042611/…
2d
comment Generate a dynamic dropdown and embed a php code
Sounds like a good idea. What exactly would be your problem? Programmers.SE isn't a tutorial writing service. programmers.stackexchange.com/help/on-topic
May
20
comment Coinvault / Bitcrypto ransomware idea
Not sure if this question is on topic here. May get closed. Anyway you may have more luck on reddit. There are some hacking related subreddits like reddit.com/r/hacking and reddit.com/r/howtohack, /r/netsec, /r/asknetsec and more. Some users there have very good knowledge.
May
20
comment Hardware for a team of programmers (iOS / Android / Web developers)
Those machines are cheap trash for home use or at best for secretary work. 250G HDD? That's just good for the first two VMs I run on my dev machine. Your devs will have to emulate servers on VMs if they do professional work and use databases. Those specs will lead too low compile times for and slow work in general. If you would ask me to work with this equipment I would start looking for a new job immediately.
May
19
comment How do I structure a URL with several querystring items?
No, just the same. If you post a form from the browser that is where all the form fields data goes for example.
May
19
comment Pushing data into chunks from server to mobile client
200 records doesn't sound like much data (unless those records are very large). Are you sure you can't send them in one go? Or zip them into a file and send this? If I assume a 'normal' record with something like product data (title, long description, prices) that should be only bytes and near to nothing compared for example to sending images.
May
19
comment How do I structure a URL with several querystring items?
Yes, the stuff behind the question mark. That's where all the additional params go. Stuff that's not directly related to address the resource. But of course some details may depend on what framework to use. For example in Ruby on Rails your method would be a big pain and lots of additional work to setup the routes.
May
18
comment How do I structure a URL with several querystring items?
It also addresses 'resources' which can be nested and structuring the variables into the URL like this could become a pain. Not necessarily, since most likely names of resources would be different from parameter/variable names. But still... Personally I would always prefer a 'cleaner' approach where the path part locates the resource and additional params that are key/value pairs go into the query string.
May
18
comment Memcache queries run on a cron job?
Would be called warmup query in other systems. It's quite common. Alternately you could trigger it when the underlying data changes if that doesn't happen too often.
May
18
comment How do I structure a URL with several querystring items?
Doesn't look too great to me. Could become very confusing soon. Have a look at RESTful routing.
May
13
comment What is the preferred way to store application configurations?
Well, git at least has something like .gitignore where I can define files or folders that should not be checked into version control. As you say I don't see where Env vars should really help, eith you have a script to set them and should be stored together with the project or you have them 'somewhere' on your system (home directory or even in the machines startup scripts) which seems to create a whole lot of problems on its own, especially if a lot of configuration is necessary. In any case I would split the config files so that confidential information go in different files.
May
12
comment SQL code gives an foreign key error
This may help: stackoverflow.com/questions/27149419/… (there are more questions for this error, so maybe search for it). Also this type of question belongs on StackOverflow.
May
12
comment Non-ambiguous wording for 'Backend'
server side? Or maybe business layer?
May
12
comment Where do I go if I want to make a difference?
The internet (and this includes Facebook to some degree) already changed the world to something better, most likely more than a Mars colony would have. Here we all sit and easily communicate with people all over the world, exchange thoughts, help each other. When I was a kid getting a phone call from Europe to the US was the best you could get (with some static noise from the cables or sats) and it was expensive. Also we actually did solve quite a few 'big' problems.
May
6
comment Read complex data from a relational database through a join or through concurrent requests?
In general for most of these cases the JOIN would be the recommended solution. It will limit the requests, be more readable and the database has highly optimized code (and can use the indexes), so most likely much faster.
May
6
comment Design interface for WebService to access several MySQL databases
What language are you working with? Also this does not look like a web service, more like class methods (maybe used by that web service?). You may want to look into the Active Record Pattern and maybe Object Relational Mapping. Then your requests would maybe look more like Connection.new(db).from(table).add(dataset) (this just a very rough idea to get a start). also Connection.new(db).from(table).where({field1: value, field2: another_value})
May
1
comment Data integrity, BinaryWriter, C#
I would look into using a database for this instead of a single huge file (as I think you are planning?). You could store single rows with some binary blob and some timestamp or other information to identify the data. That way the single lines would be as independent from each other as they are now (as far as I understand your problem without knowing much about the actual data you talk about)