8,599 reputation
11021
bio website
location Mid-Atlantic NorthAm
age 53
visits member for 4 years, 6 months
seen 2 days ago

Software by day, hardware by night, beer on the weekends.


Mar
12
answered Working with two different database types for one application
Feb
2
comment S3 image urls in database
@the_: UUIDs would be better, since random number generators can (by design) produce the same number more than once. Since you're using Postgres, I'd recommend just using a sequence.
Jan
30
comment S3 image urls in database
@the_: Use something like a UUID or a database sequence (if your database software offers one). If your data volume is low enough, you could probably get away with something like (user ID + timestamp).
Jan
29
comment S3 image urls in database
Three things you can do: (1) save the parent first to get the ID, (2) have an ID generator you can call to set the ID before you save it, or (3) generate a separate (non-primary) ID to act as a surrogate key and store that in a separate field in Product (say ProductImageID).
Jan
20
answered Scaling locks in high concurrency web apps
Jan
15
comment Is there any material difference between queries joined by WHERE clauses, and queries using an actual JOIN?
The reason the JOIN statement was added was because there was no standard for expressing outer joins, so each database vendor had their own "special" (incompatible) syntax for it. IIRC Oracle had *= or =* indicating left or right outer joins, another one I used only supported left outer joins using an |= operator.
Jan
15
answered Saving to file before storing into a database in a REST service
Jan
15
answered Is there any material difference between queries joined by WHERE clauses, and queries using an actual JOIN?
Jan
15
comment How to process large files in NetLogo?
Have you tried profiling your code to see where the hotspots are? Sometimes fairly simple changes (e.g., reading a batch of lines instead of reading them individually) can improve performance significantly.
Jan
15
comment Relation between cache line and memory page
The answers to your questions are highly CPU-architecture-dependent.
Jan
14
comment What's the best way to synchronise an event over multiple processes?
Sure it does -- it syncs on every block boundary. Clients aren't allowed to start the next block until both have signaled that they have completed playing the previous block. It would certainly be possible to have both clients preload the entire content before playback, but I saw that as an implementation detail best determined by the available network capabilities.
Jan
13
answered What's the best way to synchronise an event over multiple processes?
Jan
7
answered Why would a program require a specific minimum number of CPU cores?
Dec
11
comment Company decides standard language for all development, or coder can pick their own standard…so that is the standard? What is the norm?
@VSW: That happens. I was at a company that was a Java shop and they entered into a partnership deal with Microsoft so we all switched to .NET. Some people left rather than make the switch, claiming that if the project went south they'd be stuck as entry-level .NET developers with no current Java experience. I didn't agree, but I didn't try to talk them out of it either.
Dec
10
answered Company decides standard language for all development, or coder can pick their own standard…so that is the standard? What is the norm?
Dec
10
revised Does TCP guarantee packet transmission time?
Corrected technical misinformation
Dec
10
answered Does TCP guarantee packet transmission time?
Dec
10
answered Easy way to make old javascript files conform to new quoting standard?
Nov
14
answered How long do I have to provide the source code for a LGPL-library?
Nov
3
answered Design of high performance file processing web application