Robert Eisele
xarg.org · Personal blog · on HN since 2010
Robert Eisele, a developer who writes about PHP internals, MySQL, JavaScript and jQuery plugins, and small coding puzzles.
What HN saysCommenters cite his MySQL pagination post as a fix for slow queries and point to his PHP fork and jQuery webcam plugin.
16HN people shared it
7linked it in comments
10stories submitted
299story points
4 years agolast shared
2010people per year2026
Most-shared posts
- 1PHP Hacking aka trying to push PHP internals forwards3 people · 92 points · first shared 2011 · 61 comments on HN
- 2JQuery Webcam Plugin - Communicate with a webcam directly from JS3 people · 67 points · first shared 2010 · 25 comments on HN
- 3Optimized Pagination using MySQL2 people · 1 points · first shared 2011 · discussion on HN
- 4Make a Fair Coin from a Biased Coin (2018)1 people · 95 points · first shared 2022 · 91 comments on HN
- 5HTML5 Snake1 people · 29 points · first shared 2011 · 15 comments on HN
- 6Generate client-side PNG files using JavaScript1 people · 5 points · first shared 2010 · discussion on HN
- 7JQuery plugin to do everything you could ever need with colors1 people · 3 points · first shared 2010 · discussion on HN
- 8Cracking Apple Interview Question1 people · 3 points · first shared 2016 · discussion on HN
- 9A little idea to resolve special m:n relations a bit different with MySQL1 people · 2 points · first shared 2010 · 1 comments on HN
- 10Paginations revised with jQuery1 people · 2 points · first shared 2011 · discussion on HN
- 11Php facedetect1 people · first shared 2011
- 12Is it possible to avoid query parsing inside of mysql1 people · first shared 2011
What HN people wrote when they linked it
brutuscat · 2022-09-27
I remember coming back to "Optimised Pagination using MySQL"[1] to avoid common pagination "slowness".
[1]: https://www.xarg.org/2011/10/optimized-pagination-using-mysql/
[more]: https://stackoverflow.com/a/32360867
sgerrand · 2012-04-11
As previously discussed on HN, Robert Eisele's fork of PHP (at v5.3.6) which attempts to fix many of the issues.
http://www.xarg.org/2011/06/php-hacking/
kaolinite · 2012-03-16
No probs. This library is pretty good if you're using jQuery: http://www.xarg.org/project/jquery-webcam-plugin/
albertzeyer · 2011-03-27
I wonder a bit that there isn't a real binary protocol for SQL.
Edit: It seems there are ways to work around server-side SQL parsing: http://www.xarg.org/2011/01/is-it-possible-to-avoid-query-parsing-insi…
I was thinking more about why it is allowed at all to send text-like SQL queries to a server. A binary protocol would both be simpler to handle and would have saved us from a lot of trouble.
Edit: If all client-side libs (for PHP, Python, etc.) would just use those [prepared statements](http://dev.mysql.com/doc/refman/5.0/en/c-api-prepared-statements.html)… it would be like what I mean.
Edit: Ah, I was wrong (as I hoped): For Python: https://launchpad.net/oursql
abredow · 2011-01-31
There is also OpenCV http://opencv.willowgarage.com/wiki, which I believe has several wrapper libraries that add higher level functionality. PHP, for one, has a face detection library: http://www.xarg.org/project/php-facedetect
perucoder · 2010-10-24
Check out this example someone posted awhile back. I think it could be modified to do what you need:
http://www.xarg.org/project/jquery-webcam-plugin/