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

Jan
22
comment Do I need use really INNER JOIN?
You'd also want to store the transaction amount for each transaction in case the price changes.
Jan
19
comment How to choose DB and/or DBMS for own application?
Are you looking for an embedded database? If so, start with SQLite, though there are many others.
Jan
18
comment Minimizing database requests for moves of a chess game?
Is there a reason you can't bring back more than one move from the database with a single query?
Jan
15
comment Is there any material difference between queries joined by WHERE clauses, and queries using an actual JOIN?
I don't think there is, but you might try doing an EXPLAIN to see if there's any difference in the query execution.
Jan
14
comment What is the best way to store short-lived data?
If you are currently using a database, I'd say use whatever database you are using now so you don't have to maintain 2.
Jan
13
comment Been working on a project for the last 6+ months. Consultants have been brought in and want to change everything. What should I do?
Is it that you want to stick with JQM, but they are pushing Angular?
Jan
11
comment S3 image urls in database
I have no idea what that is supposed to mean. I think you need to edit your question to better explain the problem you are encountering.
Jan
11
comment S3 image urls in database
You'd do a one to many relationship between tables in your database.
Jan
7
answered Quickly write log entries from http requests in a MySQL database with high performance
Jan
6
comment Why is there little use of filesharing as compression (outside of libraries)?
This question appears to be off-topic because it is not about software design.
Jan
3
awarded  Enlightened
Jan
2
answered Is there a conventional way to combine file path strings?
Dec
30
comment How to access secure web services from a desktop application?
Just a bit of feedback, we can infer you are using Java, but its better to explicitly state the language you are using.
Dec
29
comment Is anyone capable of becoming a programmer and having a career?
related: blog.codinghorror.com/… Its a bit old now but touches on some potential differences between successful and unsuccessful programmers.
Dec
26
answered What kind of user info is ok to be stored as plain text in SQL Database?
Dec
24
comment Development on Android without using Java
The question is clear, but it does not show any research effort. A simple google search for "android without java" shows numerous possibilities.
Dec
23
comment Is embedding data in a executable considered a good practice?
You can physically append binary data to the end of the executable file, and read it during run time as you would read data from any file. That I believe will work on Win/Linux/OSX. But I would only do that if you absolutely need the executable to be completely standalone. Otherwise use a proper installer or package.
Dec
22
comment Retry method for generating unique code
Why would using the auto-increment id itself not be suitable? How many codes do you need per day?
Dec
22
revised Retry method for generating unique code
added 3 characters in body
Dec
22
comment Retry method for generating unique code
Is the remote database the code is being checked against part of the same application that generates the code?