Reputation
31,502
Next tag badge:
98/100 score
30/20 answers
Badges
4 59 115
Newest
 Nice Answer
Impact
~1.2m people reached

Apr
23
comment Can I start a search after a certain number of rows in MySQL
It sounds like you don't understand how indexes work.
Apr
22
comment Finger Paint path gets huge over time and slows the app
@pokche no, just compare them to the last point you added to the array. Duplicate points would be fine if paths crossed. Its repetitive points you want to remove.
Apr
22
comment Finger Paint path gets huge over time and slows the app
imo, the question of "how to improve performance when tracking many points" is completely on topic here.
Apr
22
comment Finger Paint path gets huge over time and slows the app
Are you trimming repetitive and very near points? So rather than storing every point, you'd store only new points that were further than X units away from the last. Depending on the sensitivity of the device, that may dramatically cut down on the number of points you are saving.
Apr
19
comment Could someone write an opensource version of the Windows API?
yes - winehq.org
Apr
19
comment HTTP Status Code for “Still Processing”
What kind of delay are you talking? 10 seconds? Or 6 hours? If the delays are short and generally within the same browser visit, you might do long polling or web sockets rather than periodic polling.
Apr
14
comment Question(s) about PHP PDO connections
Yep, either works. Alternatively return true/false, and remove direct access to the instance, instead adding a query() method to the db class. So its if ($connected) { $db->query("...")}
Apr
14
comment Question(s) about PHP PDO connections
There's no need to do the list(). You can return the instance itself, and check for null. That simplifies the expression a bit.
Apr
13
comment Should an audit user column be nullable?
If you initiate the ModifiedById column with the id of the article creator, there'd be no reason for that column to ever be null since presumably an article needs to be created by someone/thing.
Apr
12
answered Database design - When should a table column actually be a table?
Apr
6
comment PHP Where do routes end and queries begin
You don't need access to http.conf to handle rewrites. You can also set them in an .htaccess file.
Apr
1
comment Business logic: Database vs code
There's no actual question asked here...
Mar
31
comment When should I consider using a string table resource over a string constant in my Win32 application?
I can't think of any time that I've used them directly. For internationalization I prefer external dictionary files so that translations and new languages can be added without altering the executable. (your compiler though may be converting your hard coded strings into resources behind the scene)
Mar
31
comment Should I check for software on a users machine via a web browser?
Requiring software other than a browser to be installed defeats the purpose of a browser based application.
Mar
30
comment Should all PHP requests be centralized?
@MainMa its hardly a fashion issue. When I switched away from the "one page = one PHP script" paradigm back in early PHP4 days, doing so was decidedly unfashionable. Its all about, as Maurycy says, maintainability.
Mar
30
awarded  Nice Answer
Mar
30
comment Different instances on deserialization of php objects?
No, it should not do that. It'd be counter intuitive in most languages. Objects are typically handled by reference. If you need to compare by value, you might be able to compare hashes of the serialized objects.
Mar
30
answered Should all PHP requests be centralized?
Mar
25
answered Should REST APIs contain the ability to dispatch email?
Mar
23
comment Drawing a data-grid on canvas - whats the point?
Who are these lots of people? Have you asked them why?