30,479 reputation
457112
bio website
location
age
visits member for 4 years, 8 months
seen 1 hour ago

3h
comment How to interview with a manager who thinks that agile experience is essential?
Look on the bright side, you won't have to work for someone who worries more about methodologies than your skills.
May
22
comment DLL or web service for common functions?
A web service could be many thousands of times slower for just 'internal math calculations' than a local DLL. I think you need to look at the specific bits of functionality in question rather than a one-size-fits-all approach.
May
6
comment how to import large amounts of data without locking sqlite database
You might try parsing the csv file and loading it into a second table (perhaps a memory table), and then do a single bulk insert statement into the final table there. That would at least cut out the csv processing time. Also, make sure you are doing the whole thing within a single transactions - that seems to make a big difference.
May
1
comment Social network notification system
I worked on a project with a similar (but smaller) notification system. I had a background process that looked at a queue of new posts and handled the notifications (which in this case was actually inserting an email into a second queue for sending). It wasn't real time, but it generally handled everything within a couple minutes.
May
1
comment Social network notification system
Can you expire notifications? For example, delete anything over 2 weeks old. That should more or less balance out the size of the table used as the site matures.
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.