30,399 reputation
457111
bio website
location
age
visits member for 4 years, 7 months
seen 12 hours ago

Apr
22
comment Executing a script continuously
You can set your script up to be run by the mail server for each incoming email.
Apr
22
comment Can a the kind of load Uber handles be served from just one server?
It sounds like its one million business transactions, not one million web requests. There's likely many hundreds or thousands or more web requests per business transaction.
Apr
20
comment MySQL Database normalization for a user model
What you describe is a typical user's table. I don't know if I'd go any further with it unless you had a good reason that you need it to be more complicated.
Apr
16
comment Is there any way to establish a direct connection between 2 mobile devices over internet?
Can you VPN to a central server from those locations?
Apr
8
comment Having Foreign Keys in Business Objects
I've run into situations where doing that made sense. You seem to understand the pluses and minuses of the approach, so do what you think will work best for you.
Mar
27
comment Is it redundant and unnecessary to do file backups of a repository that has a remote repo?
I usually keep 3-5 copies of my code bases, depending on the projects. Always my working copy, the repo, and a second local copy on a different machine in case of drive failure. But also copies on removable drives and online storage for my personal projects (where I'm responsible for the backups).
Mar
12
comment How to budget for a programmer you're not ready to hire yet?
You might just assume the cost will be the upper bounds of what you would be willing to pay to have it done. Barring that, I don't see why you can't contact programmers and ask for a quote - so long as you are up front with the fact that you aren't ready to move forward immediately.
Mar
6
comment Why doesn't v8 compile typescript instead of javascript?
Typescript code is compiled to JavaScript code... which is then run by the client side JavaScript engine.
Mar
4
comment Is it premature optimization to add database indices?
After you've been working with databases for a while, its clear from the point of table creation how you'll be querying the data most of the time. So certain indexes would be pretty obvious to add when first building the tables. Also you don't want to only profile queries when they are slow. Optimizing fast queries may give you bigger performance boost if they are done more frequently.
Feb
18
comment Building an Amazon S3 based file sharing app using FTP
Multiple 100GB files? Unless your customers are all on fiber, how are they even going to download those? It might be quicker to send a hard drive via FedEx. It you really need a download solution I'd look at something like bittorrent sync.
Feb
17
comment Is it a good idea to require passwords in offline applications?
This seems like a 'it depends' question.
Feb
16
comment Is it possible to avoid SQL injection by not using a Query Language for most tasks?
Sure, you would completely avoid SQL injection if the interface to the database wasn't via SQL. That's something of a tautology.
Feb
16
comment Printing a large number of images from the browser
I think you would be much better off with a desktop application here.
Feb
16
comment Communicating between browser and a native application securely
@k3b That's not relevant to this topic, which was about a desktop application talking to a desktop browser.
Feb
9
comment Say I wanted to create a cross platform program that does not require a runtime/VM, am I stuck with C/C++?
-1, shows no research effort.
Feb
5
comment Why do all browser user agent strings begin with 'Mozilla/5.0'?
imo, because its asking for the reason behind this behavior, I think it fits here ok.
Feb
4
comment Is self referencing tables a good idea for geographical data?
A self referencing table can work well for certain situations, such as nested folder structures. I'm not sure I'd use it for what you are describing, though.
Feb
4
comment Serving a file from a private directory
yes, use PHP to load the file and send it.
Feb
4
comment Communicating between browser and a native application securely
Using an embedded browser like that would, I think, be the best way to ensure the browser is running on the machine it needs to be running on.
Feb
4
comment Communicating between browser and a native application securely
@Zak as I said, you can extend the javascript engine to allow them to talk to each other the way PhoneGap does on mobile apps. You'd define methods that could be called by the javascript on the page which are executed by the native app, or call javascript functs from the native app.