9,999 reputation
43449
bio website programmers.stackexchange.com/…
location Bad Rappenau, Germany
age 44
visits member for 3 years, 11 months
seen 11 hours ago

writes code

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

find me on Google+


Sep
1
answered Whether to store all numbers or just their ranges in database for this application
Aug
30
comment How do you set and check a single bit in a programming language that does not support bitwise operations?
The Wikipedia article on bitwise operations explains the mathematical equivalents, mostly they seem to be based on some modulo2 operations.
Aug
29
answered REST API design for associations/aggregation
Aug
28
answered Is routing a site with RESTful not the best when you have very long URLs?
Aug
28
answered Good practice to pass this information through URL parameter
Aug
28
comment Good practice to pass this information through URL parameter
Totally standard. Even if both options could be used in parallel you could use something like me=actual;past and split on the server.
Aug
28
comment Loading database in memory vs querying
Would much depend on many details. Do you really need the whole database in memory or could you for example just keep the most recent entry for every file and load older versions only on demand? Also with something that seriously wants to handle that amount of files a dedicated server for this database could be an option. Basically 10-15 million records shouldn't be that much of a query problem if the dbms system is highly optimized, columns are indexed properly etc. Maybe researching different database solution (eg NoSQL) would be another option.
Aug
28
comment Is RESTFUL API as back-end service one of the best (or suitable) choice for Mobile App?
We did this in our last project and so far everybody is happy with it. Developers easily get how the API works and is structured, most common tasks fir very well into the REST structure. (@gnat I don't see where he is asking for tools or services to be recommended. May still be off topic as opinion based, but basically it's a question about API architecture).
Aug
27
comment Making internal search engine return results that adhere to local permissions on an internal web application
btw: doing all of this within the search engine has some more benefit, like you can keep sorting which most likely gets lost when you mix things like you do now.
Aug
27
comment Making internal search engine return results that adhere to local permissions on an internal web application
Not explained very well, but permissions are always for 'pages' did I get this right? So you tag each document with the page it belongs to. Then before the query you get the pages for the user (say [2, 5, 7]) and ask ES to return only documents that have one of these as tag. That's how I understood the problem here. Alternately you could also tag every doc with the user-id of everybody who is allowed to access it, though this would be a bit more complicated (though for about 500 users this should still work at least Solr can handle such things surprisingly performant)
Aug
27
comment Making internal search engine return results that adhere to local permissions on an internal web application
I have only practical experience with Solr, but Elasticsearch should be similar enough. I would just tag the documents with the 'pages' information. (Basically as your developer recommended). This would only another type of tag and our queries use several of them for every query anyway without any performance problems. The search engine can handle this internally much faster than your code. (Though in theory you could try to optimize your intersect algorithm, but it would depend on many factors if this is worth your time when letting ES do it will most likely be easy enough)
Aug
18
comment Breadcrumbs in a modern web application, make sense?
Nielsen may be right from a technical point of view. Though fact is that users (especially the not so technical affine) like the things. They just help them to remember what they have done a few mouseclicks before reaching the page (that for the hierarchy type makes more sense).
Aug
15
comment How to convey that a project is too ambitious?
@gnat I'm always impressed how you are able to find those duplicates.
Aug
15
comment How to convey that a project is too ambitious?
That said it needs some experience to tell people that their plans won't work. First question is how much knowledge would your boss have about IT projects? It sounds like he knows near to nothing about this. In a case like this I would maybe try to split the project in smaller steps that can actually be finished. Then finish some successfully, which helps greatly to build some trust. From here show how much work is left, how much the last steps took and make a good guess how long the rest of the work would take for a single developer.
Aug
15
comment How to convey that a project is too ambitious?
The Workplace would maybe accept this question (not sure). I flagged it for migration, so a mod should drop in sooner or later.
Aug
14
comment Self-Evaluation: How do I know if I actually have a “good grasp” of OOP?
That's a good start, but depending on the object model of any specific language a lot of details come to play in how a system behaves once things like inheritance start to get a bit more complex (eg C++ dreaded diamond). Also communication between classes needs well defined interfaces. You should look into design patterns to get an idea what problems may typically appear and how they can be solved.
Aug
14
comment Equal or less than 15 lines per method(function) principle?
Question will most likely get closed as opinion based. Basically this is a good rule of thumb. The exact amount of lines may depend a bit, some languages tend to do less in a single lines while others allow you to write something like quicksort in a single line.
Aug
13
comment Would these two scenarios be good candidates for a NoSQL database?
It's important to gain some experience with this kind of databases. There are so many solutions and options. But after all not that many of them can really replace a RDBMS. So take your time and try out the most important ones. Martin Fowler wrote a great book "NoSQL distilled" that gives a rough overview about the most important aspects.
Aug
13
answered Would these two scenarios be good candidates for a NoSQL database?
Aug
8
comment what data storage method should I use?
Well, you should have some idea how long those sessions run, how many packages they send during this time etc. Another thing that may help you could be the ELK stack (Elasticsearch, Logstash, Kibana). This system would be optimal for collecting log like data (like you would for example get from Apache Web server, but not limited to this). Elasticsearch has some good video intros on their web site. I think that would be worth looking into.